Joe Celko


SQLServerCentral Article

Mathematicians and SQL

Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]

4.33 (3)

2021-01-19

5,346 reads

SQLServerCentral Article

Data Element Names and Scoping Rules in SQL

How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]

4.2 (5)

2021-01-11

1,739 reads

Stairway to Database Design

Stairway to Database Design Level 6: Procedure Bodies

Having covered the procedure headers in SQL Server in the previous level, Joe tackles the subject of the contents of stored procedures. In this level, he outlines limitations of TSQL as a procedural language, and what you need to bear in mind when deciding how to use them.

1.33 (3)

2019-04-03 (first published: )

13,064 reads

Stairway to Data

Stairway to Data, Level 1: The Basics

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you're likely to meet when handling data in databases.

2019-03-26 (first published: )

19,824 reads

Blogs

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

Creating alias on clustered instances

By Leonard Rutkowski

We are setting up aliases, on a clustered instance. When I set it up...

What's the process for SSRS migration/upgrade from 2017 instance to 2019?

By TangoVictor

I'm having trouble finding info on migration/upgrade from 2017 instance to 2019. The things...

can i store hashbyte on field with length smaller than fields i concatenate it?

By ahmed_elbarbary.2010

I work on sql server 2019 i have table have multi column string concatenation...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers