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.

#Summit14 Embarcadero Book Signing

The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies to PASS Summit 2014 attendees. You will need to come by booth 224 on Thursday November 6th between 3pm – 4pm to be able to pick up a signed copy… Read more

1 comments, 70 reads

Posted in Tim Radney - Database Professional on 4 November 2014

Managing Geeks – A journey of leading by doing

I am proud to share that my good friend Andy Leonard has just released a new book. This is also the second book published by LinchpinPress.

Over the years Andy has blogged about his experiences with managing technical teams. Andy wrote over 50 post on the subject and has… Read more

1 comments, 105 reads

Posted in Tim Radney - Database Professional on 29 October 2014

SQL Server 2014 Backup and Recovery

In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my first two books, however Joes2Pros is focusing its time and energy into video content. When SQL 2014 was released and new features were added for backups, there was a… Read more

1 comments, 105 reads

Posted in Tim Radney - Database Professional on 29 October 2014

SQL Server 2008 SP4 Released

On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates since SP3 was released as well as all updates from previous service packs.

Today begins the day we should all begin testing in Dev with SP4. You can get information… Read more

0 comments, 143 reads

Posted in Tim Radney - Database Professional on 1 October 2014

What PASS is to me #sqlpass

I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL Server Heroes UNITE”. For those who don’t know what the PASS Summit is, it is the largest SQL Server and BI convention in the world. A SQL Nerd… Read more

1 comments, 111 reads

Posted in Tim Radney - Database Professional on 29 September 2014

4 Things I Wish I Knew Sooner

I was recently called out by Tim Costello on a blog series started by Mike Walsh.  http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant

The series calls for each blogger to list 4 things they wish they had known sooner in their career as a data geek.

1) Knowing how to query data != DBA. You will… Read more

2 comments, 219 reads

Posted in Tim Radney - Database Professional on 2 September 2014

An error occurred while executing batch. Error message is: Arithmetic Overflow

Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic Overflow”.

Experience has taught me that this message is related… Read more

0 comments, 161 reads

Posted in Tim Radney - Database Professional on 31 July 2014

Microsoft SQL Server “Most Valuable Professional” MVP

Today I received an email notifying me that I have been awarded the Microsoft “MVP” award. An excerpt from Microsoft’s website states

The Microsoft Most Valuable Professional (MVP) Award is our way of saying thank you to exceptional, independent community leaders who share their passion, technical expertise, and real-world… Read more

5 comments, 187 reads

Posted in Tim Radney - Database Professional on 1 July 2014

I am speaking at the PASS Summit 2014

I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is considered the Super Bowl of SQL Server Conferences. It is the worlds largest gathering of SQL minded nerds. Consider it a SQL Server Nerd Herd.

Kidding aside it is the… Read more

2 comments, 125 reads

Posted in Tim Radney - Database Professional on 25 June 2014

SQL Server High Availability and Disaster Recovery Options

Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the availability of SQL Server databases.  Questions that always come up when discussing availability of the data is “Recovery Time Objective – RTO” and “Recovery Point Objective – RPO”.  Both questions… Read more

1 comments, 1,433 reads

Posted in Tim Radney - Database Professional on 10 June 2014

Know Backups and Know Restores – SQL Server Restores

A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving factor behind me building this session was the response I got from talking to a dozen or so DBA’s about disaster recovery. I asked how many have ever performed… Read more

1 comments, 233 reads

Posted in Tim Radney - Database Professional on 19 May 2014

Making a Difference – #SQLFamily

When I started with the SQL Community I was first encourage to start blogging which I started in Sept of 2010. While at the PASS Summit in 2010 I was encourage to submit to speak at a SQL Saturday. I submitted my first ever session for SQL Saturday #62 and… Read more

0 comments, 250 reads

Posted in Tim Radney - Database Professional on 12 May 2014

Using BMC Control-M to Automate Tasks

My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our environment I have been watching it displace other schedulers to become the centralized scheduler.  As I have learned more about the capabilities of Control-M as well as becoming more alert… Read more

6 comments, 1,252 reads

Posted in Tim Radney - Database Professional on 4 April 2014

The Primary Filegroup Cannot be Backed Up as a File Backup

File Group backups are great when working with very large databases (VLDB’s) that have been partitioned.  Typically when I come across File Group backups implemented in production the database is using the full recovery model. With the full recovery model you can specify individual file groups for backup. A very… Read more

0 comments, 408 reads

Posted in Tim Radney - Database Professional on 31 March 2014

How to check for last SQL Server backup

As a database professional, I get asked to review the health of database environments very often. When I perform these reviews, one of the many checks I perform is reviewing backup history and making sure that the backup plans in place meet the requirements and service level agreements for the… Read more

8 comments, 1,771 reads

Posted in Tim Radney - Database Professional on 18 February 2014

SSIS Training class by Andy Leonard

 

 

Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class is being offered in Reston, VA, May 19-23 2014. Andy is one to the top guru’s… Read more

0 comments, 233 reads

Posted in Tim Radney - Database Professional on 30 January 2014

How to reset the SA password in SQL Server

Getting locked out of a SQL Server can happen in a number of ways.  You could inherit a server that was managed by someone that left the company and only that person had System Admin rights for example. A recent encounter I had was were a database server was built… Read more

7 comments, 3,819 reads

Posted in Tim Radney - Database Professional on 21 November 2013

Children at Technical Conferences

I have had the pleasure of taking my son with me on a number of trips where I was a presenting at a technical conference.  My son loves to travel with me and to get to see exciting new places. I have seen a big change in him from the… Read more

3 comments, 312 reads

Posted in Tim Radney - Database Professional on 22 October 2013

Why I am not an MVP

On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to be renewed and notifying the newly awarded MVP’s. Within the SQL Server community the first day of each quarter means many are anxiously monitoring their inbox and spam folders in… Read more

0 comments, 344 reads

Posted in Tim Radney - Database Professional on 2 October 2013

Recovering the tail end of the transaction log

Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the recovery models, recovery point objectives and recovery time objectives. What I have found from speaking at many SQL Saturday’s and User Groups is that most DBA’s do not regularly practice… Read more

1 comments, 838 reads

Posted in Tim Radney - Database Professional on 2 October 2013

Older posts