Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
399 reads
Blog Posts
Monday Coffee 2017-05-15
After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the...
2017-05-15
384 reads
SQL Saturday Atlanta Precon – The Complete Primer to SQL Server Virtualization & Cloud
If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session...
2017-05-15
383 reads
SQL Server 2017 – The operating system returned the error 21
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,664 reads
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,560 reads
Trying GO with SQL Server
Not the batch separator, but the GO language.
I’m always interested in learning new things, and GO has been one of...
2017-05-15
1,124 reads
Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,273 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
487 reads
Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
290 reads
Friday Reading 2017-05-12
The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been...
2017-05-12
395 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers