T-SQL Code Coverage in SSDT using the SSDT Dev Pack

Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...

T-SQL Code Coverage in SSDT using the SSDT Dev Pack

Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...

Power BI Export Data

If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...

Learning R: Hitting the Books

I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...

Verifying Instant File Initialization

Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...

Basic Windows Administration through Powershell

Hi Guys,

In the previous blog I took you through PowerShell basics We know that PowerShell to works with different modules...

Verifying Instant File Initialization

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...

Parallelism setting in SQL Server – reduce CXPACKET waits?

This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J

Let’s...

Managing Change Data Capture T-SQL Tuesday #74

T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)
The topic for T-SQL Tuesday #74 is...

T-SQL Tuesday #74–The Changes

It’s T-SQL Tuesday time, the monthly blog party on the second Tuesday of the month. This is the first T-SQL...