Tag: SQL

Feed: Microsoft SQL Server Blog. Author: Bob Ward. Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL Server 2022, now in public preview, is our most Azure-enabled release yet, with continued innovation across performance, security, and availability. With connections to Azure Synapse, Microsoft Purview, and Azure SQL Managed Instance, it is a key offering within the Microsoft Intelligent Data Platform, which fully integrates databases, analytics, and governance, enabling organizations to move beyond fragmentation and unlock new capabilities.  In our upcoming SQL Server 2022 blog series, you will learn about new innovation, ... Read More

Feed: Microsoft SQL Server Blog. Author: Timi Oshin. Hello community, the June release of Azure Data Studio 1.37 is here! We are also excited to announce the release of SQL Server Management Studio (SSMS) 18.12. In this Azure Data Studio release, backup and restore to URL was introduced for Managed Instance. Updates were also made to support the Table Designer feature in offline mode using SQL Projects. Per user requests, Table Designer now supports column reordering and column computation to allow for easier database customizations. Additionally, improvements were made to the Query Execution Plan feature to support plan comparison to ... Read More

Feed: Microsoft SQL Server Blog. Author: Erin Stellato. Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we thought it was a good time to highlight recent updates for client tools, as we’ve had quite a few. SQL Server Management Studio First, in alignment with the announcement of preview for SQL Server 2022, we released SQL Server Management Studio (SSMS) 19 Preview 2.  SSMS 19 is the recommended version of SSMS for SQL Server 2022. The release notes for SSMS document current limitations and we will have additional previews in upcoming months ... Read More

Feed: Recent Announcements. Now you can migrate the backup files of your on-premises database without disabling TDE. You will be able to take a backup of your existing TDE certificate, store it in Amazon S3, and restore it to an existing Amazon RDS instance with the TDE option enabled. From there, you can follow the existing procedures to export a full backup of your on-premises TDE enabled database, store it in Amazon S3, and restore that backup to your Amazon RDS instance directly using the custom stored procedures offered by Amazon RDS. This feature is available for Amazon RDS for ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Is SQL, or Structured Query Language, a programming language? That’s a great question! A question that many answer with emphasis: “No, SQL is not a programming language!” There are some who answer yes; and they usually qualify that answer with something like: “SQL is a programming language designed to communicate with relational databases.” It strikes me that those saying “yes” are saying that SQL is only a collection of interface methods to read from and write to a database engine. Those saying SQL is not a programming language often qualify that a programming language ... Read More

Feed: Recent Announcements. A new minor version of Microsoft SQL Server is now available on Amazon Relational Database Service (Amazon RDS) for SQL Server, offering performance and security fixes. Amazon RDS for SQL Server supports the new minor version for Microsoft SQL Server 2014 on the Express, Web, Standard, and Enterprise Editions ... Read More

Feed: AWS Architecture Blog. Many organizations have applications that require Microsoft SQL Server to run relational database workloads: some applications can be proprietary software that the vendor mandates Microsoft SQL Server to run database service; the other applications can be long-standing, home-grown applications that included Microsoft SQL Server when they were initially developed. When organizations migrate applications to AWS, they often start with lift-and-shift approach and run Microsoft SQL database service on Amazon Elastic Compute Cloud (Amazon EC2). The reason could be this is what they are most familiar with. In this post, I share the architecture options to modernize ... Read More

Feed: Microsoft Azure Blog. Author: Peter Carlin. The global events of the last couple of years have introduced significant changes to how companies operate and the way we work, accelerating digital transformation for many as they seek the additional flexibility, scale, and cost savings of the cloud. More companies are choosing Azure SQL for their SQL Server workloads and it’s easy to see why. Azure SQL provides a full range of deployment options ranging from edge to cloud and a consistent unified experience that makes the most of your on-premises skills and experience. It’s very cost-effective, too, when you use ... Read More

Feed: Recent Announcements. AWS Launch Wizard announces support for SQL Server Always On Failover Cluster Instances (FCI) with Amazon FSx for NetApp ONTAP. Now you can use a simple console wizard to deploy SQL Server FCI on Amazon EC2 with FSx for NetApp ONTAP as the shared storage. This feature will save you time and effort replacing a complex manual deployment process with a simple to use, guided wizard that accelerates the migration of your on-premises SQL Server workloads that rely on shared storage. AWS Launch Wizard enables you to easily size, configure, and deploy SQL Server workloads on EC2 ... Read More

Feed: Microsoft SQL Server Blog. Author: Peter Carlin. Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this release. SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability. It is part of the Microsoft Intelligent Data Platform, which unifies operational databases, analytics, and data governance.   SQL Server 2022 integrates with Azure Synapse Link and Microsoft Purview to enable customers to drive deeper insights, predictions, and governance from their data at ... Read More