Using Foreign Keys to Determine Table Insertion Order
Here's a script to determine, based on your database's foreign key relationships, what the insertion order would be for, say,...
2013-02-17
1,544 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
704 reads
A Month of PowerShell – Day 17 (Databases: Views)
Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-17
691 reads
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...
2013-02-17
795 reads
A Month of PowerShell – Day 16 (Databases: Triggers)
Welcome to Day 16 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-16
970 reads
I’m dropping the book project
Update:
This book project got its second life. I am now collaborating with another author to bring this book to completion....
2013-02-16
946 reads
Reblog: February 8 to February 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
893 reads
23 Pieces of News and Fluffery (Feb 9-15)
I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s...
2013-02-15
748 reads
A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)
Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-15
735 reads
T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is...
2013-02-15
1,611 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers