Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
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...
In this article, I focus on adaptive joins. I first demonstrate an example for the classic plan reuse shortcoming with parameter-sensitive queries. I then explain how adaptive joins can alleviate the problem. I also explain how you can enable...
I don’t know about you but I’m a fan of tips and tricks that make my life easier. Here is a quick tip that has saved me numerous times when it’s come to answering the question: “when will that <insert some specific...
The trend toward virtualized computing resources shows no signs of abating. Compute, memory, storage, and operating systems are commonly available on-demand. Code is accessed via Git or other repositories, and can be deployed to automated ...