A Fine Slice Of SQL Server
Jeet Kainth wants an Execute SQL Task:
If you’re new to ADF or Synapse pipelines and looking for a way to execute SQL commands in pipelines, unfortunately there is no equivalent to the Execute SQL Task in SSIS, but I have found some alternatives which work well for me.
Click through for those alternatives.
Comments closedVinod Kurpad shares some news:
Form Recognizer continues to improve product capabilities with improved models, support for additional document types and containerized solutions that run in the cloud or on premises either connected or fully disconnected for scenarios where containers need to run in an isolated environment. Recent updates to pricing include commitment tiers for customers who have a predictable volume of documents. Starting February 15th, the pricing for Invoices and General Document API will drop to $10 per 1000 pages, an 80% reduction, making it possible for customers to use invoices and the general document APIs for high volume scenarios to significantly lower cost while providing additional value.
That’s a pretty big improvement.
Comments closedAnthony Nocentino has the need for speed. And authentication:
At work, I get to work with some fantastic tech that pushes the boundaries of performance. I needed to do some performance testing from a Windows server into a FlashBlade using s3. I reached out to a colleague of mine, Joshua Robinson, who told me about s5cmd.
s5cmdis a very fast, parallel s3 compatible command-line client.Check out Joshua’s post for some performance numbers. Here’s a direct quote from his post.
But it doesn’t matter how fast it is if you can’t connect, so Anthony shows us how to do just that.
Comments closedMeagan Longoria solves a problem:
We chose release pipelines over the YAML pipelines because it was easier to manage for the client and pretty quick to set up. While I had done this before, I had a couple of new challenges:
– I was deploying to an Azure SQL managed instance that had no public endpoint.
– There were multiple databases for which there may or may not be a change script to execute in each release.
This took a bit longer than I expected, and I enlisted my coworker Bill to help me work through the final details.
Read on to see how Meagan and Bill solved the problem.
Comments closedBen Brauer has some reference guidelines:
The AlwaysOn project strives to address the challenges of building mission-critical applications by providing organizations with a prescriptive architectural approach for the Microsoft Cloud.
It leverages lessons from numerous customer applications and first-party solutions, and applies Well-Architected best practices to provide actionable and authoritative guidance for building and operating a highly reliable solutions on Azure at-scale.
I guess marketing is calling it “AlwaysOn” again. Until they call it Always On. Or AlWaYsOn.
Comments closedAbhishek Shaha and Ahmed Mahmoud enumerate techniques to export an Azure SQL Database:
Export Azure SQL Database is a common request for Azure SQL DB customers, in this article we are going to list down some advanced scenarios, on how this can be achievable through various tools not limited to Azure Portal, Azure CLI and PowerShell. In addition, this article will provide alternative methods when it comes to private endpoints and deny public access.
Click through for several options.
Comments closedEric Rouach continues a series on Azure Data Factory:
The following will guide you into building your first Azure Data Factory pipeline.
Pre-requisite: completing Part 1 of this guide
https://www.madeiradata.com/post/get-started-with-azure-data-factory
From the Azure portal, select (click) your ADF and open you Azure Data Factory Studio:
Click through for a screenshot-heavy demo.
Comments closedBen Brauer takes us through the next step:
Congratulations! You’ve finished your Well-Architected Review of a workload, giving you a better understanding of where it could be fortified along the five pillars: Security, Reliability, Operational Excellence, Performance Efficiency and Cost Optimization. You have received Microsoft’s best practices as recommendations based on your answers to questions specific to each pillar.
The report (example below) shows a Well-Architected score for each pillar, as well as prioritized recommendations that allows for you to focus on biggest areas of impact. A great example is virtual machine right sizing. You can significantly lower your costs if you know which VM is best suited for your workload type.
By the way, if you have Azure resources, I highly recommend checking out the Well-Architected Framework assessment link there. It can take a very long time to go through because of just how many questions there are; that said, the results are also pretty specific and can be immediately helpful.
Comments closedJoey D’Antoni is not impressed:
While some services include other really useful features (for example the query data collected by the Azure SQL Database and Managed Instance platforms), I wanted to focus on the common value adds to PaaS systems across providers. I made the last two of these bold, because I feel like they are are the most important, especially in scenarios where the vendor doesn’t own the source to the applications. Like Amazon RDS for SQL Server.
Click through for Joey’s thoughts on the topic.
Comments closedAndy Leonard builds out an Azure Integration Runtime:
Many Azure Data Factory developers recommend creating an Azure Integration Runtime for use with Mapping Data Flows. Why? One reason is you cannot configure all the options in the default AutoResolveIntegrationRuntime supplied when an Azure Data Factory instance is provisioned.
At the time of this writing, it’s not obvious how one creates an Azure Integration Runtime. You would think creating an integration runtime would begin with:
It turns out to be a little trickier than you might first expect.
Comments closed