Category: SQLServerPedia Syndication

New Course: Understanding and Using Azure SQL Database

At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my course on Azure SQL Database was just published on Pluralsight too! While I am sharing awesome news, we also launched our new 3 day training class on upgrading SQL Server that Glenn and I will […]

SQL Saturdays and Why We Have Them

There has been some recent controversy over SQL Saturdays after PASS HQ announced some new changes. The changes introduced a new 600 mile radius for SQL Saturdays on the same day, an expansion from the previous 400 mile rule as well as reducing the PASS sponsorship from $500 per event to $250 per event and […]

SQL Server: Consolidation Tactics and Best Practices

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 owe so much to Paul Randal […]

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.” […]

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 […]