The Problem You have tables that have a lot of data inserted into them and deleted that use identity values and run out integers to use. I have over 3000+ databases where this can occur so we have an alerts setup that checks the tables then checks a table to
Wow, this year has been really busy. I’ve completely turned into a SQL Saturday addict with 15 SQL Saturdays completed, two more scheduled, and one more potential one to go. I might need an intervention or a 12-step program or I just may continue to have fun and meeting everyone
Problem The last T-SQL Tuesday a lot of data professionals shared their favorite PowerShell scripts including functions, but some DBAs are new to PowerShell and don’t know how to use the functions. So this post will cover how to create a PowerShell module so you can store the functions you
The Problem Our databases autogrow because we have thousands of databases and before we know we have databases with high VLF counts in the transaction logs. If you don’t know why that is bad refer to the resources section of this article. Update – November 5, 2017 I have added
This month Rob Sewell (Twitter | Blog) is hosting T-SQL Tuesday and wants us to automate more with PowerShell or at least learn PowerShell. My favorite thing to automate using PowerShell is checking on the status of things on multiple servers. For example, after patching your environment running a quick
Note: Since I wrote this dbatools had come out with an easier approach that you should check out here. Our Problem In a shared in environment you may have hundreds of databases with the same schema but depending on the data loaded into them not all of them will benefit
A recent project involved setting up encrypted connections on all our SQL Servers. To this we would have to install a certificate in on the server and restart the SQL Server service. Direction on how to do this on an individual instance are provided by Microsoft. We have test environments
This month’s T-SQL Tuesday is brought to us by Kendra Little (blog | @Kendra_Little). Kendra asked to write about interviewing patterns and anti-patterns and to be careful to protect our past/current employers and candidates. I’m going to talk about things I should have done better for interview that are really technical things
Introduction There is a lot of talk about what fill factor should be set for an index. We know for indexes that are ever increasing the fill factor should be set to 100% but for those indexes that are on things like last name or birthday it gets a bit
In last part of the series, we will touch on how to monitor availability groups using extended events. I prefer this method over using SQL Agent alerts just because I don’t like relying on the individual servers to send me emails. I like to have our central monitoring server send