Archive for the ‘Development’ Category

Querying XML in SQL Server 2005+: namespaces

I recently helped a friend solve an XML problem, and thought I would post the solution here.  Although there are lots of notes on how to use XQuery in SQL Server 2005+, this was a real world scenario that was trickier than I expected.  The friend works for an insurance company broker, and in one [...]

September 1, 2010 · stuart · No Comments
Posted in: SQL, SQLServerPedia Syndication, XML

#passvotes Welcome to the Nom Com: Here’s Your Helmet.

It’s been over a week since my last post on this subject, and to be honest, I was hoping that I wasn’t going to have to write any more.  I felt like I had stated my position that the Nominations Committee for the PASS elections of 2010 had been faced with an unpopular decision, and [...]

August 24, 2010 · stuart · 28 Comments
Posted in: Election2010, SQLServerPedia Syndication

#passvotes When doing the right thing ain’t popular…

If you Tweet or follow Steve Jones’ blog, you’ve already gotten the news that Steve will not be on the slate for the Board of Directors this year.  It was a tough decision for the Nominations Committee to make, but I wanted to address some of the controversy before it boils over.  I do, however, [...]

August 18, 2010 · stuart · 40 Comments
Posted in: Election2010, SQLServerPedia Syndication

#passvotes Interviews, interviews, interviews…

Not much new to report on the PASS 2010 Nominations process this week (http://elections.sqlpass.org).  We’ve interviewed 5 of the 7 remaining applicants, and overall, it looks like we’re going to have a great slate for selecting candidates this year.  Unfortunately, I had to miss a couple of the interviews due to a faulty merge-and-purge process [...]

August 9, 2010 · stuart · No Comments
Posted in: Election2010, SQLServerPedia Syndication

Upcoming presentations

Just a quick note about some upcoming presentations: I’ll be presenting “The Social DBA: Resources for Career Building“  at SQL Saturday 51 in Nashville, TN on August 21.  Also, on September  21, I’ll be presenting on Red Gate’s SQL Source Control at the Columbus, GA SQL Server Users Group. Tweet This Post

July 30, 2010 · stuart · No Comments
Posted in: Conferences, SQLServerPedia Syndication, User Groups

#passvotes The process rolls on…

I’m in a bit of a sticky wicket here; as a blogger, I feel obligated to share what’s going on with the Nomination Committee for the 2010 PASS elections, but as a member of that committee, I feel obligated to not say too much too soon.  However, I have seen some of the buzz on [...]

July 28, 2010 · stuart · No Comments
Posted in: Election2010, SQLServerPedia Syndication

T-SQL tip: Use a role for EXECUTE permissions

If you are in a high-security environment, this may not be the best tip for you, but if you’re in a situation like mine where you have a SQL user that is connecting to a database in order to EXECUTE stored procs, and you know that user needs to be able to EXECUTE every proc [...]

July 23, 2010 · stuart · 4 Comments
Posted in: SQL, SQLServerPedia Syndication

Kung fu and the art of SQL Server

A few nights ago, I watched The Forbidden Kingdom with my kids; I’ve seen it before, but this time there was a message in it that I needed to hear.  Obviously, I’ve been in a slump lately, and even though I’m continuing to be involved in what I do as a SQL Server professional, I [...]

July 15, 2010 · stuart · One Comment
Posted in: Education, SQLServerPedia Syndication, The Social Web

Well, boo…. Back to the drawing wheel #sqlpass

Nose to the wagon board.  Grinding away at the dog-and-pony show.  Keeping a stiff upper lip.  Insert Other Platitudes… Apparantly, PASS started notifying potential speakers that their submissions for Summit 2010 were accepted today for ; unfortunately, I was not one of them (at least not yet).  2 of my 3 submissions were “Considered” before being [...]

July 8, 2010 · stuart · One Comment
Posted in: Conferences, PASS, SQLServerPedia Syndication, The Social Web

English Interpreter of English #PASSvotes #sqlpass

In case you missed it, the call for nominations for the PASS Board of Directors went out yesterday; there are 3 seats that need to be filled this year, and PASS is trying to be very open about the nomination and electoral process this year.  I thought I would post a couple of links here [...]

June 24, 2010 · stuart · No Comments
Posted in: Election2010, SQLServerPedia Syndication