SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2011

SSIS For Each Column in a Data flow

Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here. Well things have changed since I wrote that blog, in fact I believe that old  code only works in SSIS 2005. So I thought I… Read more

0 comments, 1,216 reads

Posted in Mike Davis SQL on 29 September 2011

Getting Previous Row in SSIS Data Flow

There is no native function built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t have to use the dreadfully slow OLEDB Command transform.
In… Read more

0 comments, 1,429 reads

Posted in Mike Davis SQL on 29 September 2011

The Two Day Adjustment

I made it to Cambridge and actually feel OK. I wonder how I’ll feel tomorrow, but the two day adjustment worked well. Tuesday I woke up at 5:30, and around 4:30 Wednesday before leaving for London. I flew late in the day, a 3:00 flight to Calgary, easily cleared customs… Read more

0 comments, 791 reads

Posted in The Voice of the DBA on 29 September 2011

Chalkboard at the Office

This is something I saw recently, a large chalkboard – like the kind they used to have in schools – on a hallway at a client. People come by and write notes. I’ve seen a countdown to the holidays, reminders to work together, things about upcoming games, and more. Occasionally… Read more

0 comments, 696 reads

Posted in SQLAndy on 29 September 2011

David’s SQLBITS Day 1–The Travel Day

Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its warmer at the end of September than it was for most of July and August).

Where am I heading you ask? Liverpool the home of the Beatles, the Mersey Ferry… Read more

0 comments, 712 reads

Posted in The SQL DBA in the UK on 28 September 2011

SQL Table Columns Disappear in Access

A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns.  There were no permissions issues and the columns all showed up properly if they looked at the view via SSMS;… Read more

0 comments, 1,567 reads

Posted in Never Say Never on 28 September 2011

RTO in Disaster Recovery

When you have a disaster, the time that you have to restore service is usually referred to as the RTO time. This stands for the Recovery Time Objective and it can is defined like this in Wikipedia:

The Recovery Time Objective (RTO) is the duration of time and a… Read more

0 comments, 1,258 reads

Posted in The Voice of the DBA on 28 September 2011

Change Database Owner

This is post is going to be very simple but it is something I come across ever so often and find myself having to look up the syntax most of the time.  I guess it is one of those things that if you don’t use it often enough you don’t… Read more

3 comments, 4,985 reads

Posted in Tim Radney - Database Professional on 28 September 2011

SSIS Merge with Duplicate Rows

The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The question arises, what about duplicate records. These duplicates do not get eliminated.

Here are two tables with the ID 5 and the name Brian repeated on each.

Here is… Read more

0 comments, 1,184 reads

Posted in Mike Davis SQL on 28 September 2011

Consultants: 1099 or W-2?

As a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether to go 1099 or W-2.  Essentially, the question is in what manner will you be paid by your client.  Having faced that decision a few times myself, I will fill… Read more

0 comments, 1,872 reads

Posted in James Serra's Blog on 28 September 2011

SQL Saturday 98, Iowa City

Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!

It’s time for another SQL Saturday at the beautiful University of Iowa campus.

The speaker lineup looks great.

I’ll be there presenting on the SSIS Script Task.

There will be more SSIS goodness presented by Ted Krueger and… Read more

0 comments, 696 reads

Posted in The Gerasus Software Blog on 28 September 2011

SQL University SSIS : Named Pipes -- Consumer

Welcome to the third and last day of the Named Pipes seminar.  Today we will get into the consumer portion of the framework.  We will focus on getting a piece of information from the producer to the consumer and then moving some of that information into the Data Flow. Read more

0 comments, 512 reads

Posted in SQLRunner on 28 September 2011

Format Disk for SQL Server

Managing large SQL Server inventories requires standardisation. Do your research , create the scripts , and apply.

Occasionally, custom changes are required . This should be after careful testing.

One advantage of standardising is  for  Disaster Recovery. The rebuild is in the scripts.

If full server rebuilds are required… Read more

0 comments, 2,800 reads

Posted in SQLServer-DBA on 28 September 2011

Posting This Week

I just wanted to do a quick post to let everyone know that I am in fact going to be posting the follow up content that I promised in my webinar and at SQL Saturday.  It has been a busy busy week and I just haven’t had the time to… Read more

0 comments, 476 reads

Posted in Bradley Schacht on 28 September 2011

Online index rebuilds


I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases, the time taken to preform maintenance increases.

This seems to be a simple fact of life for the DBA. But as our maintenance time increases, we need to be… Read more

0 comments, 1,015 reads

Posted in measure twice, cut once. on 28 September 2011

How Should We Pay People?

It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some of the issues with paying for knowledge work, or work that isn’t well defined. The short version is that you don’t want to specify too tightly what you expect people… Read more

0 comments, 1,141 reads

Posted in The Voice of the DBA on 27 September 2011

Start daily programs – More n00bz fun with #Powershell!

When I get in to work in the morning, I like a good cup of coffee waiting for me, a neck rub, and all my favorite programs open and waiting for me.  Since the first two seem out of the question, I focus on the third.

I’ve automated my start-of-day… Read more

1 comments, 1,189 reads

Posted in SQL Awesomesauce on 27 September 2011

SSIS Child Errors in Parent Package

If you have a parent package that is looping through a set of files and calling child packages and want the parent package to continue even if the child package fails, there is a little work involved in making this happen.
In this example I have a parent package that… Read more

0 comments, 2,219 reads

Posted in Mike Davis SQL on 27 September 2011

24 Hours of PASS Questions

I finally found the time to work through the questions from the 24 Hours of PASS session that I did. Thanks to everyone that attended the event

Q1: Can you filter execution plans for sort warnings?

No. The sort and hash warnings don’t appear in the execution plan. You’d have… Read more

1 comments, 740 reads

Posted in SQL In The Wild on 27 September 2011

Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may have to rethink one of the answers given during that interview.

The Data Head profiles are being done by a training company called Data Education.  The company is another… Read more

2 comments, 761 reads

Posted in SQL RNNR on 27 September 2011

Newer posts

Older posts