Archive for the ‘Development’ Category

much delayed #sqlsat70 write-up

This write-up will be brief and to the point: SQL Saturday 70 rocked.  K. Brian Kelley (Blog|Twitter) and his team put together a great event (again), and it was a lot of fun catching up with so many SQL people.  Unfortunately, I had a rather severe sinus infection which kept me from really enjoying the [...]

March 28, 2011 · stuart · 3 Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication

#TSQL2sday: Emulating a FIRST aggregation

Jes Borland is hosting this month’s T-SQL Tuesday, and it’s all about aggregations.  Here’s an old coding trick of mine to emulate a FIRST aggregation in T-SQL.  Say we have a table that has three columns: ID, a uniqueidentifier Name, a varchar that represents something, and DateStored, a datetime that is set when the row [...]

March 8, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

Resolution checkup

As February draws to a close, I thought I’d do a quick check-up to see how well I was keeping up with my New Year’s resolution list.  In sum: not great, but not too bad, either.  I need to make some adjustments, but I think I can pull it back in. Here’s the rundown (copied [...]

February 28, 2011 · stuart · No Comments
Posted in: Blogging is FUN!, Development, Health, SQLServerPedia Syndication, The Social Web

What Should PASS be? #sqlpass

Andy Warren recently threw out a challenge for bloggers to “fix” things with the Professional Association for SQL Server in 3 years.   There have been some great responses so far (and I’m sorry if I’ve missed yours): Andy Leonard Grant Fritchey Robert Matthew Cook Mike Walsh All of these posts have great ideas, and have [...]

February 23, 2011 · stuart · 2 Comments
Posted in: PASS, SQLServerPedia Syndication, The Social Web

BTW… #SQLSat70

I got accepted Now, I just gotta write the presentations….

February 22, 2011 · stuart · No Comments
Posted in: Conferences, Development, SQLServerPedia Syndication

A simple codebuilder for parsing in T-SQL

If you’ve ever tried to parse a wide character column in T-SQL, you know two things: It’s a pain to do, and It’s a pain to do. A lot of the data I deal with comes in syslog format, which can come in one of two formats: positional (the location of the data element is [...]

February 22, 2011 · stuart · No Comments
Posted in: SQL, SQLServerPedia Syndication

I’m doing it wrong…

At some point in your career, you have to realize that you’re going about it in the wrong way.   It may hit you like a ton of bricks, or it might be a subtle realization, but either way you realize that things aren’t working out for you like you expected.  I’ve had a couple of [...]

February 21, 2011 · stuart · 3 Comments
Posted in: Something New, SQLServerPedia Syndication, The Social Web

Just a quick note… #sqlsat70

I just submitted a couple of sessions to SQL Saturday #70; I feel like I’ve been way off my game in terms of service to the community lately, so hopefully this will provide me a bit of a kick-start.  Even if I don’t get accepted (the list is growing longer each day), it’s at least [...]

February 10, 2011 · stuart · No Comments
Posted in: Conferences, SQLServerPedia Syndication

Something new for 2011: XML & XSD, part 2

I’m continuing my study of XML and XSD’s for January, and I realize that I ended my last post a bit abruptly.  I explained that I can cast an XML datatype to a SQL Server datatype, without giving a lot of background on WHY that’s important.   Understanding Types. Without going into too much detail about [...]

January 31, 2011 · stuart · No Comments
Posted in: Something New, SQLServerPedia Syndication, XML

#TSQL2sDay: Resolutions

For this month’s T-SQL Tuesday, Jen McCown asks: So tell us: what techie resolutions have you been pondering, and why?  Are you heading for a certification? An award? Are you looking to pick up CLR because that guy at the Summit said it’s “bitchin’”? Go crazy… I’ve already covered a lot of my techie resolutions [...]

January 11, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, The Social Web, TSQL2sDay