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
Category Archives: SQL Server
Angle Brackets vs Curly Braces
Matt Gordon hosts this month’s T-SQL Tuesday and asks us to write about how we’ve used a new capability of the SQL Server ecosystem to solve an old problem. At first blush, this seems like a good way to show concrete benefits to abstract new concepts. But I wonder if it sets the bar too high. Continue reading
Named Parameters in T-SQL Functions
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
Can’t we get this sorted?
Andy Mallon hosts this month’s T-SQL Tuesday, asking us to reflect on Allan Hirt’s tweet lamenting that “we’re still dealing with the same problems” after 25 years in IT.
I think technology has the paradoxical problem of moving both too fast and too slow. Continue reading
Let me count the ways…
Michael J Swart is hosting this month’s T-SQL Tuesday, about the June 1st release of SQL Server 2016.
There’s so much “new” that Microsoft spread it out across several sprawling lists. The headline features from a year ago are: Continue reading