Sql-Server

When I’ve been putting data into Windows Azure SQL Database (WASD) in the past, I’d normally been providing the dates from my own system. This week, I had the first time where I wanted to put a column default that provided a date in WASD. It suddenly dawned on me that I wasn’t sure what timezone the date would be from. As I was using the Southeast Asia data centre (in Singapore), I was presuming the value would be based on Singapore’s timezone. So it was time to find out.

2013-01-20

Hi folks, I’m back into the swing with a bunch of new podcasts coming, featuring SQL Server 2012. First up is Clustering MVP Allan Hirt discussing SQL Server HA with AlwaysOn. Allan also discusses the deployment of SQL Server on Windows Server Core.

Thanks for all the emails that said they loved the shows and told me to get them happening again soon. I think you’ll like the ones that are lined up. You’ll find the shows here:  https://sqldownunder.com/Resources/Podcast.aspx

2013-01-13

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