A Problem with POWER()

I ran into an interesting problem while working with the POWER() function. I was trying to do some binary conversions...

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

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

What were you thinking (hidden relationship)???

What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...

High CPU and Query Store, A Story of Spinlock Heartache

This is going to be a quick look at an issue that we recently encountered, I’m not going to go...

Power BI World Tour–Dallas Nov 27-29

Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World...

4 SQL Injection Techniques For Stealing Data

Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.

However,...

4 SQL Injection Techniques For Stealing Data

Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...

4 SQL Injection Techniques For Stealing Data

Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...

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