Category Archives: boston

Demos: SQL Saturday Boston (#262) – Clash of the Row Goals!

Thanks to everyone who joined me yesterday afternoon in Cambridge for my Clash of the Row Goals talk. It was great to receive such a welcome reception for a rather out there topic. Three things I should clarify for those who attended: The Many() function appeared to create an invalid estimate in one case; but that was due to auto-parameterization (which one of the attendees in the front row correctly called out at the time; but I’m not sure everyone heard her) Regarding the demo that failed at the…(read more)

Query Performance and Parallelism Seminars in Boston and Chicago

You’re a DBA or database developer working on a big (or even big-ish — doesn’t have to be huge) database. Your end-users are doing all sorts of data analysis, and even though you have a pretty beefy server, your queries just don’t seem to run as fast as they should . The reason (I bet)? Your queries aren’t taking full advantage of the CPU power available in today’s servers . SQL Server has powerful parallel processing capabilities, but left to its own devices (and defaults) you’re never going to…(read more)

[New England] SQL Saturday #203: April 5-6, Cambridge MA

SQL Saturday returns to the Boston area this April , with what is certain to be an exceptional speaker and session lineup . (The actual schedule will be posted soon, but in the meantime you can see the submitted sessions .) The free event ($10 if you’d like to eat lunch) will take place on Saturday, April 6. Highly recommended for anyone in the area who is interested in bettering your database skills! Friday, April 5 , as a lead in to the Saturday event, I’ll be delivering my popular full-day ” No…(read more)