The Scary DBA

Blog Post

Query Store Reports Time Intervals

A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...

2023-11-24 (first published: )

225 reads

Blog Post

Why Put PostgreSQL in Azure

I’ve had people come up to me and say “PostgreSQL is open source and therefore license free. Why on earth would I put PostgreSQL in Azure?” Honestly, I think...

2023-05-17 (first published: )

229 reads

Blog Post

ChatGPT Lied To Me

I’ve been seeing more and more noise about how ChatGPT can help with technical stuff, writing code, all that. Well, I wanted to know how best to set up...

2023-04-21 (first published: )

795 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

how to remove trailing zeros?

By water490

I have this calculation I have in a script: ROUND(T3.NUM_POINTS * 1.0 / T4.TOTAL_RECORDS...

Deciphering Data Architectures

By Additional Articles

Comments posted to this topic are about the item Deciphering Data Architectures

Learn T-SQL Querying

By Additional Articles

Comments posted to this topic are about the item Learn T-SQL Querying

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers