Query Store Data Cleanup
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
280 reads
Daily Coping 6 Feb 2023
Today’s coping tip is to get back in contact with an old friend. This is something I don’t do too often, but I have done a few times. I’ve...
2023-02-06
17 reads
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security...
2023-02-20 (first published: 2023-02-06)
304 reads
Daily Coping 3 Feb 2023
Today’s coping tip is to ask other people about things they’ve enjoyed recently I asked the question on Twitter and on Facebook, looking for interesting responses from friends. The...
2023-02-03
12 reads
Daily Coping 2 Feb 2023
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m struggling with some negative thoughts outside of work. This year as I coach older girls,...
2023-02-02
15 reads
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
145 reads
Why Managed Identities are Awesome
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
524 reads
Goal Progress for Jan 2023
The grade for January is a D. Details below, but just not making a lot of progress in these areas. I set goals at the beginning of the year,...
2023-02-01
21 reads
Context Info Across Databases–#SQLNewBlogger
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
215 reads
Introducing… Data On Rails!
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...
2023-02-01
33 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
ALAMAT BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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