Skip to Content

drsql (187 Posts)

RSS

A new (to me, and possibly you) SSMS feature – Query Plan Comparing

Posted January 26, 2017

By ,

In SQL Server 2016, SSMS, T-SQL

Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of... more »
2

Saving a Few Lines of Code by Performing Multiple Operations in a Single Command

Posted January 19, 2017

By ,

In SQL Saturday, T-SQL

I was in Mike Byrd’s session on in-memory technologies the other day and I saw him do something I had never seen and it prompted me to write this blog... more »
1

T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

Posted January 10, 2017

By ,

In bugs, Connect, T-SQL, T-SQL Tuesday, Uncategorized

I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it... more »
2

T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

Posted January 10, 2017

By ,

In bugs, Connect, T-SQL, T-SQL Tuesday, Uncategorized

I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it... more »
2

T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

Posted January 10, 2017

By ,

In bugs, Connect, T-SQL, T-SQL Tuesday, Uncategorized

I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it... more »
2

If a Tree Falls in the Forest, and No One is Around To Hear It…

Posted January 09, 2017

By ,

In database design, reporting, requirements

You no doubt have heard this old philosophical question that completes with, "Does it Make a Sound?" As nerds, we all know that the answer is that it... more »
0

My last SQL Event as a Nashvillian… SQL Saturday Nashville #581

Posted January 05, 2017

By ,

In Concurrency, Professional Development, speaking, SQL Saturday

Of course, technically, I live in Thompsons Station, about 20 miles south of Nashville, and technically this event will be held in Murfreesboro, also 20 miles... more »
0

Books are DONE…

Finally, I can say I am done with a couple of books I had been working on, pretty much simultanously at times the past few months: Exam Ref 70-762 Developing... more »
2

Quickie – SSIS Expression Function – REPLACENULL

Posted December 22, 2016

By ,

In SSIS

When I am not designing a database, I am usually loading it with data (a good percentage of my time is spent designing data warehouse structures, along with... more »
5

Quickie – SSIS Expression Function – REPLACENULL

Posted December 22, 2016

By ,

In SSIS

When I am not designing a database, I am usually loading it with data (a good percentage of my time is spent designing data warehouse structures, along with... more »
5