When good enough is good enough
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
49 reads
How to keep up with technology
(Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they...
2022-09-12 (first published: 2022-08-29)
431 reads
AWS RDS Restore To A Point In Time
The single most important part of backups are not backups. The single most important part of backups are restores. It doesn’t matter a lick if you have 100, flawless...
2022-08-29
22 reads
Daily Coping 29 Aug 2022
I 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...
2022-08-29
18 reads
Thinking about data points and more …
(2022-Aug-28) Going on a family vacation road trip always fills me with a myriad of happy emotions and expectations to explore new places, see new people and essentially be led...
2022-09-07 (first published: 2022-08-29)
196 reads
How To Linux: A Windows Administrator’s Guide to Linux for the Newbie
Well, it’s long overdue that I left the comfort of my Windows GUI and ventured into the world of Linux. Mind you I have dabbled a very little bit...
2022-09-09 (first published: 2022-08-29)
533 reads
Daily Coping 26 Aug 2022
I 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...
2022-08-26
30 reads
Daily Coping 25 Aug 2022
I 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...
2022-08-25
25 reads
Explicit and implicit datatype conversions
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
51 reads
A simple lab to demonstrate the danger of NOLOCKs in INSERT statements
The READ UNCOMMITTED isolation level, which the NOLOCK table hint activates, is not to be trusted when it comes to writing data. You are not always protected by error...
2022-09-07 (first published: 2022-08-25)
565 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
DanDan Kavling Polri | WA:083121526888
Kavling Polri, Jl No.1601 Blok F 8, RT.8/RW.02, Jelambar, Grogol petamburan, West Jakarta City,...
Toko Kosmetik Sumber Ayu | WA:083121526888
Pasar Tomang Barat (Pasar Kopro) Lt Dasar Blok B-48, RT.14/RW.5 (depan parkiran motor), Tanjung...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers