MySQL supports pattern matching using regular expressions with REGEXP. I show how to use ^, $, | and square brackets to match values in a table.
SQL SERVER – What is the Difference Between Latches and Locks
What is the difference between latches and locks? Latches guard a page only during the physical operation, while locks last for the whole transaction.
SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running
The default instance uses port 1433, but what about a second instance on the same box? Here is how to find the port SQL Server is listening on.
SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full
Could not allocate space for object because the PRIMARY filegroup is full? I hit this error on my laptop, and here is how I resolved it.
SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019
SSIS data flow problems look simple but are hard to fix. In part 1, Andy Leonard explains how to troubleshoot the SSIS Data Flow Task.
MySQL – How to do Straight Join in MySQL?
How does a straight join in MySQL work? STRAIGHT_JOIN is like an INNER JOIN but always reads the left table first. Here is a simple items and sales example.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.