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 […]
SQL in the City US tour begins tomorrow #sqlcity
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered for an event in your area then hurry up as seats are limited. The events are being held in New York, Austin, San Francisco, Chicago, Boston and Seattle. Come hear about many day to day problems that we […]
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, […]
Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many red-gate products in my time as a DBA but was not familiar with SQL Storage Compress until a couple of months ago. I did what any regular DBA would do, downloaded a demo and put […]
SQL in the City – FREE Training
Is SQL in the City coming to a town near you? The events are being held in New York, Austin, San Francisco, Chicago, Boston and Seattle. If so you need to make sure to register ASAP as seats are filling up quick and seating is limited. Come hear about many day to day problems that […]