Tag : T-SQL Tuesday - SentryOne Team Blog

Tag: T-SQL Tuesday

Rob Farley : Because you need to know PowerShell

Rob Farley : Because you need to know PowerShell

Rob Farley (@rob_farley) gives a rather thorough crash course on PowerShell for this month's installment of T-SQL Tuesday.

Looking Back at Bad Interviews

Looking Back at Bad Interviews

As part of this month's T-SQL Tuesday, Aaron Bertrand describes a few experiences from last decade, from both sides of interviews.

T-SQL Tuesday #92 : Lessons Learned the Hard Way

T-SQL Tuesday #92 : Lessons Learned the Hard Way

For T-SQL Tuesday #92, Aaron Bertrand (@AaronBertrand) shows one trick he uses to prevent errant DML from running in production.

T-SQL Tuesday #90 : Shipping Database Changes

T-SQL Tuesday #90 : Shipping Database Changes

Aaron Bertrand (@AaronBertrand) recounts the way he implemented database changes in a distributed SQL Server system a decade ago.

T-SQL Tuesday #89 : Roll with the Changes

T-SQL Tuesday #89 : Roll with the Changes

Aaron Bertrand (@AaronBertrand) explains why he isn't scared of the cloud, and why most of you shouldn't be, either.

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

T-SQL Tuesday #87 : Shiny New Toys

T-SQL Tuesday #87 : Shiny New Toys

For T-SQL Tuesday #87, Aaron Bertrand (@AaronBertrand) talks about two shiny new toys used for disassembling and reassembling strings: STRING_SPLIT() and STRING_AGG().

T-SQL Tuesday #86 : What The Heck Is Wrong With My String/Binary Data?

T-SQL Tuesday #86 : What The Heck Is Wrong With My String/Binary Data?

For T-SQL Tuesday #86, Lori Edwards promotes one of the most frustrating SQL Server error messages in existence, "String or binary data would be truncated."

T-SQL Tuesday #86 : Sorting a Stacked Chart

T-SQL Tuesday #86 : Sorting a Stacked Chart

Melissa Connors (@MelikaNoKaOi) wonders why she can't sort items in a Power BI Stacked Chart in a post for this month's T-SQL Tuesday about Connect items.

T-SQL Tuesday #86 : My Favorite Connect Items

T-SQL Tuesday #86 : My Favorite Connect Items

For T-SQL Tuesday #86, Aaron Bertrand (@AaronBertrand) highlights a few of his favorite bugs and feature requests on Microsoft's improvement site, Connect.

Rob Farley : Estimated Number of Rows to be Read

Rob Farley : Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

T-SQL Tuesday #84 : So You Want To Present A Session

T-SQL Tuesday #84 : So You Want To Present A Session

Lori Edwards (@loriedwards) contributes to this month's T-SQL Tuesday, explaining how to get over some of the fears you might have before speaking to a crowd.

T-SQL Tuesday #080 : DBCC CLONEDATABASE

Melissa Connors (@MelikaNoKaOi) takes a look at the new DBCC CLONEDATABASE command in SQL Server 2014 SP2 in this T-SQL Tuesday post.

T-SQL Tuesday #080 – SQL Server R Services

For this month's T-SQL Tuesday, Lori Edwards (@loriedwards) explains why she wants to learn about R Services in SQL Server 2016.

T-SQL Tuesday #080 : CREATE OR REPLACE

Aaron Bertrand (@AaronBertrand) submits a wish list item for the 80th T-SQL Tuesday : CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.