SQL Server – Foreach Table

To execute a query against all tables in a database, you can use the sp_msForeachTable stored proc, like this: Note: The ? is a placeholder for the table name. In this article I’ll show two examples of using sp_msForeachTable. Example – Get record counts for all tables This query saves record counts to a temp … Read more

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

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