Michael Coles

The Joy of Numbers

Numbers are fascinating concepts in all types of mathematics, but they can be very helpful as well in your SQL Server queries. Guru Michael Coles brings us a look at how a numbers table can you and includes a bunch of code for both SQL Server 2000 and SQL Server 2005.

5 (1)

2006-08-14

16,754 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.

5 (1)

2006-05-04

14,077 reads

Sequential Ordering on SQL 2005

Many people have posed the question of how to generate sequential numbers for some report when the underlying data has no numbering system. The solutions have always been complicated derived or temporary tables and are difficult to implement. SQL Server 2005, however, brings us the ROW_NUMBER() function and author Michael Coles shows us how this can be used to easily add sequential numbering to your results.

5 (5)

2006-02-14

18,338 reads

Blogs

Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around

By

(2020-May-24) It has never been my plan to write a series of articles about how...

3D Printing Ear Savers

By

On April 5th, I started printing ear savers for healthcare workers. I started with...

Updated Default Settings for Azure SQL Managed Instance Databases

By

A common saying about Azure is that it is always changing. This is a...

Read the latest Blogs

Forums

Golden Goose Sneakers popular

By ashoessaler

But thanks to the jolie laide shoe phenomenon (kick-started back in 2013 with Phoebe...

Configuring the Analysis Services Query Log still supported in SQL 2017/2019 ?

By Pierrot

Option seems to be still available, but I don't get it working. Latest documentation...

Are there application developers in here? Where are you doing your SQL?

By bbsimonbb

Hi, Are there app developers in this forum? Where does your app's SQL live?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers