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.
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.