Category Archives: 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 … Continue reading

Share
Posted in Pluralsight, Presentations, SQLServerPedia Syndication, Training/Events | Leave a comment

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 … Continue reading

Share
Posted in Presentations, SQLServerPedia Syndication, Training/Events | Tagged , , , , | 5 Comments

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 … Continue reading

Share
Posted in Presentations, SQLServerPedia Syndication, Training/Events | Tagged , , , , | Leave a comment

I am joining SQLskills

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | 10 Comments

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”. … Continue reading

Share
Posted in Query Tidbits, SQLServerPedia Syndication | Leave a comment

Microsoft SQL Server “Most Valuable Professional” MVP << I am one #mvpbuzz

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 … Continue reading

Share
Posted in Presentations, SQLServerPedia Syndication | Tagged , , | 6 Comments

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | 3 Comments

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 … Continue reading

Share
Posted in Backups/Recovery, SQLServerPedia Syndication | 2 Comments

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 … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits, SQLServerPedia Syndication | Leave a comment

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 … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits, SQLServerPedia Syndication | 20 Comments