Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This...

We Are All Responsible

Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):

PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...

You Have One Job

I’m sure most if not all of you are familiar with the meme “You had one job”. I was reminded...

[T-SQL Tuesday] Data modeling: The trouble with prefixes

This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...

Calculating Table Partition Sizes in Advance

[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...

Create stub tSQLt tests in SSDT from stored procedures

I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...

Cumulative update package 9 for SQL Server 2012 SP2

Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2

Microsoft reference: [Click Here]

For more updates:
Subscribe for Blog posts [Click Here]
Follow...

Steps to install SQL Server CTP 3 on Windows Azure

Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...

My PASS Summit 2015 Recap

A few days ago I returned from PASS Summit 2015 (and a vacation I took afterwards). Here’s my recap: I...

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...