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,128 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,058 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,080 reads

Blogs

India-US Tariff War: Is the Indian IT Sector at Risk?

By

How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...

Save BIG on Microsoft Azure Certification – Up to 100% Off!

By

🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...

Modifying a Trigger to Capture More Info: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Read the latest Blogs

Forums

What is a Failed Deployment?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is a Failed Deployment?

Generating a Series I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Generating a Series I

Dimensional Modeling Case Study Part 3 - Dynamic Days Dimension

By Hang Liu

Comments posted to this topic are about the item Dimensional Modeling Case Study Part...

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers