Slowly Changing Dimensions

When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make.  It...

Speaking for Baton Rouge UGs and SQL Lunch Next Week

I have been quiet over the past year trying to get acclimated to my new job and my new found work...

Verifying Last Successful CheckDB with Powershell and SMO - sorta

A few years ago, I wrote a script that was published on SQLServerCentral.com about how to verify the last successful...

A Script A Day - Day 2 - Database Mail Troubleshooting

Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...

PowerPivot for Excel Install Issues

At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...

Returning Results from an Insert – OUTPUT clause

I needed to return an identity value recently from an insert for use in another piece of code. For a...

SmartPaster

I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...

Speaking for Baton Rouge UGs and SQL Lunch Next Week

I have been quiet over the past year trying to get acclimated to my new job and my new found...

SQL Server – COPY TABLE from another SQL Server

To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...

SQL server 2012 - NextGen HADR Solution