SQL Server Restore to LSN

For this post I want to show you how I recovered to a LSN where I did do this on...

Two Weeks to Live! 360 and VSLive Orlando

A short break in speaking, as I haven’t been on stage since Oct 11.

Now it’s two weeks to Live! 360...

XmlReader vs XmlDocument Performance

Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...

Configuring Integration Services in a SQL Server 2016 Cluster

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.Clustering Integration Services is...

Escaping a Dollar Sign in PoSh–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...

PowerShell to Test a Query

So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...

Query tuning 101: How to measure Query Plan I/O cost

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...

Restoring a SQL Server backup on Linux

Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...

SQL Server & Containers – Part Two

This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since...