Blog from a SQL Server Professional
Specialising in everything SQL Server
Need Help? Ask a question at the bottom of this page

About

About the author

Click Here

Contact

Contact the author

Click Here

Links

Related Links

Click Here

Check data distribution in partitioned table – Script

In an ideal world, all partitioned tables would maintain themselves through a sliding window implementation, archiving process, or other automated routine which performs a split/switch/merge of partitions as-needed. Occasionally however, you may come across a partitioned table which requires manual intervention. This may happen when the table has outgrown the…

Dynamic Snapshot Creation Script

Recently I was testing a database release against a VLDB, and I needed the ability to revert the database to its original state, without restoring from backup. So the obvious approach here is to use SQL Server’s Database Snapshot technology, right!? #SQLFunFact - Database snapshot creation has no GUI in…

SQL Saturday #365 Speaker Idol!

I delivered my first ever session to SQL Saturday #365 in Melbourne over the weekend, and I was pleased to find out that I had won the SQL Saturday #365 Speaker Idol competition, with my brief talk on Microsoft Azure! Overall it was a daunting but humbling experience. I am…

Synchronous DB Mirroring and running in an ‘exposed’ state

A few people I have spoken to as of late have been quite surprised to find that their ‘zero data loss’ Synchronous Mirroring solution can actually allow data loss! In fact, data loss is ALWAYS a possibility, regardless of your budget and HA solution in place. It’s just that if…

Archive Data with Table Partitioning

In my last post called Out In Space, I looked at ways of freeing up some space on your database server in a hurry; this led me to thinking about longer term solutions, like archiving your data. Let’s run through a demo of how this can be achieved with table…

Out in Space

Lately, I have come across a few DB servers that have .NDF files approaching 1TB in size, and while this is a far cry from being a VLDB, it does start to become a problem when you are running out of disk space… and in some cases due to the…

Suitably Certifiable?

Last week, I had the pleasure of sitting my 6th ever SQL exam and I did it in the heart of London city. I don't think I would even be in London, if I had not done my first… In this post I’ll share the process that I go through…

SQL 2014 ColumnStore Indexes

When SQL 2012 was released it came with a feature called ColumnStore indexes. What are they you ask? In a nutshell, the traditional b-tree structure that we know and love stores pages of data which contain the ‘rows’ of a table. An index page will contain one or more columns…

SQL2014 governs IO!

The release of SQL 2014 CTP1 has brought IO to the list of resources it can govern! (yes, previously it was memory and cpu only.) Lets get down to business and run through a quick demo so we can get a sneak peek of SQL server 2014 metering IO!  For…

SQL Server 2014 CTP release

Just when we thought we were getting used to SQL server 2012, Microsoft unveils 2014 CTP1! I still have a lot of reading to do on SQL 2012... So my initial feelings are denial! Then I realize that I cannot alter this fact, and I get over it. (Isn't IT…