T-SQL Tuesday #87 : Shiny New Toys
For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().
Category: T-SQL Tuesday
T-SQL Tuesday #86 : My Favorite Connect Items
For T-SQL Tuesday #86, I highlight a few of my favorite bugs and feature requests on Connect (RIP).
T-SQL Tuesday #85: Are your backups worthless?
For both T-SQL Tuesday and #BackToBasics, I provide information about SQL Server backups, and why your restores can be just as important.
T-SQL Tuesday #80 : CREATE OR REPLACE
I submit a wish list item for the 80th T-SQL Tuesday: CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.
T-SQL Tuesday #79 : A Weird Trick Still Missing From SQL Server 2016
For this T-SQL Tuesday, I talk about a feature long missing from SQL Server: The ability for Developer Edition to act like Standard.
T-SQL Tuesday #78 : Is a RID Lookup faster than a Key Lookup?
For T-SQL Tuesday #78, I take a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.
T-SQL Tuesday #72 : Models Gone Wild!
For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.
T-SQL Tuesday #69 : Always Encrypted Limitations
For this T-SQL Tuesday, I talk about a few of the limitations of Always Encrypted.
T-SQL Tuesday #68 : All Features With Defaults
I look at the tempting All Features With Defaults installation choice for this T-SQL Tuesday.
T-SQL Tuesday #67 : New Backup and Restore Extended Events
For T-SQL Tuesday #67, I describe a new way to track backup and restore operations using Extended Events in SQL Server 2016.
T-SQL Tuesday #66 : Babysitting a Slow Backup or Restore
For T-SQL Tuesday, I discuss undocumented trace flags that provide additional diagnostics to troubleshoot slow backup or restore operations.
T-SQL Tuesday #65 : Teach Something New
For T-SQL Tuesday< #65, I give a little detail on something I learned this week about altering a column from NOT NULL to NULL.
T-SQL Tuesday #64 : One Trigger or Many?
I follow up on a question from a triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
T-SQL Tuesday #58 : Giving out the sa password
For T-SQL Tuesday #58, I discuss a few of the reasons people give out the sa password, and what you should do in those cases instead.
T-SQL Tuesday #57 : A SQL _VARIANT Use Case (No Pun Intended)
I use a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
T-SQL Tuesday #56 : Assumptions
This month's T-SQL Tuesday is about assumptions in SQL Server.
T-SQL Tuesday #36 : Reflections on the PASS Summit and our community
Last week I attended the PASS Summit in Seattle. I blogged from both keynotes (Keynote #1 and Keynote #2), as well as the WIT Luncheon – which SQL Sentry sponsored. I had a fantastic...
T-SQL Tuesday #33 : Trick Shots : Schema Switch-A-Roo
I describe a way to use ALTER SCHEMA … TRANSFER to refresh data with minimal disruption.
T-SQL Tuesday #26 : Second Chances
This month's T-SQL Tuesday is being hosted by Dave Howard (@DaveH0ward), and the topic is "Second Chances." What he's letting us do is look back at all the previous T-SQL Tuesdays and pick a...
T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks
This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought...
T-SQL Tuesday #24 : Dude, where's the rest of my procedure?
This month's T-SQL Tuesday is being hosted by Brad Schulz (blog) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against...