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.

Cumulative Update #16 for SQL Server 2008 SP3

Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx.  The post also includes all the previous updates and with links to the KB articles.  

Read more

0 comments, 73 reads

Posted in Coffee and SQL on 31 March 2014

Understanding CXPACKET wait stats in SQL Server

Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait … Continue reading

Read more

2 comments, 151 reads

Posted in Coffee and SQL on 21 January 2014

Understanding the Copy_Only option in Backups for SQL Server

The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of log sequence number in conventional SQL Server backups. For example, when you have a schedule of daily full backups and … Continue reading

Read more

4 comments, 486 reads

Posted in Coffee and SQL on 8 January 2014

Reviewer #17 Database Replication in SQL Server 2012

Wow, my first article for the year 2014! Here’s to a blessed and fruitful year ahead for all of us <3 Database Replication  This topic is part 3 and the last topic of lesson in High Availability which covers 12% … Continue reading

Read more

0 comments, 89 reads

Posted in Coffee and SQL on 8 January 2014

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

Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to my First post for initial details and videos from 1 to 6 remaining Videos are as below :: –>…

Read more

0 comments, 149 reads

Posted in Coffee and SQL on 24 December 2013

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 around with SQL server 2014 CTP2 release or have some concepts cleared on always ON on SQL SERVER 2012…

Read more

0 comments, 142 reads

Posted in Coffee and SQL on 24 December 2013

Thank you very much

This year has been so awesome!! I hope to do better in the coming year and be able to share more in the SQL DBA community. Let’s do this!

Read more

0 comments, 113 reads

Posted in Coffee and SQL on 24 December 2013

Holiday Greetings!!!

0 comments, 81 reads

Posted in Coffee and SQL on 24 December 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, 200 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, 244 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, 221 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, 195 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, 182 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, 145 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, 346 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, 198 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, 174 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, 181 reads

Posted in Coffee and SQL on 10 November 2013

Strategizing your Index Maintenance in SQL Server

Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or weekly on your server. For the junior DBA, the rebuilding of indexes task will include a scheduled job that will … Continue reading

Read more

0 comments, 256 reads

Posted in Coffee and SQL on 28 September 2013

Poor Microsoft Doesn’t Understand What Tablets Are For

That’s the title of an article i came across this morning in Slate.com. I am not a big fan of Surface. I’m totally IOS fanatic from iPhone to iPadMini to using Mac at home. IMHO, Microsoft has been committing a … Continue reading

Read more

0 comments, 292 reads

Posted in Coffee and SQL on 24 September 2013

Older posts