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.

A quicker way to know when DBCC CHECKDB last ran in your database.

Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes you miss checking reports on these scheduled jobs if they did run or completed but failed. So how do you monitor when was the last run of DBCC CHECKDB…

Read more

0 comments, 399 reads

Posted in Coffee and SQL on 1 June 2014

Setting Up Your Custom Data Collector Set

Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable for monitoring purposes and reporting on disk usage and server activities. But what if you want to monitor other areas of your database server aside from the default data collection…

Read more

0 comments, 148 reads

Posted in Coffee and SQL on 21 May 2014

Developer’s Life – Every Developer is a Spiderman

Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero.  The most recent movie recently was released in theaters, so it has been at the front of my mind for some time. Spiderman was my favorite superhero even before the…

Read more

0 comments, 189 reads

Posted in Coffee and SQL on 17 May 2014

Data Collection in SQL Server

Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+ SQL Server databases. One of the top skill required for this is being proactive in your managing task and being able to fix something even before it even happens.…

Read more

1 comments, 192 reads

Posted in Coffee and SQL on 11 May 2014

That “Cannot Generate SSPI Context” headache

Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally and and everything is fine. No headaches. Now to test your SQL Server, you try to connect from a client PC and you get that “Cannot Generate SSPI Context”…

Read more

4 comments, 567 reads

Posted in Coffee and SQL on 10 May 2014

Allowing your App team to run SQL Agent Jobs

Problem : In most of your projects, there is always that situation that the application team have that need to run their own application jobs in the SQL Agent. But how do you allow them to let them have that right (and fun) without letting them make any changes to…

Read more

1 comments, 179 reads

Posted in Coffee and SQL on 10 May 2014

SQL Agent Error During Windows Failover Cluster Setup

Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and working in your Failover Cluster Manager window, you see that the SQL Agent resource is not online or you don’t see the SQL Agent resource at all. Or maybe after…

Read more

0 comments, 160 reads

Posted in Coffee and SQL on 27 April 2014

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, 144 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 type becomes a problem.” To get a deeper understanding, it…

Read more

2 comments, 274 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 differential backup of every six hours daily. Then you need…

Read more

4 comments, 561 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, 132 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, 187 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, 195 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, 154 reads

Posted in Coffee and SQL on 24 December 2013

Holiday Greetings!!!

0 comments, 134 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, 251 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, 387 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, 266 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, 233 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, 225 reads

Posted in Coffee and SQL on 15 November 2013

Older posts