Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
210 reads
Blog Posts
Running Windows and Linux SQL Containers together
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,883 reads
Speaking at DataGrillen
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...
2019-01-04
15 reads
Speaking at DataGrillen
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read...
2019-01-04
155 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January 12, 2019. I’ve been to Nashville before, in fact...
2019-01-04
10 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
127 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s what I call a gift that keeps on giving....
2019-01-04
11 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s...
2019-01-04
146 reads
Year in Review 2018 – The Year of Making a Difference – Up to 50
Rough Year, But 50 Kids, Can’t Beat That!
Last year was a pretty rough year personally. I totaled two cars, not...
2019-01-04
153 reads
Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
389 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers