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   (RSS)
Showing page 2 of 3 (24 total posts)
  • NJ .NET User Group Presentation: Building a SQL Server Search Engine in .NET

    I'll be presenting at the Northern NJ .NET User Group meeting on Tuesday February 9.  Topics we'll cover include: Intro to SQL Server 2008 Integrated Full-Text Search (iFTS) features and functionality, including: Full-text indexes Thesaurus Word breakers, filters and stemming Multilanguage support Intro to SQL Server 2008 FILESTREAM ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 7, 2010
  • It's Official - SQLSaturday is Coming to NYC!

    New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010!  The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.  The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers.  This is a free full-day ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 6, 2010
  • Encrypt it in .NET/Decrypt it on SQL Server?

    A common question on the newsgroups is ''how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?'' I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details, but the answers all pretty much say the same thing -- ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 29, 2010
  • Parent-Child Build Scripts with SQLCMD

    On the SQL Server public programming newsgroup someone recently posted a question about an SSMS error (''Cannot parse script. 'System.OutOfMemoryException' thrown.'') I hadn’t encountered this error myself, but the workaround is to break up very large scripts (50+ MB) into smaller scripts. Adam Machanic posted a T-SQL Tuesday challenge to post a ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 10, 2010
  • 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
  • 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
  • Defensive database programming: eliminating IF statements.

    The following pattern is quite common in database programming: IF EXISTS(some query) BEGIN   DO SOMETHING; END When such code runs in high concurrency situations, it may not work as expected. I will provide a repro when such logic fails 40% of the time. The following script provides a test table and attempts to ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on November 27, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement