Archive
Check a Huge collection of books on Microsoft technology .. all FREEEEE
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
Hi There,
check below link about all our SQL SERVER MVP’s ,their blogs links and much more …
http://mvp.microsoft.com/en-us/mvp/search-mvp.aspx?ty=a&ex=SQL+Server&sc=n
http://mvp.microsoft.com/en-us/default.aspx
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 ..
ENJOY 🙂
Check out SQLSERVER-Performance-Tuning blog
Hi All,
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 🙂
http://sqlserver-performance-tuning.net/
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
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
SQL DBA learning curve 
