“That sounds way too complex!” – Challenge Accepted!

Yesterday Adam Machanic called for new #tsql2sday hosts. I applaud his continued efforts organizing this monthly blog party. It inspires new bloggers, gently guilts those who have lapsed, and provides a topic and schedule for the uncertain. But it routinely surprised me that there was no canonical list of past events with a link to the current topic. Continue reading

Named Parameters in T-SQL Functions

T-SQL Tuesday Logo

I have to admit, I’ve been pleased with the developments with SQL Server 2016. In addition to all of the new features, they brought SQL Server to Linux and with SP1 they opened all the goodies up to Standard Edition. So when Brent Ozar asked us to scour Microsoft Connect for even more improvements for T-SQL Tuesday #86 (#tsql2sday), I wondered if we wouldn’t tempt fate. But as IT folks we love to complain about our tools, so here goes. Continue reading

No one wants to eat you.

T-SQL Tuesday Logo

“When are we going to see you up there?” Mark Vaillancourt had just finished presenting DANGER: The Art and Science of Presenting at SQL Saturday #238. He and Mike Donnelly had put the question to me as they were packing up. I demurred; surely that was best left to experts like them. They persisted, noting how I was always at our user group meetings and how a novice viewpoint was often more helpful for beginners. Being an audience member was one thing, I protested, and speaking was quite another. They kept on the offensive but I managed to slink away without any firm commitments. Nonetheless, they’d struck a chord. Continue reading

No Walls. No Emails. Just SQL.

PASSMN LogoAfter the dust has settled from our national brouhaha, the PASSMN SQL Server community will hold elections for 3 of its 6 board positions. Paul Timmerman (Board Chair), Jim Dorame (Director of Program Development), and Riley Major (Director of Technology) are ending their 2-year terms. Cecil Spivey (Director of Membership / Treasurer), Eric Zierdt (Director of Corporate Development), and Jim Horn (Director of SQL Saturday) will stay on to finish the second year of their terms. Continue reading