SQL Server 2016 announced


Microsoft SQL Server 2016 will be available for public previewing this summer (2015).

Several new features are included:


  • Always Encrypted - secures on-prem or in-cloud data
  • Stretch Database - dynamically stretches your data to cloud
  • Real-time Operational Analytics & In-Memory OLTP - extends in-memory processing
  • Built-in Advanced Analytics, PolyBase and Mobile BI - Integrates Revolution Analytics & R
       
  • Native JSON support 
  • Security enhancements for Row-level Security and Dynamic Data Masking 

Check out the SQL Server blog here:
http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx

Comments

Post a Comment

Popular posts from this blog

Project Professional 2013 Error 12015

Image
Got an error 12015 when opening Project Professional 2013.  Clicking the More info and it shows this: <detail><ServerExecutionFault xmlns="http://Microsoft.Office.Project.Interfaces/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Actor i:nil="true"/><LastError>12015</LastError><Message/><Source/><StackTrace/><TargetSite i:nil="true"/><ExceptionDetails><errinfo xmlns=""><general><class name="ActiveCacheUnsupportedProjectProfessionalVersion"><error id="12015" name="ActiveCacheUnsupportedProjectProfessionalVersion" uid="315f3c6b-46fa-e411-80d9-00155d106504" version="15.0.4569.1504"/></class></general></errinfo></ExceptionDetails></ServerExecutionFault></detail> and the second error message is: According technet ( http://blogs.technet.com/b/p...
Read more

SP optimization with TVF, View

Had problem with a SP, SP has a few parameters SP unions three queries and then filter by a parameter and then return data  One of the three queries links a TVF with a few tables The TVF links a standard view with a few tables The View links several tables, however not all tables are used by the TVF Symptom: One table used by the TVF has many scan count and slows down the SP Optimization options: Bring the parameter to the three queries referenced by the SP - no effect Modify the TVF and pass in the SP parameter - Speed up 4x Replace the view with the base table and remove unused tables - Speed up 4x
Read more

OWASP Top 10s

Image
Web security is such a broad topic to talk about. There are numerous vulnerability scanning tools available these days that can check your application and provide comprehensive reports.  While it is impossible to know what next attack on your site will be, we need to be ready to deal with any possibilities. One of the preparation steps is to review the top vulnerabilities learned from history.   T he OWASP Top 10 provides a list of the 10 Most Critical Web Application Security Risks and for each Risk it provides: A description Example vulnerabilities Example attacks Guidance on how to avoid References to OWASP and other related resources
Read more