SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...

Utility link for excel import to SQL

Utility link for excel import to SQL

Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...

What’s happening in Asia Pacific?

TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.

I...

Azure Data Lake enhancements

I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here).  There are already enhancements, as...

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...

Data Warehouse from the Ground Up at SQL Saturday Orlando, FL on Oct. 10th

SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell...

Fixing MSI errors during patching

Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the...

Load Testing Your Storage Subsystem with Diskspd – Part II

In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...