Sites Microsoft


Real-Time Operational Analytics using In-Memory Technology

Publié le 9 décembre 2015 sur sql server team blog
 

Operational workloads refer to the business transactions that are critical to running a business. For example, a retail store has a transactional system to create or modify new orders, and a credit card company tracks all charges made by vendors on beh …

CHECKSUM and BINARY_CHECKSUM might not return unique values for different inputs

Publié le 9 décembre 2015 sur Microsoft SQL Server database engine blog
 

CHECKSUM and BINARY_CHECKSUM create checksums for text inputs. Checksum values should be different for different input text. However, in some cases, returned values are not always unique for different inputs. You can find patterns of inputs that return …

Create relational view over JSON text

Publié le 9 décembre 2015 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 enables you to use JSON_VALUE, JSON_QUERY, and OPENJSON functions to fetch data from JSON text. However, if you want to to query JSON data using standard relational models you can create views that encapsulate these functions. In Advent …

Columnstore Index: Speeding up analytics in SQL Server 2016

Publié le 9 décembre 2015 sur Microsoft SQL Server database engine blog
 

Please refer to the post http://blogs.technet.com/b/dataplatforminsider/archive/2015/12/08/speeding-up-business-analytics-using-in-memory-technology-in-sql-server-2016-and-azure-sql-database.aspx  Thanks Sunil Agarwal

Speeding up Business Analytics using In-Memory Technology

Publié le 8 décembre 2015 sur sql server team blog
 

New challenges Businesses have always used data and analytics for improved business decisions. As the new age of the IOT (Internet of Things) approaches, businesses are experiencing exponential data growth and the challenges that come along with managi …

Built-in functions for compression/decompression in SQL Server 2016

Publié le 8 décembre 2015 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 provides built in functions for compression and decompression: COMPRESS – compress data using GZip algorithm and returns binary data. DECOMPRESS – decompress binary data using GZip algorithm and returns binary data. You will n …

SQL Server 2016 Temporal Data Assists Machine Learning Models

Publié le 7 décembre 2015 sur css sql server engineers
 

Microsoft is always seeking out ways to improve the customer experience and satisfaction.  A project that is currently active looks at the SQL Server incidents reported to Microsoft SQL Server Support and applies Machine Learning.   A sp …

AdventureWorksCTP3 JSON Sample

Publié le 7 décembre 2015 sur Microsoft SQL Server database engine blog
 

New database and samples for AdventureWorks 2016 CTP3 database are published on AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3. In SQLServer2016CTP3Samples.zip file (attached in this post) you can find various example sc …

MultiSubnet = TRUE Is Now Default Behavior

Publié le 3 décembre 2015 sur css sql server engineers
 

I get to be the a good new messenger today.    We have made changes to the SQL Server Client Provider.  The provider detects when multiple IP addresses are present for a listener.   The links below detail the behavior maki …

SQL Server 2016: Advanced Capabilities without Expensive Add-Ons

Publié le 3 décembre 2015 sur sql server team blog
 

What does the industry leading SQL Server 2016 have in common with spaghetti sauce? Just the fact that if you need something, “it’s in there.” With SQL Server 2016 the advanced capabilities you need in a data platform are built in. Yo …

Get the most out of SQL Server 2016

Publié le 1 décembre 2015 sur sql server team blog
 

Blog post series to highlight new features and enhancements available with SQL Server 2016. Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today. With SQL Server 2016, it’s never …

Row-Level Security block predicates are generally available on Azure SQL Database

Publié le 1 décembre 2015 sur sql server security blog
 

Azure SQL Database’s Row-Level Security (RLS) feature now officially supports block predicates. In contrast to filter predicates, which limit the rows visible to a user, block predicates prevent a user from inserting, updating, or delet …

SQL Server Data Tools Preview update for November 2015

Publié le 1 décembre 2015 sur sql server data tools team blog
 

The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for November 2015 includes a new connection experience for Microsoft SQL Server and Azure SQL Database. Key improvements are …

Always Encrypted Data Security and Competitive Advantage

Publié le 1 décembre 2015 sur sql server team blog
 

As data becomes the center of digital business, your organization’s ability to secure data is crucial for compliance and confidentiality. But data security is so important that it can also be a competitive differentiator. Indeed, Forrester Resear …


Pages :