(Bill Graziano) I found the time to update ClearTrace to support Extended Events. You can download ClearTrace for Extended Events from my corporate site.

(Rick Dobson) A derived table is a subquery nested within a FROM clause. Because of being in a FROM clause, the subquery’s result set can be used similarly to a SQL Server table. The subquery in the FROM clause must have a name. One reason for including a derived table in an outer query is to sim

(Steve Endow) This is a discussion of how to send a list of values to a SQL stored procedure parameter.

(Greg Larsen) There are times when an application needs to execute dynamic TSQL. Dynamic TSQL is SQL code that is generated by a program then executed.

(Pinal Dave) I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Comprehensive Database Performance Health Check. It was indeed a very large scale project where I had to help a customer get 10x speed to their original transactions wit

(Rajendra Gupta) DBATools is an open-source PowerShell that contains a collection of useful commands. In this series of articles on DBATools (see TOC at the bottom) we performed installation of it.

(Tim Radney) I’ve been teaching and writing about common SQL Server mistakes for many years.

There are many instances when dates and times don’t show up at your doorstep in the format you’d like it to be, nor does the output of a query fit the needs of the people viewing it.

(blobeater) I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database.

(Kenneth Fisher) I recently did a post on the case expression short circuting and received a very very interesting comment from Chad Estes.