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.
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
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
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
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
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
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
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
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
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