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 – […]

Count to 41

My children never cease to delight me in all kinds of ways, but never more when they come up with some unusual twist out of the blue. My youngest daughter loves to play hide and seek, and always has to be the first to count (seek). Lately when it’s my turn to count she insists, for […]

Maciej Pilecki Speaking at Space Coast UG on July 14, 2011

Just got an email from the Space Coast User Group that Maciej Pilecki (@DrHouseOfSQL) will be doing a presentation to the group on July 14th. Great for a chapter to get a well known speaker.

PASS Update #59 (Run for the Board)

If it hasn’t happened already we should be close to beginning the election cycle for the 2012 election. Last year we had rough election and we’ve made some changes since then. In particular because we had a rough election last year we need a good pool of candidates this year. We need people that care, […]

SQLSaturday #85-Call for Pre-Con Speakers

We’re going to be hosting two pre-conference seminars this year in Orlando on Friday, September 23rd, and we’re looking for speakers! All the details about eligibility and money are posted on the front page of the event site. It’s not huge money, but it’s guaranteed travel expenses and more importantly, it’s experience. Experience you need […]

SQLAndy

Month: July 2011