Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

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

2 comments, 2,147 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, 75 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, 122 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, 106 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, 146 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, 92 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, 93 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, 126 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.

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

Read more

0 comments, 138 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, 172 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, 109 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, 118 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, 374 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, 236 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, 3,489 reads

Posted in DBA On The Go on 17 March 2014

Issues Installing SQL 2008 R2 on Server 2012 R2 Clustering

Oh so the nightmare begins. 

At the bottom I've included a set of links where I found my answers. What I'm doing here is just giving a comprised list of what I had to do to get it to work. I ran into a few issues almost immediately.

I got…

Read more

6 comments, 857 reads

Posted in DBA On The Go on 3 March 2014

Free Month To PluralSight!

Free Month of PluralSight!

Ok, personally this is pretty cool. www.SQLSkills.com is giving away a free month to pluralsight! Well, let me rephrase a bit. They're giving away a free month of PluralSight to people who run a bit of code on their SQL Server(2005 and up) for 24 hours.…

Read more

6 comments, 387 reads

Posted in DBA On The Go on 25 February 2014

SQL Saturday OKC 309!

SQL Saturday OKC is coming up!

The event will be August 23rd, 2014!


Now is the time to get signed up. We already have three great precons ready.

BECOME AN ENTERPRISE DBA WITH SEAN AND JEN MCCOWN 

REAL WORLD SSIS: A SURVIVAL GUIDE WITH TIM MITCHELL

PRACTICAL SELF-SERVICE BI WITH…

Read more

0 comments, 109 reads

Posted in DBA On The Go on 24 February 2014

First Presentation Ever And My 50th Post

Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public in front of a large group. I learned a few things then. This may seem obvious to anyone who's done this even  through high school... but I didn't really do…

Read more

0 comments, 119 reads

Posted in DBA On The Go on 17 February 2014

Do Not Set Maximum Ram To 0 Ever - Mistakes We Make

I'm going down memory lane here and remembering one of the first things I did as a DBA. I was told by one of our other DBA's that if you have 40GB of RAM for a database and it's not working very well, the fix is to modify the max…

Read more

0 comments, 165 reads

Posted in DBA On The Go on 10 February 2014

Older posts