Beginning with SQL Server 2019, Microsoft has redesigned the database recovery process (ie. crash recovery and rollback) to improve availability…
In SQL Server 2016 Microsoft introduced Automatic Seeding for Availability Groups (AG). The Automatic Seeding process streams the database files…
So far this series has covered: installing Docker for Windows, the basic commands for managing images and containers, and creating…
The ability to use a parameter file (configurationfile.ini), for automating the installation of SQL Server, has been around for many…
Part 1 of this series covered installing Docker for Windows and the basic comands for managing SQL Server images and…
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…