quinta-feira, 4 de fevereiro de 2016

Keeping up with the data needs of the business with SQL Server 2016

Leaders are embracing the need to partner with IT to help them gain actionable insights from data. Attesting to this, The Economist recently published a study, “Big data evolution: Forging new corporate capabilities for the long term,” which found that companies “that have a well-defined data strategy are much more likely to say that they financially outperform their competitors — in fact, strategic data managers are four times as [likely] to report that they are substantially ahead of peers.” As a result, “a new kind of partnership has emerged between IT and the business … Not only is this resulting in less dead-weight friction about the goals and approach to data initiatives, but it is also allowing IT to up their game.”

Data’s contribution to business success is ever-expanding, however, unless IT can help transform more data into actionable insights, then it is not providing the business with the trusted information they need to uncover new business opportunities and fuel innovation.

Modern BI platform

For IT to remain responsive and agile to the business demands they need a modern Business intelligence (BI) and analytics platform that provides trusted datasets and metrics that can be easily accessed, consumed and shared by the right people.

SQL Server continues to evolve to let you benefit from data without incurring extra cost from expensive add-ons or facing additional expenses for training IT staff. Because the enhancements to SQL Server 2016 are based on technology that IT is already familiar with, IT can build on existing skill sets to perform modern BI and analytics responsibilities and supporting a modern data strategy. For example, SQL Server 2016 lets IT transform data into easily understood, trusted data models with user access control to make sure only appropriate users see sensitive data. This means IT can transform complex data from multiple sources into powerful, scalable models that business analysts can easily understand and access by using familiar data analytics and discovery tools such as Excel or Power BI.

But these enhancements are just the beginning. The release of SQL Server 2016 starts the cloud-paced cadence of new capabilities in Microsoft’s comprehensive enterprise-ready BI platform. This approach enables organizations to continuously build on existing investments to create, manage, and consume business insights on premises and in the cloud. With all this, SQL Server 2016 provides what you need to transform data into actionable insights to help advance your business, including mobile and hybrid BI. To learn more about the modern advances built into SQL Server 2016, read about what you can expect and the Microsoft BI reporting roadmap here. Upcoming blog posts in this series will dive into the technology that makes all this functionality possible.

Mobile BI

Accommodating mobile users has become a key requirement of BI&A efforts. Businesses recognize that the number of mobile workers will continue to increase as the number of smartphones and mobile devices increases. And with this growth, users expect IT to support their mobile devices as the means to access the information they need to do their jobs whenever and wherever they need it — from business executives to the individual employee; whether they are in the warehouse, visiting a customer, or at the airport; and whether they are connected or not.

SQL Server 2016 delivers built-in mobile BI capabilities for both IT and business users. IT professionals have the tools they need to administer user access and shared data sets in one place. Business users can then access insights in an intuitive, engaging way from their desktop and mobile devices and expect the insights to be optimized for different form factors and major mobile platforms.

When you think about optimizing your data infrastructure and maximizing your IT personnel, mobile BI is an important consideration. Providing BI access to more employees can help you transform the decision making process and make your organization agile.

Hybrid BI

As your organization transitions to the cloud to benefit from flexibility and scale, you might still have many data sources that reside on premises. Microsoft BI tools support this trend so that you can transition to the cloud at your pace and take advantage of a hybrid BI solution that will let you continue to benefit from existing on-premises investments. For example, you can pin a Reporting Services paginated report item to a Power BI dashboard so you can view all your information in one place. Or you can access on-premises data from the Power BI service without the need to move the data to the cloud.

Trusted BI platform: Building on your foundation

SQL Server has gained a reputation as a trusted and scalable platform, and has been recognized as a leader in Gartner’s Magic Quadrant for Business Intelligence and Analytics. (Download the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms). With that knowledge and the Microsoft data platform infrastructure that organizations depend on today, business and IT can strengthen their data partnership by building on the existing skills and technology and the advances built into SQL Server 2016. Grow your business bottom line by confidently relying on the Microsoft data platform, knowing that it will work with what you have—whether your data and tools reside on-premises or in the cloud—and it will scale with your business as your data and reporting needs grow over time.

Stay tuned to this blog series for in-depth details on SQL Server 2016 analysis, reporting and BI innovations, and click below for further reading and to try SQL Server 2016 CTP3 for yourself.

See the other posts in the SQL Server 2016 blogging series.



from SQL Server Team Blog http://ift.tt/23Mv0EG

Keeping up with the data needs of the business with SQL Server 2016

Leaders are embracing the need to partner with IT to help them gain actionable insights from data. Attesting to this, The Economist recently published a study, “Big data evolution: Forging new corporate capabilities for the long term,” which found that companies “that have a well-defined data strategy are much more likely to say that they financially outperform their competitors — in fact, strategic data managers are four times as [likely] to report that they are substantially ahead of peers.” As a result, “a new kind of partnership has emerged between IT and the business … Not only is this resulting in less dead-weight friction about the goals and approach to data initiatives, but it is also allowing IT to up their game.”

Data’s contribution to business success is ever-expanding, however, unless IT can help transform more data into actionable insights, then it is not providing the business with the trusted information they need to uncover new business opportunities and fuel innovation.

Modern BI platform

For IT to remain responsive and agile to the business demands they need a modern Business intelligence (BI) and analytics platform that provides trusted datasets and metrics that can be easily accessed, consumed and shared by the right people.

SQL Server continues to evolve to let you benefit from data without incurring extra cost from expensive add-ons or facing additional expenses for training IT staff. Because the enhancements to SQL Server 2016 are based on technology that IT is already familiar with, IT can build on existing skill sets to perform modern BI and analytics responsibilities and supporting a modern data strategy. For example, SQL Server 2016 lets IT transform data into easily understood, trusted data models with user access control to make sure only appropriate users see sensitive data. This means IT can transform complex data from multiple sources into powerful, scalable models that business analysts can easily understand and access by using familiar data analytics and discovery tools such as Excel or Power BI.

But these enhancements are just the beginning. The release of SQL Server 2016 starts the cloud-paced cadence of new capabilities in Microsoft’s comprehensive enterprise-ready BI platform. This approach enables organizations to continuously build on existing investments to create, manage, and consume business insights on premises and in the cloud. With all this, SQL Server 2016 provides what you need to transform data into actionable insights to help advance your business, including mobile and hybrid BI. To learn more about the modern advances built into SQL Server 2016, read about what you can expect and the Microsoft BI reporting roadmap here. Upcoming blog posts in this series will dive into the technology that makes all this functionality possible.

Mobile BI

Mobile BI iPhoneAccommodating mobile users has become a key requirement of BI&A efforts. Businesses recognize that the number of mobile workers will continue to increase as the number of smartphones and mobile devices increases. And with this growth, users expect IT to support their mobile devices as the means to access the information they need to do their jobs whenever and wherever they need it — from business executives to the individual employee; whether they are in the warehouse, visiting a customer, or at the airport; and whether they are connected or not.

SQL Server 2016 delivers built-in mobile BI capabilities for both IT and business users. IT professionals have the tools they need to administer user access and shared data sets in one place. Business users can then access insights in an intuitive, engaging way from their desktop and mobile devices and expect the insights to be optimized for different form factors and major mobile platforms.

When you think about optimizing your data infrastructure and maximizing your IT personnel, mobile BI is an important consideration. Providing BI access to more employees can help you transform the decision making process and make your organization agile.

Hybrid BI

Pin Report items to Power BI dashboard

As your organization transitions to the cloud to benefit from flexibility and scale, you might still have many data sources that reside on premises. Microsoft BI tools support this trend so that you can transition to the cloud at your pace and take advantage of a hybrid BI solution that will let you continue to benefit from existing on-premises investments. For example, you can pin a Reporting Services paginated report item to a Power BI dashboard so you can view all your information in one place. Or you can access on-premises data from the Power BI service without the need to move the data to the cloud.

Trusted BI platform: Building on your foundation

SQL Server has gained a reputation as a trusted and scalable platform, and has been recognized as a leader in Gartner’s Magic Quadrant for Business Intelligence and Analytics. (Download the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms). With that knowledge and the Microsoft data platform infrastructure that organizations depend on today, business and IT can strengthen their data partnership by building on the existing skills and technology and the advances built into SQL Server 2016. Grow your business bottom line by confidently relying on the Microsoft data platform, knowing that it will work with what you have—whether your data and tools reside on-premises or in the cloud—and it will scale with your business as your data and reporting needs grow over time.

Stay tuned to this blog series for in-depth details on SQL Server 2016 analysis, reporting and BI innovations, and click below for further reading and to try SQL Server 2016 CTP3 for yourself.

See the other posts in the SQL Server 2016 blogging series.

Try SQL Server 2016 CTP3



from SQL Server Blog http://ift.tt/1Pjnh7g

quarta-feira, 3 de fevereiro de 2016

Introducing: SQL Server 2016 Community Technology Preview 3.3

The SQL Server 2016 Community Technology Preview (CTP) 3.3 is now available for download! In SQL Server 2016 CTP 3.3, part of our new rapid preview model, we made enhancements to several features which you can try in your development and test environments.

In SQL Server 2016 CTP 3.3, available for download or in an Azure VM today, some of the key improvements include:

  • Continued enhancement of Stretch Database: Stretch Database allows you to stretch operational tables in a secure manner into Azure for cost-effective historic data availability. CTP 3.3 includes multiple improvements to Stretch Database, including Azure Stretch database edition preview with support for up to 60TB, Point-in-time restore and geo-failover support.
  • Enhancements to In-Memory OLTP: In-Memory OLTP, which dramatically improves transaction processing performance, has added support in CTP 3.3.
  • Enhancements to Analysis Services DirectQuery models: Analysis Services Tabular Models running in DirectQuery mode now also allows us of DAX filters when defining roles and creation of calculated columns.
  • Enhancements to the new Reporting Services web portal: An updated preview of the new web portal now enables you to add the KPIs and reports you use to your Favorites, to create and edit shared data sources for your KPIs and reports, and to perform other management tasks.

For additional detail, please visit the detailed CTP 3.3 technical overview blog post, CTP 3.3 Analysis Services blog post, CTP 3.3 Management Studio blog post, and SQL Server 2016 CTP 3.3 Reporting Services blog post.

Download SQL Server 2016 CTP 3.3 preview today!

As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know on Connect. We look forward to hearing from you!



from SQL Server Blog http://ift.tt/1ULZQqX

Technical Overview: SQL Server 2016 Community Technology Preview 3.3

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 public preview release CTP 3.3. This release advances the “Cloud First” tenet; the build has already been deployed to SQL Azure Database worldwide.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know using Microsoft’s Connect tool. We look forward to hearing from you.

New Stretch Database improvements in CTP 3.3 include:

  • Support to enable TDE on a remote DB if the local database has TDE enabled
  • Azure Stretch database edition preview with support for up to 60TB
  • Alter and drop index support for stretch tables
  • Add, alter and drop columns support for stretch tables
  • Point-in-time restore and geo-failover support
  • Query performance improvement

SQL Server Management Studio improvements in this release include:

  • Additional Wizard features:
    • Added new SQL db credential management functionality
    • Integrated Table validation and selection updates to prevent stretch of unsupported datatypes at selection time
    • Table search functionality for table select page
    • Table selection column reordering
    • Support for temporal tables during table select
    • Integrated Azure sign in and SQL sign in credential
    • Add support for stretching using federated accounts
    • New firewall configuration and subnet detection functionality
    • Updated summary page details with pricing information
    • Improved SSMS visualization with StretchDB icons
  • Object Explorer:
    • Fly out menu updates to support disable and un-migration functionality
    • Un-migrate support functionality at database and table level

Read the SSMS blog post to learn more.

CTP3.3 adds support with In-Memory OLTP for:

  • Automatic update of statistics on memory-optimized tables: The statistics for memory-optimized tables are now updated automatically, removing the need for running maintenance tasks that update statistics manually.
  • Sampled statistics for memory-optimized tables: Sampling of statistics for the data in memory-optimized tables is now supported, alongside the previously supported fullscan statistics. This reduces the time it takes to collect statistics for large tables.
  • Use of LOB types varchar(max), nvarchar(max), and varbinary(max) with built-in string functions (‘+’, len, ltrim, rtrim and substring) in natively compiled modules, and as return type of natively compiled scalar UDFs.
  • Memory-optimized tables with row size > 8060 bytes, using non-LOB types. CTPs 3.1 and 3.2 supported larger rows using LOB types; as of CTP3.3, memory-optimized tables support also larger rows using types varchar(n), nvarchar(n) and varbinary(n). See below for an example.
  • The OUTPUT clause can now be used with INSERT, UPDATE and DELETE statements in natively compiled stored procedures.

Autostats improvements in CTP 3.3

Previously, statistics were automatically recalculated when the change exceeded a fixed threshold. As of CTP 3.3, we have refined the algorithm such that it is no longer a fixed threshold, but in general will be more aggressive in triggering statistics scans, resulting in more accurate query plans.

Foreign Key Support enhancements in CTP 3.3

SQL Server 2014 and earlier versions have limitations on the number of FOREIGN KEY references a table can contain, as well as the maximum number on incoming foreign key REFERENCES. The documented recommended maximum is 253, and when performing DML on tables with large numbers of incoming REFERENCES, statements time out with stack overflow error messages.

This improvement increases the number of supported incoming foreign key REFERENCES to a table, while maintaining good performance for DML operations in both the referencing and the referenced table. The new maximum is 10,000. However, with the CTP 3.3 release, we have certain limitations on this feature:

  • We ONLY support Delete DML operation on foreign key references that go beyond the current recommended maximum of 253. Therefore, we will validate that no referencing rows exist before deletion.
  • Update and Merge operations are not supported with this release. Update will be available in RTM.
  • You will not see any change in behavior for cascading actions.
  • This is not available in ColumnStore, Hekaton or StretchDB.
  • This change is not applicable to a primary key table that is self-referencing (that is, if the table has a foreign key to itself). In this case, the behavior would remain the same as before.
  • This is not supported for partitioned foreign key tables for CTP 3.3. However, partitioned tables will be supported in RTM.

SQL Server Analysis Services (SSAS) includes multiple additions in this release. Read the SSAS CTP 3.3 blog post to learn more.

SQL Server Reporting Services (SSRS) includes an updated preview of its brand-new web portal with additional functionality:

  • Add the KPIs and reports that matter most to you to your Favorites and view them all in one place.
  • Manage shared data sources for your KPIs and reports and perform other management tasks.

Read the SSRS blog post to learn more.

Master Data Services (MDS) improvements in this release include:

  • Business rule changes
    • New, easier-to-use web UI administration page
    • Support for NOT conditional operator
    • Support for ELSE section that contains a set of actions to execute if the IF condition is false
    • Removed management UI from Excel add-in
  • Added support for purging (hard-deleting soft-deleted members) of an entity version
  • Added to the web explorer page a button to open the current entity view in the Excel add-in



from SQL Server Blog http://ift.tt/1R3HKBr

TLS 1.2 support availability for SQL Server

Microsoft is ensuring that customers can remain compliant with the current changes in guidance for using strong cryptography for implementing security control. A number of known vulnerabilities has been reported against SSL and earlier versions of TLS which has changed the security guidance to move to TLS 1.2 for support secure communication.

There has been no known vulnerability that has been reported for Microsoft’s TDS implementation which is the communication protocol used between SQL Server clients and the SQL Server database engine.

As of January 29, Microsoft SQL Server supports TLS 1.2 for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 and major client drivers like Server Native Client, Microsoft ODBC Driver for SQL Server, Microsoft JDBC Driver for SQL Server and ADO.NET (SqlClient).

You can read more about the release here. The list of builds that support TLS 1.2 along with the client and server component download locations is available in KB3135244.



from SQL Server Blog http://ift.tt/1ULZP64

It’s time! Registration is now open for Microsoft Ignite

It’s time — Register now for Microsoft Ignite and mark your calendar for September 26–30. Be there when top industry leaders talk about what’s next, get direct access to the people who built the products you use every day, and surround yourself with smart people talking tech.

Sharpen your ideas with the best in the business.

From high-level strategy to deep product insights, you’ll hear about new technologies and explore real-world solutions to today’s challenges. Customize your schedule to go deep on the topics that matter most to you and your organization including: cloud infrastructure and management, big data, analytics, productivity, communications, operating systems, mobile devices, and more.

  • 1,000+ hours of content, 700+ sessions, and a multitude of networking opportunities
  • Insights and roadmaps from industry leaders
  • Deep dives and live demos on the products you use every day
  • Direct access to Microsoft product experts
  • Hands-on learning in digital labs

Connect with techies like yourself.

After last year’s conference, an attendee wrote, “Networking at #MSIgnite is like coming home.” We make it easy to connect, with dozens of opportunities including networking lounges, mealtime mashups, and meetups. You’ll expand your contact list—and meet people who can challenge your thinking and inspire you to take your ideas further.

Join us. Register for Microsoft Ignite 2016.



from SQL Server Blog http://ift.tt/1ULZQaq

Webcast: Upgrading and migrating SQL Server 2005 BI features to SQL Server 2014 and 2016

Please join us on February 3, at 10:00 am PST for a webinar on upgrading and migrating from SQL Server 2005 BI features to SQL Server 2014 and 2016 with guest speaker Paul Turley, SolidQ Mentor and MVP. The following is a post from Paul on why this is such an important topic. Register here and join us on Wednesday to learn more.

 

If you’re still on SQL Server 2005, there are some important things to be aware of. First and foremost is that you are missing out on innumerable capabilities in more recent versions of the SQL Server platform, in the relational engine and the BI stack. Secondly, Microsoft will no longer support SQL Server 2005 after mid-April of this year. This is not a marketing ploy to upsell customers but simply the normal retirement cycle of a ten-year-old, outdated product. Yet, for some organizations managing critical systems, it’s a disaster waiting to happen.

Considering performance and security alone, the differences between SQL Server 2005 and recent versions are quantum. We frequently see cases where performance improvements on a typical workload improve by multiples of two, ten and more, making the ROI math pretty simple. Improvements to the core BI feature set (Reporting Services, Analysis Services and Integration Services) are also vast, with improved reliability, ease of design and usability. These are some of the topics I’ll discuss in this free presentation.

An upgrade of your SQL Server Business Intelligence solution brings with it the challenge of understanding how to apply new features to your BI workload, but it also opens up tremendous opportunity for business impact. In this session we’ll talk about business benefits to upgrading your BI solution, costs to upgrade now vs. the costs of waiting, and current trends in corporate upgrade strategies. For those impacted by the end of extended support for SQL Server 2005 on 04/12/2016, we will discuss enhancements to the SQL Server platform and examples of how to take advantage of the latest features. We’ll touch on workload-specific upgrade benefits to modernizing your SSAS, SSRS, and SSIS environments, then wrap up with how upgrade can improve users’ reporting experience using the latest in mobile BI.

Speaker: Paul Turley, Solid Q Mentor and MVP



from SQL Server Blog http://ift.tt/1R3HKl3

Introducing: SQL Server 2016 Community Technology Preview 3.3

The SQL Server 2016 Community Technology Preview (CTP) 3.3 is now available for download! In SQL Server 2016 CTP 3.3, part of our new rapid preview model, we made enhancements to several features which you can try in your development and test environments.

In SQL Server 2016 CTP 3.3, available for download or in an Azure VM today, some of the key improvements include:

  • Continued enhancement of Stretch Database: Stretch Database allows you to stretch operational tables in a secure manner into Azure for cost-effective historic data availability. CTP 3.3 includes multiple improvements to Stretch Database, including Azure Stretch database edition preview with support for up to 60TB, Point-in-time restore and geo-failover support.
  • Enhancements to In-Memory OLTP: In-Memory OLTP, which dramatically improves transaction processing performance, has added support in CTP 3.3.
  • Enhancements to Analysis Services DirectQuery models: Analysis Services Tabular Models running in DirectQuery mode now also allows us of DAX filters when defining roles and creation of calculated columns.
  • Enhancements to the new Reporting Services web portal: An updated preview of the new web portal now enables you to add the KPIs and reports you use to your Favorites, to create and edit shared data sources for your KPIs and reports, and to perform other management tasks.

For additional detail, please visit the detailed CTP 3.3 technical overview blog post, CTP 3.3 Analysis Services blog post, CTP 3.3 Management Studio blog post, and SQL Server 2016 CTP 3.3 Reporting Services blog post.

Download SQL Server 2016 CTP 3.3 preview today!

As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft's data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know on Connect. We look forward to hearing from you!



from SQL Server Team Blog http://ift.tt/20GSWa0

Technical Overview: SQL Server 2016 Community Technology Preview 3.3

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 public preview release CTP 3.3. This release advances the “Cloud First” tenet; the build has already been deployed to SQL Azure Database worldwide.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know using Microsoft’s Connect tool. We look forward to hearing from you.

New Stretch Database improvements in CTP 3.3 include:

  • Support to enable TDE on a remote DB if the local database has TDE enabled
  • Azure Stretch database edition preview with support for up to 60TB
  • Alter and drop index support for stretch tables
  • Add, alter and drop columns support for stretch tables
  • Point-in-time restore and geo-failover support
  • Query performance improvement

SQL Server Management Studio improvements in this release include:

  • Additional Wizard features:
    • Added new SQL db credential management functionality
    • Integrated Table validation and selection updates to prevent stretch of unsupported datatypes at selection time
    • Table search functionality for table select page
    • Table selection column reordering
    • Support for temporal tables during table select
    • Integrated Azure sign in and SQL sign in credential
    • Add support for stretching using federated accounts
    • New firewall configuration and subnet detection functionality
    • Updated summary page details with pricing information
    • Improved SSMS visualization with StretchDB icons
  • Object Explorer:
    • Fly out menu updates to support disable and un-migration functionality
    • Un-migrate support functionality at database and table level

Read the SSMS blog post to learn more.

CTP3.3 adds support with In-Memory OLTP for:

  • Automatic update of statistics on memory-optimized tables: The statistics for memory-optimized tables are now updated automatically, removing the need for running maintenance tasks that update statistics manually.
  • Sampled statistics for memory-optimized tables: Sampling of statistics for the data in memory-optimized tables is now supported, alongside the previously supported fullscan statistics. This reduces the time it takes to collect statistics for large tables.
  • Use of LOB types varchar(max), nvarchar(max), and varbinary(max) with built-in string functions (‘+’, len, ltrim, rtrim and substring) in natively compiled modules, and as return type of natively compiled scalar UDFs.
  • Memory-optimized tables with row size > 8060 bytes, using non-LOB types. CTPs 3.1 and 3.2 supported larger rows using LOB types; as of CTP3.3, memory-optimized tables support also larger rows using types varchar(n), nvarchar(n) and varbinary(n). See below for an example.
  • The OUTPUT clause can now be used with INSERT, UPDATE and DELETE statements in natively compiled stored procedures.

Autostats improvements in CTP 3.3

Previously, statistics were automatically recalculated when the change exceeded a fixed threshold. As of CTP 3.3, we have refined the algorithm such that it is no longer a fixed threshold, but in general will be more aggressive in triggering statistics scans, resulting in more accurate query plans.

Foreign Key Support enhancements in CTP 3.3

SQL Server 2014 and earlier versions have limitations on the number of FOREIGN KEY references a table can contain, as well as the maximum number on incoming foreign key REFERENCES. The documented recommended maximum is 253, and when performing DML on tables with large numbers of incoming REFERENCES, statements time out with stack overflow error messages.

This improvement increases the number of supported incoming foreign key REFERENCES to a table, while maintaining good performance for DML operations in both the referencing and the referenced table. The new maximum is 10,000. However, with the CTP 3.3 release, we have certain limitations on this feature:

  • We ONLY support Delete DML operation on foreign key references that go beyond the current recommended maximum of 253. Therefore, we will validate that no referencing rows exist before deletion.
  • Update and Merge operations are not supported with this release. Update will be available in RTM.
  • You will not see any change in behavior for cascading actions.
  • This is not available in ColumnStore, Hekaton or StretchDB.
  • This change is not applicable to a primary key table that is self-referencing (that is, if the table has a foreign key to itself). In this case, the behavior would remain the same as before.
  • This is not supported for partitioned foreign key tables for CTP 3.3. However, partitioned tables will be supported in RTM.

SQL Server Analysis Services (SSAS) includes multiple additions in this release. Read the SSAS CTP 3.3 blog post to learn more.

SQL Server Reporting Services (SSRS) includes an updated preview of its brand-new web portal with additional functionality:

  • Add the KPIs and reports that matter most to you to your Favorites and view them all in one place.
  • Manage shared data sources for your KPIs and reports and perform other management tasks.

Read the SSRS blog post to learn more.

Master Data Services (MDS) improvements in this release include:

  • Business rule changes
    • New, easier-to-use web UI administration page
    • Support for NOT conditional operator
    • Support for ELSE section that contains a set of actions to execute if the IF condition is false
    • Removed management UI from Excel add-in
  • Added support for purging (hard-deleting soft-deleted members) of an entity version
  • Added to the web explorer page a button to open the current entity view in the Excel add-in



from SQL Server Team Blog http://ift.tt/1TDRkvJ

terça-feira, 2 de fevereiro de 2016

TLS 1.2 support availability for SQL Server

Microsoft is ensuring that customers can remain compliant with the current changes in guidance for using strong cryptography for implementing security control. A number of known vulnerabilities has been reported against SSL and earlier versions of TLS which has changed the security guidance to move to TLS 1.2 for support secure communication.

There has been no known vulnerability that has been reported for Microsoft's TDS implementation which is the communication protocol used between SQL Server clients and the SQL Server database engine.

As of January 29, Microsoft SQL Server supports TLS 1.2 for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 and major client drivers like Server Native Client, Microsoft ODBC Driver for SQL Server, Microsoft JDBC Driver for SQL Server and ADO.NET (SqlClient).

You can read more about the release here. The list of builds that support TLS 1.2 along with the client and server component download locations is available in KB3135244.



from SQL Server Team Blog http://ift.tt/1Px499a