SQL Server: Timeout When Viewing SQL Server Agent Job History

Too many times when I try to look at the history of a SQL Server Agent Job, I get this error: TITLE: .Net SqlClient Data Provider ------------------------------ Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.2210&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: The wait … Continue reading SQL Server: Timeout When Viewing SQL Server Agent Job History

PowerShell: Drop All SQL Server Tables, Views, SP’s, Functions, Types etc.

I hope this script does not become infamous for the wrong reasons! Please use caution. I had to help a team recreate everything in a database and test their scripts but leave the roles and role grants in place. Basically, this meant that I could have scripted out the permissions and recreated the database but … Continue reading PowerShell: Drop All SQL Server Tables, Views, SP’s, Functions, Types etc.

SSAS: Automate SSAS Backups With PowerShell

I was looking for a solution to automate SSAS backups using PowerShell. By "automate", I mean the following: Backup one or more SSAS databases in an SSAS instance to a network location Automatically cleanup backups that are older than [x] days Schedule the backups via SQL Server Agent with minimal overhead Backup multiple host instances/databases … Continue reading SSAS: Automate SSAS Backups With PowerShell

PowerShell: SQL Server Services Startup Mode Change

This is one of those extremely simple posts where everyone who does PowerShell knows how ridiculously simple it is to do and you will too today. You will look like a magician to the uninitiated. Today, I had about 5 hosts running 4 instances of SQL Server each and I had to Stop all SQL … Continue reading PowerShell: SQL Server Services Startup Mode Change

SQL Server – Space – Data And Log File Growth Auto-Grow History TSQL

I apologize for the lull in my blogging. After most of my blog posts were completely ripped off by a Chinese website (full copy/paste or web-crawl and replace my name type plagiarism) a switch just flipped in my brain. I am trying again after submitting complaints with Google (Thanks to Brent Ozar for the guidance) … Continue reading SQL Server – Space – Data And Log File Growth Auto-Grow History TSQL