Category Archives: SQL Server

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

Split a string using a table Variable

Was just playing around with Table variables and thought of a practical problem lot of people approached to me with. Thought its worth documenting on how I do it so somebody can reuse the trick. Given a set of names … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks | Tagged , , | 1 Comment

Passed Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Passed Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008. This now takes my skillset to a new level on Dev aspects of sql server Microsoft Certified IT Professional (MCITP): Database Developer 2008 I could … Continue reading

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