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 […]
Azure SQL Database
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 […]
Register today—Free Azure Data training at Data Platform Summit 2022
Data Platform Virtual Summit 2022 (DPS 2022) is just a few weeks away, running from September 1923. A […]