IRL #8: SQL Server Down
Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...
2023-09-06
47 reads
Temporal Table Data Fixes
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
612 reads
SQL Server is not a Car
Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...
2023-09-05
49 reads
SQL Homework – September 2023 – Time for temporal tables.
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
419 reads
Connecting to SQL Server Database Engine, simplified
One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we can respond quickly to...
2023-09-05
125 reads
BotChat BiWeekly 1.00.00
Hey there, I’m Mala. I’ve been in the data game for a good 25 years, first as a DBA and then as a Data Engineer, mainly working with Microsoft...
2023-09-04
73 reads
The PASS Data Community Summit On Guy in a Cube
I’ve known Adam and Patrick for a long time and I’m thrilled with the content they produce on their Guy in a Cube show. It’s a great resource for...
2023-09-04
28 reads
Mastering Data Engineering with Databricks: Your Path to Becoming a Data Engineer Associate
Introduction
In today’s data-driven landscape, skilled data engineers are the backbone of organizations, driving insights from vast data streams. If you’re aspiring to become a Data Engineer Associate and harness...
2023-09-04
62 reads
How to Secure SQL Server
Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...
2023-09-27 (first published: 2023-09-04)
414 reads
Yet another kind of orphan users in SQL Server
Yet another kind of orphan users in SQL Server
Or YAOU for short. (This silly acronym, I just made it up so don’t try...
2023-09-25 (first published: 2023-09-02)
1,251 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