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
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
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
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
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
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
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
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
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
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
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
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
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
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
I have known Tim for a few years now. We have attended numerous events together over the years and… Read more
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
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
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
<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
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