What's New in SQL Server 2016

-

 

Check this out. Below is the summary of SQL Server 2016 new features. 

1       Query Store
a)     It contains query work load history.
b)    It can enforce polices to direct SQL Server Query processor to execute in a specific     manner
c)      Captures queries, query plans, runtime statistics, etc.
d)      New system views are added to support Query store
e)      Helps system-wide or database level performance analysis and troubleshooting

2      Column Store
a)      Column store index on your in-memory table for higher throughput
b)     Columnstore indexes achieve up to 10x greater data compression than row store indexes. This greatly reduces the IO required to execute analytics queries and therefore improves query performance

3      Live Query Statistics
a)      Live Query plans with system resources consumption such as CPU and memory for all running queries in the plan
b)      It helps you watch change of statistics during query execution
c)      You can drill down further into live running queries from its query plan  

4      Row Level Security
a)     Security can be defined on a complete row based on the characteristics of the user    executing a query (e.g. group membership or execution context)

5      Always Encrypted
a)      Encrypted data at rest and in motion
b)      Encryption master key resides at Application
c)      No application change required (Simple SSIS Package convergence)


6      Native JSON Support
a)      Language - Independent data-interchange format
b)      Modern Web and Mobile Applications are using it
c)      Alternate XML
d)      Parsing done via Standard JavaScript function
e)      Easier and faster than XML parsing
f)       Several new T-SQL constructs introduced to facilitate JSON

7      Temporal Database support
a)      Keep track data in the database (Current and historical)
b)      Provides ability to query the table snapshot for any point in time
c)      Data can be restored to any known state without downtime
d)      Help regulate compliance and audit
e)      Help implementing slowly changing dimension

8      Polybase
a) Querying relational and non-relational data
b) Example: SQL + Hadoop  (With the help of external table)

9      Advance Analytics
a)      Data Scientists can get model or templates from MS Azure where others are sharing and    
hook it up with their real time data for data examining
  

10    BI on Mobile Devices
a)      All BI on Mobile: New – DataZen App
  •   Windows
  •   IOS
  •   Android
  •   HTML5


11    Data Stretch to MS Azure
a)      Stretch the data to the cloud 
  •      Remote data archive (DBA)
  •      Power BI Scenarios with SSIS 
  •     Stretch tables into Azure

b)      Enhanced Backup/restore for stretched databases

12   SSDT (All in One)

Comments

  1. atalnetworksNovember 3, 2020 at 2:30 AM

    This is a well-researched article which you have shared here about SQL server. This is a very informative and useful article. This type of advice is not easy to find so, thanks for this information. Unmetered Server

    ReplyDelete
  2. ActiveServersJuly 7, 2021 at 3:39 AM

    Very interesting. Your article is so convincing that I can never stop myself from saying anything about it. You are doing a great job, thanks for sharing such a great blog. vps server

    ReplyDelete

Post a Comment

Popular posts from this blog

AWS: Benefits of using Amazon S3

-
Image
Let us start with a quick introduction. Amazon simple storage service or Amazon S3 provides developers / IT teams / Organizations / Individuals with secure, available, price friendly object storage in the cloud. Ok. Slow down. What is object storage? It is a computer data storage architecture that manages data as objects, as opposed to other storage architectures like file systems, which manage data as a file hierarchy, and block storage, which manages data as blocks within sectors and tracks. Amazon S3 is easy to use and can be used to store and retrieve any amount of data at any time. All data transfers are over automatic encryption and SSL. Data is secure, available when needed and will scale as your needs grow. Last thing you want to worry about is losing valuable data. Amazon S3 automatically replicates your objects on multiple devices across multiple facilities. In Amazon S3, you create bucke
Read more

Google To Acquire Looker For $2.6 Billion

-
Image
The deal is expected to close later this year, at which point Looker will become part of Google Cloud , helping serve Google customers a more comprehensive analytics solution. Data remains an untapped resource for many organizations and businesses. I believe the addition of Looker to Google Cloud will provide customers with a more comprehensive analytics solution,from ingesting and integrating data to gain insights, to embedded analytics and visualizations enabling enterprises to leverage the power of analytics, machine learning and AI. Whether that’s supply chain analytics in retailing; media analytics in entertainment; or healthcare analytics at global scale. The market for business intelligence software is large. Indeed in August 2018, IDC said that "Worldwide revenue for big data and business analytics (BDA) solutions was $166 billion, up 11.7% over 2017 and would reach $260 billion
Read more

Python - GUI - Tkinter(Bar & Pie Chart)

-
Image
Quickly, i just want to show you a simple example of creating bar and pie chart with Tkinter . Try this simple example: import tkinter as tk root = tk.Tk() root.title("Tkinter Bar and Pie Graph") #here is for bar chart............ tk.Label(root, text='Bar Chart').pack() data = [21, 20, 19, 16, 14, 13, 11, 9, 4, 3] c_width = 400 c_height = 350 c = tk.Canvas(root, width=c_width, height=c_height, bg= 'white') c.pack() #experiment with the variables below size to fit your needs y_stretch = 15 y_gap = 20 x_stretch = 10 x_width = 20
Read more