SSIS and Oracle All Your Non-options

Why do some things have to be so hard?

I have been asking myself that question for the better part of two weeks as I wrestle with SSIS 2008 R2 and getting data out of Oracle and into SQL Server.

It’s like the shell game, only with drivers. Like, go native man!

Like anyone else working in SSIS and dealing with Oracle I started with the default drivers that ship with SSIS. Technically, they work. There are a couple of glaring caveats. They only work in 32 bit mode. Huge non starter on our 64 bit system. They are slow. I know that’s like saying the sky is blue, especially if you don’t have any More >

The Fundamentals of Storage Systems – Shared Consolidated Storage Systems

Shared Consolidated Storage Systems – A Brief History

Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes I did.

For as long as we have had computers there has been a need to store and retrieve data. We have covered the basics of hard disks, RAID and solid state storage. We have looked at all of this through the aspect of being directly attached to a single server. It’s time we expand to attaching storage pools to servers via some kind of network. The reason I chose to say shared and consolidated storage instead of just SAN or Storage Area Network was to help More >

One Great Day And Mixed Feelings

If it happens two times then you know the first time wasn’t a fluke.

Today was my anniversary date for the SQL Server MVP award. I wasn’t expecting to be renewed. I was though. Three of my friends weren’t added to the MVP roster. All three of them have put in the time and work. If this was as simple of do X and Y get MVP it would be easy to say you didn’t do X enough or Y enough. That’s not the nature of an award.

a·ward verb (used with object) 1. To give as due or merited; assign or bestow: to award prizes. dictionary.com

An award is given. Let me say that one more time. An award is GIVEN. More >

SQL In The City: Austin

So, No SQL Saturday in Austin This Year.

I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in time for a SQL Saturday in Austin this year. We are shooting for a spring date and I’ll be posting more about that in the next couple of weeks.

SQL In The City To The Rescue!

Red Gate Software, a sponsor last year for Austin’s SQL Saturday, are doing something different. They have done a few of these events in the UK but they are taking it on the road! They have six events planned for us here in the states. We are one of the first stops in the tour. On October 1st More >

Demystifying SQL Server Differential Database Backups

Odd Man Out

SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.

Let’s start with a technical recap of the three backup types for SQL Server.

1. Full Database Backup

When you request a full backup, SQL Server dumps all the data pages from your database, metadata about how your database is stored on disk and finally enough of the transaction log to bring the database back into a consistent state.  There are a few things you need to know about the full backup semantics. When you take a full backup it makes a few changes. Those changes More >

Free Tools for Testing SQL Sever

You Need To Test Your SQL Server!

Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the tools or know how it is just good advice you can’t follow. I’ve done a TON of benchmarks over the years using every tool imaginable including ones I’ve written myself. There are several barriers to generating a valid repeatable benchmark in your own environment. Lets take a look at the general criteria that I use when testing OLTP systems and the benchmark tools available.

I’ve Been Spoiled

I’m going to come clean. I really like Quest Software’s Benchmark Factory. They have put years of More >

Speaking at PASS Summit 2012

It’s Not A Repeat

Speaking at the PASS Summit last year was one of the highlights of my career. I had a single regular session initially and picked up an additional session due to a drop in the schedule. Both talks were fun and I got some solid feedback.

The Boy Did Good

I won’t say great, there were some awesome sessions last year. I did do well enough to get an invite to submit for all the “invite only sessions”. I was stunned. I don’t have any material put together for a half day or a full day session yet and the window to submit sessions was a lot smaller this year. But I do have three More >

News Flash! PASS Board Makes Unpopular Decision!

Meh.

(n.) A multi-purpose response, primarily used to imply a degree of indifference. Tone of voice and circumstance often implies a meaning. Can be used when you don’t want to answer an awkward or embarrassing question, or if you just plain have nothing else to say, and you want the other person to interpret the “meh” however he/she chooses. As in: Q: “What do you think of my new dress?” A: “Meh.” or Q: “What do you want to do tonight?” A: “Meh.”

Source: unwords.com

You heard me. I think this whole situation is getting way out of hand. People are making personal attacks, making false More >

2011 What A Great Year

What A Diffrince A Year Makes

In January I posted up my new years list basically, stuff I wanted to learn in the last twelve months. Lets take a quick look at last years goals.

SQL Server Stuff

1. Partitioning Win Done, and pretty early on. I did a lot of reading and did some partitioning setups in my home lab and feel much better about partitioning.

2. Change Data Capture Draw This was a business need. At my old company we were using triggers everywhere and CDC seemed like a good fit for most of that. I did some reading and test setups but didn’t get much farther than that. Not a 100% win More >

SQLSaturday 97 Speaker Recap

Great Content + Great Speakers = Awesome Event

All the evaluations have been tallied, its official SQLSaturday #97 was a hit! As a speaker I always like to know how well I did. As a competitor, I like to know how well I stacked up overall. SQLSaturday #97 had some heavy hitters with Conor Cunningham, Joe Celko and the Midnightdba’s in the house. I won’t release the full rankings to the public but I will share some metrics with you. If a speaker had two sessions they were not aggregated together, each session stands on its own.

The Stats

28 speakers signed up to speak and we had zero no shows. More >

Go to Top