2011-11-14
1,988 reads
Tom Thomson
- Interests: Music, song, singing, gaelic poetry, computers, databases, declarative languages, mathematics, natural languages and linguistics, science fiction and fantasy, walking, scrambling.
2011-10-12
2,210 reads
2011-10-05
2,455 reads
Third Normal Form
The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.
2011-07-28
8,415 reads
Second Normal Form
In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.
2011-07-14
8,070 reads
First Normal Form
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
2011-06-30
10,870 reads
2011-01-11
2,745 reads
2010-06-24
3,973 reads
2010-04-23
3,903 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers