SSWUG Virtual Conference II
Today is day one of the SSWUG SQL Server Virtual Conference II. This has been really fun so far. Our...
2008-06-24
1,511 reads
Blog Posts
Microsoft BI Conference Oct 6-8, 2008
Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in...
2008-06-23
1,636 reads
Notes on My Visit to Birmingham SQL Group
Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance...
2008-06-22
1,383 reads
One Note
Lately I've been trying out a few new pieces of software to see how well they work. One is Twitter,...
2008-06-20
2,007 reads
Transparent, Translucent, or Opaque? Whats Your Strategy?
It's a couple weeks old, but there was a mild blog roar over some comments from Microsoft about wanting to...
2008-06-19
1,518 reads
Virtual Conference II
Check out the SSWUG Virtual Conference next week. Here is a link with more information: http://www.vconferenceonline.com/sswug/demo.asp . The first 200 people...
2008-06-19
1,574 reads
Asking a SQL Question
I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions...
2008-06-18
1,552 reads
SQLSaturday #4 Lessons Learned
Earlier in the week I posted a quick & positive note about the event, today I'll add some notes about things...
2008-06-18
1,384 reads
Link: Killing Terminal Service Connections
Needed to kill a connection so I get could logged on recently to a server and didn't have the server...
2008-06-17
1,391 reads
Off-Topic: Microsoft Marketing
I saw a blog post by Robert Hensing talking about Microsoft's new GPS product and its very uncreative name. This...
2008-06-17
1,877 reads
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Forums
Which selection criteria is more efficient.
Is it more efficient to search on an int than a nullable DateTime? I...
Trigger After Update to Update the Updated Table
Okay I can easily see how to update a table field after an Insert...
The Pervasive Nature of Open Source
Comments posted to this topic are about the item The Pervasive Nature of Open...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers