Some software publishers will add ping back features to their apps, and e-books often contain digital watermarks that are unique to the account that originally purchased the product, so they...

Steve,
Have you ever published an architectural overview for SQL Server Central, similar to what other websites like Stack Overflow and Netflix do?
Also, while the hood is up,...

Performing transformation in the SELECT is OK, but staging the data to a table and then performing UPDATE(s) is a waste of time and disk space.

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