|By Jayaram Krishnaswamy||
|November 30, 2016 07:15 PM EST|
According to the above release blog:
Many of the features (listed in the table here) available in Enterprise Edition are now available in several other editions as well after installing the SP1 (Standard, web, express and LocalDB).
Note that Change Data Capture requires SQL Server Agent not available in Express and In Memory OLTP not possible in LocalDB due to security reasons
DBCC CLONEDATABASE added supports cloning of CLR, Filestream/Filetable, Hekaton and Query Store objects are available after installing SP1
DBCC CLONEDATABASE (source_database_name, target_database_name) –– Default CLONE WITH SCHEMA, STATISTICS and QUERYSTORE metadata.
DBCC CLONEDATABASE (source_database_name, target_database_name) WITH NO_STATISTICS –– SCHEMA AND QUERY STORE ONLY CLONE
DBCC CLONEDATABASE (source_database_name, target_database_name) WITH NO_QUERYSTORE –– SCHEMA AND STATISTICS ONLY CLONE
DBCC CLONEDATABASE (source_database_name, target_database_name) WITH NO_STATISTICS,NO_QUERYSTORE –– SCHEMA ONLY CLONE
New Create/Alter supports modifying and deploying database objects such as
User–Defined Functions, and
This is just a short list from more than a dozen others. Make sure you visit the link referenced at the top.
The SQL Server 2016 Enterprise specific sample database, WorldWorldImporters can now be used in Standard and Express editions.
Download SQL Server 2016 SP1 here .
Mar. 25, 2017 11:15 AM EDT Reads: 666
Mar. 25, 2017 11:15 AM EDT Reads: 1,401
Mar. 25, 2017 11:00 AM EDT Reads: 3,426
Mar. 25, 2017 10:45 AM EDT Reads: 1,980
Mar. 25, 2017 10:30 AM EDT Reads: 10,159
Mar. 25, 2017 10:15 AM EDT Reads: 2,814
Mar. 25, 2017 10:00 AM EDT Reads: 2,818
Mar. 25, 2017 09:15 AM EDT Reads: 2,355
Mar. 25, 2017 09:15 AM EDT Reads: 4,115
Mar. 25, 2017 08:30 AM EDT Reads: 1,940
Mar. 25, 2017 08:00 AM EDT Reads: 1,167
Mar. 25, 2017 08:00 AM EDT Reads: 4,001
Mar. 25, 2017 08:00 AM EDT Reads: 1,737
Mar. 25, 2017 08:00 AM EDT Reads: 13,917
Historically, some banking activities such as trading have been relying heavily on analytics and cutting edge algorithmic tools. The coming of age of powerful data analytics solutions combined with the development of intelligent algorithms have created new opportunities for financial institutions. In his session at 20th Cloud Expo, Sebastien Meunier, Head of Digital for North America at Chappuis Halder & Co., will discuss how these tools can be leveraged to develop a lasting competitive advanta...
Mar. 25, 2017 07:45 AM EDT Reads: 2,573