An Introduction to Azure SQL Databases

This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases

It does pretty much what is says on...

Power BI Custom Visuals Class (Module 79 – Venn Diagram MAQ Software)

In this module you will learn how to use the Venn Diagram Custom Visual by MAQ Software. The Venn Diagram...

PoshSSDTBuildDeploy Update – Now With LocalDB!

Hello!
Late on Friday I published a PowerShell Module that gives working examples of using DataToolsMSBuild. All very interesting, go and...

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

Now I’m all for making my life easier and one thing that makes life easier for me is having a...

Installing Pester

One of the things that I believe strongly in is that we need better testing of software. Actually, what we...

Watch Out for Automap in SQL Compare

I wrote a piece on SQL Compare and customizing the Automap feature. This was handy for me in a small...

Database Fundamentals #15: Modifying Data With T-SQL

The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...

Create users in Azure AD

In this post I'll show you how to create new users in your Azure Active Directory so you can use them as service accounts or to grant other users...

Closing all of the connections to a database

Doing a database restore may not be the most common task a database professional will ever do, but it’s a...

Back To (Security) Basics

Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...