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: 

DataCAT

  • 254 Blog Articles
Options
10.8K

SQL Server Backup to URL – a cheat sheet

Dimitri_Furman on Feb 15 2019 02:15 PM
A quick reference for using Backup to URL in SQL Server and in Azure SQL Database Managed Instance
1,924

SQLCAT at PASS Summit 2018

Dimitri_Furman on Dec 20 2018 12:29 PM
First published on MSDN on Nov 05, 2018 This week in Seattle, PASS Summit 2018 will be happening for the twentieth time.
12.4K

Real-time performance monitoring for Azure SQL Database Managed Instance

Denzil Ribeiro on Dec 20 2018 12:29 PM
First published on MSDN on Sep 26, 2018 This article was co-authored by Dimitri Furman and Denzil RibeiroReviewed by: Da...
19.7K

Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)

Dimitri_Furman on Dec 20 2018 12:27 PM
First published on MSDN on Jul 20, 2018 Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh S...
1,355

DataCAT team at Data Platform Summit 2018

Arvind Shyamsundar on Dec 20 2018 12:27 PM
First published on MSDN on Jul 16, 2018 Team members from Microsoft AzureCAT (a.
10.4K

Turbo boost data loads from Spark using SQL Spark connector

Denzil Ribeiro on Dec 20 2018 12:27 PM
First published on MSDN on May 12, 2018 Reviewed by: Dimitri Furman, Xiaochen WuApache Spark is a distributed processing...
9,528

CPU and Memory Allocation on Azure SQL Database Managed Instance

Dimitri_Furman on Dec 20 2018 12:25 PM
First published on MSDN on May 04, 2018 Reviewed By: Ajay Kalhan, Borko Novakovic, Drazen Sumic, Branislav UzelacIn the ...
3,582

Azure SQL DB Managed Instance - sp_readmierrorlog

Dimitri_Furman on Dec 20 2018 12:25 PM
First published on MSDN on May 04, 2018 Reviewed by: Kun Cheng, Borko Novakovic, Arvind Shyamsundar, Mike WeinerAzure SQ...
3,136

SQL Server VLDB in Azure: DBA Tasks Made Simple

Dimitri_Furman on Dec 20 2018 12:24 PM
First published on MSDN on Jan 22, 2018 Reviewed by: Rajesh Setlem, Mike Weiner, Xiaochen WuWith thanks to Joey D’Antoni...
1,614

Recent Updates to setting up SQL Server Availability Groups in Azure VM with AAD Domain Services

DataCAT team on Dec 20 2018 12:24 PM
First published on MSDN on Oct 30, 2017 Authored by Rajesh SetlemReviewed by: Dimitri Furman, Kun ChengThis blog is an e...
1,180

SQLCAT @PASS Summit 2017

Kun Cheng on Dec 20 2018 12:24 PM
First published on MSDN on Oct 30, 2017 Authored by Kun ChengAre you coming to the PASS Summit 2017 in Seattle? SQLCAT w...
3,138

Top Questions from New Users of Azure SQL Database

Dimitri_Furman on Dec 20 2018 12:24 PM
First published on MSDN on Oct 23, 2017 Reviewed by: Kun Cheng, John Hoang, Denzil Ribeiro, Rajesh SetlemOver the years,...
2,562

Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems

Arvind Shyamsundar on Dec 20 2018 12:23 PM
First published on MSDN on Oct 19, 2017 Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu ...
2,274

Performance implications of using multi-Statement TVFs with optional parameters

Arvind Shyamsundar on Dec 20 2018 12:22 PM
First published on MSDN on Oct 16, 2017 Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu ...
2,401

Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses

Kun Cheng on Dec 20 2018 12:22 PM
First published on MSDN on Oct 06, 2017 Authored by Kun ChengReviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajes...
1,871

Unattended install and configuration for SQL Server 2017 on Linux

Denzil Ribeiro on Dec 20 2018 12:22 PM
First published on MSDN on Oct 03, 2017 SQL 2017 bits are generally available to customers today.
2,444

Enterprise Data Pipelines using Azure PaaS Services – An Introduction

DataCAT team on Dec 20 2018 12:21 PM
First published on MSDN on Sep 19, 2017 Authored by Rangarajan SrirangamAuthors: Rangarajan Srirangam, Mandar Inamdar, J...
1,429

Instant Log Initialization for SQL Server in Azure

Dimitri_Furman on Dec 20 2018 12:21 PM
First published on MSDN on Sep 11, 2017 Reviewed by: John Hoang, Denzil Ribeiro, Rajesh Setlem, Mike WeinerIntroductionI...
3,358

Common ISV application patterns using Azure SQL Data Warehouse

DataCAT team on Dec 20 2018 12:20 PM
First published on MSDN on Sep 05, 2017 Authored by John HoangAuthor: John HoangTechnical Reviewers: Dimitri Furman, Mur...
2,322

Collecting performance data with PSSDIAG for SQL Server on Linux

Denzil Ribeiro on Dec 20 2018 12:20 PM
First published on MSDN on Aug 11, 2017 Reviewed by: Suresh Kandoth,Rajesh Setlem, Steven Schneider, Mike Weiner, Dimitr...
2,926

How the SQLCAT Customer Lab is Monitoring SQL on Linux

DataCAT team on Dec 20 2018 12:19 PM
First published on MSDN on Jul 03, 2017 Authored by Steven SchneiderReviewed By: Denzil Ribeiro, Dimitri Furman, Mike We...
2,168

Performance impact of memory grants on data loads into Columnstore tables

Denzil Ribeiro on Dec 20 2018 12:18 PM
First published on MSDN on Jun 02, 2017 Reviewed by: Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun...
11.9K

Azure SQL Data Warehouse loading patterns and strategies

DataCAT team on Dec 20 2018 12:18 PM
First published on MSDN on May 17, 2017 Authored by John HoangAuthors: John Hoang, Joe Sack and Martin Lee Abstract This...
2,166

Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB

Arvind Shyamsundar on Dec 20 2018 12:17 PM
First published on MSDN on Apr 21, 2017 Authored by Arvind Shyamsundar and Shreya Verma Reviewed by Dimitri Furman, Joe ...
1,280

Try and try again: not always a good idea (at least not for SSMS!)

Arvind Shyamsundar on Dec 20 2018 12:16 PM
First published on MSDN on Apr 06, 2017 Contributions from, and reviewed by: Ken Van Hyning, David Shiflet, Charles Gagn...
1,206

SQLCAT at SQLBits 2017

Dimitri_Furman on Dec 20 2018 12:15 PM
First published on MSDN on Mar 30, 2017 The widely popular SQLBits conference will take place April 5-8 2017 in Telford,...
5,673

Backing up a VLDB to Azure Blob Storage

Dimitri_Furman on Dec 20 2018 12:15 PM
First published on MSDN on Mar 10, 2017 Reviewed by: Pat Schaefer, Rajesh Setlem, Xiaochen Wu, Murshed ZamanAll SQL Serv...
2,034

SQL Server Availability Groups in Azure VM setup with AAD Domain Services

DataCAT team on Dec 20 2018 12:15 PM
First published on MSDN on Feb 23, 2017 Authored by Rajesh SetlemReviewed by: Steven Schneider, Sanjay Mishra, Mike Wein...
2,033

Migration from SQL Server to Azure SQL Database Using Transactional Replication

Dimitri_Furman on Dec 20 2018 12:13 PM
First published on MSDN on Feb 03, 2017 Written by: Josh Gnanayutham, Program Manager, SQL EngineeringIntroductionAs use...
1,232

How to Check Database Availability from the Application Tier

Dimitri_Furman on Dec 20 2018 12:13 PM
First published on MSDN on Jan 29, 2017 Reviewed by: Mike Weiner, Murshed ZamanA fundamental part of ensuring applicatio...

Latest Comments

Dimitri_Furman
in SQL Server Backup to URL – a cheat sheet on Sep 24 2021 08:18 AM
@Keith Culpepper , here's the article describing storage access keys: https://docs.microsoft.com/en-us/azure/storage/common/storage-account-keys-manage. Also see the second example here for how to create the credential with a storage access key: https://docs.microsoft.com/en-us/sql/relational-databa...
1 Likes
Keith Culpepper
in SQL Server Backup to URL – a cheat sheet on Sep 24 2021 05:36 AM
You mention that for 2012, the "Credential holds storage account key". Is there any documentation on how to get this to work for 2012? I'm not sure which one is the storage account key and I'm not sure if I'm calling the "WITH CREDENTIAL" properly and would like to see some documentation if anyone h...
0 Likes
Nilavalagan
in Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database on Mar 30 2021 03:41 AM
We are using this pattern in our scenarios and seeing latency issues with bulk copy as the concurrency goes up. When checked further on query store, we see the execution is waiting for memory grants.
0 Likes
Dimitri_Furman
in Backing up a VLDB to Azure Blob Storage on Jul 24 2020 07:32 AM
Hi @TheoEkelmans - you are using the older Backup to URL version that backs up to page blobs and does not allow more than one backup file. In recent versions of SQL Server, you should back up to block blobs. See https://techcommunity.microsoft.com/t5/datacat/sql-server-backup-to-url-a-cheat-sheet/ba...
0 Likes
TheoEkelmans
in Backing up a VLDB to Azure Blob Storage on Jul 23 2020 11:26 PM
Hi @Dimitri_Furman Good article ! But.... :) I'm trying to backup a large database on DB a SQL 2019(CU5) server on an L32s_v2 VM using this command:BACKUP DATABASE SqlManagement TOURL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part01.bak',URL = 'https://i...
0 Likes