Implementing Vector Datatype with Azure SQL Server
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates […]
Azure SQL Database
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads […]
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for […]
Creating a Hyperscale Database in Azure Using the Azure Portal
Data is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these […]
The SQL Developer Experience: Beyond RDBMS
SQL Server has always empowered developers through a wide variety of drivers, the robust T-SQL language, and an […]
Quickstart: Connect SQL Server machines to Azure Arc
The post Quickstart: Connect SQL Server machines to Azure Arc appeared first on SQLServerCentral.
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance […]
Creating an Azure SQL Database Using Azure Cloud Shell
Introduction Azure Cloud Shell is a browser-based tool that allows the creation, configuration, and management of Azure resources […]
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Data Lineage is a process of understanding data’s lifecycle, from origin to destination. It tracks where data originates, […]
SQL Ledger: Protecting Data in Azure SQL
Here in Malta, there are many I-Gaming companies. The I-Gaming business creates an important movement for the Maltese […]