Archive

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 …

FREE_SQL_BOOK

Click on below link for more details :: Enjoy 🙂

http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?PageIndex=1#comments

Advertisements

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_FullColor_ForScreen_thumb

 

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

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 🙂

http://sqlserver-performance-tuning.net/

SQLtuning

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

CentralManagementServer

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