What is DBCC?

If I ask you what is DBCC, what would your answer be?
I want you to think about that one for...

Using Qure Profiler To Benchmark Tuning Progress

the problem of monster views

I’ve been working with tuning an application that performs a lot of Entity framework calls,...

Generating Estimated Plan and the Plan Cache

Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.
 
What? Still here? You want more?...

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...