Archive for the ‘SQL Server’ Category

Finally putting together my #SQLPASS Summit schedule

It’s hard to believe that the Summit is next week; I’m just now pulling together my schedule, and I’ve got some tough choices to make.  I have noticed a pattern, however; this year, I’m going to sessions for new features and possible solutions as opposed to “OMG, I have to solve this problem NOW” kinds [...]

November 1, 2012 · stuart · No Comments
Posted in: Conferences, PASS, SQL Server, 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

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

#sqlsat35 looking ahead to the weekend

This weekend I’ll be traveling to the DFW metropolitan area to attend SQLSaturday #35; I’m very excited about it.  I didn’t know if I’d be able to attend this weekend (had to trade kid time with the ex-wife), so I missed the call for speakers.  I am looking forward to actually attending sessions and bumping [...]

May 21, 2010 · stuart · No Comments
Posted in: Blogging is FUN!, Conferences, PASS, SQL Server, SQLServerPedia Syndication, The Social Web

Speaking today: PASS AppDev Virtual Chapter

I know it’s short notice, but to be honest, I totally forgot about this until a couple of weeks ago.  I’ll be presenting today at noon eastern on a LiveMeeting for the Application Developers Virtual Chapter of PASS.  Deets below: “You Got XML In My Database? What’s Up With That?” May 11th 12:00 PM EDT (GMT [...]

May 11, 2010 · stuart · No Comments
Posted in: PASS, SQL, SQL Server, SQLServerPedia Syndication, XML

YAY! Somebody likes me…

I just got the email today; Red Gate friended me.  Or, rather, I am now a Friend of Red Gate.  What does this mean?  I try to think of it kind of like a NASCAR patch; I now have a perpetual sponsor for all of my various presentations in the SQL community.   I don’t know [...]

October 14, 2009 · stuart · One Comment
Posted in: SQL Server

Building ranges using numbers

A while back, I posted a solution to a problem I was facing where I needed to generate a table of ranges.  While I haven’t experienced any sort of issues with the solution, a couple of things have recently occurred which has caused me to go back and take a look at the problem, and [...]

September 27, 2009 · stuart · 3 Comments
Posted in: SQL, SQL Server, SQLServerPedia Syndication

FizzBuzz

Stumbled across Mike Hillwig’s post in response to a question posed by Brent Ozar.  Depending on how literally you want to use the word “print” (do you mean the actual command, or do you just want output?), I think I have a slightly more elegant solution than what Mike proposed. SELECT CASE WHEN n%3=0 AND [...]

September 27, 2009 · stuart · No Comments
Posted in: SQL, SQL Server, SQLServerPedia Syndication

Coming to PASS Summit 2009: Twitter BINGO!

So, last year at PASS Summit, I had my first real experience with a heavily-twittered event.  What was interesting was that I met a lot of people in real-life that I had just recently begun following on Twitter; I had made the comment (in passing) to someone that we should have had BINGO cards to [...]

September 25, 2009 · stuart · 23 Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication, The Social Web