SQL Server Performance Tuning

Supporting packaged SQL Server apps: What you can get away withTip - Before making changes in SQL Server, you have to consider how they might affect other applications. The challenge is knowing what you can and can’t do.
Quick tips for monitoring SQL Server performance issuesTip - When it comes to performance, the most basic techniques can make all the difference. Learn which PerfMon counters to be on the lookout for when tuning your SQL Server environment.
Quick tips for monitoring SQL Server performance issuesTip - When it comes to performance, the most basic techniques can make all the difference. Learn which PerfMon counters to be on the lookout for when tuning your SQL Server environment.
Tutorial: Performance tuning SQL Server via queries, indexes and moreTutorial - If you are looking to tune your SQL Server in the hopes of improving performance, this tutorial has the expert advice you need. Learn how to optimize queries, employ the best indexing practices, utilize the best storage or memory configurations and troubleshoot any other errors or problems that might be limiting SQL Server performance.

SQL Server Replication from searchSQLServer.com

Coding for seamless SQL Server database mirroring

Tip -SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring.
Compare and synchronize databases with SQL Compare

Tip -Do you frequently need to compare or synchronize your databases? Read this tip by SQL Server expert Roman Rehak to learn the secrets of effective database synchronization using SQL Compare.
SQL Server merge replication using IIS

Tip -In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS).

SQL Server 2012 security: Changes for the newest version

Feature -SQL Server 2012 is here, and many DBAs wonder what kinds of changes to expect in SQL Server security. Basit Farooq explains what we can anticipate.
BI as a Service: Tips for scaling your BI system...in human terms

Tip -BI systems are great...if you can get your employees to use them. How do you make your system scalable? Read this tip from Don Jones to find out.
SQL Server 2012

Definition -Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a standard interactive and programming language for getting information from and updating a database.

database mirroring

Definition -Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially compromised.
Pssdiag and Sqldiag Manager – the lifeblood of SQL troubleshooting

Tip -What’s the most important part of SQL troubleshooting? Pssdiag and Sqldiag manager, says SQL Server professional Serdar Yegulalp. Find out what makes Pssdiag and Sqldiag so important.
Configuring SSRS the easy way

Tip -Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak.

Virtualizing SQL Server? What to keep in mind

Tip -Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration.
In-memory SQL Server: The implications of integration

Tip -How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install.
database mirroring

Definition -Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially compromised.