93,000 Concurrent SAP Users In A Free Download?!

Well, not exactly..   After teasing you on Friday with hints of what you’d hear in today’s launch of SQL Server 2005, Visual Studio 2005, and Biztalk Server 2006, I’m pleased to say the information is out there, and more than worth your while.   Rather than rehash the content of our website (which is worth your…

14

The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statement

Updated 20 Mar 2009: This code is revisited here. This nifty little trick will allow you, with some limitations, to treat the output of a stored procedure as a named SQL record set rather than creating a table and going through an INSERT.. EXEC process.  The output of the stored procedure is then available for…

12

R.I.P. Tun-Hsu "Martha" McCoy — and Thank You!

Every once in awhile, you get a piece of news that sets you looking at where you are and where you’ve been.  Today is one of those days. There will be no technical content in this post, and it might ramble some.  Bear with me; it’s been a contemplative night.. =-=-=-=-=-=-=-= When I was a…

12

A Seasonal Query

UPDATED 29 Dec 2008: Back to the tried-and-true source code formatting method, per Kalen’s comment and my response.  UPDATED 24 Dec 2008: I got this from a couple of different sources, so I didn’t realize when I drafted this post that Dirk wrote this query.  Yesterday.  Dirk is obviously a genius with a huge spirit. …

12

Database Programming: Denis’ Prime Number Challenge

‘Denis the SQL Menace’ read Wednesday night’s post on “the million GUID march” and offered up a challenge of his own: How about the next challenge is to return all 78498 prime numbers between 1 and 1000000? What an interesting idea!  Crazy, in a sense (I’ll get to that in a second), like most interesting ideas,…

11

What I Know Now: Ward’s Epistle to the N00bs

And I remember what she said to me How she swore that it never would end I remember how she held me, oh so tight Wish I didn’t know now what I didn’t know then Bob Seger, Against the Wind All you need is love Love is all you need John Lennon and Paul McCartney,…

11

Front Page (Career) News: Opportunity Knocks; Your Correspondent Answers

Don’t it always seem to hit you Right when you think you can lay back easy?           — Front Page News, Bill Payne & Lowell George   For the past seven years, I’ve had one of the best jobs somebody in my line of work can have.  Those of you who’ve perused the About page…

11

Database Programming: Slaying The Time Zone Conversion Beast (or at least rendering it comatose)

Does anybody know what time it is? Does anybody really care about time?           -Robert Lamm/Chicago   One of the most vexing issues in developing and deploying global systems is handling time zone conversions among the various locales one is servicing around the world.  While this might appear to be a trivial issue on its…

10

Database Programming: Implementing Optional Parameters To A Stored Procedure

A colleague asked the following question recently: I have a stored procedure that takes four parameters that are optional.  My WHERE clause is supposed to include those parameters that are NOT NULL.  If, for example, only @p1 and @p3 have a value, the query will be: SELECT xFROM   dbo.fooWHERE  y1 = @p1AND    y3 = @p3…

10