Since Azure SQL databases are limited in what they expose to the management studio client we miss out on a lot of features within SSMS that we could […]
administration / Database / MSSQL / TSQL
Set based vs row by row (procedural code)
I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide […]
Calculating Pi in MS SQL Server
PI is a very commonly used mathematical constant, in fact it is probably more famous than the equation E=MC2. We might not find a lot of use for […]
administration / Database / MSSQL / TSQL
Actual vs Estimated plan and the use of Time to arrive at the best plan
I came across a comment on linkedin today about the difference between the actual and estimated execution plan in SQL Server and how it is used to determine […]
Word Cloud on Second Presidential Debate :- SSIS and PowerBI
With the recent debates on the US presidential election we felt it presented a good opportunity to do some text analytics on the second presidential debates. We used […]
administration / Database / MSSQL / TSQL
Plan reuse for conditional statements in MS SQL Server
I was asked this question the other day on linkedin and figured it might be good to write a post on it considering the confusion around the topic. […]
Creating subfolders within SSAS
Recently there was a requirement for organizing columns from certain dimensions into individual entities within the presentation layer of powerview and powerbi. The approach that was taken was […]
Interview Questions – Which TCP/IP port does SQL Server run on? How can it be changed?
This is the first of a series of posts where I cover common Interview questions in MS SQL Server in detail. Why? Some questions are not framed properly […]
It depends …. Really?
I have never been a fan of the answer “it depends”. In fact I often go out of my way to prove that there is more to SQL […]
An Overview of the tools SQL Server database professionals use
Recently I was asked what tools database professionals use and I wanted to clarify a little bit on the topic so here goes. Previously we used to have […]