Find the distance between two coordinates using SQL and C#

Imagine you’re in the middle of Millennium Park in Chicago. You want some coffee, but want a good deal on it. You open an app and see the nearest coffee shops offering deals to anyone with this app. How did this app know the distance from you to the coffee shops? This article will show … Read more Find the distance between two coordinates using SQL and C#

How to install MySQL on Windows

We’re going to install MySQL Community Edition, which is the free edition of MySQL. It includes a database server (MySQL Server) and a GUI database client (MySQL Workbench), among other tools. Go to MySQL Community Downloads. Click on MySQL Installer for Windows. Download the web community installer. Run the installer you downloaded. On the Setup … Read more How to install MySQL on Windows

How to sort data into groups then further sort within each group using SQL

I recently came across a complex sorting problem that required sorting the data into groups, then further sorting the data within each group. Requirement My requirement is to sort a list of orders for users in charge of approving orders. Here is a list of orders with their status and department: Here is a list … Read more How to sort data into groups then further sort within each group using SQL

The specified sa password does not meet strong password requirements

Problem When entering the sa password while installing SQL Server you get the following error: “The specified sa password does not meet strong password requirements.“ Solution If the computer is on a domain Go to Administrative Tools / Domain Security Policy :: Security Settings | Account Policies | Password Policy Set “Minimum password length” = Not … Read more The specified sa password does not meet strong password requirements