Archive | October, 2009

Common Table Expressions (CTE)

Common Table Expressions have been available to use since SQL Server 2005 and provide a more elegant way in which to handle a temporary result set other than using a temporary table. The syntax is similar to what I show below WITH <expression name> ([column name1,column name 2,…) AS ( SELECT ….. ) One of […]

Read more

SQL Server Saturday – Louisville

I had a great time presenting at the SQL Server Saturday event in Louisville over the weekend. Thanks to all of the people whom volunteered their time to put it on as I think that everyone there generally enjoyed themselves. Attendance was good and the crowd seemed to be fairly attentive. I did hear a […]

Read more

SQL Server 2005 Transactional Replication: Tips & Tricks

One of the more intimating things in the database architecture for DBAs that I meet at events is replication. Especially, if the replication that you need to set up needs to have a little twist in it that is not handled necessarily by the GUI Wizards in SQL Server Management Studio. What most DBAs need […]

Read more

SQL Saturday #23 – Louisville,KY

Just a quick hit to let everyone know again that I will be speaking at the SQL Saturday event in Louisville,KY on October 24th! If you haven’t signed up for the event then make sure you get onto the SQL Saturday site and do so today. It should be a great day to learn some […]

Read more

PASS Blogging Contest!

PASS is putting on its 2009 Logreader Awards which can be read about here. They are looking for the best blog articles written on the 15th and 16th of October. So now is your chance to email me and tell me what kind of article you would like to see. I figure that it will […]

Read more

Filtered Indexes on SQL Server 2008

What is a ‘filtered’ index? A filtered index is basically a non-clustered index that is created on a subset of the data in a table defined by some query criteria(AKA the filter). Please note that I wrote non-clustered for a reason. You cannot create a filter on a clustered index. Why is this cool? It’s […]

Read more

SQL Server 2008 Cluster on Windows 2008 R2

During installation of a SQL Server 2008 cluster on Windows 2008 R2, I ran into an installation problem. The process would go through the installation until the very end and then throw an error such as this. The following error has occurred: There was an error setting private property ‘RequireKerberos’ to value ‘1’ for resource […]

Read more