Giving Back to Speakers
It might be hard to think back to 2007, but at that time, there were only a few SQL Server events taking place in the world. SQL Bits held...
2020-07-24
51 reads
Blog Posts
How to Spell and Capitalize tempdb for SQL Server
No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...
2020-07-24 (first published: 2020-07-15)
628 reads
Saving My Garmin Data
With the Garmin outage, I was a little worried about my data. As a result, I wanted to ensure I could get information off of my device and at...
2020-07-24
57 reads
T-SQL Tuesday #128–Learning From Others
It’s the second Tuesday of the month and time for T-SQL Tuesday again. This month I’m grateful that Kerry Tyler is hosting. I had the pleasure of sitting with...
2020-07-24 (first published: 2020-07-14)
488 reads
Daily Coping 23 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-23
5 reads
Power BI Monthly Digest – July 2020
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-07-23 (first published: 2020-07-15)
461 reads
Setting up a New SQL Change Automation Project
It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...
2020-07-23 (first published: 2020-07-15)
1,054 reads
Tonight is the PASS Marathon on SQL Server Performance
The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...
2020-07-23
21 reads
Daily Coping 22 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-22
15 reads
Moving 1/3 of a heap
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
15 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers