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.

SQL Saturday 167

SQL Saturday #167 is just hours away.  We have worked hard to get everything setup and in place and hope no details were missed.  We have an excellent lineup of speakers, coffee and donuts ordered for the morning, hundreds of bottles of water and soda, large coolers, swag bags packed,… Read more

0 comments, 312 reads

Posted in Tim Radney - Database Professional on 7 September 2012

Reducing Your Storage Footprint Using SQL Storage Compress

I was asked to speak at SQL in the City in New York and Austin Texas.  I have used many red-gate products in my time as a DBA but was not familiar with SQL Storage Compress until a couple of months ago.  I did what any regular DBA would do,… Read more

0 comments, 1,427 reads

Posted in Tim Radney - Database Professional on 4 September 2012

SQL in the City – FREE Training

Is SQL in the City coming to a town near you?  The events are being held in New York, Austin, San Francisco, Chicago, Boston and Seattle.  If so you need to make sure to register ASAP as seats are filling up quick and seating is… Read more

0 comments, 548 reads

Posted in Tim Radney - Database Professional on 29 August 2012

When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on a tier one application.  Unfortunately it was on a system that utilizes SQL 2000 SP4.  Having a rather small toolset to use for support I had to rely on Perfmon,… Read more

3 comments, 396 reads

Posted in Tim Radney - Database Professional on 3 August 2012

Support from Atlanta MDF

 

I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in Columbus GA.  The Columbus GA SQL Users Group has been dubbed the “Extreme Southwest Atlanta Chapter” by Aaron Nelson (blog, twitter)  For the past two years… Read more

0 comments, 315 reads

Posted in Tim Radney - Database Professional on 22 July 2012

Redirecting a page on WordPress

WordPress creates a unique link for each of your post. They are broken out with your URL then YYYY / MM / DD then what you are allowed to name your link. This is inconvenient when trying to reference back to yourself. Wouldn’t it be nice to have a shorter… Read more

0 comments, 391 reads

Posted in Tim Radney - Database Professional on 22 July 2012

Talent Shift

Today a friend Kevin Edward Kline announced he was joining SQL Sentry.  Last week Kevin announced his intent to leave Quest Software which he has been at for over 10 years.  Being part of the SQL Community for the past 4 years, Kevin has been a staple of Quest.  When… Read more

1 comments, 351 reads

Posted in Tim Radney - Database Professional on 16 July 2012

IOPS verses Throughput – Measuring Performance of Your Storage

Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s verses IOPS as I had recommended a storage array that would provide many more IOPS and throughput than what is currently in use.

For this client I had presented the… Read more

3 comments, 712 reads

Posted in Tim Radney - Database Professional on 6 July 2012

File Extensions for SQL Server Database Files

I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL Server database files was .MDF for the data file, LDF for the log file and NDF for additional data files.  This was good stuff so far, then the author stated… Read more

3 comments, 487 reads

Posted in Tim Radney - Database Professional on 18 June 2012

One week after #sqlsat132

 

It has been nearly one week since SQL Saturday 132 in Pensacola Florida.  I was chosen to give my talk on “Know Backups and Know Recovery”.  The session was in the first time slot and when I arrived at the event just before 8:00 AM I had to walk through… Read more

0 comments, 403 reads

Posted in Tim Radney - Database Professional on 15 June 2012

SQL Saturday #167 – Columbus GA

The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus State University.  We currently have 5 classrooms reserved and have the ability to add a couple more if needed.  Each room holds over 40 people so our current capacity is… Read more

2 comments, 708 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

9 comments, 736 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Turn on Instant File Initialization for SQL Server Performance

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

1 comments, 2,683 reads

Posted in Tim Radney - Database Professional on 30 May 2012

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written.  He received an error, “cannot resolve collation conflict for equal to operator”.

Early in my career I had experienced the same issue so I quickly searched my code snippets and… Read more

0 comments, 594 reads

Posted in Tim Radney - Database Professional on 25 May 2012

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into a development environment you don’t care so you just restore… Read more

5 comments, 1,709 reads

Posted in Tim Radney - Database Professional on 21 May 2012

SQL Saturday 112 Recap

I had the pleasure of attending SQL Saturday 112 this past weekend.  This was my second time speaking at a SQL Saturday in Birmingham.  I was selected to present two sessions again this year in the first and second time slot.  I started off with “Getting Involved and Getting Ahead”.… Read more

0 comments, 350 reads

Posted in Tim Radney - Database Professional on 17 May 2012

It was time for an upgrade


I am not one of these anti PC sorta guys, but I do love my MacBook Pro.  I have owned a PC since 1993 when I got my Packard Bell 386 with Windows 3.1.  Even with my MacBook I have 9 Windows flavored VM’s on it.  To be honest, I… Read more

1 comments, 398 reads

Posted in Tim Radney - Database Professional on 5 May 2012

Spend two hours with me at #sqlsat107.

In just two days SQL Saturday 107 will be in full swing.  Tomorrow begins their precon with the infamous Kalen Delaney.  Those who were lucky enough to sign up and get one of the coveted spots are in for a treat.  Thanks to the Idera ACE program I was blessed… Read more

0 comments, 412 reads

Posted in Tim Radney - Database Professional on 19 April 2012

Becoming the dumbest guy in the group

“Why I joined Linchpin People as a Teammate”

It was announced publicly this past weekend at SQL Saturday #111 that I have joined Linchpin People as their first teammate.  My friend Andy who is also a Chief Servant Officer of Linchpin made the announcement during the speaker dinner and gave… Read more

4 comments, 437 reads

Posted in Tim Radney - Database Professional on 19 April 2012

I am speaking at #sqlsat111 on TEMPDB.

I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend.  I will be doing my session called “It’s TEMPDB, Why Should You Care”.  In this session I cover the importance of TEMPDB and how best to configure TEMPDB in your environment.  Not only do I cover… Read more

0 comments, 322 reads

Posted in Tim Radney - Database Professional on 13 April 2012

Newer posts

Older posts