THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL » SQL Server 2008   (RSS)
Showing page 2 of 2 (19 total posts)
  • Mission Accomplished: NJSQL Saturday Event

    Thanks to all those who made the NJSQL Saturday event held in Iselin, NJ today a success! Those lucky enough to attend were given a sneak preview of one of the best young presenters out there--MVP Jacob Sebastian--who will also be speaking at PASS.  I have to hand it to Jacob: he gave one of the best presentations on a SQL Server topic ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 24, 2009
  • NJSQL Saturday Event (10/24)

    The NJSQL user group is hosting a one-day Saturday SQL Server event at the Microsoft Iselin offices.  On October 24th Jacob Sebastian, Robert Pearl and I will be presenting on the following SQL Server topics: * T-SQL Defensive coding and exception handling best practices* Database forensics in SQL Server (''Who did it and ran?'')* SQL Server ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 6, 2009
  • No Backup For Asymmetric Keys

    The encryption features in SQL Server 2005 and 2008 provide the ability to create asymmetric encryption key pairs (RSA public/private key pairs) using the T-SQL CREATE ASYMMETRIC KEY statement. One feature that was left out, however, is the ability to backup and restore asymmetric key pairs generated on the server. Once an asymmetric key pair has ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on July 10, 2009
  • "Cloning" Symmetric Keys

    It's well-known by now that SQL Server 2005 and 2008 include new encryption-related statements that allow you to create and administer encryption keys. You can use CREATE CERTIFICATE to create or import a certificate or DROP ASYMMETRIC KEY to remove an asymmetric key from the database, for instance.  One of the interesting ommissions ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 17, 2009
  • Presenting in Louisville; Meeting in Cincinnati

    I'll be presenting ''New SQL Server 2008 Features'' in downtown Louisville, KY on June 22, in conjunction with the Louisville SQL Server Users Group thanks to group leader Malathi Mahadevan.  We'll be giving away some SQL 2008 books and other goodies.  I'll post further details (exact time and location) shortly. Update:  The ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 1, 2009
  • Protecting Your Data @ Rest Presentation (Tuesday)

    Tuesday night I'll be presenting on SQL Server encryption to the NJSQL user's group in Parsippany.  More information about this event and NJSQL can be found here: http://njsql.org/Default.aspx. UPDATE: Uploaded the encryption presentation, attached to this post.
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on May 16, 2009
  • XML Optimization Presentation Sample Code

    During the XML Optimization presentation today I'll refer back to the sample code posted at http://www.apress.com/book/downloadfile/4021.  I'll also update this post with additional sample code by tomorrow. UPDATE: The PowerPoint presentation and sample code are attached to this post in the ZIP file. Jacob Sebastian's book ''The Art of ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on May 16, 2009
  • Let's Hash a BLOB

    In my last post I talked about how to work around a couple of the limitations of SQL Server encryption by using SQL CLR and the .NET Framework to encrypt a BLOB value (up to 2.1 GB in size), using any supported algorithm you choose. In the example I used AES to encrypt data using a passphrase. SQL Server 2008 also allows you to generate ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 12, 2009
  • Practical SQL Server XML: Part 2

    In response to a challenge from Pinal Dave, a fellow MVP and a winner of an award for his blog at the MVP Summit 2009, I am writing a couple of articles to demonstrate practical uses for SQL Server’s XML capabilities.  (Dave’s great blog is at http://blog.sqlauthority.com/). Dave posted the first post in this series over at ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on March 3, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement