Browse by Tags

Related Posts
  • Blog Post: How Important Is Your Data? (Mini-Lab Part 1/2)

    [Next Post in Series] What would it mean to you and your business if a hacker or a competitor had access to your database? What would happen if data like personal customer information, Human Resources data, sales details, product lists and prices got in the wrong hands? What about banking information...
  • Blog Post: Using Read-Committed Snapshot Isolation - Mini-Lab

    Dassault ENOVIA requires the use of read-committed snapshot isolation. By using the read-committed snapshot isolation level introduced in Microsoft SQL Server 2005, you can reduce blocking and deadlocking issues caused by lock contention. Every time a row is modified by a specific transaction, the instance...
  • Blog Post: Mini-Lab - Part 2 - Backup Compression with Resource Governor

    [Prior Post in Series] In Part 1 of this 2 part Mini-Lab series we looked at a new feature that was introduced in SQL Server 2008 called Backup Compression. We were able compress the backups of our test database ( 2008FeaturesDB ) to roughly 10% of the size of the uncompressed full backup while also...
  • Blog Post: How Important Is Your Data? (Mini-Lab Part 2/2)

    [Prior Post in Series] In Part 1 of this 2 part Mini-Lab series we looked at setting up TDE (Transparent Data Encryption) for a database and backing it up. In Part 2 we're going to discuss restoring a database (that has TDE enabled) to a different instance as well as disabling and removing TDE if...
  • Blog Post: Use CPU Instance Counters for Better Insight

    Windows Performance Monitor, a management tool included with Windows, is a key tool for understanding the performance characteristics of your database server. Performance Monitor lets you observe a wealth of metrics about the activity of the operating system and applications such as SQL Server 2008....
  • Blog Post: Mini-Lab - Part 1 - Backup Compression

    [Next Post in Series] In previous blog posts we have touched briefly on some of the new features that were introduced in SQL Server 2008 but if you're like me you need to get your hands dirty and work with them before you really understand and see the value. BACKUP COMPRESSION Backup Compression...