Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Radney - Database Professional

Tim Radney - Database Professional by Tim Radney I am a Sr DBA for a top 40 US bank. I live in the south eastern US. I have been working with database since 1999 but only full time for the past three years.

Archives: July 2011

Spoke at #sqlsat81

I presented two sessions this weekend in Birmingham AL at SQL Saturday 81.  I was in the first slot of the day with my “You Inherited a Database, Now What” session.  The room was pretty full so I was excited.  I had a great group that was very interactive.

My… Read more

0 comments, 558 reads

Posted in Tim Radney - Database Professional on 31 July 2011

Thank you PASS Community

This has been a great week for me.  I had a lot of new faces come out for the Columbus GA SQL Users Group meeting Tuesday night as well as being notified that I have been made a PASS Regional Mentor for South Central US. Mark Ginnebaugh sent out the… Read more

0 comments, 505 reads

Posted in Tim Radney - Database Professional on 29 July 2011

Build a schedule for SQL Saturday

A new feature has been added to SQL Saturday.  Now when you register for an event you can build your schedule on the website.  I used it tonight to build my schedule for SQL Saturday 81.  This will be a huge help for attendees in preparing for their big… Read more

1 comments, 572 reads

Posted in Tim Radney - Database Professional on 29 July 2011

Preparing for #sqlsat81

SQL Saturday 81 is coming up this weekend in Birmingham AL.  This will be my 5th SQL Saturday to speak at.  So far I have spoken in Tampa FL, Columbia SC, Jacksonville FL and Pensacola FL.  I still get nervous getting up in front of some many people to speak,… Read more

0 comments, 143 reads

Posted in Tim Radney - Database Professional on 27 July 2011

What is the hardest part of planning a SQL Saturday?

For me so far it has been the speaker selection.  Getting sponsors didn’t prove to be difficult, we have a great market being we are Atlanta GA.  Locating a venue to hold the event presented a few challenges but again we are a large area so there are several venue… Read more

0 comments, 204 reads

Posted in Tim Radney - Database Professional on 27 July 2011

Get count of folders using Power Shell

More on my recent PowerShell project.  I recon I have taken on the challenge to handle this entire request using Posh.  It started out just moving folders based on the folder name that included the date in format MMDDYY.  Next was having to stop services before moving the folders.  After… Read more

0 comments, 199 reads

Posted in Tim Radney - Database Professional on 25 July 2011

Starting and Stopping a Remote Service with PowerShell

A recent project I was working on required me to move folders from a staging location to a processing location.  I found that PowerShell was the easiest way to accomplish that.  After getting that part of the project working a new requirement came up.  In order to move the folders… Read more

0 comments, 1,386 reads

Posted in Tim Radney - Database Professional on 18 July 2011

My first PowerShell Script to Move Folders

I just had my first encounter with having to write a PowerShell script.  The request seemed pretty harmless when I originally got it.  The request was much like others I had gotten in the past where I needed to check to make sure that data had been loaded and kick… Read more

2 comments, 903 reads

Posted in Tim Radney - Database Professional on 15 July 2011

SQL Saturday 89 Pre-Con

Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89 in Atlanta on September 16th?  For starters I am a production DBA.  Sure I create SSRS reports and build ETL processes with SSIS and the like, but… Read more

0 comments, 223 reads

Posted in Tim Radney - Database Professional on 14 July 2011

Listing Stored Procedures From Every Database

Recently I answered a question on AskSSC that I thought I would create a quick blog about.  Someone had asked if there was an easy way to run SELECT * FROM SYS.PROCEDURES on every database.  I immediately thought of the undocumented stored procedure sp_msforeachdb.  I posted a response and gave… Read more

1 comments, 341 reads

Posted in Tim Radney - Database Professional on 4 July 2011

Planning a SQL Saturday

On June 8th we announced SQL Saturday 89.  The call for speakers went out to all those who had submitted sessions at a previous SQL Saturday, an alert went out to sponsors and the event was live.  Immediately emails started coming in, people started registering and sessions were being submitted.… Read more

0 comments, 149 reads

Posted in Tim Radney - Database Professional on 1 July 2011