Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Michael Coles

SQLServerCentral.com profile

<< Newer    Items 21 to 25 of 25   
 

The Basics of Cryptology

After a fantastic reception to his SQL Server 2000 cryptography toolkit, Michael Coles brings us a basic look at cryptography so you can understand what you are getting into if you implement it.   Read more...
By Michael Coles 2005/08/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,897 reads

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,275 reads

Sound Matching and a Phonetic Toolkit

One of the features of SQL Server 2000 is the Soundex feature that allows phonetic matching. Michael Coles brings us a new toolkit that solves some of the issues that occur with soundex as well as an explanation why this occurs.   Read more...
By Michael Coles 2005/08/03 | Source: SQLServerCentral.com | Category: full-text search
Rating: |  Discuss |   Briefcase | 13,823 reads

Gotcha! SQL Aggregate Functions and NULL

Working with NULL functions can be tricky in T-SQL and SQL Server 2000. If you add in aggregates, you need to be sure you understand what the behavior will be or you might report incorrect values to a user. Michael Coles has written a new article that talks about how NULL affects your results.   Read more...
By Michael Coles 2008/04/04 (first published: 2005/07/05) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 86,662 reads

Four Rules for NULLs

In SQL Server 2000 or any relational database, the concept of NULL can be both confusing and hazardess to your employment. Not understanding how to work with NULLs can lead to incorrect responses to queries and poor business decisions being made. New author Michael Coles brings us four rules that can help you work with NULL values in your tables.   Read more...
By Michael Coles 2008/03/28 (first published: 2005/06/27) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 88,314 reads
<< Newer    Items 21 to 25 of 25