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)

best practices,benefits - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » best practices » benefits (RSS)

SQL Server data platform upgrade - Why upgrade and how best you can reduce pre & post upgrade problems?

SQL Server upgrade, let it be database(s) or instance(s) or both the process and procedures must follow best practices in order to reduce any problems that may occur even after the platform is upgraded. The success of any project relies upon the simpler...

Cumulative Update packages for SQL Server 2008 are available now: CU7 for SQL2008 SP2 and CU2 for SQL2008 SP3

Another instalment of Cumulative Update package for SQL Server 2008 SP3 is available now, which is CU2 and the build number is known as 10.00.5768.00. As usual this CU2 for SQL2008 SP3 contains hotfixes for issues that were fixed after the release of...

SQL Relay - Cardiff Usergroup my presentation #sqlserverfaq #sqlrelay #upgrade #bpa

It was a great opportunity to meet and greet the SQL professionals in Cardiff on 05th October 2011 as a part of SQL Relay Usergroup metings across UK. Thanks to Adam Morton for giving me chance to present, since last year and half we have been trying...

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...

Developer related training kits - learn at your own pace!

Training kits are very useful to learn about the technology at your own pace. Now a days web has become prime spot with useful resources for quick learning, with numerous blogs & article the learning curve has been straightened. Here are few Developer...

SQL Server 2008 Best Practices Analyzer (BPA) available for download

In followup to the SQL Server 2008 Best Practices Analyzer - keep an eye for the release post here, CSS SQL Server Engineers from PSSQL blog have announced .... SQL Server 2008 Best Practices Analyzer (BPA )

Microsoft Tech-Ed North America 2010 - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field

It is just a week to go for Tech-Ed North America 2010 in New Orleans, this time also I'm speaking at this conference on the subject - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field... more from here .. It is a coincedence...

SQL Server Setup Portal - a preview and planning of what you are about to setup?

There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! .... read here ...

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...

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 ...