I started this post over a year ago and have just now come back around to finish it. Over the years I have been asked about a few misconceptions about speakers for SQL Saturday’s. Over the past several years as I have been involved with speaking and organizing SQL Saturday’s. Like many I love hanging […]
SQL Server Installation Date
I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server. In doing a quick search on where this property would be located I found that sys.server_principals […]
What is Page Life Expectancy (PLE) in SQL Server
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a good way to quickly look at proper memory usage. Checking out the Page Life Expectancy […]
SSIS training for a cause
On Thursday March 14th (PI Day) in Duluth GA, Audrey Hammonds and Julie Smith will put on a spectacular SSIS training event to benefit the Cloverleaf School of Atlanta. Both Audrey and Julie are SQL Server MVP’s and have given a countless amount of their time to the SQL Server Community over the years. Visit their […]
How to break a high end de-duplication backup device
I have been working with a client recently who purchased a nice top of the line de-duplication backup device in order to synchronize backups between two data centers. This device is very nice in how it will de-duplicate data to reduce storage needs and also compress the data. It will then synchronize the data to […]
SQL Backup and Recovery – new distribution
I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and Noble’s website in addition to Amazon in print and Kindle. This is very exciting. In just three months SQL Backup and Recovery has sold nearly 500 copies. I am still in awe that my name […]
SQL Saturday 220 Atlanta GA
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over will come together in Atlanta GA for a full day of free training. I have been part of the previous two years SQL Saturday events in Atlanta and have had a blast volunteering and helping […]
Performance Impact from Page Splits
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list I noticed memory pressure on the box and made the recommendationof more memory which was simple to fix. What caught my attention though was that blocking was occurring on a transaction that was trying to […]