Posts Tagged ‘Microsoft’

Check a Huge collection of books on Microsoft technology .. all FREEEEE

July 23, 2013 Leave a comment

Check a Huge collection of books on Microsoft technology ..

including SQL SERVER ,SSIS ,sharepoint and many more …


Click on below link for more details :: Enjoy 🙂


list of all SQL SERVER MVP till date

July 7, 2013 Leave a comment

Hi There,

check below link about all our SQL SERVER MVP’s ,their blogs links and much more …


MVP’s are great asset for the community and great role models for junior’s ..

they share their learning and experiences  without holding anything back …

A BIG CONGRATULATION to ALL MVP’s for the year 2013 ..



Check out SQLSERVER-Performance-Tuning blog

July 7, 2013 Leave a comment

Hi All,New start to start

Check out below Link for all latest trends and news on SQL SERVER Performance

tuning ,its an unique efforts in GULF and MIDDLE EAST ,

do join the subscription list and stay updated with latest blog-post ,,, ENJOY 🙂


SQL Server Performance Tuning is a specialized SQL Server community fully of several rich blogs ,videos tutorials , offline and online event for widely concerned topics on Microsoft SQL Server  like T-SQL performance optimization , Data Warehousing solutions, Replication Solutions , DMV library ,new SQL Server 2012 features ,index tuning , heavy locks and deadlocks   ..etc


set SQL error log retention period through T-SQL

April 18, 2013 Leave a comment

we all may need to tweak the SQL error log retention period on a single instance or list of SQL server VIA CMS (central management server)

below 2 commands are quite useful for achieving the same


READ the current setting of sql error log retention 

/* USE [master] GO EXEC xp_instance_regread N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’NumErrorLogs’ GO */

you may receive below error on few server .. you may want to  go ahead with the update command and come back to see the results of xp_instance_regread

possible error message for some server ..

RegQueryValueEx() returned error 2, ‘The system cannot find the file specified.’ servername(username): Msg 22001, Level 1, State 1

set  the LOG retention sql error to 20 days 

/* USE [master] GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’NumErrorLogs’, REG_DWORD, 20 GO */

above command will set the retention to 20 days and you may rerun EXEC xp_instance_regread to confirm the same setting