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 […]
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 […]
Cannot get the column information from OLE DB provider
Cannot get the column information from OLE DB provider “Microsoft.Ace.OLEDB.12.0” for linked server “(null)”. Encountered this little gem while performing a migration today. Turns out the SQL Server […]