This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.