Overview First, we need to cover what distributed availability groups are. The basic definition is it an availability group of availability groups (AG). No remembering back to English class in school you were not allowed to use words that were part of the word to define the word so that makes
My environment has over 400 servers and we use MSX/TSX to manage those servers but we want to be able to have different parameters on different servers. Plus we have the need to run Ola’s scripts on Linux with sqlcmd not available in SQL Agent we will need T-SQL jobs. So
I re-branded my website to match my job title. I like the comic book feel and superhero theme. At had a few designs to pick from but went with a classic American superhero with red and blue colors logo with ripping off their shirt jumping into action which is the way
Problem The current environment is rather unique, with a unique workload that requires writing things like this. One of those being having the transactions cache on the server take up nearly 10 GBs of our memory. Being that we would like that 10 GBs of memory go towards the Buffer Pool
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