cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure SQL

  • 398 Blog Articles
Options
384

How to Use Citus to Shard Postgres, for Performance and Scale | Data Exposed

MarisaBrasile on Sep 16 2021 09:00 AM
Learn how to scale out Posgres with Citus, this week on Data Exposed.
1,803

Azure SQL Managed Instance – Terraform command available

UrosMilanovic on Sep 14 2021 07:04 AM
Command for Azure SQL Managed Instance deployment is officially available in Terraform registry under Azure provider
1,025

How-to determine the SQL MI Failover Group & HA Replicas Details

NikoNeugebauer on Sep 14 2021 01:12 AM
Discover a way to determine the details for SQL MI Failover Groups and High Availability Replicas, such as the type of t...
2,087

How-to determine the SQL MI Failover Group configuration

NikoNeugebauer on Sep 12 2021 12:22 PM
Discover an easy way to determine with the help of T-SQL with the SQL MI if it is connected to the Failover Group and wh...
1,338

Data Platform Summit 2021 is a few days away!

MarisaBrasile on Sep 09 2021 12:52 PM
Plan which sessions you'll be attending at DPS with our quick reference guide.
854

Using Query Store Hints to Optimize Memory Grants Improving Performance | Data Exposed

MarisaBrasile on Sep 09 2021 10:42 AM
Learn how to improve the performance of bulk loading data using query store hints
2,180

Scalar UDF Inlining now available on Azure SQL

Pooja_Kamath on Sep 07 2021 07:29 AM
TSQL Scalar UDF Inlining is now available for Azure SQL Managed Instance and Azure SQL DatabaseThis feature is a part of...
3,239

Server roles for Azure SQL Database: Database Management without admin-access

AndreasWolter on Sep 02 2021 04:31 PM
Announcing Server roles for Azure SQL Database: Database Management without admin-access
906

Azure SQL VM: Using PerfInsights to Evaluate Resource Health and Troubleshoot (Ep. 5) | Data Exposed

MarisaBrasile on Sep 02 2021 09:29 AM
Learn how to evaluate the health of your Azure SQL Virtual Machines with PerfInsights.
1,188

Azure SQL News Update: September 2021

Anna Hoffman on Sep 01 2021 09:00 AM
Read about the latest Azure SQL news or catch the live episode! We’ve included an iCal file, so you can add a reminder t...
4,390

Announcing Azure SQL Migration extension for Azure Data Studio - public preview

Mohamed Kabiruddin on Sep 01 2021 08:06 AM
Use the Azure SQL Migration extension for Azure Data Studio to migrate to either Azure SQL Managed Instance (Platform-as...
1,376

Azure SQL MI now removes virtual cluster as part of the delete flow

UrosMilanovic on Aug 31 2021 11:00 PM
Virtual cluster and other dependent components are removed with last instance deletion in the subnet.
1,596

Improved columnstore data loading using Query Store hints

Denzil Ribeiro on Aug 31 2021 01:44 PM
With query store hints, DBAs and engineers can use hints to affect performance without changing the source application o...
740

Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio | Data Exposed: MVP Edition

MarisaBrasile on Aug 31 2021 08:58 AM
Learn how to create, maintain, and manage SQL Server Agent jobs using Notebook Jobs.
1,650

Azure SQL Managed Instance – introduction to #SQLMIOPS

UrosMilanovic on Aug 26 2021 09:00 AM
A series of article dedicated to #sqlmiops – an area that will consolidate all aspects of instance management.
724

Migrating to SQL: New Conversion Reports in SSMA (Ep. 7) | Data Exposed

MarisaBrasile on Aug 26 2021 09:00 AM
Learn about all the new benefits of conversion reports in SQL Server Migration Assistant (SSMA).
1,667

How-to determine the timestamp of the last SQL MI failover

NikoNeugebauer on Aug 20 2021 11:33 AM
Discover when the last failover of the Azure SQL Managed Instance took place and you will be able to explain why the per...
1,141

Azure SQL VM: Get the best price-performance for your SQL Server workloads on Azure VM (Ep. 4)

MarisaBrasile on Aug 19 2021 08:53 AM
Learn what VM sizes to choose from when migrating SQL Server workloads to Azure VM.
1,400

Learn how Azure SQL works with Azure Purview on at the Azure Data Governance event on September 28

MarisaBrasile on Aug 17 2021 09:00 AM
Achieve unified data governance with Azure Purview
4,896

SQL Managed Instance How-tos series

NikoNeugebauer on Aug 13 2021 02:43 AM
We started a series on simple & extremely useful how-tos, and this blog post serves as a principal source of accumulatio...
1,062

Azure SQL VM: Use Azure Monitor Metrics to Track VM Cache Health (Ep. 3) | Data Exposed

MarisaBrasile on Aug 12 2021 09:00 AM
Learn how to keep your Azure VMs healthy and monitored in part three of this seven-part Azure SQL VM series.
1,703

How-to find out reserved and available Disk Space on SQL MI

NikoNeugebauer on Aug 11 2021 09:07 AM
Discover how-to find out the total reserved and available space on Azure SQL Managed Instance with the help of T-SQL. Un...
3,830

Azure SQL News Update: August 2021

Anna Hoffman on Aug 11 2021 09:03 AM
Read about the latest Azure SQL news or catch the live episode! We’ve included an iCal file, so you can add a reminder t...
1,487

Azure SQL VM: Automate Management with the SQL Server IaaS Agent extension (Ep. 2) | Data Exposed

MarisaBrasile on Aug 05 2021 09:00 AM
Learn how to manage your Azure SQL virtual machine with the SQL Server IaaS Agent extension.
1,882

Configuring backup storage redundancy in Azure SQL Hyperscale

Sourabh Agarwal on Aug 04 2021 08:00 AM
Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect y...
2,013

Database copy for Azure SQL Hyperscale now generally available!

Denzil Ribeiro on Aug 04 2021 08:00 AM
Database copy provides a way to create a transactionally consistent snapshot of the source database as a new database on...
2,004

How-to find out the SQL MI total amount of RAM

NikoNeugebauer on Aug 02 2021 03:23 AM
Discover scripts for consulting the total and total available amounts of RAM in Azure SQL Managed Instance with the help...
3,618

Use external table on Azure SQL Managed Instance to read data from Azure SQL Database

Danimir Ljepava on Jul 31 2021 09:45 AM
This article explains how to create external tables on Azure SQL Managed Instance to read data from Azure SQL Database. ...
1,362

Azure SQL VM: Caching and Storage Capping (Ep. 1) | Data Exposed

MarisaBrasile on Jul 29 2021 06:45 AM
Kick-off part one of this eight-part Azure SQL Virtual Machine (VM) series with caching and storage capping tips.

Latest Comments

walonsor
in Introducing Change Data Capture for Azure SQL Databases (Public Preview) on Sep 15 2021 12:38 PM
Hi @MaraSteiu, Is this feature (CDC) delivered for all regions? for example China? or should I consider the location of my SQL Database?
0 Likes
Danimir Ljepava
in Use external table on Azure SQL Managed Instance to read data from Azure SQL Database on Sep 15 2021 08:53 AM
Yes, this was included in the closing remarks. It is also possible also to have an External table on Azure SQL Database and query Managed Instance. See this article: https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-129-using-data-source-external-from-azure-sql/ba-p/1...
0 Likes
UrosMilanovic
in Azure SQL Managed Instance – introduction to #SQLMIOPS on Sep 14 2021 07:15 AM
Hi @deivasigamani-duraisamy Unfortunately it is not possible to subscribe to tags. Subscribing to Azure SQL Managed Instance label seems as the closest solution.
1 Likes
DaleGreenaway
in PowerShell cmdlets for managing SQL Vulnerability Assessments on Sep 13 2021 02:29 AM
Hi,We are having the same issue where the results in the GUI after running the vulnerability scan are not matching the results when we run the following Powershell cmd 'Invoke-SqlVulnerabilityAssessmentScan' against the database. Is there something we are missing here? As an example the GUI produces...
0 Likes
AndreasWolter
in Server roles for Azure SQL Database: Database Management without admin-access on Sep 10 2021 03:09 PM
Hi @Foresight200102 absolutely. I agree this is the ideal scenario.The goal is to support AAD principals as well. But since these are server-level roles we first need Server scoped AAD Logins to be available first. So we do have plans for sure, but I can't give a date here.Thanks Andreas
0 Likes
www.000webhost.com