Testing if a Port is Open With PowerShell

Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that,...

Testing if a Port is Open With PowerShell

Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that, Test-NetConnection. With the -Port option, this cmdlet will do...

Watch out – new Database Level Health Detection can send your AOAG down!

Background
In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups...

Would you give our database monitoring the UX thumbs up?

“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other...

Would you give our database monitoring the UX thumbs up?

“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other similar UX advice, before. We are passionate believers in...

How to migrate SQL Database to Azure SQL Database using SSMS Export/Import

Migrating SQL Database to Azure SQL Database using SSMS...

How to migrate SQL Database to Azure SQL Database using SSMS Export/ImportMigrating SQL Database to Azure SQL Database using SSMS Export/Import
Contents

Introduction
Creating the .bacpac file using SSMS Export
Importing the .bacpac...

A New Video - Create a DB Executor Role

A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...

Ethics in Data Science and Artificial Intelligence

Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One...

Fun with PowerShell: I made a game

So we got to playing around with PowerShell last week – one son is making a game hack, and the other...