I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
Category: SQL Server 2014
I describe the new SQL Server 2014 feature, Delayed Durability, and put it through its paces.
Update 2014-08-01: Below I mention that the T-SQL and XQuery references were not available locally with the initial release; they have now been provided (see this post for more details). I've seen people complain that...
Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed at time of publication (121 total) Build number is 12.0.2342 Relevant for @@VERSION 12.0.2000 through 12.0.2341 UPDATE...
I talk about SQL Server 2014 Standard Edition and a couple of little carrots that might make this upgrade more compelling than SQL Server 2012.
I investigate a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.
I take a quick look at performance of encrypted backups in SQL Server 2014, and point out a couple of other things you will want to know before implementing the feature.
I give some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it does not play well with others.