-
T-SQL Tuesday: Managing an Enterprise
This month’s T-SQL Tuesday is hosted by Jen McCown (b|t), and is on strategies for managing an enterprise. My first job as an actual SQL Server DBA was for a local hospital. Between two of us we were responsible for about 90 SQL Server instances, including the backend databases for the Electronic Health Record system and…
-
T-SQL Tuesday: Models Gone Wild!
November's installment of T-SQL Tuesday, hosted by Mickey Stuewe (@SQLMickey), has nothing to do with Zoolander or Gisele Bundchen. The topic is "Data Modeling Gone Wrong," and since I'm old and grumpy, I've seen a lot of data modeling sins over the years. I tend to share a lot of my war stories in sessions I deliver in…
-
How to Reduce Latency and Boost SQL Server Performance
When it comes to frequent performance bottlenecks on SQL Server, few are as frequent or as problematic is I/O latency. Relational databases, by their very nature, perform a great deal of I/O both to support the ACID properties of transactions as well as to cache the most frequently used data and code for maximum…
-
Custom Conditions: A Logical Choice
If you are not familiar with Custom Conditions in SQL Sentry, we'll be doing a deep-dive into the Boolean operations which power the checks. Be warned, this is about to get a little nerdy. Table of Contents * Single Step Conditions * Two Step Conditions * Boolean Operators* And * Or * Not And * Not Or * Multiple Step…
-
Index Analysis
When @jason.hall mentioned a new version, I will admit, I had some goosebumps. I knew that a new module that we had been working on for many months was finally going to see some daylight. Nothing is more exciting than once again blowing the doors off the native tools and providing you with another feature that helps you…
-
Using Azure Automation to Pause SQL Data Warehouse
Continuing on with the theme of automation in Automating Large SQL Sentry Installations , I wanted to take a few minutes and talk about Azure SQL Data Warehouses (SQLDW). Back in November, with the release of SQL Sentry v9, we added support for monitoring SQLDW. SQL Sentry Azure SQL Data Warehouse Dashboard Part of my…
-
T-SQL Tuesday: All Features With Defaults
This month's T-SQL Tuesday comes to us from Andy Yun (@SQLBek) and is themed, "Just Say No to Defaults." I'm sure a lot of entries will come out talking about some of the horrible defaults for an instance of SQL Server - data and log files (location, size, and growth settings), min and max server memory, cost threshold for…
-
T-SQL Tuesday: The "Smoking Man" of SQL Server Defaults
This month's T-SQL Tuesday comes to us from Andy Yun (@SQLBek) and is themed, "Just Say No to Defaults." Flawed Defaults? It Depends Going with the defaults is a big deal, and in most situations where performance matters, it is a BIG MISTAKE. So much so, that I've listed it as one of the Top 10 DBA Mistakes since the very…
-
T-SQL Tuesday: Just Say No to Defaults
This month’s T-SQL Tuesday is hosted by Andy Yun (b|t), and is on default settings in SQL Server. I have a SQL Saturday session that covers set-up and configuration of SQL Server, so I do talk about default values and why you may or may not want to change them. There are plenty to discuss, but I'm going to cover three of…
-
T-SQL Tuesday: Default Settings for SQL Server Agent
This month's T-SQL Tuesday topic, hosted by Andy Yun (b|t) is "Just Say No to Defaults". Thanks Andy for hosting this month and picking a topic with so many possibilities! Where to Begin? There are a lot of default settings in SQL Server that I, along with most experienced DBAs, routinely change via scripts I have stolen…