Download AWS RDS SQL Server Backup
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
2024-09-16
Articles
Level up your learning in 2024 with PASS Data Community Summit
Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.
2024-09-16 (first published: 2024-08-19)
The Mastering Azure Data Studio Series
A list of articles in my series on Azure Data Studio along with a few other links.
2024-09-13 (first published: 2024-01-10)
2,715 reads
Introducing the New Stars of Data speakers for PASS Summit 2024
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
2024-09-13
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.
2024-09-13
Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric
This next article examines the impact of transaction sizes on the performance of our Delta Parquet tables.
2024-09-11
1,876 reads
SQL Server 2016 Build List
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2024-09-11 (first published: 2017-01-25)
39,192 reads
2024-09-11 (first published: 2018-12-18)
8,817 reads
2024-09-11 (first published: 2018-12-20)
11,272 reads
Event Streams for Persistent and Asynchronous Microservice Communication
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
2024-09-11
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers