PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates

One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...

Automating T-SQL Code Analysis

With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...

I have a new Passion

Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...

My Favorite SSMS Shortcut (After Copy/Paste)

Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...

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