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,639 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,964 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,679 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,986 reads

Blogs

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022

By

Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs

Forums

When use sql graph on sql server 2019 ?

By ahmed_elbarbary.2010

I working on sql server 2019 . i read more about sql graph but...

how to change hard coded dates to ytd please

By asita

Dear Helpers, Below query is working fine giving me what i needed but if...

Couldn't allocate new page for database alert even the Database has free space

By ramana3327

Hi, We have a database. We received the alert Could not allocate new page...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers