Epic Life Quest – 2020 Update
I started keeping a written record on bigger goals in life from the year 2018 – following the example set by Steve Jones and Brent Ozar. This method of...
2020-01-06
20 reads
Blog Posts
Getting most recent transaction log backup time irrespective of where the transaction log backup is performed in always on availability groups
Most recent transaction log backup in always on availability groups
I should mention outright...
2020-01-06
75 reads
Undercover Catalogue 0.4.0 Released
We’re pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of...
2020-01-06
30 reads
Unicode, Emojis and Databases Oh My!
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
274 reads
Unicode, Emojis and Databases Oh My!
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
3 reads
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2020-01-06 (first published: 2019-12-13)
567 reads
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
120 reads
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
19 reads
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
5 reads
Checking SSIS Variable Values During Runtime
As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...
2020-01-03 (first published: 2019-12-21)
1,120 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