SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Blogs
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups […]
Backing Up MySQL Part 2: Percona XtraBackup
There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […]
Optimizing MySQL: The Basics of Query Optimization
MySQL is a very interesting beast to deal with – both junior developers and expert database administrators […]
The PASS Data Community Sessions I Am Most Excited For
Note: Edited to add more sessions… So many The PASS Data Community Summit is coming up in […]
Going to the PASS Data Community Summit this year?
We are just one month away from the PASS Data Community Summit. One month. If you haven’t […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM
SELECT CASE WHEN 1 = NULL THEN ‘True’ Else ‘False’ end, CASE WHEN NOT(1 = NULL) THEN […]