To AutoGrow or not?

Note: This is a repost of an older blog by Sean that’s still applicable. We’ve updated it with a note...

Cleaning Your #PowerBI Power Query Code

Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve...

SSIS Catalog – Path to backup file could not be determined

I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...

An interesting setting for NULL but don’t use it for future TIP #109

As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for...

A big issue when try to Alter user define table type structure TIP #108

 
I hope all of you aware of  User define table type (a table value parameter) which we discussed earlier in...

HealthySQL – A Review

A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:

My Book Contributions November 30, 2018

Profiler for Extended Events: Quick Settings March 5, 2018

How to be...

HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...

SQL Sentry Grows in the UK and Beyond

Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...

Another Career Podcast – Working at Microsoft

I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...

Twitter Analysis with #PowerBI & Plus One

Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...