-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

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, 694 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, 666 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, 1,548 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, 1,618 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

2 comments, 4,142 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, 771 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, 2,374 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, 563 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, 611 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, 608 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, 733 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, 528 reads

Posted in Tim Radney - Database Professional on 13 April 2012

I am a Linchpin Team Mate

Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as Partners.  For those who do not know about Linchpin, they are a technology company with a focus on the Microsoft Database stack on the front, but behind the scene they… Read more

4 comments, 964 reads

Posted in Tim Radney - Database Professional on 13 April 2012

SQLSAT107

I was recently selected to speak at SQL Saturday 107 in Houston TX.  I am really excited to be selected from such a great group of folks who submitted.  This will be my second time speaking in TX, but my first time to Houston.

I will already be in Houston… Read more

0 comments, 506 reads

Posted in Tim Radney - Database Professional on 26 March 2012

SQL Skills IE3 #sqlskills

I attended my first SQL Skills event in December 2011.  Due to a big project at work I was able to work in week three of the Immersion Events which is HA/DR “High Availability and Disaster Recovery”.  Although I am taking the training out of sequence my hope is to… Read more

1 comments, 656 reads

Posted in Tim Radney - Database Professional on 16 March 2012

SQL Saturday 103 Recap

SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean.  I was fortunate enough to be able to attend this event and demo a couple of favorite tools of mine.  SQL Prompt and SQL Compare.  Being the PASS regional mentor for this area made me want to… Read more

0 comments, 579 reads

Posted in Tim Radney - Database Professional on 14 March 2012

Idera ACE Program

On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was included in the list.  http://bit.ly/ABedR0  March 9th could also be deemed the day twitter blew up my iPhone.  The congratulations from the SQL Community was truly amazing.

The Idera ACE… Read more

0 comments, 571 reads

Posted in Tim Radney - Database Professional on 14 March 2012

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database.  Since most folks probably don’t have a routine in place to record the version number each time SQL… Read more

0 comments, 2,516 reads

Posted in Tim Radney - Database Professional on 20 January 2012

SQL Server Login Auditing

In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins.  It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click on security and then check the proper radio button.  When… Read more

6 comments, 2,435 reads

Posted in Tim Radney - Database Professional on 3 January 2012

Increase SQL Server Error Log Files

Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance of SQL Server maintains.  This is real simple to change.  You can make the change via the GUI with a few simple steps or accomplish it with TSQL.

To make… Read more

5 comments, 3,580 reads

Posted in Tim Radney - Database Professional on 30 December 2011

Newer posts

Older posts