Author Archives: Suleman

Passed Exam 70-462 : Administering Microsoft SQL Server 2012 Databases

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

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

Send an Email Alert when SQL Server Agent Service Stops/Fails

Here is how you can setup an Alert to send you an Email when SQL Server Agent Server Stops or Fails. As a matter of fact you can do this for any Service you want to Alert on. Open computer … Continue reading

Posted in Alert, SQL Server, SQL Server Agent | Tagged , , | 4 Comments

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

Passed Exam 70-448: MSSQL Server 2008, Business Intelligence Dev & Maintenance

Passed Exam 70-448: MS SQL Server 2008, Business Intelligence Dev & Maintenance this morning. Watch this space for my next step forward i.e., 70-452.

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

Attaching a database without log file

To attach a database without a log file is to use a simple T-SQL as below: I am taking an example of AdventureWorks 2008R2 database to attach without a log file; T-Sql as below: CREATE DATABASE AdventureWorks ON (FILENAME =’C:\Database\Data\AdventureWorks2008R2_Data.mdf’) … Continue reading

Posted in Attach database without log file, SQL Server | Tagged , | Leave a comment

Upgrading SQL Server Enterprise Evaluation Edition to Enterprise

Are you near to completing or have finished 180 trial period with your Sql server evaluation edition and would like to own the full corresponding edition of the product; If yes then you are probably concerned if there is going … Continue reading

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