Code Snippet: How To Customize a DateTime with the FORMAT Function

Post published:January 3, 2019
Post category:SQL Server
Post author:Chris LaGreca

Demonstration of customizing a DateTime with the FORMAT Function.

How To Collect SQL Server Metrics: Database File Growth

Post published:December 17, 2018
Post category:SQL Server
Post author:Chris LaGreca

In this post, I demonstrate a method for collecting data file growth metrics that can be used for further analysis.

Database Restore Failed: Could Not Obtain Exclusive Access

Post published:December 10, 2018
Post category:SQL Server
Post author:Chris LaGreca

I was "testing" a bit hard today and broke the WideWorldImporters database. A valiant effort was made to restore the database to a prior known good working state, however, the UI in SSMS had other plans.

Git Blitzed: An Experiment of Automation with Git, PowerShell, and SQL Server

Post published:November 28, 2018
Post category:Git PowerShell SQL Server
Post author:Chris LaGreca

Since there is no known way to receive SQL Server First Responder Kit patches automatically, I contrived a plan to keep my local repository and SQL Server up to date.