Tags : #sqlserver

23

Oct

Ask the team that built SQL Server 2017 anything on October 25, 2017

Hi! We’re Travis Wright and Tobias Ternstrom from the Microsoft SQL Server engineering team and we along with other members of the team are hosting a Reddit Ask Me Anything session on /r/Database, Wednesday, October 25, 2017, from 10:00 am to 11:30am PDT.

Why are we doing an AMA?

SQL Server 2017 was made generally available on October 2, on Windows, Linux and Docker containers. With this release, customers have an even wider choice of development languages, data types, and operating systems. We’re excited to connect with you on Reddit to tell you more about our experiences bringing it to market and answering your questions!

We’re also getting ready to join thousands of data professionals in Seattle from October 31 – November 3rd at the PASS Summit 2017. We look forward to this gathering every year. If you’re attending or planning to watch online, this AMA is a great time to catch up beforehand.

Join us! We’re looking forward to having a conversation with you.

Share

18

Oct

Monitoring SQL Server and Azure SQL DB Session at DBA Fundamentals PASS VC

https://blogs.msdn.microsoft.com/sql_server_team/monitoring-sql-server-and-azure-sql-db-session-at-dba-fundamentals-pass-vc/Source: https://blogs.msdn.microsoft.com/sql_server_team/monitoring-sql-server-and-azure-sql-db-session-at-dba-fundamentals-pass-vc/   On 10/17/2017, we delivered a webinar session titled “Comprehensive Guide for Monitoring SQL Server and Azure SQL DB” hosted by DBA Fundamentals PASS Virtual Chapter. You can find the link to the recording below. In the session, we talked about READ MORE

Share

12

Oct

SQL Server Tiger at PASS Summit 2017
SQL Server Tiger at PASS Summit 2017

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-tiger-at-pass-summit-2017/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-tiger-at-pass-summit-2017/   The SQL Server team will again be at the Summit this year. If we are not speaking or co-speaking in a session, you can find us at the SQL Server Clinic at any time. Sessions Here are READ MORE

Share

05

Oct

SQL Server 2012 Service Pack 4 (SP4) is now available!
SQL Server 2012 Service Pack 4 (SP4) is now available!

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2012-service-pack-4-sp4-is-now-available/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2012-service-pack-4-sp4-is-now-available/   SQL Server Product Team is excited to bring you the final release of SQL Server 2012 Service Packs, Service Pack 4 (SP4). This release of SQL 2012 Service Pack has 20+ improvements centered around performance, scalability and READ MORE

Share

05

Oct

Enabling Confidential Computing with Always Encrypted using Enclaves (Early Access Preview)

https://blogs.msdn.microsoft.com/sqlsecurity/2017/10/05/enabling-confidential-computing-with-always-encrypted-using-enclaves-early-access-preview/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/10/05/enabling-confidential-computing-with-always-encrypted-using-enclaves-early-access-preview/   Last week at Ignite, we announced a major SQL security investment that enhances Always Encrypted with secure enclave technologies to enable: Rich computations on encrypted columns, including pattern matching, range comparisons, and sorting, which unlocks Always Encrypted READ MORE

Share

20

Sep

Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7

https://blogs.msdn.microsoft.com/sql_server_team/backup-compression-for-tde-enabled-databases-important-fixes-in-sql-2016-sp1-cu4-and-sql-2016-rtm-cu7/Source: https://blogs.msdn.microsoft.com/sql_server_team/backup-compression-for-tde-enabled-databases-important-fixes-in-sql-2016-sp1-cu4-and-sql-2016-rtm-cu7/   Backup Compression and Transparent Data Encryption (TDE) have been two immensely valuable and popular features for customers in SQL Server. In SQL Server 2016, backup compression was enabled for TDE-enabled databases, where if you backup a TDE-enabled READ MORE

Share

29

Aug

Enabling communication traces in C# application for Azure AD authentication with SQL DB using token-based mechanism with Multi-factor authentication (MFA)

https://blogs.msdn.microsoft.com/sqlsecurity/2017/08/29/enabling-communication-traces-in-c-application-for-azure-ad-authentication-with-sql-db-using-token-based-mechanism-with-multi-factor-authentication-mfa/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/08/29/enabling-communication-traces-in-c-application-for-azure-ad-authentication-with-sql-db-using-token-based-mechanism-with-multi-factor-authentication-mfa/   SQL server security team presents a code sample ( as VS project) allowing to enable communication traces for ADAL managed library used to support Universal Authentication with MFA for SQL DB ( see also Azure AD authentication READ MORE

Share

18

Aug

Token-based authentication including Multi-factor auth (MFA) for Azure SQL DB using Azure Active Directory (AD)

https://blogs.msdn.microsoft.com/sqlsecurity/2017/08/18/token-based-authentication-including-multi-factor-auth-mfa-for-azure-sql-db-using-azure-active-directory-ad/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/08/18/token-based-authentication-including-multi-factor-auth-mfa-for-azure-sql-db-using-azure-active-directory-ad/   SQL server security team presents an application solution for token-based authentication with multi-factor (MFA) support for SQL DB using Azure AD auth. The zip file attached below with the codes sample and a Readme doc present more details on this topic. READ MORE

Share

24

May

Now Available:  Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

https://blogs.msdn.microsoft.com/sqlsecurity/2017/05/24/now-available-guide-for-enhancing-privacy-and-addressing-gdpr-requirements-with-the-microsoft-sql-platform/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/05/24/now-available-guide-for-enhancing-privacy-and-addressing-gdpr-requirements-with-the-microsoft-sql-platform/   Data privacy and data security have become one of the most prominent topics in organizations in almost every industry across the globe. New regulations are emerging that formalize requirements around these topics, and compel organizations to comply. READ MORE

Share

02

May

Threat Detection in Azure SQL Database is now Generally Available

https://blogs.msdn.microsoft.com/sqlsecurity/2017/05/02/threat-detection-in-azure-sql-database-is-now-generally-available/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/05/02/threat-detection-in-azure-sql-database-is-now-generally-available/   We are excited to announce that Threat Detection is now Generally Available in Azure SQL Database. Threat Detection detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. Threat Detection leverages machine learning READ MORE

Share