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.Read more "Profiled on SQLPeople"
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.Read more "Denali on TechNet Radio"
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: […]Read more "Subtle Errors When Using Dates-Part 2"
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 […]Read more "SQLSaturday Round Table at the PASS Summit (Early Reminder)"
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 […]Read more "Subtle Errors When Using Dates-Part 1"
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 – […]Read more "Baseball and Scheduling Your Vacation, and a Puzzle?"
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 […]Read more "Count to 41"
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.Read more "Maciej Pilecki Speaking at Space Coast UG on July 14, 2011"
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, […]Read more "PASS Update #59 (Run for the Board)"
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 […]Read more "SQLSaturday #85-Call for Pre-Con Speakers"