Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,397 reads
Blog Posts
Getting Stubborn Chief Executive Officers to Listen: Speak Their Language
After consecrating several posts on workplace bullying, and hearing our great Steve Jones rant about Toshiba’s lack of action regarding...
2010-03-24
1,956 reads
Meeting Offsite and a Little Vacation
I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group...
2010-03-24
783 reads
PASS Update #27
I’m just back from the March 2010 Board meeting and it went better than usual (for any meeting). Most of...
2010-03-24
593 reads
SQL Server 2008 R2 - The list of the supported features
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,234 reads
Why I Don’t Run for the PASS Board
It’s getting close to that time of year when you can apply to run for the PASS Board of Directors....
2010-03-24
1,649 reads
An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
2010-03-23
2,174 reads
Critiquing Free Events
Yesterday I wrote about expectations at free events, basically saying they don’t differ a lot from paid events. The next...
2010-03-23
563 reads
Inserting into an XML document
I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...
2010-03-23
2,049 reads
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
12,429 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers