Those of you who are regular readers may notice that my content has shifted towards scripting and some of the emerging platforms and tools for interacting with Microsoft SQL Server. There is a method to this madness but I can’t go into details ...
In a recent article I presented you with an option for searching for any string of t-sql text inside your stored procedures; for that I used sys.syscomments. A point was raised by a reader that sys.syscomments, being a System Compatibility vi...
Have you ever been asked for your thoughts on upgrading a database server? If you’re like most data professionals, your response probably included something along the lines of, “it’s difficult” and “everything breaks...
This is an article about references and looking for clues. I originally wanted to title this article “Dude, Where’s My Code” but I had a feeling that:
A: Not many would catch the 1990’s movie reference.
B: I never actually saw “Dude, Wher...
T-SQL supports distinct grouped aggregate calculations like COUNT(DISTINCT ), but as of SQL Server 2017 CTP2, it doesn’t yet support distinct windowed aggregate calculations. There’s an open connect item requesting this feature. In this article...
We have entered a brave new world of computing when it comes to the Microsoft Data Platform. It has only been a few years when the running joke in the (then) SQL Server Microsoft MVP Community was essentially the point in time when SQL Server r...
