Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Coffee and SQL

I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

Archives: November 2013

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. http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/10/08/connection-pooling-for-the-sql-server-dba.aspx Well, now and then I get approached with connection pooling issues and I’m like :| I plan to use … Continue reading

Read more

0 comments, 249 reads

Posted in Coffee and SQL on 27 November 2013

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 statement below; SELECT OBJECT_NAME(OBJECT_ID), mid.included_columns, mid.statement, mic.column_name, mid.equality_columns, mid.inequality_columns, mic.column_usage FROM sys.dm_db_missing_index_details mid CROSS apply sys.dm_db_missing_index_columns(mid.index_handle) mic ORDER BY mid.index_handle … Continue reading

Read more

4 comments, 380 reads

Posted in Coffee and SQL on 27 November 2013

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 the Field series. While installing SQL Server many DBA takes pride that they were able to install SQL Server without…

Read more

0 comments, 262 reads

Posted in Coffee and SQL on 26 November 2013

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 the certification exam. This part covers the AlwaysOn Availability Groups, a high availability feature that is new in SQL Server … Continue reading

Read more

0 comments, 230 reads

Posted in Coffee and SQL on 17 November 2013

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 time when managing Security in my SQL Servers i need to verify if a user or a group is already … Continue reading

Read more

0 comments, 221 reads

Posted in Coffee and SQL on 15 November 2013

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 to the new storage. All database files and logs files have been successfully migrated to the new storage. But how … Continue reading

Read more

0 comments, 195 reads

Posted in Coffee and SQL on 13 November 2013

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 everything is OK, you may use the following T–SQL statements. To check the principal id the database mirroring is using; … Continue reading

Read more

0 comments, 410 reads

Posted in Coffee and SQL on 11 November 2013

70-457 Reviewer #15 Implement Database Mirroring

This reviewer is part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of the certification exam. Database mirroring is a process of creating and maintaining an always up-to-date copy of your database on another … Continue reading

Read more

1 comments, 224 reads

Posted in Coffee and SQL on 10 November 2013

70-457 Reviewer #14 Database and Application Roles

This lesson is part two of lesson Reviewer #13 Managing SQL Server Logins. There is so much to cover about securing SQL that i decided to cover the entire lesson in parts. From the first lesson we covered mainly logins … Continue reading

Read more

0 comments, 199 reads

Posted in Coffee and SQL on 10 November 2013

70-457 Reviewer #13 Managing SQL Server Logins

This lesson covers managing security principals at the instance level. Security principals at this level allows access to the instance and serve as gateway that allow access to database hosted on the instance. This part of the lesson covers 18% … Continue reading

Read more

2 comments, 207 reads

Posted in Coffee and SQL on 10 November 2013