Wednesday, November 29, 2017

Use T-SQL to create caveman graphs

›
I found this technique on Rich Benner's SQL Server Blog:  Visualising the Marvel Cinematic Universe in T-SQL  and decided to play arou...
5 comments:
Wednesday, October 25, 2017

How to update 2 tables with 1 statement in SQL Server..the hard way....

›
Every now and then you will get someone asking how to update two tables with one statement in SQL Server. The answer is usually, no that ...

Foreign Keys don't always need a primary key

›
In the post  Your lack of constraints is disturbing  we touched a little upon foreign key constraints but today we are going to take a clos...
Thursday, October 19, 2017

Your lack of constraints is disturbing

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Wednesday, October 18, 2017

SQL Server does support regular expressions in check constraints, you don't always need triggers

›
Someone posted the following question I need to add table called group with a column called code How do I add a check constraint to the...
Tuesday, October 17, 2017

Standardized Naming And Other Conventions

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Monday, October 16, 2017

Do not trust the SSMS designers, learn the T-SQL way

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has chang...