Synapse database templates info and tips
I had previously blogged about Azure Synapse Analytics database templates, and wanted to follow-up with some notes and tips on that feature as I have been involved on a...
2022-09-13
28 reads
Blog Posts
T-SQL Tuesday #154–Thinking about SQL Server 2022
This month is an interesting T-SQL Tuesday party, as Glenn Berry hosts and asks us to think about the upcoming new release of SQL Server. Sometime later this year,...
2022-09-13
382 reads
Daily Coping 12 Sep 2022
Today’s coping tip is to forgive yourself when things go wrong. A theme of being better to myself, starting with last Thur and Fri. What’s gone wrong for me?...
2022-09-12
19 reads
How to keep up with technology
(Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they...
2022-09-12 (first published: 2022-08-29)
413 reads
SQLpassion Live Training about SQL Server Availability Groups
On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had...
2022-09-12 (first published: 2022-09-05)
181 reads
Daily Coping 9 Sep 2022
Today’s coping tip is to let go of self-criticism and speak to yourself kindly. This tip follows on nicely from yesterday’s tip, just the other side of that one....
2022-09-09
12 reads
How To Linux: A Windows Administrator’s Guide to Linux for the Newbie
Well, it’s long overdue that I left the comfort of my Windows GUI and ventured into the world of Linux. Mind you I have dabbled a very little bit...
2022-09-09 (first published: 2022-08-29)
506 reads
SQL Saturday Baton Rogue Recap
Thank you to everyone who came out and saw me present at the SQL Saturday in Baton Rogue! It was a blast to see smiling faces and not be...
2022-09-09 (first published: 2022-08-23)
123 reads
Daily Coping 8 Sep 2022
Today’s tip is to notice the things you do well, however small. I think I have a lot of room for improvement, and it’s easy to self-criticize and find...
2022-09-08
18 reads
A simple lab to demonstrate the danger of NOLOCKs in INSERT statements
The READ UNCOMMITTED isolation level, which the NOLOCK table hint activates, is not to be trusted when it comes to writing data. You are not always protected by error...
2022-09-07 (first published: 2022-08-25)
552 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers