Michael Coles

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)

2008-03-21 (first published: )

83,855 reads

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)

2008-01-25 (first published: )

37,691 reads

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)

2008-01-24 (first published: )

13,153 reads

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)

2007-08-24 (first published: )

52,365 reads

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)

2007-06-22 (first published: )

30,454 reads

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)

2007-04-10

5,892 reads

Blogs

Adding a License to GitHub

By

I’ve rarely thought about licensing my code, but it’s something to be aware of...

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

#PowershellBasics: Get-Help -Online

By

One of the other things I learned from the Powershell class I’m taking this...

Read the latest Blogs

Forums

CHECKSUM(3) = CHECKSUM(-3) ???

By David Rueter

I am trying to use CHECKSUM() to streamline a WHERE clause that detects when...

SP Estimated Execution Plan

By sizal0234

Please let me know your thoughts. FYI.. I removed the tb and Dbname. First...

SQL Server Sizing

By Admingod

I am trying to migrate Mysql Database which is hosted on Linux to SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers