Uncover SQL Server Missing Indexes
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
Articles
AWS Services Using SQL for Big Data Analysis
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
2024-10-16
366 reads
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
2,088 reads
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,447 reads
Azure Managed Instance Download and Restore SQL Server Backup
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
2024-10-14
Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,824 reads
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in the short history of computing. As applications reach new levels of sophistication and become deeply interconnected, these companies find themselves increasingly overworked, overheated, and at their wits’ end, desperately trying to squeeze just a bit more performance and availability out of their aging database architectures.
2024-10-11
PASS Summit 2025 Dates
You heard it here first, PASS Data Community Summit will return to Seattle next year! Save the date, as PASS Summit will take place in person at Summit, Seattle Convention Center, from November 17-21, 2025!
2024-10-11
Identify CPU Intensive SQL Server Queries from an Implicit Conversion
Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues.
2024-10-09
Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor
Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and attend expert-led sessions on topics from database migration to modernization.
2024-10-09
120 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers