-
The Relativity of Server Health
A few weeks ago, my wife reminded me of a doctor's appointment for a quick checkup. I don't enjoy having to go to the doctor, but it's important, so I didn't complain much. I was feeling great on the day of the appointment. I had no cough, no sniffles, or sore throat. I figured I would be out of there in 10 minutes with…
-
T-SQL Tuesday: Shiny New Toys
This month's T-SQL Tuesday - hosted by Matt Gordon (@sqlatspeed) - is called "Fixing Old Problems with Shiny New Toys." Matt wants us to write about how we've solved old problems in new ways afforded by enhancements to SQL Server (or new features anywhere in the stack, I would guess). Over the years I have helped a lot of…
-
T-SQL Tuesday: My Favorite Connect Items
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." This is a topic near and dear to my heart; for several years I was a huge proponent of the Connect system. For a while, I even published weekly digests, where I highlighted bugs and feature requests that I thought deserved more eyeballs and…
-
T-SQL Tuesday: Sorting a Stacked Chart
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." My T-SQL Tuesday post is about a request for Power BI, which may be a little on the edge of SQL Server as far as T-SQL Tuesday goes. I want to talk about a limitation when sorting a Stacked Chart. As I mentioned in my previously, I started to…
-
T-SQL Tuesday: What the Heck is Wrong With My String/Binary Data?
This month's T-SQL Tuesday is hosted by Brent Ozar (b/t), and is about those wonderful Connect requests that we want fixed/added in SQL Server. Aaron Bertrand (b/t) reminded me of one of my all-time favorites. You know when you started working with SQL Server and you'd get error messages that you couldn't figure out? One…
-
SQL Sentry and SQL Server Agent Jobs
There are so many cool, exciting new features in SQL Server these days! Polybase, Query Store, R Services, Stretch Databases, and the list goes on! This post isn't about any of those. SQL Server Agent jobs aren't new or cool or sexy, but I honestly don't know what I'd do without them. I remember a few years back I was…
-
Advisory Conditions: Available Actions
SentryOne Advisory Conditions provide a powerful and flexible solution for monitoring environments across a diverse range of situations. This post focuses on the available actions and alerting options for Advisory Conditions. As shown below, the options for available actions are as robust as the conditions themselves. To…
-
Customizing Your Alert Emails in SQL Sentry
SentryOne has some of the most robust and dynamic alerting capabilities in our market. Out of the box, we provide a number of options for responding to virtually any type of condition, and these are by no means limited to sending an email: Still, email is one of the more popular options, and we get the occasional question…
-
SQL Sentry Plan Explorer 3.0 Demo Kit
Last month we released the new, all-free, Plan Explorer 3.0, and now seemed the right time to follow that up with the 3rd version of the demo kit, too. Please consider earlier versions of the demo kit deprecated; I won't remove them, but I will add a note to those pages soon. Now, you might ask, "What is a demo kit?" We…
-
Send SQL Sentry Alerts to Your Phone
From time to time, we’ve gotten questions on whether it is possible to send the alerts generated by SQL Sentry to cell phones in the form of a text message. The short answer is yes, with the use of SMS/MMS gateways. The not so long answer is this blog post . The process of getting alerts on your phone involves the use of…