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 and a bit nervous to leave a […]
Category: SQLServerPedia Syndication
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 to an invalid dataset within a […]
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 knowledge of Microsoft products with others.” […]
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 best opportunity to learn as […]
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 are very important when determining […]
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 common backup strategy for VLDB’s […]
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 business. I have found a […]
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 recovery strategies. It is very […]