SQL Server TempDB Tutorial
In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.
2020-07-27
Articles
2020-07-24 (first published: 2018-12-27)
4,772 reads
SQL Server Backup Monitoring with PowerShell
In this part of the series we look at how to use the PowerShell monitoring scripts to collect backup information from your monitored instances.
2020-07-24
SQL Server MSDB Database Tutorial
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.
2020-07-23
Automate Database Restore for SQL Server
In this article we look at how to automate a SQL Server database restore using a PowerShell script.
2020-07-22
TDE BYOK and Geo-Replication in Azure SQL DB
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
2,567 reads
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-21
Loading data in Azure Synapse Analytics using Azure Data Factory
This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.
2020-07-20
11,194 reads
Getting Started with GitFlow
In this article, Diogo Souza explains GitFlow, a branching model for Git. He demonstrates how to work with GitFlow to create and deploy a feature and a hotfix to GitHub.
2020-07-20
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-20
Blogs
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers