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.

How to break a high end de-duplication backup device

I have been working with a client recently who purchased a nice top of the line de-duplication backup device in order to synchronize backups between two data centers. This device is very nice in how it will de-duplicate data to reduce storage needs and also compress the data. It will… Read more

1 comments, 700 reads

Posted in Tim Radney - Database Professional on 8 February 2013

SQL Backup and Recovery – new distribution

I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and Noble’s website in addition to Amazon in print and Kindle. This is very exciting.

In just three months SQL Backup and Recovery has sold nearly 500 copies. I am… Read more

0 comments, 246 reads

Posted in Tim Radney - Database Professional on 5 February 2013

SQL Saturday 220 Atlanta GA

That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over will come together in Atlanta GA for a full day of free training.  I have been part of the previous two years SQL Saturday events in Atlanta and have had… Read more

0 comments, 323 reads

Posted in Tim Radney - Database Professional on 4 February 2013

Performance Impact from Page Splits

Recently I was brought in to help troubleshoot performance issues on a database server.  Going through my typical check list I noticed memory pressure on the box and made the recommendationof more memory which was simple to fix. What caught my attention though was that blocking was occurring on a… Read more

8 comments, 858 reads

Posted in Tim Radney - Database Professional on 30 January 2013

PASS Summit 2012 – Networking

I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle Washington and attended the largest Microsoft SQL Server convention in the world. My first year was all about attending sessions and learning new things. Year two was about attending technical… Read more

1 comments, 242 reads

Posted in Tim Radney - Database Professional on 20 November 2012

Instant File Initialization with TDE

If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization.

Microsoft does not provide many details around the reasoning why but I would have to assume that since data is encrypted at the page level,… Read more

0 comments, 320 reads

Posted in Tim Radney - Database Professional on 13 November 2012

Scripting out users

Many of us know the importance of scripting out our users on a regular bases in order to be able to before DR restores more efficiently.  If you are responsible for performing backup and restores or disaster recovery solutions and you do not have a routine to regularly script out… Read more

1 comments, 478 reads

Posted in Tim Radney - Database Professional on 2 November 2012

SQL Backup and Recovery

I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very important to me. As database professionals, few things are more important than being able to properly backup and recover our data.

I had put together a presentation for user groups… Read more

4 comments, 292 reads

Posted in Tim Radney - Database Professional on 1 November 2012

SQL in the City US tour begins tomorrow #sqlcity

 

 

 

 

The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered for an event in your area then hurry up as seats are limited.

The events are being held in New YorkAustinSan Francisco Read more

0 comments, 551 reads

Posted in Tim Radney - Database Professional on 27 September 2012

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, 279 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,362 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, 504 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, 357 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, 286 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, 343 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, 315 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

2 comments, 621 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

2 comments, 437 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, 357 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, 640 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Newer posts

Older posts