MySQL TinyInt treated as Boolean

When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the...

Excel in T-SQL Part 1 – HARMEAN, GEOMEAN and FREQUENCY

Today’s blog will be the first in a multi-part series on replicating Excel functions in T-SQL, starting with HARMEAN, GEOMEAN...

Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller

This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...

Using SSIS Lookup Transformation in ETL Packages

Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of...

Are You Backing Everything Up?

We hear the common refrain among DBAs all the time. Back up your data! Test your restores! If you can’t restore the backup, it’s worthless. And yes, absolutely, you...

Restoring a database that doesn't exist

When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't...

Restoring a database that doesn’t exist

When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t...

A Tale of SQL Server Disk Space Trials and Tribulations

#SQLNewBlogger
Details:

System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the...

Using PowerShell to Export SQL Data to CSV. How well does it perform?

So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following...

Windows Temporary Profile

Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc...