SQL Homework – April 2018 – Indexes

This month we are going to look at a topic near and dear to both database developers and database administrators...

Jacksonville, South Florida, and Houston

Just crossed off my quarterly goal of planning SQLSaturday attendance for the next quarter (I’m writing this on March 31st!)....

Imposter syndrome

Last week I posted the following “joke” on twitter: –

I’ve called it a “joke” but I wasn’t really joking. This...

How SQL Compilation Can Prove the Server CPU

It is relatively easy to spot CPU-bound system. But, the source of CPU pressure is not always easy to pinpoint....

SQL Server Extended Availability Groups

It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...

SQL Server Extended Availability Groups

It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...

Database Superhero Adventures, April 2018 Edition

Chicago O’Hare AirportI had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold....

Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...

Geometry Objects in SQL Server using Latitude/Longitude coordinates

(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...

Azure SQL Database Manage Instance

Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...