Deploying your SSIS Packages in SQL Server 2008

Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a...

Flexible Fiscal Data Sort

Flexible Fiscal Data Sorting
A few months ago, I faced the challenge of extracting data via SQL Queries (for our enterprise),...

More on SQL Server Built-In Cryptography Options

I wrote a series of articles at MSSQLTips.com to cover the cryptographic algorithms that are available with Microsoft SQL Server....

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for 24 hours of PASS, PASS Summit Preview.  The abstract...

Reblog: July 26 to August 1

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Review: The Phoenix Project

Back in April Steve Jones mentioned reading a review of The Phoenix Project by mutual friend Thomas LaRock. It’s a...

Speaker of the Month, August 2013

I’m trying out a new blog post series, mostly for myself as an exercise. I’m going to pick one speaker...

70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012

This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...

Baton Rouge SQLSaturday and Tech Day 2013

This will be the fifth SQLSaturday and Tech Day in Baton Rouge, LA on Saturday August 3rd, 2013.

I found a...

How Will Your Product Fare Over Time?

I like to look at things that have been in use for a while to see how they hold up....