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 […]
2021-01-19
4,249 reads
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 […]
2021-01-11
1,413 reads
This final level to the first landing completes the basics of a SQL database, by explaining what cursors are and why you should never use them.
2020-11-18 (first published: 2011-11-02)
10,955 reads
2020-10-12
1,844 reads
Joe Celko tackles the most difficult of all the types of data handled by SQL, temporal data, and explains how to avoid the commonest traps for the unwary programmer
2020-07-08 (first published: 2011-06-15)
10,802 reads
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.
2019-04-03 (first published: 2011-09-21)
12,860 reads
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-02-06 (first published: 2011-05-12)
19,434 reads
In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.
2018-02-21 (first published: 2011-11-11)
13,716 reads
In levels one to four, we built the tables, base and virtual, of a schema. Levels five and six dealt with stored procedures. This level deals with a feature you need to avoid as much as possible; this is article is on Triggers.
2018-01-24 (first published: 2011-09-30)
11,413 reads
Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.
2017-10-25 (first published: 2010-08-25)
14,952 reads
When you don't have statistics, what does SQL use to calculate the estimated number...
By Ed Elliott
This is a bit of a longer one, a look at how to do...
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
I have a requirement whereby testers on ServerA need a copy of the production...
I need to get value portion key to every 3 row on one row...
We have sharepoint as the data source and we have 2 dates created...
Ask SSC