New year, new role, and new book
Happy new year to everyone! As I enter my 9th year at Microsoft, I have switched roles, and am now an Industry Advisor in Federal Civilian, helping our Federal...
2023-01-20 (first published: 2023-01-12)
302 reads
Blog Posts
Daily Coping 19 Jan 2023
Today’s coping tip is to switch off tech an hour before bedtime. I read at night often, so this is a challenging one. However, I decided to give this...
2023-01-19
17 reads
Connecting to PostgreSQL from Azure Data Studio
I’ve been doing a bit of work with PostgreSQL as part of my work with Redgate. PostgreSQL is a relational platform that is open source, free to use, available...
2023-01-18
57 reads
Daily Coping 17 Jan 2023
Today’s coping tip is to get moving. Ideally do something outside. Taking time to walk the dogs outside, heading to the dog park to get them, and me, some...
2023-01-18
12 reads
Daily Coping 18 Jan 2023
Today’s coping tip is to say positive things to the people you meet today. In general, I don’t encounter a lot of people on any day, but I do...
2023-01-18
5 reads
Heading Back to VS Live in March 2023
I’m speaking at VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel a new place for me. I’m...
2023-01-18
14 reads
Help! My tempdb is full and I can’t access SQL Server!
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,086 reads
Microsoft SQL Server Management Studio Error
I came across an issue with SSMS not loading properly recently. Regardless of launching from the start menu with or without administrator, SSMS would error out. Due to this...
2023-01-18 (first published: 2023-01-09)
503 reads
SQL Bits 2023
I’m honored to be heading back to SQL Bits 2023. I was selected to deliver one session, in the professional development track. With so many people submitting, I’m not...
2023-01-17
23 reads
Daily Coping 16 Jan 2023
Today’s coping tip is to learn something new and share it with others. I do this all the time. It’s a part of my job, and I did this...
2023-01-16
10 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers