ssms

One weird trick for managing a bunch of servers

Last Updated April 28, 2016

Let’s face it, most people don’t have just one SQL Server How many they tell Microsoft they have is another matter, but let the record show that I don’t condone licensing dishonesty. But going one step further, most places… Well, they’re ‘lucky’ if they have one DBA, never mind a team. Everyone else: Give me…

A funny thing happened on my way to set up Mirroring…

Last Updated February 9, 2017

Erik Darling

Database Mirroring, SQL Server

I’ve set up Mirroring about a billion times I’m not bragging about that. I’d rather say that I set up a billion AGs, and not one of them ever failed. But then I’d be lying to you; those things fail like government programs. One thing I’d never done, though, is set up Mirroring with a…

An Update to SQL Server Management Studio is Available

Last Updated July 3, 2015

Brent Ozar

SQL Server

That’s the message you get in your tray if you open SSMS 2016 today: SSMS Update Available Then click Tools, Check for Updates, and you get: Check for Updates What’s awesome is that I didn’t even install SQL Server Management Studio from the new standalone installer – this is my full CTP2.1 installation of SQL Server,…

And Party and Alt Shift

Last Updated April 14, 2015

Erik Darling

SQL Server

This is a cool SSMS trick I picked up a while back Though not nearly as far back as I wish I had. It’s so cool I made a .gif of it in action. When you’re done putting your socks back on, I’ll tell you how it works. This .gif was brought to you by…

SQL Server Management Studio: More than Meets the Eye

Last Updated November 28, 2012

Jes Schultz

SQL Server

SSMS is the standard tool for working with SQL Server databases. It does the job well. But if you’re using the default settings, you’re missing out! You can enable word wrap and number the lines. Change the settings when you script objects out. Filter through objects. Let Jes guide you through the world of hidden…

Recognizing SQL Server’s Warning Signs

Last Updated November 13, 2019

Brent Ozar

SQL Server

It’s crucial for database administrators to recognize signs of pending doom. Make sure you’re able to quickly spot problems in SQL Server Management Studio by studying these screenshots. Databases that haven’t been backed up in 24 hours Databases with old compatibility levels Databases running out of space on the C drive SQL Server with Priority…