The most recent content from our members.
This month's T-SQL Tuesday is hosted by Raul Gonzalez (@SQLDoubleG), and is about Lessons Learned the Hard Way. Now, I've learned many lessons the hard way. When I started my career and transitioned from web design and server-side scripting into more focus on SQL Server, I bought a whole bunch of books; my favorites were…
In a previous life, I was responsible for a production system with somewhere around 1,500 roughly identical databases, one per client. I called it a multi-tenant system for years, but that causes strife, because many people only think of multi-tenant as a database-level concept rather than an instance-level concept. This…
This month's T-SQL Tuesday - hosted by Matt Gordon (@sqlatspeed) - is called "Fixing Old Problems with Shiny New Toys." Matt wants us to write about how we've solved old problems in new ways afforded by enhancements to SQL Server (or new features anywhere in the stack, I would guess). Over the years I have helped a lot of…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." This is a topic near and dear to my heart; for several years I was a huge proponent of the Connect system. For a while, I even published weekly digests, where I highlighted bugs and feature requests that I thought deserved more eyeballs and…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." My T-SQL Tuesday post is about a request for Power BI, which may be a little on the edge of SQL Server as far as T-SQL Tuesday goes. I want to talk about a limitation when sorting a Stacked Chart. As I mentioned in my previously, I started to…
This month's T-SQL Tuesday is hosted by Brent Ozar (b/t), and is about those wonderful Connect requests that we want fixed/added in SQL Server. Aaron Bertrand (b/t) reminded me of one of my all-time favorites. You know when you started working with SQL Server and you'd get error messages that you couldn't figure out? One…
This month's T-SQL Tuesday, the 80th event, is being hosted by Chris Yates (blog | @YatesSQL). Today happens to be his birthday, so he approached the topic with ideas about gifts. He had several suggestions for our posts, and one that stood out to me aimed at features we wished weren't missing from SQL Server: Perhaps…
This DBCC CLONEDATABASE post is my first contribution to the T-SQL Tuesday series and that is mostly due to it being Chris Yates' birthday. He gives a lot to the community and this post is my gift to him. Happy Birthday, Chris! Additionally, it's my mom's birthday, therefore I must say Happy Birthday, Mom! DBCC…
This month, T-SQL Tuesday is being hosted by fellow Canadian and all-around good guy Michael Swart. The topic? SQL Server 2016. I've blogged quite a bit about the new version already, but one of Michael's bullets of inspiration did exactly what he meant it to: It’s 2016, why is this still (not) a thing? For nearly a decade…
This month’s T-SQL Tuesday is hosted by friend and Zen Master Chris Yates (b/t). Since this T-SQL Tuesday falls on Chris' birthday, he's made it a present to all of us. Basically write about something you want to learn/teach/have/whatever in SQL Server. Since I've spent most of this year studying, I'm going to write about…
It looks like you're new here. Sign in or register to get started.