HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1

Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...

Thank you very much

This year has been so awesome!! I hope to do better in the coming year and be able to share...

Holiday Greetings!!!

Connection pooling and the DBA

Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....

Identifying Columns to Create Index via T-SQL

To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...

SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...

70-457 Reviewer #16 Implement AlwaysOn in SQL Server 2012

This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...

Checking your users and groups in Command Window.

As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...

Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008

Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...

Troubleshooting Database Mirroring Configuration

From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...