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 […]
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 […]
Getting all values when input parameter is NULL and still get IX seek behavior!!
Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in […]