A common thing I keep forgetting when I try to import an excel file into PowerBI is the fact that the data in the excel sheet needs to […]
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 […]
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 […]
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 […]
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 […]
administration / Database / MSSQL / TSQL
Improving the performance of functions
Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and […]