Archive for the ‘SQLServerPedia Syndication’ Category

Three Myths about Agile Development

I recently attended Microsoft Tech Ed in Atlanta, and while there wasn’t much new being announced about SQL Server (I had heard about many of the features for Denali at PASS Summit 2010), I did find myself drawn to several sessions regarding Agile principles and development.  My shop has been using the Scrum method for [...]

June 9, 2011 · stuart · No Comments
Posted in: Good Habits, Something New, SQLServerPedia Syndication

Reminder: Data Architecture PASS VC presentation tomorrow

Just a quick note: I’ll be presenting from the wilds of Hoschton, GA via Live Meeting tomorrow night at 8PM EST.  Details cut and pasted below from http://dataarch.sqlpass.org/:   Subject: From DBA to Data Architect: Changing Your Game Start Time: Thursday, May 19, 2011 8:00 PM US Eastern Time (May 20, 2011 1:00 AM GMT) [...]

May 18, 2011 · stuart · No Comments
Posted in: Education, SQLServerPedia Syndication

#msteched Columnstore indexes unveiled–DBI312

Live blogging again; hope you find my notes useful (scattered though they are).  I’ve been waiting on this session because it’s a very specific area of interest.  I work a lot with VLDB’s, and performance is always a concern; claims are that Denali’s columnstore may boost performance of certain queries hundred-fold.  Let’s see how they [...]

May 17, 2011 · stuart · No Comments
Posted in: Code, Conferences, SQL, SQL Server, SQLServerPedia Syndication

#msteched “Juneau” preview

Sitting in the Database Dev session at Tech Ed, taking a look at “Juneau”, the new development suite for SQL Server.  I can’t wait to see if this thing slices and dices data like a Ronco food processor.  Again, live blogging, so please excuse the scattered thoughts, poor spelling, and other bad habits below. Database [...]

May 16, 2011 · stuart · No Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication

#msteched skydiving into the cloud

Here’s a first for me; I’m live-blogging from a keynote.  Diving straight into it, so please excuse the sparseness of the notes. Robert Wahbe trying to lay out the vision for the cloud from Microsoft; trying to establish that the future is the cloud.  I hate buzzwords, but I think the point of the metaphor [...]

May 16, 2011 · stuart · No Comments
Posted in: Conferences, SQLServerPedia Syndication

knowing when to walk away…

I don’t like to think of myself as a quitter; I especially don’t like to walk away from something I enjoy doing.  However, I’ve recently had to re-evaluate my workload (both personal and professional), and I realized that something had to give.  For me, that something was the Atlanta SQLSaturday 2011. Now, before you panic, [...]

May 2, 2011 · stuart · One Comment
Posted in: Conferences, SQLServerPedia Syndication

SQLSaturday Atlanta 2011–advance notice

Last night a small group of us (Aaron Nelson, Audrey Hammonds, Julie Smith, Tim Radney, and me) met to discuss this year’s upcoming SQL Saturday; our goal is to make it a bigger event than last year, but still try to keep it very community-centric.  Here’s a couple of bullet points that I can tease [...]

April 22, 2011 · stuart · 2 Comments
Posted in: Conferences, SQLServerPedia Syndication

Something new for 2011: bunches of little stuff

OK, it’s the last day of March, and I’m phoning in this blog post.  It’s not that I haven’t spent a lot of time learning something new this month, it’s that I’ve got a pile of stuff to get through before leaving on vacation next week, and I really just don’t have more than 15 [...]

March 31, 2011 · stuart · 3 Comments
Posted in: Something New, SQLServerPedia Syndication

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