T-SQL Tuesday #69–Encryption

This is a good T-SQL Tuesday topic for me. This month Ken Wilson asks everyone to write on encryption, which...

What is DBCC?

What is really mean by DBCC and what do people mean when they say DBCC?
Related Posts:

Database Corruption and IO Errors January 18, 2018

Common Tempdb Trace Flags - Back...

What is DBCC?

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

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

Iterate Over Web Pages Using Power Query

Power Query makes it easy to pull data from a web page. As easy as deflating a football. Poof. Gone. However,...

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

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

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

#PowerBI and #SSAS Tabular: A Natural Fit with the Power BI SSAS Connector

In late June last month, the Microsoft Power BI team released the Microsoft Power BI Analysis Services Connector. The Power...