2011-11-14
1,996 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,215 reads
2011-10-05
2,465 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,462 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,095 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,897 reads
2011-01-11
2,756 reads
2010-06-24
3,996 reads
2010-04-23
3,910 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Removing TDE
Comments posted to this topic are about the item Removing TDE
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers