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.

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

5 comments, 925 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, 260 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

7 comments, 1,544 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, 129 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

6 comments, 3,473 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, 202 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

8 comments, 260 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

0 comments, 744 reads

Posted in Tim Radney - Database Professional on 2 October 2013

PASS Elections part two

Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think we need to have a “TIM” on the Board of Directors.

I have known Tim for a few years now. We have attended numerous events together over the years and… Read more

2 comments, 164 reads

Posted in Tim Radney - Database Professional on 24 September 2013

PASS Elections

I as well as many others have a decision to make on who I am voting for the PASS Board of Directors. I haven’t made my mind up completely for all the votes I get to cast but one vote for sure is for Allen Kinsel.

Why is my mind… Read more

1 comments, 142 reads

Posted in Tim Radney - Database Professional on 23 September 2013

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I support.  In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value… Read more

0 comments, 315 reads

Posted in Tim Radney - Database Professional on 20 September 2013

SQL in the City 2013 US Tour

It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate put on a phenomenal tour in 2012 hitting 6 major cities. This year they are bringing the event back. This year will bring Red Gate to Pasadena on October 9th,… Read more

0 comments, 282 reads

Posted in Tim Radney - Database Professional on 30 August 2013

Professional Etiquette When Sending Mass Email – Use BCC:

<begin soap box rant>

Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email.

The main rule of thumb I tell the senders is that if dialog is not… Read more

0 comments, 240 reads

Posted in Tim Radney - Database Professional on 30 August 2013

Cannot create Cluster – the computer X is joined to a cluster

Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”.

 

 

My… Read more

2 comments, 550 reads

Posted in Tim Radney - Database Professional on 21 August 2013

Linchpin People Partner

In April 0f 2012 I was fortunate enough to be asked to become Linchpin People LLC’s first ever TeamMate. (blog). I was really cool to become part of a great group of guys like Andy Leonard (blog | twitter), Brian Moran (blog | twitter)… Read more

1 comments, 201 reads

Posted in Tim Radney - Database Professional on 13 August 2013

Speaking at PASS Summit 2013

PASS Summit 2013 will be my fifth Summit to attend.  I wrote a blog post about how different my fourth Summit experience as from the previous three. Summit 2012 was all about networking and offered my first experience to speak to a crowd.  Idera allowed me to present two sessions… Read more

1 comments, 177 reads

Posted in Tim Radney - Database Professional on 9 August 2013

SQL Community Speakers – Why We Do It

I started this post over a year ago and have just now come back around to finish it.  Over the years I have been asked about a few misconceptions about speakers for SQL Saturday’s.

Over the past several years as I have been involved with speaking and organizing SQL Saturday’s.… Read more

7 comments, 176 reads

Posted in Tim Radney - Database Professional on 24 July 2013

SQL Server Installation Date

I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server.  In doing a quick search on where this property would… Read more

0 comments, 271 reads

Posted in Tim Radney - Database Professional on 27 June 2013

What is Page Life Expectancy (PLE) in SQL Server

Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a good way to quickly look at proper memory usage.

Checking… Read more

0 comments, 532 reads

Posted in Tim Radney - Database Professional on 8 March 2013

SSIS training for a cause

On Thursday March 14th (PI Day) in Duluth GA, Audrey Hammonds and Julie Smith will put on a spectacular SSIS training event to benefit the Cloverleaf School of Atlanta.

Both Audrey and Julie are SQL Server MVP’s and have given a countless amount of their time to the SQL… Read more

1 comments, 227 reads

Posted in Tim Radney - Database Professional on 12 February 2013

Older posts