Monthly Archives: June 2012

Passed Exam 70-461 : Querying Microsoft SQL Server 2012

Passed Exam 70-461 : Querying Microsoft SQL Server 2012 Watch this space for my next stop i.e., Exam 70-462 : Administering Microsoft SQL Server 2012 Databases

Posted in MCM, MCSA, SQL Server, SQL Server 2012 | Tagged , , , , | 2 Comments

Installing Books Online for Microsoft SQL Server 2012

Installing Books Online for Microsoft SQL Server 2012 on to your Local Disk to use a local source for help. BOL is not installed by default with SQL Server 2012. The Documentation & Tutorial of previous versions is renamed to … Continue reading

Posted in Booksonline, SQL Server, SQL Server 2012, Uncategorized | Tagged , , , , | Leave a comment

Passed Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Passed Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 Watch this space for my next step i.e., 70-461 : Querying Microsoft SQL Server 2012

Posted in Business intelligence, MCITP, MCM, SQL Server | Tagged , , , , | Leave a comment

Common SQL Server Performance Counters

Somebody asked me what are the common SQL Server Performance Counters to monitor for bottlenecks and unusual activity on the server. The list of common SQL Server Performance counters is as below: SQLServer:Access Methods – Full Scans / Sec SQLServer:Access … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

SQL Server Health Checks

I have been working on automating SQL Server Health checks for a while now and use this post to share my work with the community. You will find me constantly updating this post and adding more checks and Content/Scripts . … Continue reading

Posted in SQL Server, SQL Server Health Checks, T-SQL Scripts, Uncategorized | Tagged , , | Leave a comment