SQLBits Session “T4 Templating within SSDT using SQL Server 2014″

Very pleased that my session on “T4 Templating within SSDT using SQL Server 2014″ has been excepted for SQLBits 12.   SQL 2014 and the latest SQL Server Data Tools has made T4 much easier to use in SQL Development Projects. I gave a talk last month on ETL Design for Warehouse loads to the London SQL User Group.  The(…)

Reasons why your plans suck : No 56,536

I have been working with SQL server for more years than I really care to mention and like to think that I am now quite comfortable with the internals, specifically the Query Optimizer. Every so often though a new problem gets thrown into the mix, just to keep me on my toes ( or so(…)

Maximum IOPS for a 10K or 15K SAS Hard Disk Drive is not 170!

At times, mmm quite often now actually (perhaps it’s because I’m getting older and more grumpy) the industry I’m part of really makes me embarrassed, all too often folk just quote things they’ve seen on Wikipedia or via word of mouth without even a basic knowledge of the “fact” they are quoting – a “fact”(…)

T4 Support in SSDT

Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me.  On tuesday night, at SQL Supper, Geoff Clark ( a uk MCM ) (t) done a fantastic presentation on end-to-end datawarehouse loading, a portion of this was on t4 templating.  The question arose about SSDT and T4 templating(…)

Whats This Command Bar ?

One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out exactly what the names of the Command Bar objects internal to Visual Studio were. Most of the advice on the internet is fairly haphazard ie guess/trial and error, but there is a simpler way. Here http://1drv.ms/1fsR3n3 is(…)

SSDT – Cut n Paste substituting CMDVARs

Another thing that slows me down with SSDT is testing stored procedure that use CMDVARS. Consider this proc : If I wish to test that in SSMS, I can cut-n-paste it in then use SQLCMD mode and add in :setvar statements or simply replace the $(CmdSwitch) and $(Otherdb) with the appropriate values.  Ok for one(…)

SSDT – Fast deploy

Let me state first of that I do really like SSDT, integration of a source control system of your choice and all its extra features make its use a real boon. However…….. On my past few assignments SSDT has been heavily used, and deployment is done via Build/Deploy powershell scripts.  This is all very well(…)

The inescapable problem of Latency within Data-based systems

It’s long troubled me people touting Real-Time Business Intelligence when its physically impossible to achieve true real-time; I’ve jotted down some thoughts in an attempt to bring order and better understanding to the reality of “Real-Time” – hopefully the post will help you in dealing with vendors, giving you some insight into what questions to(…)

TSQL Smells in SSDT – The monster lives

What seems like many many moons ago, I released a powershell script that could detect many different “TSQL Smells“. Whilst it worked, I was never very happy with the interface, it was clunky and didnt feel quite ‘right’. One of my longer term aims was to do something about that and make TSQLSmells more accessible.(…)

SQL Server Hekaton (XTP) in-memory tables: Choosing the correct BUCKET_COUNT for a Hash Index

In this post I cover off how to choose the correct number for the BUCKET_COUNT and how you go about that, also, how to monitor and change the bucket_count. The general approach is that you set the BUCKET_COUNT to the number of unique values there will be given just the columns on your hash index (see(…)