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)

configuration - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » configuration (RSS)

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 )

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 Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.

Is there a way of recylce the SQLAgent.out file in SQL Server 2000 and SQL Server 2005?

You may be aware about SP_CYCLE_ERRORLOG from older SQL Server versions, this will only take care of SQL Server error log and not with SQLAgent error log. So the question is there any way out to recycle the SQLAgent log file too without restarting this...