2007-12-24
3,467 reads
Database Design
2007-12-14
2,750 reads
Relational Databases 101
In this sample chapter, William R. Vaughn gives you a kick-start on designing relational databases that can perform better, be easier to maintain, and be more successful thanks to a combination of formal rules and informal suggestions to normalize your database.
2007-12-10
3,397 reads
Too Simple, Too Soon
The author explains an application development approach advocated by many proponents of agile application development that can cause future problems for developers, while potentially sacrificing the integrity and reusability of the data.
2007-11-28
3,689 reads
Beginning Database Design - Spot the Flaws
A new series by Steve Jones that tackles a basic design of a few tables. Read the scenario, look over this design, and see if you can find the problems.
2007-11-20
8,776 reads
Celko on SQL: Natural, Artificial and Surrogate Keys Explained
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.
2007-10-25
3,595 reads
Views for Abstraction
Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.
2007-10-25
5,081 reads
SqlCredit – Part 9: Message Authentication Codes
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers searching encrypted data, dictionary attacks, and look-ups by hashed value.
2007-10-01
1,557 reads
SqlCredit Part 8: Comparing Encrypt/DecryptByCert and Encrypt/DecryptByKey
Continuing with this series looking at encryption functions.
2007-09-28
2,381 reads
Blogs
Why Microsoft Fabric Signals the Next Wave of Data Strategy
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
PostgreSQL Timeline: History and Evolution
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Databases and Disasters
Comments posted to this topic are about the item Databases and Disasters
Automating SQL Server Access Review
Comments posted to this topic are about the item Automating SQL Server Access Review
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers