(Pinal Dave) Here are my previous blogs about Backup to URL, I have share scripts to take backup using Access Keys and SAS Token. One of my blog readers wanted to take stripped backup to Azure Blob. In this blog, I am sharing the script to perform a stripped backup using shared access signature (SAS
Tag: sql server
SQL Server – Blocking a Truncate
(blobeater) The truncate option is fast and efficient but did you know that it takes a certain lock where you could actually be blocked? What am I talking about?
Building an Azure Event Grid app. Part 2: Adding a Logic App subscriber to the Event Grid Topic.
(gdavi) I want to have something that subscribes to the Event Grid Topic, and when a new event is published takes action depending on the details of the event. In my scenario, I want to pay attention to and take action on alarm events with a status of red.
How to use the TREATAS function in DAX
(Koen Verbeeck) The DAX query language – used in Analysis Services Tabular, Power Pivot and Power BI – contains some powerful functions. One of these functions is the relatively new TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where th
Get started with Python on SQL Server – Run Python with T-SQL on SSMS
(Manoj) With SQL Server 2016 Microsoft added Machine Learning support with R Language in SQL engine itself and called it SQL Server R Services.
How to attach databases to custom SQL Server containers
(Michael Otey) Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach your databases to them.
Azure SQL Database Business Continuity Enhancements
(Marcin Policht) In one of our earlier articles published on this forum, we have presented a range of capabilities that enhance business continuity of Azure SQL Database deployments. That article is, at this point, over a year old, which constitutes a rather long time when you consider the rapid rat
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
(Pinal Dave) As I mentioned in my earlier blog, backup to URL is one of the common methods used in SQL Server performs a backup to Azure Blob Storage.
SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified
(Pinal Dave) In my recent project with a customer, they wanted to configure SQL backups to Azure Blob Storage. When we were trying to take a backup, we were facing error.
PsPing your Azure SQL Server
(blobeater) PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to find out latency to your Azure SQL Server.
