Sites Microsoft


SQL Server 2014 Service Pack 1 Now Available for Download

Publié le 15 mai 2015 sur sql server team blog
 

Today, we are pleased to announce the availability of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center. This upgrade is available to all customers with existing SQL Server 2014 deployment …

SQL Server Page Life Expectancy (PLE)

Publié le 14 mai 2015 sur css sql server engineers
 

This week I was involved in a conversation with Paul Randal relating to PLE per node vs PLE server wide. There is an all-up PLE counter as well as individual, per NUMA node PLE counters.  SQL Server Books Online describes the values as: SQL Server …

Recommendations for using Cell Level Encryption in Azure SQL Database

Publié le 12 mai 2015 sur sql server security blog
 

When we introduced Transparent Data Encryption (TDE) to Azure SQL Database, we also introduced Cell-Level Encryption (CLE, also known as SQL Server key hierarchy). For more details on TDE on Azure SQL Database, I would recommend visiting the Channel9 s …

How to: Scale out multi-tenant apps using RLS and Elastic Database Tools

Publié le 7 mai 2015 sur sql server security blog
 

In response to a common customer ask, we’ve published guidance for developing multi-tenant applications on Azure SQL Database using row-level security (RLS) for tenant isolation and elastic database tools (formerly « Elastic Scale ») for sharding. These …

Presentation: Best Practices for multi-environment database development

Publié le 5 mai 2015 sur sql server data tools team blog
 

A few months ago our team presented at the SQLBits XIV conference. The topic was Best Practices for multi-environment database development. The full video can be found on the SQLBits site and is a very informative presentation. The topics cov …

Azure SQL Data Warehouse updates for BUILD

Publié le 5 mai 2015 sur sql server team blog
 

Guest post by Tiffany Wissner, Senior Director, Data Platform Top reasons why enterprises should choose Azure SQL Data Warehouse! Yesterday at Microsoft’s Ignite conference, we demoed the first sneak peak of Azure SQL Data Warehouse.  As you …

XEvent Timestamp is a large integer value not the expected datatime value

Publié le 4 mai 2015 sur css sql server engineers
 

The timestamp column for XEvent is stored internally as an offset from the start of the trace.   The XEvent header contains the starting, UTC time and each event stores the offset in ticks from the value stored in the header. On a system wher …

SQL Server 2016 public preview coming this summer

Publié le 4 mai 2015 sur sql server team blog
 

Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world.  The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for …

Data-Tier Application Framework Update for May 2015

Publié le 30 avril 2015 sur sql server data tools team blog
 

The SQL Server Data Tools team is pleased to announce an update for the Data-tier Application Framework (DACFX) is now available. This update adds support to DACFX for Full Text Search in Azure SQL DB. Once this update is installed, SQL Server Man …

SQL Server 2005 support ends April 2016 – Here’s why that’s a good thing

Publié le 29 avril 2015 sur sql server team blog
 

Now’s the perfect time to deploy Microsoft SQL Server 2014. Sure, it enables faster data processing and performance, but that’s just the beginning. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data …

Microsoft Announces Azure SQL Database elastic database, Azure SQL Data Warehouse, Azure Data Lake

Publié le 29 avril 2015 sur sql server team blog
 

In this mobile-first, cloud-first world, we’re creating and consuming data through new devices and services – and developers are building applications and analytics solutions at a rapid pace to take advantage of the new forms, types and sizes of data. …

Announcing Transparent Data Encryption for Azure SQL Database

Publié le 29 avril 2015 sur sql server security blog
 

Available today, SQL Database Transparent Data Encryption (preview) protects your data and helps you meet compliance requirements by encrypting your database, associated backups, and transaction log files at rest without requiring changes to your appli …

Server’s “Max Degree of Parallelism” setting, Resource Governor’s MAX_DOP and query hint MAXDOP–which one should SQL Server use?

Publié le 29 avril 2015 sur css sql server engineers
 

SQL Server allows a user to control max degree of parallelism of a query in three different ways.   Just for references, here is a list of documentation: SQL Server wide “max degree of parallelism” configuration is documented in m …

Row-Level Security: Performance and common patterns

Publié le 24 avril 2015 sur sql server security blog
 

This post demonstrates three common patterns for implementing Row-Level Security (RLS) predicates: Rows assigned directly to users Row assignments in a lookup table Row assignments from a JOIN In addition, this post shows how RLS has performance compar …


Pages :