My wife and I got the kids a Beagle puppy from a local pet shelter for Christmas, so this holiday was extra special. 🙂

Hey, the days leading up to Christmas is the perfect time for team leads to schedule deployment requests. That way, if something goes wrong, the DBA will have plenty of...

You're already importing the source text files using SSIS anyhow, so I agree with others that you should do this transformation using a "derived column" or "import column transformation" task....

Look at this from different angles, I'll start by saying that the DBA should own the database. She should should be the smartest guy in the room when it comes...

One thing that most all data breaches have in common is that it involves data access patterns that are not typical. The hacker must poke around, exploring for vulnerabilities, and...

RegEx is useful, particularly for ETL, but from the perspective an application, having the data in a normalized and index-able format is more useful. A discussion came up a few...

Here is a portion of the execution plan:

After examining Query Store, I have determined the following update statement is the source for the sample error above. It's performing an UPDATE/JOIN between a staging table and the production...

OK, here I will restate the problem, this time with less obfuscation, except for the actual data values involved.

Here is a sample error. 

Cannot insert duplicate key...