Michael Coles


SQLServerCentral Article

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.

4.9 (99)

You rated this post out of 5. Change rating

2008-03-28 (first published: )

94,660 reads

SQLServerCentral Article

Updated SQL Injection

SQL injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought.

4.03 (30)

You rated this post out of 5. Change rating

2008-03-21 (first published: )

84,995 reads

SQLServerCentral Article

NULL Versus NULL?

Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new
tricks with NULLs.

4.74 (81)

You rated this post out of 5. Change rating

2008-01-25 (first published: )

39,147 reads

SQLServerCentral Article

SQL 2005: Enter XML

SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.

5 (3)

You rated this post out of 5. Change rating

2008-01-24 (first published: )

13,180 reads

SQLServerCentral Article

SQL 2005 Symmetric Encryption

One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate.

4.75 (16)

You rated this post out of 5. Change rating

2007-08-24 (first published: )

54,474 reads

SQLServerCentral Article

Sic Semper NULL

The great debate over NULLs will probably never end. Should we use them in our databases? What meaning do they have? These are all
valid questions. In this article SQL Server expert Michael Coles takes a look at the problems that are inherent in eliminating NULLs completely from
a database.

5 (2)

You rated this post out of 5. Change rating

2007-04-10

5,969 reads

Blogs

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Advice I Like: Transactions and Relationships

By

Life gets better as you replace transactions with relationships. – from Excellent Advice for...

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Read the latest Blogs

Forums

Yankees Mailbag: Assembling the lineup buy and in general reflections

By Bellingers

Wonderful afternoon every person, it's season towards dive again into the mailbag and resolution...

Limits, Not Goals

By Grant Fritchey

Comments posted to this topic are about the item Limits, Not Goals

Making Additions and Changes; Getting Error Preventing Them

By Ahr Aitch

MS SQL Server/SSMS are my tools. As my project evolves I find I need...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, length, and scale for an int variable?

See possible answers