Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
6 reads
Bert Wagner
Time Zones and Daylight Saving Time
Watch this week’s episode on YouTubeAT TIME ZONE is great because it makes it easy to perform daylight saving time and...
2019-03-19 (first published: 2019-03-05)
9,255 reads
Time Zones and Daylight Saving Time
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
7 reads
Time Zones and Daylight Saving Time
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
33 reads
Searching Complex JSON Data
Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...
2019-02-26
929 reads
Searching Complex JSON Data
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
9 reads
Searching Complex JSON Data
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
18 reads
COUNT, DISTINCT, and NULLs
Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...
2019-03-05 (first published: 2019-02-19)
3,556 reads
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
17 reads
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
12 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers