I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
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 […]
Tracing Analysis Services – the trace that won’t stop
I am currently facing an issue where profiler is running a trace on SSAS and the trace can’t be stopped from within SSMS profiler since it keeps throwing […]
administration / Database / MSSQL / TSQL
The Log buffer – improving performance for write log activity
The log buffer is the space in the memory where transactions are written to before they are committed to disk. The size of the Log buffer pool is […]
administration / Database / MSSQL / TSQL
Script to Enable and use CDC in MS SQL Server
Recently at a training I was asked about CDC and while this script is old and previously published I couldn’t find it within the blog after I migrated […]