Michael Coles


SQLServerCentral Article

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.

4.18 (11)

2018-10-10 (first published: )

77,481 reads

SQLServerCentral Article

SQL 2000 DBA Toolkit Part 1

SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.

4.67 (3)

2013-04-18 (first published: )

30,899 reads

SQLServerCentral Article

The Hazards of IT

Are you taking care of yourself as an IT professional? We try to cover all aspects of your SQL Server career here, not just the technical stuff. Longtime SQL Server guru Michael Coles brings us some health tips in an interview with Dr. Jerry Sanders

3.67 (3)

2008-05-23 (first published: )

9,654 reads

SQLServerCentral Article

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.

4.9 (58)

2008-04-04 (first published: )

100,195 reads

Blogs

Daily Coping 24 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Notes on SQLSaturday Jacksonville 2022

By

I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...

TSQL Tuesday #150: Your first technical job. Rollup.

By

This months subject for T-SQL Tuesday was Your first technical job. I have to...

Read the latest Blogs

Forums

Is this If Condition Expression Valid?

By Stamey

I hate to be a pain, but I am a beginner at this and...

SSRS 2012 Email Relay question

By wentigels

Hi All,   I am trying to figure out if it is possible to...

Interviewing for a SQL Server DBA role, any tips?

By subevenis

Hi all, as the title says, I'm interviewing for a job as a SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers