Additional Articles

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

by Additional Articles

SQLCAT

Backup and restore

Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.

2009-09-25

2,989 reads

Querying a Multi-Tenant Data Architecture

by Additional Articles

4 Guys From Rolla

Database Design

This article discusses different ways to query multiple databases and shows a simple, web-based tool I've created and routinely use for those SaaS-style web applications I work on that use separate databases to store different customer data. Read on to learn more!

2009-09-25

2,679 reads

SQL WHERE Clause Optimization

by Additional Articles

SQL-Server-Pro

T-SQL

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...

2009-09-25

9,654 reads

Multi-Tenant Data Architecture

by Additional Articles

Microsoft MSDN

Database Design

The second article in our series about designing multi-tenant applications identifies three distinct approaches for creating data architectures.

2009-09-24

3,979 reads

Performance Improvement: Understanding

by Additional Articles

developer.com

Performance Tuning

I'm going to try to lay out some general guidelines for performance improvement through improving understanding about what performance is, how to measure it, and finally solutions to common problems. This article will cover the core understanding of the performance conversation.

2009-09-24

3,790 reads

Service Broker example on how to configure, send and receive messages

by Additional Articles

MSSQLTips.com

Service Broker (SSSB)

SQL Server 2008 and 2005 offer the Service Broker feature. In this tip we will go through the different components of service broker and step by step on how to setup Service Broker for a single database.

2009-09-23

3,250 reads

Ten Pitfalls In Establishing An Enterprise Architecture

by Additional Articles

Intelligent Enterprise

Data Warehousing

Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.

2009-09-23

4,327 reads

Keep Your SQL Server Indexes Fragmentation Free

by Additional Articles

DevX

Indexing

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.

2009-09-22

5,457 reads

Migrating SQL Server Databases - The DBA's Checklist (Part 2)

by Additional Articles

SQL Server Performance

Migration

Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.

2009-09-22

2,503 reads

Best Practice - Increasing the Number of SQL Server Error Logs

by Additional Articles

MSSQLTips.com

SQL Server

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.

2009-09-21

3,332 reads

All authors

Additional Articles

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

Querying a Multi-Tenant Data Architecture

SQL WHERE Clause Optimization

Multi-Tenant Data Architecture

Performance Improvement: Understanding

Service Broker example on how to configure, send and receive messages

Ten Pitfalls In Establishing An Enterprise Architecture

Keep Your SQL Server Indexes Fragmentation Free

Migrating SQL Server Databases - The DBA's Checklist (Part 2)

Best Practice - Increasing the Number of SQL Server Error Logs

Blogs

Resetting on the AI hype train

A New Word: Etherness

Vibe Coding a Login Tracking System

Forums

The Max PK Length

My experience using the GitHub Copilot in SSMS 22

The Microsoft SQL Year in Review

Question of the Day

The Max PK Length