(Robert L. Davis) Hash indexes, used for SQL Server in-memory OLTP, are not ordered by the index keys and scans on hash indexes can significantly hinder performance. Additionally, hash index functions require that all key columns be supplied in equality expressions.

(Pinal Dave) When I did the session at SQLPass about the 42 tips, I had included an interesting behavior I got when working with Geometry data types.

(Thomas LaRock) I love how Azure SQL Database keeps adding new features on a frequent basis. And while they maintain a good list of new features being added, every now and then something slips under the radar for me. Here’s an example of something I came across for Azure SQL Database V12 that I don’

(Jen McCown) Let’s have some fun with operator precedence today. Specifically, logical operator precedence.

(Burt King) I have SQL Server 2014 Enterprise edition and the online reindex process sometimes blocks other processes because the reindex process needs to take SCH-S locks and then a SCH-M lock at the end of the process which blocks subsequent processes. The SCH-M lock isn’t compatible with other lo

(Rick Strahl) Not sure if this is a common occurrence, but I’ve had a number of occasions where Entity Framework migrations have left the state of migrations in an unusable state.

(Kenneth Fisher) I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do security audits?

(Arshad Ali) SQL Server 2005 introduced native support for storing, managing and processing XML data when XML had become the de-facto standard for data interchange. This feature still exists in SQL Server as XML has some inherent advantages and is still used widely, but because many new applications

(Robert Sheldon) DocumentDB only uses SQL for querying data. To create procedures and functions, you have to flex your JavaScript skills to create JavaScript functions that are saved to a DocumentDB collection.

(Pinal Dave) Long time ago I have written blog to rename column name.