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 […]
PASS Summit 2012 – Networking
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle Washington and attended the largest Microsoft SQL Server convention in the world. My first year was all about attending sessions and learning new things. Year two was about attending technical sessions and hanging out with […]
Instant File Initialization with TDE
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization. Microsoft does not provide many details around the reasoning why but I would have to assume that since data is encrypted at the page level, that TDE has to still […]
Scripting out users
Many of us know the importance of scripting out our users on a regular bases in order to be able to before DR restores more efficiently. If you are responsible for performing backup and restores or disaster recovery solutions and you do not have a routine to regularly script out your users and permissions, then […]
SQL Backup and Recovery
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very important to me. As database professionals, few things are more important than being able to properly backup and recover our data. I had put together a presentation for user groups and SQL Saturday’s titled “Know […]