I was catching up on work recently, reading the third installment of The 5 Worst Days in a DBA's life, starring The DBA Team. Someone had asked me if I enjoyed having Paul Randal (b | t) of SQLskills join them team. The piece had been edited and published while I was gone, and I hadn't had a chance to immerse myself in the adventure. I was anxious too read how Paul helped save the day.
It was a fun read, but one quote in the piece struck me. "A job that runs long or doesn't run at all can sting just as bad as one that fails." That's a quote from my character showcasing a situation that few people actually think about. However jobs that don't run or don't finish are situations that DBAs should be monitoring for.
So many of us adopt a set-it-and-forget-it mentality with our jobs. We assume that things will work, or fail, as we set them up. However it's easy to forget that there are other states we might find ourselves or our systems in that can cause issues.
Monitoring is critical to any well run system, but monitoring needs to be set up well. If we require that certain jobs run, we need to not only check for success or failure, but if the job has actually run and completed. It's easy to accidentally disable the wrong job and not notice. It's also entirely possible that a job gets stuck and doesn't complete.
If you're not watching for those other states, you might find yourself in a situation where you don't have backups and your job is on the line. However you probably won't have The DBA Team to call on.
Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ways that the customer expects, and to prove that it does so for the lifetime of the system. Michael Sorens starts an introduction to TDD that is more of a journey in six parts. More »
SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.
Yesterday's Question of the Day
DECLARE @i INT = 1
WHILE @i < 5
DECLARE @j AS TABLE
SET @i = @i + 1
INSERT INTO @j
SELECT * FROM @j
If I run the above query, what will be the result set using SQL Server 2012?
Answer: This will return 4 rows with the values (2,3,4,5)
SQL Server variable scope is per batch or the entire function/procedure/trigger, not per black/nested construct
- I have this:
@profile_name = 'DBA_Mail',
@recipients = 'firstname.lastname@example.org',
@body = 'The count of the unprocessed records.',
@subject ='Number of unprocessed records...
- [url=http://www.youtube.com/watch?v=oLi1zoPuvkw]Crusaders vs Waratahs Live stream[/url]
[url=http://www.youtube.com/watch?v=4_hl2pQeh9A]Super Rugby Final Live stream[/url]
[url=http://www.youtube.com/watch?v=cgW3slgEJbk]Waratahs vs Crusaders Live stream[/url]
Using a parameter value as a field name
Two multi-value parameters come in. For example :
ColumnLabel & ColumnField
Columnlabel denotes the column header label
& ColumnField denotes the field that should...
Group total expression
I want to add a column after Total lets say..'Progress' where Progress = sum(Actual)/sum(Budget)
The only filter on Progress is to consider...
A subreport as a parameter
- Is it possible to define a subreport as a parameter?
My situation is I have 6-7 subreports with identical parameters. I'd...
help with SSRS performance
Our SSRS report times is getting worse. We process about 5000 report subscriptions on a daily basis. They start at...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.