NEWSEQUENTIALID() defect in SSMS. Wasn’t it fixed already in SQL 2012 RTM?

I have recently received this question from different sources, so I think it’s worth documenting why some people still see validation error for the default value of a column when it’s defined as a NEWSEQUENTIALID() built-in. The tracking defect on Connect (https://connect.microsoft.com/SQLServer/feedback/details/472092/newsequentialid-bug-in-management-studio) keeps receiving complains about the observed, undesired behavior. It’s been fixed in Denali…

0

Is SQL 2014 Buffer Pool Extension an Enterprise Edition only feature?

No, it’s not. It’s on Standard too. If an attempt is made to enable it on any other edition, you’ll see error 865 written to ERRORLOG “Buffer pool extension is only supported on Standard and Enterprise Editions of SQL Server.” and the same exception is raised aborting the ALTER SERVER CONFIGURATION statement. It’s also worth…

0

Encrypted text in Profiler for unencrypted modules

A colleague came up with this situation: ************ I am tracing some SQL activity on a SQL 2008 R2, Enterprise SP2 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for procedures that are clearly plain text and are not encrypted. Though, I do notice in certain scenarios, where…

0

Is eXtreme Transaction Processing (ie In-Memory OLTP) Supported?

Someone recently asked under which circumstances SQL Server 2014 would return false when interrogated for the IsXTPSupported server property. I looked into the source code and this is what I encountered there. For the boxed version of SQL14, that server property would return FALSE if: 1) lightweight pooling (fiber mode) is enabled, 2) the instance…

0

Log initialization on Azure Blob

One fellow MCM posted the other day the following question about log initialization on Azure Blob storage: ******************** In SQL 2014 (VM hosted in Windows Azure) I’ve tested creating a DB  on the Azure Blob storage with a statement like this CREATE DATABASE TesBlob1GB ON    (NAME = file_data1, FILENAME = ‘https://whatever.blob.core.windows.net/sqldata/filedata9.mdf’, SIZE = 10GB,…

0