SQL developers must have a solid understanding of the database schema before delving into SQL development. Investigate and understand the database’s tables, columns, relationships, and constraints.

A novella size of SQL Server database best practices, all for free. Some of the links do not work yet as indicated by the "TODO" text tag. This is being converted to be more readable form from the ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

This project aims to provide a simple environment to learn and develop SQL without having to deal with installing and configuring any database engine on your system. The project is already preset to ...

I have a 2014 15” MacBook Pro that I’m looking to replace sooner or later with an equivalent M1 MacBook Pro (most likely the 14”). However, one big holdup is that for my day job, I run Visual Studio ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.