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.
#SQLFamily Extended Events: Live 360 @ Orlando, FL
All in all, Live 360 was an excellent event and I thoroughly enjoyed it. I spent some time in sessions covering technologies that I don't generally have much experience with: Azure, data science and PowerBI. The event was well put together with a good variety of SQL Server content and another great reminder of how amazing #SQLFamily is.
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.
A Little Bit of Git History
In April 2005, Linus Torvalds, began development on Git, following some developer turmoil over the use of a proprietary source-control management software.
Git Primer for SQL Server Pros
One of the greatest assets we have as data professionals is our unrelenting desire to understand how things work and leave them better than the way we found them. We often write scripts, code, and even applications to help us solve ALL the problems. And "solving problems" is our middle name. When we solve these problems though, what do we do with the code?
It’s Been Like, Real Busy: Working, Writing, Live 360, and SQLOrlando Meetup
A little over a week has gone by since my first blog post went out. Somehow I've shipped four blog posts during that time and I'm starting to get warmed up to the idea of sharing things with the internet.
Quick Setup: Ubuntu Server 18.04 LTS on Hyper-V
SQL Server containers are hot right now and if you are trying to understand the technology better, get to your nearest PC and get started with containers. I’ll be posting guides on working with SQL Server containers in the future, but first we’ll need an operating system to work with. Since Ubuntu Server 18.04.1 is the latest LTS, that is where we will begin.