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.

Archives: January 2014

Forcing Results To Conform For Exports

This one is a bit off for me. I've had to make SSIS exports kick out in specific ways such as how a number is returned or how many spaces a column returned every time regardless of how long the actual return was. Here's a few things I've put in…

Read more

0 comments, 1,471 reads

Posted in DBA On The Go on 27 January 2014

PowerShell Remote Commands

This is something I've found useful here recently when I had a server acting up. It's a simple way to send commands to a remote server such as 'shutdown -r'

Enable-PSRemoting -Force

Enables to you actually remote through PowerShell.

Test-WSMan Server1

Just tests that you can reach the server through…

Read more

0 comments, 925 reads

Posted in DBA On The Go on 22 January 2014

Who Do You Rely On?

We tend to think of ourselves as self reliant. Sit and think for a second, how many people do you rely on?

Help Desk

Our angry callers hit them first. They let us know if something's down and our monitor doesn't see it. The more information we can give them,…

Read more

0 comments, 1,233 reads

Posted in DBA On The Go on 20 January 2014

Restore Master From Backup

There are a few posts running around talking about restoring master from backup. Thomas LaRock has a fantastic "How To: Restore The Master Database In SQL Server 2012" post. It's very well organized and has a lot of great examples and directions. SQLSkills also has a survey up…

Read more

0 comments, 555 reads

Posted in DBA On The Go on 15 January 2014

What Tables Are Wasted?

Wasted space still seems to be on everyone's mind to some extent. I've wondered what tables do we use? We have our offenders, those are easy to track. What about that little database that's been around for 4 years that no one left even really knows what it does? I…

Read more

1 comments, 490 reads

Posted in DBA On The Go on 13 January 2014

New Baby Girl!

On the 7th of January, 2014 my baby girl Kaitlyn was born. She came in about a month early.

This is my mother and my wife using face time so that my sick grandmother can see the new grand baby. It wasn't an intentional 4 generation picture.

Sleep exists... but…

Read more

1 comments, 459 reads

Posted in DBA On The Go on 9 January 2014

Posts I've Found Interesting:

This is a question I had until I came across a great script by The Scripting Guys. The script below is unaltered and entirely their creation. I just found it useful enough to forward it along. This is a short post. Prepping for a baby on the way has…

Read more

0 comments, 349 reads

Posted in DBA On The Go on 6 January 2014

Final Giveaway And Some Stats

Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012 Internals and Troubleshooting to Robert! I have been lucky enough to give away 4 months of PluralSight to Komal, Annapu Reddy Gayathri, Aadhar Joshi, and Daniel.

Things I've Learned Blogging


Read more

2 comments, 296 reads

Posted in DBA On The Go on 1 January 2014