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,603 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,114 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,492 reads

Blogs

A New Word: Lookaback

By

lookaback– n.  the chock of meeting back up with someone and learning that your...

Azure Vulnerability Assessments

By

Regarding managing databases in the cloud, security should never be an afterthought. That’s where...

Speaking at the NYC Lunch and Learn–May 23

By

In a couple of weeks, I’ll be in New York City for the Redgate...

Read the latest Blogs

Forums

Deleting a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting a Database

Data Analyst AI tool

By Daniel Calbimonte

Comments posted to this topic are about the item Data Analyst AI tool

Removing Log Shipping

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing Log Shipping

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers