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
541 reads
RealSQLGuy - Helping You To Become A SQL Hero
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
905 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,253 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
374 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
421 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,310 reads
Blogs
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time...
Copilot Outside of SSMS Seems to Work
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
A New Word: Falesia
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
Forums
Question about updating statistics
We have very large tables in our database, some even more 1 B records,...
What tool or tools do people like for monitoring SQL servers?
I have a few tools at my disposal but none of them seems like...
Question of the Day
A Basic Data API Builder ADD
What parameters are required for the dab add command in the Data API Builder?
See possible answers