Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
545 reads
Client Pressures and Code Quality
In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is...
2013-06-09
430 reads
SQL Query Result Order
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...
2013-06-05
643 reads
SQL Logical Query Processing Order
This probably applies more to beginners or people who have been using SQL for a while but have been wondering...
2013-06-03
495 reads
SQL and Relational Theory
Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...
2013-05-31
1,001 reads
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
393 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
738 reads
Blogs
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers