Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

↑

performance,dba - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » performance » dba (RSS)
24 May 2011 14:03

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , , ,
07 March 2011 20:34

Microsoft SQL Server 2008 R2 Administration Cookbook - Book and eBook expected June 2011. Pre-order now!

Over 85 practical recipes for administering a high-performance SQL Server 2008 R2 system. Book and eBook expected June 2011 . Pre-order now! Multi-format orders get free access on PacktLib , This practical cookbook will show you the advanced administration...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , , ,
30 April 2010 10:41

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , , , , , ,
08 September 2009 13:11

SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often more from here ...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , , , , , ,
13 November 2008 09:07

RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to...
Posted by ssqa.net | with no comments
Filed under: , , , , , ,
10 March 2008 07:09

SQL Server scrollable server cursors, use them carefully!

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , , ,