My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years.
I had a lot of fun working on this course and… Read more
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year. 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… Read more
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career. I am very excited to be working with some of the best in the industry… Read more
I often get asked for advice on how to get started in a career as a DBA or in IT in general. I make the often regurgitated information such as getting a few good books, a copy of SQL Server Developer Edition, watch webinars, attend user groups and SQL Saturdays,… Read more
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
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
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
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
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
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
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