By Lori Brown | Lunch And Learn , SQL Server
Please join SQLRX’s Lori Brown and the SQLRX team at the Microsoft Campus in Irving, Texas this coming Wednesday November 16, 2016 for an informative take on reasons to upgrade to SQL Server 2016. Register Now! There are a lot of really good reasons to upgrade to SQL 2016. Even if you’re still on SQL 2008 […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah The dynamic management view sys.dm_server_registry has been around since SQL 2008 R2 SP1 so it is not new but it’s relatively new to me. Since I have a ton of SQL Servers to monitor, it is always good to have some way of easily knowing if there are any start up […]
Continue readingBy Lori Brown | Expert , SQL Administration , SQL Maintenance , SQL Server
— by Lori Brown @SQLSupahStah Recently, I was checking on some of the servers that I manage and found that one had an 8GB msdb database. While that is not too bad it is kind of large so I figured that there must be something that needed to be cleaned up. I ran the Disk […]
Continue readingBy Lori Brown | Beginner , Helpful Scripts , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Periodically, all DBA’s are going to run into code that fails due to a deadlock. Deadlocks happen when two or more SPIDs\sessions try to access a resource that is locked by each other. In short, something has to give so one is usually chosen by SQL to be the victim […]
Continue readingBy Ginger Daniel | Beginner , SQL Administration , SQL Server
–by Ginger Keys Recently I had a client who, after speaking with their software vendor, became overly fearful of their database log files growing too big and taking up all of the disk space on their server. The software vendor is apparently used to having clients that don’t have a DBA on staff, and made […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , Perfmon , SQL Administration , SQL Server
–by Ginger Keys Recently, a client of mine contacted me in a panic because CPU was running at 99-100% over an extended period of time, which was affecting everything on the machine. We’ve all seen it at one time or another. And there are several reasons this could be happening. It could be SQL consuming […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah If you are the usual DBA, you are often the last person to know when something new has been added to the databases you are managing. After finding that some people in an organization were abusing their access to a certain database, I decided to create a TSQL DDL trigger […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Since I manage several SQL clusters, I came up with a way to get a notification that the cluster may have failed over. This failover notification was created in self-defense because often times no one from the system administrators team will tell the DBA when work is being done or […]
Continue reading