When talking with people about databases and disaster recovery our conversation often sounds like this: Q: What does your backup…
Jupyter Book: A collection of SQL, PowerShell, and Python-based notebooks and markdown files. In a recent Channel9 segment, Vicky Harp…
SQL Server containers are gaining popularity as a way of enhancing and standardizing development environments for Windows & Linux based…
Troubleshooting “slow” reports in PowerBI Report Server (or SQL Server Reporting Services) can be an arduous task. End users are…
Delegated authentication (or double-hop authentication as it’s sometimes called) is a common requirement with SQL servers that are using Kerberos…
Recently I started getting random alerts that a job on one of the SQL servers was failing because of a…
Recently I was working on rolling out a new PowerBI Report Server, along with migrating our 2014-based SQL Server Reporting…
First, thanks to Sean McCown (@KenpoDBA) at MinionWare (@heyMinionware) for the help troubleshooting. Recently I had to rename a SQL…
SQL Server natively supports 3 types of backups: Full, Differential and Log. Full backups take a complete backup of the…
This is one article in a series that cover how to use PowerShell scripts to automatically install SQL Server. The full script set can be found here. High availability in production SQL Servers is often a desirable feature.…