Login creation in SQL Server 2005 for SQL Server Authentication Mode

Its a graphical representation of login creation in SQL Server 2005 for SQL Server Authentication Mode.

Log Shipping with SQL Server 2005

Log shipping has been a mechanism for maintaining a warm standby server for years. Though SQL Server supported log shipping with SQL Server 2000 as a part of DB Maintenance Plan, it has become a built-in feature of SQL Server 2005. This article gives brief introduction to SQL Server 2005 Log Shipping, configuration of it, monitoring of it and failing over at the disaster.

Configure aliases for SQL Server databases and servers

Configure alias names for SQL Server database objects and servers. Make fewer changes to application code and configurations with SQL Server alias methods.

Why store sensitive data if you don't have to?

Storing sensitive data in your database leads to security risks. Learn how not storing sensitive data indefinitely is a form of data protection.

SQL Server Reference Guide

Buck Woody's SQL Server Reference Guide is your "one-stop shop" into the world of Microsoft's SQL Server, providing you with the information you need to manage and program SQL Server.

Evaluation Edition

The “sys.dm_os_performance_counters” Dynamic Management View

SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005 performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).

SQL Server Protocols

SQL Server 2005 Bug Alert: Merge Replication Could Mean Data Loss

The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.

Troubleshooting Performance Problems in SQL Server 2005

It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem.