Do You Need A Log Recovery Tool?
A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...
2013-11-04
945 reads
RealSQLGuy - Helping You To Become A SQL Hero
Building The Redneck Treadmill Desk
Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...
2013-11-08 (first published: 2013-11-04)
3,972 reads
sp_BackupDatabases v1.2
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,620 reads
What’s In My Utility Belt? Issue #1
Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”....
2013-10-29
556 reads
SQL Query Formatting – Putting Lipstick On A Pig
“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...
2013-10-24
917 reads
No, Simple Mode Doesn’t Disable The Transaction Log
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,261 reads
One-stop Shopping for Backups
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
381 reads
New Blog Series – Origins
I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the...
2013-10-02
431 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,324 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor Resmi BCA KCP Gorontalo Tlp:08218154393
WA:08218154393 Jl. Nani Wartabone No.293, Limba U I, Kota Sel., Kota Gorontalo, Gorontalo 96111
Alamat Kantor Resmi BCA KCP Ratulangi Tlp:08218154393
WA:08218154393 Jl. Dr. Sam Ratulangi No. 7, Kompleks Ratulangi Office Park Blok A3-A4, Kota...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers