Install-Module dbatools
At some point in my career, I had been bitten enough times by linked servers failing to connect that I built a way to automate the checking of the linked server connections.
administration
Automate SQL Server Express Backups with Powershell
Last week I had the honor of presenting at TechEd Europe a session titled “Deploying Microsoft SQL Server 2012 Using Windows Server Core“. Presenting that session gave me the opportunity to learn about administering SQL server using PowerShell, specifically how to administer an instance of SQL Server running on Server Core (PRO TIP: it’s the … Read more
The Minimalist Guide to Database Administration
Every great DBA I know is both driven AND lazy. They are driven to be as efficient as possible, so they can do less work. It’s a wonderful pair of personality traits to have as a DBA. The unfortunate part is that the more driven they are, the more efficient and lazier they get, which … Read more
