Tag Archives: #tsql2sday

Deploying the Old Fashioned Way

T-SQL Tuesday Logo

For this month’s T-SQL Tuesday, James Anderson asks us to write about Shipping Database Changes.

These days all the rage is continuous deployment. Once development is “complete”, you push a button, (insert automated process here), and boom, the code is in production. I applaud shops which can reach this stage. It requires extreme devotion to automated testing and scripted processes. I haven’t worked with that sort of a system. However, many of the same principles apply to deploying the old fashioned way. Continue reading

Mmm… fudge.

T-SQL Tuesday Logo

Kennie Pontoppidan hosts this month’s T-SQL Tuesday and asks us to write about “the daily (database-related) WTF”. I will admit that occasionally I submit to Schadenfreude. And when I get stuck cleaning up someone else’s mess, my hindsight is 20/20. I can point out all the problems they were too “ignorant” or too “lazy” to fix. And then I remember that “they” was “me”. Continue reading

“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