Sql-Server

Hi Folks,

I have to say that I’m really impressed by the rate at which the Windows Azure Mobile Services team is rolling out updates and samples. In particular, it’s good to see a new sample for using Geolocation, given how common a requirement that is in mobile apps today. It’s worth checking out the following:

·         New Code Samples page on WindowsAzure.com

·         Updated WindowsAzure.com Tutorials and Resources page that includes new tutorials and related videos from the new Windows Azure Mobile Services channel 9 series

2013-01-11

While the level of compatibility of Windows Azure SQL Databases is high, there are a number of things that need to be dealt with differently, compared with how they are done with on-premises SQL Server.

An example of this, today I needed to know how full one of my databases was. I wanted to know how much space I had used but also to know what the limit was. My first attempt was the usual system views such as:

2013-01-03

When Power View appeared, one of the big outcries was “but what about connecting to existing cubes!”.

Great to see that the SQL Server team have addressed that. A tool that allows connecting Power View to SSAS Multidimensional cubes is now available.

(NOTE: CTP no longer available)

Help the team get this out the door by trying it and providing feedback.

2012-11-30

Ola has produced another update of his database management scripts. If you haven’t taken a look at them, you should. At the very least, they’ll give you good ideas about what to implement and how others have done so. The latest update allows targeting multiple devices during backup. This is available in native SQL Server backup and can be helpful with very large databases. Ola’s scripts now support it as well.

2012-09-17

Late last night I got to record an interview with Conor Cunningham.

Most people that know Conor have come across him as the product team wizard that knows so much about query processing and optimization in SQL Server. Conor is currently spending quite a lot of time working on Windows Azure SQL Database, which we used to know as SQL Azure.

I’m still trying to think of a good way to say “WASD”. I suppose I’ll pronounce it like “wassid”. Windows Azure SQL Reporting is easier. I think it just needs to be pronounced like “wazza” with a very Australian accent.

2012-08-22

Hi Folks,

I’ve recorded an interview today with SQL Server MVP Louis Davidson. In it, Louis discusses some of his thoughts on database design and his latest book.

You’ll find the podcast here: https://sqldownunder.com/Resources/Podcast.aspx

And you’ll find his latest book (Pro SQL Server 2012 Relational Database Design and Implementation) here: http://www.amazon.com/Server-Relational-Database-Implementation-Professional/dp/1430236957/ref=sr_1_2?ie=UTF8&qid=1344997477&sr=8-2&keywords=louis+davidson

Enjoy!

2012-08-15

One of the things I’ve always wanted in DBCC CHECKDB is the option to omit particular tables from the check. The situation that I often see is that companies with large databases often have only one or two very large tables. They want to run a DBCC CHECKDB on the database to check everything except those couple of tables due to time constraints.

I posted a request on the Connect site about time some time ago:

2012-07-02

Well it’s been a few months but I’m back on a roll creating some SQL Down Under podcasts. The first out the door is an interview with Gadi Peleg from the SQL Server team, introducing Data Quality Services.

Gadi came to Microsoft when Zoomix was acquired.

Details of this podcast (and other available podcasts) are here: https://sqldownunder.com/Resources/Podcast.aspx

Hope you enjoy it even though there are some telling signs that I recorded it at 3AM :-)

2012-06-14

There are lots of reports of data quality services (DQS) not working after installing CU1 for SQL Server 2012. One symptom is that when trying to connect from the DQS client, you receive the following error: “System.Data.SqlClient.SqlException (0x80131904): An error occurred in the Microsoft .NET Framework while trying to load assembly id 65581”

After applying CU1, you need to execute:

dqsinstaller.exe -upgrade

This is typically from the folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn (but depends upon your installation path)

2012-04-27

Great to see our buddy Ola Hallengren has created an updated version of his database maintenance scripts. Many people use these in place of the database maintenance plans that ship with SQL Server.

Here’s the updated info from Ola and the best part is that they continue to be free:

New Version Available

A new version of the SQL Server Maintenance Solution is now available. The new version supports SQL Server 2012.

2012-04-22