Category Archives : #SQLServer

30

Oct

Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program

Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to support the scenarios below.

Modernize to SQL Server 2017 to begin your journey to cloud

With SQL Server 2017, now on Windows, Linux, and Docker containers, you can build modern applications using the language of your choice, on-premises or in the cloud. SQL Server 2017 offers tremendous performance features for your mission-critical, intelligence, and data warehouse applications. In-Memory OLTP delivers up to 30x faster transaction processing and columnstore indexes deliver up to 100x faster analytical processing. In addition to these features, SQL Server also owns the top TPC-H performance benchmarks for data warehouse.¹ With SQL Server 2017, you can inject intelligence into your applications with transformative insights and real-time analytics at up to one million R predictions per second.² Leverage these latest enhancements while protecting your application data with the least-vulnerable database over the last seven years.³

Modernize on-premises SQL Server or Oracle apps to

Share

30

Oct

Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program

Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to support the scenarios below.

Modernize to SQL Server 2017 to begin your journey to cloud

With SQL Server 2017, now on Windows, Linux, and Docker containers, you can build modern applications using the language of your choice, on-premises or in the cloud. SQL Server 2017 offers tremendous performance features for your mission-critical, intelligence, and data warehouse applications. In-Memory OLTP delivers up to 30x faster transaction processing and columnstore indexes deliver up to 100x faster analytical processing. In addition to these features, SQL Server also owns the top TPC-H performance benchmarks for data warehouse.¹ With SQL Server 2017, you can inject intelligence into your applications with transformative insights and real-time analytics at up to one million R predictions per second.² Leverage these latest enhancements while protecting your application data with the least-vulnerable database over the last seven years.³

Modernize on-premises SQL Server or Oracle apps to

Share

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

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

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