Reblog: SSIS Performance Testing

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...

SQLKonferenz in Darmstadt: Vorstellung der Security Features von SQL Server 2016 mit dem Leiter des Security-Teams aus Redmond

Azure SQL Database Error

I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...

DocumentDB Tutorial 2 – Working with Documents

Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...

Flash sale – Discount for Chicago SQL Saturday Precon – This Afternoon Only

I’m running a flash sale discount for my upcoming Chicago SQL Saturday Precon called ‘SQL Server Infrastructure Tuning for Availability...

Limiting Database Permissions for DLM Dashboard

I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues,...

The Easy Phone Restore

This is hardware week for me, with a new phone coming in the mail. This was a warranty replacement for...

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...

Azure SQL Database security

Life we be so much easier if we could just trust everyone, but since we can’t we need solid security...

CONVERT and HEX

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