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.

Archives: December 2013

Final December Giveaway!

Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US, I'll instead send you a 25$ card to amazon to use however you wish. Congratulations to all the winners we've had so far! Do not forget to post here!…

Read more

19 comments, 161 reads

Posted in DBA On The Go on 30 December 2013

SQL Saturdays Coming Up!

Don't forget! Monday is the final give away! I will be giving away a free copy of the Professional SQL Server 2012 Internals and Troubleshooting. Any previous winner can win this as well. If you live outside of the continental US, I will send you a code for a…

Read more

0 comments, 155 reads

Posted in DBA On The Go on 27 December 2013

Powershell Backups and Post Frequency Change

It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these 36 posts out one a week day for some time now. I'm going to scale back. I"m not sure yet if I'll go down to one or two a week.…

Read more

0 comments, 243 reads

Posted in DBA On The Go on 26 December 2013

Christmas Day Winner and RDC Clients: Day 13

Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free book post is going up Dec 30th and the free book winner will be announced New Years day! As always, I will need an E-Mail to do the drawing and…

Read more

0 comments, 175 reads

Posted in DBA On The Go on 25 December 2013

Pre-Holiday Checks: Day 12

Expecting that great Christmas Day dinner, fire roaring, kids screaming, Excedrin stock prices skyrocketing and maybe a little something for you? I hope your servers are in good shape. No one likes being called in on such a day. This isn't things to check on your server. This is just…

Read more

0 comments, 146 reads

Posted in DBA On The Go on 24 December 2013

Can Your Database Survive A Bus? Final Training Giveaway!: Day 11

This is the final training give away  for a free month of Pluralsight! A comment on this post gets your name in the hat. The only rule is that you have an E-Mail address for me to mail the winner. Next week is the final giveaway this month in the…

Read more

8 comments, 158 reads

Posted in DBA On The Go on 23 December 2013

Unused Heaps? - Quick Tips: Day 10

Don't forget! This coming Monday is the last Monday to win a free month of Pluralsight! All it takes is a single comment on the post that day and some way to get your E-Mail address to give you the code. The Monday following that, December 30th, will have a…

Read more

2 comments, 1,286 reads

Posted in DBA On The Go on 20 December 2013

To All Recruiters - Canned Emails Kill Kittens: Day 9

Small disclaimer

I'm going to file this one under rant. Let me first say that there are some wonderful recruiting agencies out there. In OKC there are actually a few. Two specifically stick out as they've helped our SQL community without asking for much spotlight time. I would highly recommend…

Read more

0 comments, 220 reads

Posted in DBA On The Go on 19 December 2013

Popular DBCC's And Our Third Winner Of The Month!: Day 8

Winner Announcement!

The third winner of this month is Annapu Reddy Gayathri! I've seen a nice increase of participants so far. I have one more month of Pluralsight to give away then it's on to the book! Dec 30th I will be mailing a book to one lucky winner. Something that…

Read more

2 comments, 173 reads

Posted in DBA On The Go on 18 December 2013

Database Recovery: Day 7

Recently we were talking about Backups and how you need to test them often. The most complete way to test a backup is to restore from it. The syntax is already documented out there. Also don't forget that our contest giveaway is tomorrow! All you need is a single comment…

Read more

0 comments, 213 reads

Posted in DBA On The Go on 17 December 2013

Talk Your Boss Into A Free Lunch and Giveaways!: Day 6

Monday Giveaway!

It's Monday again! I know we all hate Mondays, but let's have a Fun Monday!It's another week to give away a free month of Pluralsight! We've had Two Winners so far! Today is chance number three! Remember, you need to post here with an E-Mail address either…

Read more

8 comments, 198 reads

Posted in DBA On The Go on 16 December 2013

Keeping Up With Training: Day 5

Let's keep this talk going about what you can do. We know I'm rather big on user groups and SQL Saturdays... I also love books, virtual chapters and most online training. I still have another give away for this coming Monday. It's a free month of PluralSight.…

Read more

0 comments, 147 reads

Posted in DBA On The Go on 13 December 2013

SQL Saturdays: Day 4

Well, we talked about user groups... Let's talk about their big brother; SQL Saturdays. @SQLCenturion runs them here in OKC. They are fantastic ways to get lots of good training for a great price...  FREE! Let's break this up like the user group post.

8 Hours of High Quality…

Read more

0 comments, 169 reads

Posted in DBA On The Go on 12 December 2013

User Groups and Winners!: Day 3

Today's winner is! Aadhar Joshi!
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.

We still have two free months to give away and a great book on the 30th!

Update: Everyone is eligible for the book drawing on the 30th. You can enter…

Read more

2 comments, 170 reads

Posted in DBA On The Go on 11 December 2013

Documentation: Day 2

As a reminder, we have one more day before this weeks giveaway is over. All you need is a single comment on this thread. The winner will be announced Wednesday. We have more than a few people in the running this week! Good luck to you all.

/**************************************
Created…

Read more

0 comments, 147 reads

Posted in DBA On The Go on 10 December 2013

Backups and Giveaways! Day 1

We have 16 days until Christmas. Since I started this blog, I've posted every day Monday through Friday. I am going to make it my goal to post a new update every workday from now until the 25th regarding day to day operations and what's made my life easier. I…

Read more

12 comments, 148 reads

Posted in DBA On The Go on 9 December 2013

Junior DBAs - Where to start?

I personally would start with your local user groups. Getting to know people and networking may be your best bet to sneak in with low/no experience.

Start testing theories at home. you can install VirtualBox and get a SQL instance up and running off trials.

Watch the forums, see the…

Read more

0 comments, 184 reads

Posted in DBA On The Go on 6 December 2013

Blocked processes: Quick Tips

Sometimes activity monitor just isn't fast enough. Maybe it's not telling you what a specific query is doing. Below is a quick script just to get a glimpse into what is going on. This could be very useful if activity monitor decides not to load.... again.

First, what's blocking?

select…

Read more

0 comments, 165 reads

Posted in DBA On The Go on 5 December 2013

Ideal Working Conditions and Free Training Winner!

Contest Winner!

So last Monday I announced a giveaway that I think is a great gift to give away. Every Monday for the rest of this month prior to Christmas, I'm giving away a 1 Month Plural Sight code.

Congratulations Daniel U! You win the month code. I will E-Mail…

Read more

5 comments, 198 reads

Posted in DBA On The Go on 4 December 2013

Testing labs

What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost as often as I see SQL in these books. Is there anything else out there? Jeremiah Peschka made a post recently about sample databases. Are there any others out…

Read more

3 comments, 889 reads

Posted in DBA On The Go on 3 December 2013

Older posts