SQL Server DBA Team Knowledge Wave 1

Please register for Junior SQL Server DBA What to do & What not to do on Sep 13, 2014 2:00 PM IST at: https://attendee.gotowebinar.com/register/1233616123437806338 This webminar is usefull to the Junior DBA. Best Practices to follow SQL Server Optimal Settings. Database Optimal Settings Monitoring SQL Server Performace Activity Monitor Perfmon Change log how to do […]

How to know the details of your SQL Server

Once or a while many of  the people really get confused with the edition of SQL Server,A very good example is as Below Answer is very simple run xp_msver in the SSMS  .check the output below xp_msver gives the complete information about the SQL Server . Option 2 run this query SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), […]