Sql-Server

BACKUP TO URL was introduced as an add-on in Cumulative Update 2 for SQL Server 2012 Service Pack 1 and as a built-in feature for SQL Server 2014. I previously described this in a blog post.

We have been using this in a variety of ways from on-premises systems:

For example, it is an easy way to distribute a backup of a database to a large number of systems. Imagine you have a chain of retail stores that needs product and other reference information updated regularly. You can keep this data in a separate database at the head office, back it up to an Azure Storage account, and have each store download it separately.  This has major bandwidth and reliability improvements over other solutions such as having each store maintain a VPN connection to the head office.

2014-07-09

It was great to catch up with Jimmy May recently. Jimmy is a principal database architect at Microsoft and was part of the SQL CAT team (customer advisory team) for quite a while. We recorded a new SQL Down Under podcast. In this podcast, Jimmy discusses his experiences with columnstore indexes and the new updatable clustered columnstore indexes. You’ll find it here: https://podcast.sqldownunder.com Enjoy!

2014-06-22

I had the distinct honour (honor) this week of recording a new SQL Down Under podcast with Paul Larson.

Paul is a principal researcher at Microsoft and is one of the keen minds involved in the technologies behind the in-memory tables (Hekaton) and clustered columnstore indexes in SQL Server 2014.

In this podcast, Paul explains his role, and discusses how these core enhancements in SQL Server 2014 have been implemented.

2014-04-04

I’ve always thought that the support for spatial data types that was added in SQL Server 2008 was one of the best parts of that release.

In SQL Server 2012, a great set of enhancements were made to the spatial support.

We’ve had lots of interest lately in SQL Server spatial so we’ve been working on a new course that targets it specifically. We’re pleased that we’ve now added a brand new one day SQL Server Spatial Core Skills course to our list of regularly scheduled courses. It covers a wide variety of topics from understanding the data types, to loading data, geolocation, indexing, etc. It also covers the enhancements that were made in 2012.

2014-02-28

I hear comments from people all the time that say it’s not worth posting details on the Connect website as they don’t get actioned anyway. While it can seem a frustrating process, and often take quite a while, improvements do come from there.

At a SQL Saturday event in Brisbane, I was speaking to an attendee (Ian Roberts) who was complaining that DQS was returning what he perceived as the wrong status. More importantly, the results from using the DQS client differed from using the SSIS transform. He described it this way:

2014-02-22

In the sessions that I was attending in Redmond yesterday, I was interested to see the presenter discussing the idea of having individual database files in the cloud as some sort of bizarre option that’s now available in SQL Server 2014. I don’t see it as bizarre at all. However, I see two distinct use cases that make complete sense to me:

Overcoming Drive Limitations in Azure-based SQL Virtual Machines

One of the current limitations of running SQL Server in Azure virtual machines is that you can only attach two additional data drives per CPU core, and each of those drives is up to 1 TB in size. For example, if you spin up a two core VM, you can attach 4 data drives.

2013-11-20

I had the distinct honour (honor) this week of recording a new SQL Down Under podcast with Dr David DeWitt from the Jim Gray Systems Lab at Microsoft. Anyone that has been to a PASS summit over the last few years would know that David seems to have single-handedly converted morning keynotes into must-attend events.

In this podcast, David explains his role, gives a philosophical view on where we’re at in the database industry and discusses core enhancements in SQL Server 2014.

2013-11-14

I posted another podcast over the weekend. Late last week, I managed to get a show recorded with Adam Machanic. Adam’s always fascinating. In this show, he’s talking about what he’s found regarding increasing query performance using parallelism. Late in the show, he gives his thoughts on a number of topics related to the upcoming SQL Server 2014.

Enjoy!

The show is online now: SQL Down Under Podcast

2013-06-30

I have to say that I continue to be frustrated with finding out how to do things in Windows 8. Here’s another one and it’s recorded so it might help someone else. I’ve also documented what I tried so that if anyone from the product group ever reads this, they’ll understand how I searched for it and might try to make it easier.

I wanted to add a network loopback adapter, to have a fixed IP address to work with when using an “internal” network with Hyper-V. (The fact that I even need to do this is also painful. I don’t know why Hyper-V can’t make it easy to work with host system folders, etc. as easily as I can with VirtualPC, VirtualBox, etc. but that’s a topic for another day).

2013-06-13

If you have followed any of the Azure website forums, you’d realize that having SSL available was one of the highest rated requests. That’s hardly surprising given the number of clients that want to use these sites for eCommerce work.

So it’s really good to see that Scott Guthrie and the team have been listening and that SSL is now available. To see the details, click on the “SSL” button in the “Learn More” area of the Azure pricing page. An FAQ is also provided.

2013-06-03