My Favorite SSMS Shortcut (After Copy/Paste)

If there's one keyboard shortcut I use more than any other (with the exception of copy and paste) it would be the ALT + highlight multi-line edit/block selection shortcut.
Let's...

2 Ways to Loop through collections in Pester

In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...

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...