Michael Coles


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2006-05-04

14,133 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2006-02-14

19,063 reads

SQLServerCentral Article

The Basics of Cryptography Part 2

Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.

You rated this post out of 5. Change rating

2005-08-17

11,131 reads

Blogs

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

By

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

Read the latest Blogs

Forums

Technological Dinosaurs or Social Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?

DBCC CHECKIDENT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKIDENT

Distributed Availability Group Health: T-SQL and Zabbix

By Pablo Echeverria

Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...

Visit the forum

Question of the Day

DBCC CHECKIDENT

What is returned as a result set when I run this command without a new seed value?

See possible answers