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...

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 Stickers–Someone Should Build It

Here’s a niche idea that someone might have some fun with, build a site where someone can request some or...

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...

SmartPaster

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

Introduction to XML DML (Part 3) - Using the modify() method: delete

This is the last part of a 3 part blog which will attempt to show some different ways of how...

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 Virtual Launch

Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.

You can register the event by using the...

CHECKSUM vs HashBytes

Hashing can be useful in Data Warehousing  as well  It can give you the ability to break large problems into...

SSAS: Currency Conversion Using Measure Expressions

Currency conversions can be implemented several ways as part of a business intelligence solution.  In some scenarios it may be...