SQL Server Performance Tuning
Must Read
- 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).
Microsoft SQL Server Tools and Utilities from searchSQLServer.com
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
Feature -What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year.
-
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.
Microsoft SQL Server Performance Monitoring and Tuning from searchSQLServer.com
-
Index tuning for the reluctant DBA
Tip -Many reluctant DBAs find index tuning intimidating. Read this article by Don Jones to learn why index tuning is a must for your SQL Server shop.
-
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.
SQL Server High Availability, Scalability and Reliability from searchSQLServer.com
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
Feature -What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year.
-
Index tuning for the reluctant DBA
Tip -Many reluctant DBAs find index tuning intimidating. Read this article by Don Jones to learn why index tuning is a must for your SQL Server shop.
-
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.