Five Facts about the SQL Server Resource Database
In this article we cover interesting facts about the hidden resource database in SQL Server and how this is used by SQL Server.
2021-04-28
In this article we cover interesting facts about the hidden resource database in SQL Server and how this is used by SQL Server.
2021-04-28
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
2021-04-20
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
2021-04-19
Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.
2021-04-14
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
2021-04-12
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
2021-04-05
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
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.
2021-03-19
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
2021-03-19
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers