Additional Articles

Azure Managed Instance Download and Restore SQL Server Backup

by Additional Articles

MSSQLTips.com

Azure SQL Managed Instance

Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.

2024-10-14

Database Sharding: Strategies for Seamless Scaling and Performance Optimization

by Additional Articles

SimpleTalk

Database Design and Implementation

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

Identify CPU Intensive SQL Server Queries from an Implicit Conversion

by Additional Articles

MSSQLTips.com

Performance and Tuning

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

Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star

by Additional Articles

PASS

PASS Summit

After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.

2024-10-07

Uniqueness, Keys, and Identity

by Additional Articles

SimpleTalk

Database Design and Implementation

If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It says that: “To be is to be something in particular; to be nothing in particular or anything in general, is to be nothing at all.”

2024-10-07

Storing and Retrieving the Initialization and Configuration Data for Applications

by Additional Articles

SimpleTalk

All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.

2024-10-04

Why customers love SQL Prompt

by Additional Articles

Redgate

SQL Prompt has long been a customer favorite thanks to its ability to boost productivity. Discover how fellow database professionals are leveraging SQL Prompt to accelerate their coding speed and improve code quality.

2024-10-04

Casino night is back at PASS Summit 2024!

by Additional Articles

PASS

PASS Summit

Back by popular demand, casino night from SQL Server Central will return to PASS Summit this year. Casino night will take place on November 5 after the welcome reception. Tickets will be allocated at random via a lottery.

2024-10-02