Skip to content
Chris LaGreca

Every day as a database professional, I am challenged with a new puzzle to solve.

  • Blog
Menu Close
  • Blog

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

  • Post published:January 3, 2019
  • Post category:SQL Server
  • Post author:Chris LaGreca
Code Snippet: How To Customize a DateTime with the FORMAT Function

Demonstration of customizing a DateTime with the FORMAT Function.

Continue Reading Code Snippet: How To Customize 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
How To Collect SQL Server Metrics: Database File Growth

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

Continue Reading How To Collect SQL Server Metrics: Database File Growth

Database Restore Failed: Could Not Obtain Exclusive Access

  • Post published:December 10, 2018
  • Post category:SQL Server
  • Post author:Chris LaGreca
Database Restore Failed: Could Not Obtain Exclusive Access

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.

Continue Reading Database Restore Failed: Could Not Obtain Exclusive Access

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.

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

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

  • Bits and Bytes
  • Git
  • Hyper-V
  • PowerShell
  • SQL Community
  • SQL Server
  • Ubuntu

Archives

  • February 2019 (1)
  • January 2019 (1)
  • December 2018 (8)
  • November 2018 (3)
Chris LaGreca © 2021. All Rights Reserved.