Monday Coffee 2016-11-21

Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made...

Task Manager is a liar

I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try...

Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)

Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of...

Custom indexes on VMware vCenter database breaks 6.5 upgrade

Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before...

Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)

Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on a...

SQL Server 2016 SP1 Query Specific Wait Statistics Available Through Execution Plans

SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands...

SQL Server 2016 - SQL Service Doesn't Start after GDR Security update

Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on  SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...

New home for SQL Server Citation

Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the...

Microsoft SQL Server 2016 Service Pack 1 (SP1)

Microsoft just announced Microsoft SQL Server 2016 Service Pack 1 (SP1)

Microsoft reference: [Click Here]

Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin

Power BI On Premises Integration with Reporting Services Preview

Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment...