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)

You rated this post out of 5. Change rating

2021-01-19

5,588 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)

You rated this post out of 5. Change rating

2021-01-11

2,092 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)

You rated this post out of 5. Change rating

2019-04-03 (first published: )

13,467 reads

Blogs

A New Word: Lilo

By

lilo– n. a friendship that can lie dormant for years only to pick right...

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Read the latest Blogs

Forums

how to calculate an average only if a minimum number of records exist?

By water490

Hi I am working on a rolling average calculation that is not working quite...

Subscribing to a Great New Year

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Subscribing to a Great New...

dont want pkg to abort if someone is in excel source document

By stan

Hi, is there a way when using excel as a flat file source in...

Visit the forum

Question of the Day

The Funny Dynamic SQL

What happens when I run this code:

EXEC sp_executesql N'PRINT 1; GO';

See possible answers