Author Archive
I’ve been working on a PowerShell script which will be used to build out and configure our new SQL Server AGs. As part of the build, I wanted to install Ola Hallengren’s Maintenance solution and Adam Machanic’s sp_WhoIsActive, as those are standard in our production environment. I have a function which reads a list of [&hellip[ READ MORE ]
Today’s installment of #TSQL2sday is brought to you by Chris Yates (b/t); the subject is ‘Something New Learned’. My first #TSQL2sday! Our production environment includes a couple SQL Server 2008 R2 n+1 clusters, to which we recently applied SP3. The upgrade failed on one of the instances due to [&hellip[ READ MORE ]
Multiple DBA’s, each with their own style of database and user management, has left my employer with a combination of users and groups across several instances containing multiple databases. I had a request to move a database from a soon-to-be-deprecated instance, and thought this would be a perfect opportunity to begin the rather daunting task [&hellip[ READ MORE ]
I’m alive! Posts will mostly be about SQL Server and my adventures in database land, with occasional forays into running. ~[ READ MORE ]