Latest News on SQL Server Data Tools

What is Coming in SQL Server 2016 for Business Intelligence?

Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades in numerous presentations at both //build and Ignite conferences. Here are a few of my top take-away points from a BI professional perspective.
For more click here
SQL Server 2016 -
    Key Capabilities in SQL Server 2016 CTP2
  1. Always Encrypted
  2. Stretch Database
  3. Real-time Operational Analytics & In-Memory OLTP

Additional capabilities in SQL Server 2016 CTP2 include:
  • PolyBase – More easily manage relational and non-relational data with the simplicity of T-SQL.
  •  AlwaysOn Enhancements – Achieve even higher availability and performance of your secondaries, with up to 3 synchronous replicas, DTC support and round-robin load balancing of the secondaries.
  •  Row Level Security– Enables customers to control access to data based on the characteristics of the user. Security is implemented inside the database, requiring no modifications to the application.
  •  Dynamic Data Masking – Supports real-time obfuscation of data so data requesters do not get access to unauthorized data.  Helps protect sensitive data even when it is not encrypted.
  •  Native JSON support – Allows easy parsing and storing of JSON and exporting relational data to JSON.
  •  Temporal Database support – Tracks historical data changes with temporal database support.
  •  Query Data Store – Acts as a flight data recorder for a database, giving full history of query execution so DBAs can pinpoint expensive/regressed queries and tune query performance.
  •  MDS enhancements – Offer enhanced server management capabilities for Master Data Services.
  •  Enhanced hybrid backup to Azure – Enables faster backups to Microsoft Azure and faster restores to SQL Server in Azure Virtual Machines. 
For the more details, watch at  Official News from Microsoft’s Information Platform

SQL Server Management Studio August 2015 Preview

This release supports SQL Server 2016 through SQL Server 2005, and has many new features including improved compatibility with previous versions of SQL Server, a light weight stand-alone web installer, and toast notifications within SSMS when new releases become available. This release also provides the greatest level of support for working with the latest cloud features in Azure SQL Database.



This version of SQL Server Management Studio is supported side-by-side with earlier released versions installed on the same machine. This update is aligned with the SQL Server 2016 CTP 2.3 release. The August update includes: 

1. Updates to the object explorer to reduce the loading delay when there are a large number of databases hosted on a single SQL server instance. 
2. Bug fixes to allow installation of SSMS on Windows 10 machines. 
3. Additional bug fixes including updates to SSMS user reports UI, and SQL Server Configuration manager fixes. 
You can read more about the release, as well as previous updates at: SQL Server Management Studio August 2015 Preview

Row Level Security for SQL Server Databases
Data is the biggest concern for any organisation to make a significant growth in their business. Business users want to fetch data as fast as possible, and write the data back into the database as fast as possible but database size grows with every passing day and we want to make sure that all operations are executing smoothly. So, we have to take care of the tuning our database server for performance and security purpose also.
Row Level Security feature is introduced within SQL Server 2016. Row-Level Security enables customers to control access to rows in a database table based on the characteristics of the user executing a query (e.g., group membership or execution context).
Row-Level Security (RLS) simplifies the design and coding of security in your application. RLS enables you to implement restrictions on data row access. For example ensuring that workers can access only those data rows that are pertinent to their department, or restricting a customer's data access to only the data relevant to their company.
To learn more Row Level Security for SQL Server Databases

September 26-27 2016 | Atlanta GA 
Microsoft Data Science Summit
Join Joseph Sirosh, Corporate Vice President, to hear how Microsoft will help you deliver the next generation of intelligent applications across your business delivering deeper insights, meaningful actions, and greater profits.

No comments:

Post a Comment

Popular Posts