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

DBA On The Go

I've been working in Enterprise IT environments for roughly 10 years. My move to become a DBA was new, but expected. I've worked in secure DoD databases and secure Pharmaceutical databases. One thing to note, the security aspect isn't a lot different. My goal is to marry Databases and security in a functional manner and see how we can speed these things up with minimal work.

I'm Back!

I've been gone... wow. Since March 31st of this year?! Let's fix that.

So what has been holding me back? 

Kids? I have three! 2, 15, 18. One wants to drive, one wants to move out into the world, the other wants to rule the world. 

Wife? She's always there…

Read more

0 comments, 296 reads

Posted in DBA On The Go on 23 September 2016

I hope you didn't miss it!

Warning: This is a really short post.

Today March 31st, BrentOzar.com is giving away their videos! Well, not giving away... but they are 50% off! I doubt anyone follows this blog and isn't aware of Brent Ozar, but just in case!

Good luck and happy hunting. 

Read more

0 comments, 583 reads

Posted in DBA On The Go on 31 March 2016

SQL Saturday Oklahoma City, OK: 422 August 29th, 2015!

We're proud to bring back the OKC SQL Saturday for the 5th year in a row! We have 3 precons setup and ready to cover almost any interest! You can find more information about them here.

We're hoping to see new speakers this year! 

We will still have our…

Read more

0 comments, 693 reads

Posted in DBA On The Go on 9 March 2015

SQL Server, Error message 1785, and cascading deletes: How it kills kittens

I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete would cause an update? Strange isn't it? So where to begin?

It was a dark and stormy night... Wait, wrong movie. 

I just finished a design on a project for…

Read more

2 comments, 701 reads

Posted in DBA On The Go on 3 March 2015

I'm Speaking at SQL Saturday 300 - Kansas City and a Few Questions About SQL Saturdays!

This is just a short update. I will be speaking at SQL Saturday Kansas City! I really hope to see you all there. This will be my last SQL Saturday this year. If anyone has seen my presentation, how do you think I did?

I've wondered a few things about…

Read more

1 comments, 531 reads

Posted in DBA On The Go on 8 September 2014

Speaker Buddy System

SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in our community that are trying to make the jump to a SQL Saturday or any larger event. I think it's a fantastic idea. He brought on a story of a…

Read more

6 comments, 7,937 reads

Posted in DBA On The Go on 21 July 2014

Collaborated Training: What Legacy Will You Leave?

My very first IT job was a bit daunting for me. I really wanted to do my best but I wasn't really sure what they did. One of our supervisors had built a large collection of documentation and a list of our most common issues. It helped so much. That…

Read more

0 comments, 495 reads

Posted in DBA On The Go on 7 July 2014

Plagiarism: A Community Destroyed

Personal Thoughts

Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and how the help a great community exist. They host tons of articles and moderate a forum well enough to build a rather strong following of people that are highly…

Read more

0 comments, 436 reads

Posted in DBA On The Go on 23 June 2014

Come see me in Baton Rouge Aug 2nd!

I've been accepted for SQL Saturday Baton Rouge!

Yes, I am a little excited. I've wanted to become a speaker for some time. I'm excited to be speaking at my second SQL Saturday. My first session was at SQL Saturday Houston. I'll be honest, I chose the less…

Read more

0 comments, 459 reads

Posted in DBA On The Go on 16 June 2014

Documentation: What Can We Document?

          I think I'd like to do a small short series on documentation. I personally love documentation. I honestly think most of us like documentation, we just hate writing it. There are quite a few excuses I've heard against writing it.
  1. I don't have time to…

Read more

0 comments, 672 reads

Posted in DBA On The Go on 9 June 2014

Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!

We will actually be getting our final Service Pack! 

The information can be found here. You may still want extended support if you just simply cannot upgrade... but at least you're going out with one final update. This is a copy and paste from the link listed above, "We are…

Read more

2 comments, 597 reads

Posted in DBA On The Go on 3 June 2014

Tulsa User Group

I love user groups.

I have a special place in my heart for people who go out and give their time and knowledge away for free. I've written before about user groups. I used to think a good year of training involved a pretty specific list.

1) 12 local…

Read more

2 comments, 576 reads

Posted in DBA On The Go on 20 May 2014

SQL Saturday Houston

I spoke for my first time at a SQL Saturday in Houston this past week. I had a lot of fun doing so! I got to meet other speakers starting out, see some of the old hats and overall just get to give something back to the community. 

A few…

Read more

0 comments, 667 reads

Posted in DBA On The Go on 12 May 2014

Searching SSIS Packages or searching XML In General

Today I'm posting a small script with a simple purpose. I wanted to search all of my SSIS packages in MSDB for a specific word. This does not work on encrypted packages. That being said, here's the script in question.

, CONVERT( xml, CONVERT(varbinary(max),PackageData) )   AS…

Read more

0 comments, 719 reads

Posted in DBA On The Go on 7 May 2014

Resume Generating Event (RGE)

No, I haven't lost my job. This is just one of those topics that's good to get out there. There are honestly few things that can cause you to question if you still have a job the next day, but those things still exist. There are ways to mitigate RGEs,…

Read more

2 comments, 897 reads

Posted in DBA On The Go on 28 April 2014

5 Years Running! OKCSQL!

I want to congratulate OKCSQL on a 5 year run. 

I personally wasn't here for that whole duration, but we have leaders and members that have been. We’re still growing and have plenty of room for new members. We have an awesome group! We have some fantastic sponsors even. GDH

Read more

0 comments, 637 reads

Posted in DBA On The Go on 14 April 2014

I'm Speaking at SQL Saturday Houston, May 10th.

I will be speaking at my first SQL Saturday. I'll be in Houston May 10th. I'm rather surprised to be honest. No, I don't have that sinking feeling that my presentation isn't good enough or that I'll show up at the event in my underwear with everyone laughing... those fears…

Read more

3 comments, 528 reads

Posted in DBA On The Go on 7 April 2014

SQL 2014 Release Date, April 1st

I'm not a fan of anything releasing on April Fool’s Day, but that's not for me to decide. I personally cannot wait to upgrade to 2014.  I want to see the full power behind PCI-e based SSDs pushing extended ram. I want to have the security of having a server…

Read more

0 comments, 1,612 reads

Posted in DBA On The Go on 31 March 2014

SQL Server Enterprise is Cheaper than Standard

Free Month of Plural Site

I'm interested in seeing your responses. Any relevant response will be accepted and a free month of Plural Site will be given away. You do not have to agree with me to be relevant. I want to hear what you think.

Now this may seem…

Read more

0 comments, 1,388 reads

Posted in DBA On The Go on 24 March 2014

My Favorite Free Scripts

I'll start off with Ola Hallengren's scripts. I'm not a fan of reinventing the wheel. If someone makes gold, I tend to want to use it. Ola's scripts are fantastic. They're even already updated for 2014! You do have to contact them for the CTP version…

Read more

9 comments, 4,455 reads

Posted in DBA On The Go on 17 March 2014

Older posts