Classing Up SSMS is as Easy as 1, 2, 3.
25 Comments
Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: And presto, no one will ever again question whether or not you know what you’re doing.
Read MoreHumor
Drawing Entity Relationship Diagrams with Stable Diffusion
Documenting your database and code is such a pain in the rear. Wouldn’t it be awesome if artificial intelligence could help? Good news! There are a bunch of AI systems like Stable Diffusion and DALL-E that will draw things based on your text prompts. Forget the slow, tedious task of sketching out the relationships between your…
Read More
Tweets You Missed
You don’t follow me on Twitter because you’re not on Twitter, and I can’t say that I blame you. It’s a bunch of people yelling at each other. Come to think of it, I’m not even sure why *I’m* on there. But anyway, here are a few things I’ve said on there lately that you’ll…
Read More
You Captioned This Pic and Won Free Stuff.
Last week, over 600 of y’all captioned this picture, and we had a lot of laughs: My favorite caption overall was from Aart Bluestoke, who won a Live Class Season Pass for this: The funniest part to me was that I’ve had that exact experience several times with several different data type combinations, and I think…
Read More
Contest: My Favorite Caption Wins a Live Class Season Pass
Update 2021-05-24: the contest is over, and the winners are here. Let’s have a few laughs this week. In the comments, write a caption for this: Prizes: My favorite caption overall wins a Live Class Season Pass Runners-up get both a Recorded Class Season Pass: Mastering Classes and Recorded Class Season Pass: Fundamentals Classes Honorable…
Read More
Query Store is the Flight Data Recorder. It’s Obvious What We Need Next.
When Microsoft brought out Query Store, they wrote: Similar to an airplane’s flight data recorder, Query Store collects and presents detailed historic information about all queries, greatly simplifying performance forensics by reducing the time to diagnose and resolve issues. I have a straight face under here, for real It certainly works, making it easier for…
Read More
What SQL Server Feature Do You Wish Would Go Away?
I asked a two-part question on Twitter: if you could only remove one feature from SQL, why would it be cursors? If you could only remove one feature from SQL, why would it be cursors? — Brent Ozar (@BrentO) January 20, 2021 The responses were great: Auto-shrink does not agree — Warner Chaves (@warchav) January…
Read More
New Music Friday: Killa DBA’s New Release Just Dropped
Familiar readers will know that I don’t actually do New Music Friday here very often. Okay, ever. I don’t do it ever. Because frankly, nobody writes music about us. Nobody except Homer McEwen, aka Killa DBA (YouTube – @KillaDBA). You may remember him from The SQL Server 2017 Song, and if not, you should go…
Read More
Poor Man’s Resource Governor: Database-Scoped Configurations
Let’s say you had report queries that were going wildly parallel, and you wanted to put a stop to it, but you couldn’t afford SQL Server Enterprise Edition. You could do is create databases with different MAXDOP settings: CREATE DATABASE [MAXDOP4] GO USE [MAXDOP4] GO ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 4; GO CREATE…
Read More
Bad Idea Jeans: Building Big Query Plans
When you build a monitoring tool that sends advice via email, you discover two things: Some people have really, really big execution plans Email servers have reasonable limits on file attachment sizes Add those two things together, and Richie found himself working on a new feature for SQL ConstantCare® that would automatically break up advice…
Read More
What Does This Button Do? Wrong Answers Only.
One of my favorite memes is Wrong Answers Only, where you show something and people have to answer incorrectly, like this and this and this. So now it’s your turn: you’re in SSMS, you right-click on a database, and go into Tasks: What does that bottom right task do? Wrong answers only.
Read More
So, uh, you can, like, draw me in SSMS.
Adrian Sullivan and Michael J. Swart have way too much time on their hands, because Adrian just posted this T-SQL gist, which draws … me: It uses the spatial results feature in SSMS. My mind is blown. I’m totally going to use that in a demo. Thanks, Adrian! I’m already envisioning all kinds of crazy…
Read More
Brace Yourself for These 9 Database Horror Stories
Last week, I asked for your worst database horror stories. Hoowee, did you deliver. Make yourself a nice cup of cocoa, gather around the campfire, and listen up for these terrible tales. Illustrations courtesy of Swear Trek (not safe for work.) The mistake we’ve all made Russ did an update without a where clause, but…
Read More
Contest: What’s Your Worst Database Horror Story?
At SQL Intersection in Orlando last week, a few of us were sitting around a table talking shop. One thing led to another, and as so often happens at conferences, we started talking about our worst scars from database misfortunes. That got me thinking – I could kinda bring that fun experience to y’all here…
Read More
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Server 2000 Service Pack 1, and it hit me…these bugs…
Read More
One Hundred Percent CPU
Raise Your Hand If You’ve ever wanted to play a prank on your co-workers, but just didn’t have a any ideas that didn’t involve exploding Hot Pockets. Now you have something even less safe than molten cheese squirts! A stored procedure that pushes CPUs to 100%. All of’em. Transact-SQL CREATE OR ALTER PROCEDURE dbo._keep_it_100 AS…
Read More
300 Blogs And Running
Why Bother Blogging? I blog primarily because there’s a Certain Kind of Person that irks me to no end. The kind of person who: Withholds information (you wouldn’t understand anyway) Mocks people for not knowing what they know (oh, you silly things) Uses the people they mock to validate their necessity (you’d be lost without…
Read More
Stupid T-SQL Tricks
Presented without comment: Transact-SQL CREATE TABLE dbo.[FROM] ([SELECT] INT, [WHERE] INT, [LIKE] INT); GO SELECT [SELECT] FROM [FROM] WHERE [WHERE] LIKE [LIKE]; GO 1234 CREATE TABLE dbo.[FROM] ([SELECT] INT, [WHERE] INT, [LIKE] INT);GOSELECT [SELECT] FROM [FROM] WHERE [WHERE] LIKE [LIKE];GO Next up, can you break up a query with spaces? Yep: Transact-SQL SELECT * FROM…
Read More
Stuff People Tell Me Is The Default
Playing The Odds Assuming that life carries on as usual for a couple more weeks, I’ll have been a consultant here for three years. In that time, I’ve had some really interesting conversations with people, mostly about why things are the way they are on their servers. My favorite response is “isn’t that the default?”,…
Read More
Today’s Press Conference Transcript: I’m Running for Database Administrator General
Thanks for joining me today – I know you reporters are all really busy, and I appreciate you taking the time to attend this press conference. I’d like to start off by formally announcing my candidacy for Database Administrator General. There’s a lot of great candidates out there, but I think it’s time for me…
Read More