SQLBits X talk – Loading Data Warehouse Dimensions
I’m thrilled to have been asked to present another session at SQLBits X, especially so as it’s set to be the biggest and best Bits yet.
It’s the official UK […] Continue Reading…
Using T-SQL Merge to load Data Warehouse dimensions
In my last blog post I showed the basic concepts of using the T-SQL Merge statement, available in SQL Server 2008 onwards.
In this post we’ll take it a step […] Continue Reading…
Introduction to T-SQL Merge Basics
A number of Frog-Blog posts over the next couple of months are going to make heavy use of the awesome SQL Server MERGE statement, introduced in SQL Server 2008. […] Continue Reading…
Fast record count in SQL Server using sp_spaceused
Just a quick tidbit today, but a very useful one.
Ever need to do SELECT Count(*) on a very large table? It can take ages.
Instead, use sp_spaceused
EXEC sp_spaceused ‘MyTable’
It returns […] Continue Reading…
PowerPivot Vs QlikView 101 – SQLBits Video
PowerPivot Vs QlikView 101 – SQLBits Video
The video is now available from my PowerPivot and QlikView talk at SQLBits 9 in Liverpool in September 2011. You can download […] Continue Reading…
SQLBits 9 Session – PowerPivot and QlikView 101
Thank you to the SQLBits committee, speakers, helpers and attendees, for making SQLBits 9 one of the best yet. What a great example SQLBits is of the power of […] Continue Reading…
New UK SQL Server User Groups
What an exciting few weeks we’ve got to look forward to!
SQL Bits starts on Thursday this week which promises to be another fantastic event. I’m speaking on the Saturday, […] Continue Reading…
Midlands SQL Server User Group now a PASS chapter
Back in September 2010 I spent another evening with the Cardiff SQL Server User Group, run by Adam Morton. Having got so much out of the Cardiff group since […] Continue Reading…
Pattern matching in SSIS using Regular Expressions and the Script component
One of my favourite features of SSIS is the script component, and I know I’m not alone. Why? Because it brings the entire might of the .NET framework to […] Continue Reading…
SQL User Groups and SQLBits
SQLBits 9
It only seems like yesterday since the SQLBits crew put on their awesome 8th conference in Brighton. The next conference has just been announced, SQLBits will move to […] Continue Reading…
The Frog Blog
I'm Alex Whittles.
I specialise in designing and implementing SQL Server business intelligence solutions,
and this is my blog! Just a collection of thoughts, techniques and ramblings on SQL Server, Cubes, Data Warehouses, MDX, DAX and whatever else comes to mind.
