All articles categorized under "Sql Server".
Recently I wrote a post on partition switching, however, one of the big pieces I left out was how to go about properly partitioning your database tables. Unfortunately, partitioning strategy can vary greatly, but generally your partitions will be aligned with your clustered index (quite frequently date). I recommend reading...
Great news! I found out this week that I will be presenting at SQL SQL Saturday #160. During my presentation I will be covering how to load balance your SSAS databases using a unique approach called Analysis Services Load Balancing (ASLB). Microsoft uses a variation of this method internally, and...
Quite often when building a data warehouse we are given the challenge of having to delete existing data before importing the latest and greatest. In an ideal world we would just insert new records and be on our way, but quite often that is not the case. Deleting data isn't...
This week I was at the Detroit MTC for a SQL Server 2012 release event where Rick Brewis (Microsoft) and my friend Josh Fennessy (BlueGranite) presented on the new functionality of SQL Server 2012. One of the highlights Rick’s presentation was the new Columnstore Index, and the huge performance increases...
I’ve been in the process of improving the functionality in ASLB, one of the improvements I have been working on adding is functionality for ASLB to be smart enough to understand geo-location in a large network. However in doing so I went through many iterations on how to identify which...
You've reached the end of all articles.