Notes from SQLSaturday #81

I started by journey to Birmingham by leaving work at 1130 and getting to the airport in time to have a quiet lunch with my wife before going through security. It’s a short flight to Birmingham, about 1.5 hours, uneventful. The plan was to meet up with Heather Sullivan from Idera about 3 pm and […]

My Schedule for The Remainder of 2011

Just a few notes about things I’m doing over the next few months: July 30 – Attending SQLSaturday Birmingham. I went to their first one and had to skip last year, great to have time to go back to see one of my favorite SQL groups Aug 13 – Making my annual trek to South […]

A Big Milestone-SQLSaturday #100

Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years since we started the planning for #1 in Orlando, it seems like both a long time and not very long at all. A lot of people have volunteered a lot of time to get to […]

PASS Update #60

I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship moving (my part of it at least) while I recharge. I still manage to have a few things going on, so here is the 60th update on my efforts as I hit 2.5 years […]

Profiled on SQLPeople

I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going on and it’s interesting indeed to see the similarities and differences from those of that work with SQL Server.

Denali on TechNet Radio

A quick plug for my friend Blain Barton from Microsoft, he’s got a series of three broadcasts that are video, but done in radio interview format. Worth a look.

Subtle Errors When Using Dates-Part 2

It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when doing some checks on some billable data that had been captured: select * from sometable where somedate between ‘6/1/2011’ and ‘7/1/2011’ Nine times out of ten when you see that statement what they meant was: […]

SQLSaturday Round Table at the PASS Summit (Early Reminder)

Once again this year we’ll be holding a meeting open to all SQLSaturday event leaders and key team members (and space permitting, we’ll also welcome SQLSaturday volunteers at any level). Karla from PASS HQ will be sending out invitations in the next couple weeks, but for now wanted to get it published as early as […]

Subtle Errors When Using Dates-Part 1

Note: My original code was not helpful (wrong!), the corrected version is shown below. I was reviewing some code recently that has been in production for a while and I saw something like this: delete from sometable where datecol > getdate() – 3 …..lots of work here, several seconds to a minute Insert Into SomeTable….new rows […]

Baseball and Scheduling Your Vacation, and a Puzzle?

I saw an article in the newspaper titled How to Visit 30 Ballparks in 35 Days This Summer. I think it would be an I interesting idea to visit all of them and see some of America in the process, but doing it in 35 days seems less like fun and more like work – […]

SQLAndy

SQL Community