It seems like every DBA has a USB stick or a shared drive filled with scripts they can pull up in almost any situation. How can I build such a library of T-SQL files?
2023-06-26
Take a moment and submit to be on the WIT panel at the PASS Data Community Summit in Seattle this November. We would like to see more women taking part in this.
2023-06-23
173 reads
This article shows a number of ways in which you can find out the version of your instance.
2023-06-23
5,735 reads
This article demonstrates two techniques for allowing Flyway to read extra configuration information from a secure location, possibly encrypted. The first technique pipes the contents of the config file to flyway via STDIN, and the second uses PowerShell splatting. This makes it much simpler to use Flyway to manage multiple development copies of a database using role-base security.
2023-06-23
Deadlocks can occur in any database system, and SQL Server is no exception. In this article, we look at the steps I used to detect and resolve deadlocks in stored procedures.
2023-06-23
This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.
2023-06-21
4,224 reads
Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.
2023-06-21
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.
2023-06-21
A comparison of the lambda and kappa architectures for real time ingestion and analysis of big data.
2023-06-19
4,777 reads
SQL Server supports working with JSON data and provides many different functions that can be used. SQL Server 2022 has expanded the ability to check if the JSON format is valid using the ISJSON function which we will cover in this article.
2023-06-19
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
By Brian Kelley
Most of us know that spending a lot of time on social media and...
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Comments posted to this topic are about the item Hash Joins IV
Comments posted to this topic are about the item How to Load a Fabric...
Comments posted to this topic are about the item Adding the Right Value