As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.
2012-12-05
4,169 reads
Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.
2012-11-14
4,482 reads
In the first level of his Stairway to SQL Dialects, Joe Celko looks at the origins of the SQL language and how the language has spawned the various different dialects in use today.
2012-10-31
5,754 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.
2011-11-02
9,151 reads
Joe discusses Hierarchical, Vector and Concatenation encoding before rounding up with general guidelines for designing encoding schemes.
2011-08-31
4,280 reads
Joe discusses how to deal with the kinds of encoding schemes, how to use them and how to design them. He discusses Enumeration, Measurement, Abbreviation and Algorithmic categories
2011-08-10
5,843 reads
Joe Celko introduces more powerful scales such as Interval, Log interval and ratio scales; before moving on to conversions, punctuation and units. Finally he gives guidelines as to how best to use scales in a database.
2011-07-27
4,463 reads
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.
2011-07-20
3,438 reads
Joe Celko discusses Nominal, Categorical, Absolute, Ordinal and Rank scales. These are the weakest scales we can use, starting with the weakest.
2011-07-06
6,282 reads
Character-handling in SQL is not particularly straightforward, and confusion about collation and character encoding is a common cause of problems with searching, joining, and sorting.
2011-06-01
8,933 reads
By Tim Radney
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on...
By Steve Jones
In a previous post, I set up the SQL Clone server. This is really...
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Hi, This is one of the incident at our clients side and does not...
Hello..i am running into an issue where below query is requesting large amount of...
Ask SSC