Notes from the January 2016 MagicPASS Meeting

I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...

Overview of Published Articles – 2015Q4

Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...

Power BI Export Data

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

The SQL Server Security Model, Part 1: Logins [Foundations Friday]

How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...

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

Using Change Tracking in SSIS

Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...

What Do You Want?

It’s that time of year, planning for PASS Summit 2016.  We’ve already put out the Call for Volunteers, which closes...

All about the Change

The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you...

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

Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks

There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...