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 […]
Category: SQLServerPedia Syndication
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 […]
SQL Saturday 167
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope no details were missed. We have an excellent lineup of speakers, coffee and donuts ordered for the morning, hundreds of bottles of water and soda, large coolers, swag bags packed, signage ready to put up, […]
When Things That Are Supposed to Protect You Try to Kill You
This past week I was presented with a very unique issue. A call came in with a production issue on a tier one application. Unfortunately it was on a system that utilizes SQL 2000 SP4. Having a rather small toolset to use for support I had to rely on Perfmon, sysprocesses and the usual old […]
Support from Atlanta MDF
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in Columbus GA. The Columbus GA SQL Users Group has been dubbed the “Extreme Southwest Atlanta Chapter” by Aaron Nelson (blog, twitter) For the past two years our two chapters have worked together in promoting […]
Talent Shift
Today a friend Kevin Edward Kline announced he was joining SQL Sentry. Last week Kevin announced his intent to leave Quest Software which he has been at for over 10 years. Being part of the SQL Community for the past 4 years, Kevin has been a staple of Quest. When I would see a logo […]
IOPS versus Throughput – Measuring Performance of Your Storage
Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s versus IOPS as I had recommended a storage array that would provide many more IOPS and throughput than what is currently in use. For this client I had presented the expected IOPS per type of […]