InfoQ Homepage SQL Server Content on InfoQ
-
Microsoft Claims SQL Server Performs Better on Azure Than AWS
In a recent benchmark, Microsoft claims that SQL Server on Azure Virtual Machines can be up to 57% faster and cost up to 54% less than running a similar workload on AWS EC2.
-
GCP Adds Simplified Operator for Connecting Google Kubernetes Engine to Cloud SQL
Google Cloud has released a public preview of Cloud SQL Proxy Operator. The operator simplifies the process of connecting an application running in Google Kubernetes Engine with a database deployed in Cloud SQL.
-
Entity Framework 7 Brings Bulk Operations and JSON Columns
Version 7 of Entity Framework (EF) Core, Microsoft's object-to-database mapper library for .NET Framework, was released in November. The updated version brings performance updates when saving data, allows JSON column operations, enables efficient bulk operations, and contains many minor fixes and improvements. The EF7 Core is available for both .NET 7 and .NET 6.
-
A New Microsoft Platform in Town: the Microsoft Intelligent Data Platform
Recently Microsoft introduced a new platform called the Microsoft Intelligent Data Platform that fully integrates their database, analytics, and governance offerings. The new platform encompasses everything already available in the Azure Data space (Azure Data Factory, Azure Data Explorer, etc.) to the Synapse Analytics products, Power BI, and the newly rebranded Purview data governance service.
-
Improve Access Control of Google Cloud SQL with IAM Conditions and Tags
Recently, Google announced the general availability (GA) of IAM Conditions and Tags for Cloud SQL, a fully-managed relational database service for MySQL, PostgreSQL, and SQL Server.
-
Amazon RDS Custom for SQL Server Is Now Generally Available
Amazon announced the general availability of Amazon RDS Custom for SQL Server. The new service supports legacy, custom, and packaged applications that have dependencies on specific configurations and third-party tools and have historically been unable to move to a fully-managed database.
-
Microsoft Announces the General Availability of Azure Arc-Enabled SQL
Recently Microsoft announced the general availability as per the end of July of Azure Arc-enabled SQL, which extends the Azure SQL instances to be hosted on an edge data center or in a multi-cloud environment. An Azure Arc enabled SQL Managed Instance has near 100% compatibility with the latest SQL Server database engine.
-
Microsoft Announces Azure Monitor SQL Insights for Azure SQL in Public Preview
Recently Microsoft announced Azure Monitor SQL Insights for Azure SQL in public preview. With the preview, customers will get a flexible canvas for telemetry collection, analysis, and rich custom visualization.
-
PASS to Cease Operations on January 15
PASS, formerly known as the Professional Association for SQL Server, will cease operations on January 15. The non-profit organization, which was known primarily for its conferences, is unable to meet its financial obligations.
-
AWS Announces New Database Service Babelfish for Aurora PostgreSQL in Preview
During the AWS re:Invent keynote, AWS announced the new database service Babelfish for Aurora PostgreSQL in Preview. The service is a fully-managed, PostgreSQL-compatible and ACID-compliant relational database engine that runs in the Amazon cloud and is open-source.
-
Google Releases Enterprise Database Options, Targets SQL Server Customers
In a recent blog post, Google announced enhancements to their existing Google Cloud Platform (GCP) database investments, including Cloud SQL for Microsoft SQL Server in alpha, Federated queries from BigQuery to Cloud SQL and Elastic Cloud on GCP being available in Japan and soon to be released in Sydney, Australia.
-
Enabling Single Tenant Workloads in the Cloud, Microsoft Introduces Azure Dedicated Host
In a recent blog post, Microsoft announced Azure Dedicated Hosts, a service that allows organizations to run Linux and Windows virtual machines on single-tenant physical servers. This service was introduced to address customer compliance and regulatory requirements. Organizations can also take advantage of Azure Hybrid Benefits which allows them to leverage existing software investments.
-
SQL Server and .NET Core 3.0
In our last article we looked at System.Data in .NET Core 3.0. Now we turn our attention to System.Data.SqlClient, which is the SQL Server driver.
-
SQL Server 2019 Fixes Function Inlining Bug
Like most databases created in the last couple of decades, SQL Server allows developers to extend the database by creating functions. But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with problems that caused them to run over a thousand times slower.
-
Microsoft Previews Cross Platform Tool for Working with SQL Server
Microsoft has released a public preview of SQL Operations Studio, a cross platform tool for working with SQL Server. This product is based on the existing Visual Studio Code editor and uses the SQL Tools API service under the hood.