A Fine Slice Of SQL Server
I’ve used the Ola Hallengren Maintenance Solution across various SQL Server environments . I was recently asked by a colleague about how adaptable they are to the AWS RDS SQL Server environment.
I checked the Ola Hallengren FAQ and there is a comment :
Read on to learn the details.
Comments closedI have been working with a customer where I have got data in AAS and in PPU for the same dataset.
What I have found is that when the data is loading it is very similar in terms of how long the data takes to load.
With one of my customers as an example the data was being curated in Asia, whilst the business was running things from Australia. By hosting AAS/PPU where the data was curated meant that the data loading was significantly faster. Yes while the reports would have to access the data across the ocean, this only sends the results, so the performance of the reports was and is still blazingly fast!
Click through for the full story.
Comments closedAs requests to execute Azure Functions increase, then the demand for such compute resources is supported, but only while it is needed (scale-out). As requests fall, any extra resources and application instances drop off automatically (scale-in).
Recently Microsoft enabled a new Drain mode in Azure Functions, that allows for a graceful shutdown of the Azure Function host by completing inflight invocations and stops listening for new events from triggering sources.
Read on for the set of steps it performs, as well as the benefit it provides.
Comments closedWolfgang Strasser points out a new feature with Azure Synapse Analytics:
Let’s call it by accident, that I found out that Azure Synapse Analytics now let’s you to link more than just one Power BI workspace.. There is an entry in the Release notes/Update menu that lists this option.
Read on to see what this means for you.
Comments closedMichael Bourgon needs to get some data out of S3:
I was running into issues with the Linked Server lopping off long JSON that I’m having to pull out from the raw files. I can’t explain it – doesn’t appear to be SSMS. See previous post
But I needed to automate this, rather than use SQL Workbench, save to “Excel” (it was XML), then opening it again and saving it so that instead of 250mb, it’s 30mb. Runs against the previous month, one day at a time (walking the partitions), and then saves to a file. You got your Athena, your ODBC, your Export-Excel…
Incidentally, that previous post was around trying to use a linked server to pull the data in via SQL Server.
Comments closedMarc Lelijveld shows how you can combine Power BI deployment pipelines with Azure DevOps:
Looking at the Power BI release plan, dataflow support for Deployment Pipelines is coming up shortly! Currently it is scheduled for June 2021 to reach the public preview state. Versioning and DevOps integration go hand-in-hand to our opinion. With Azure DevOps Git integration, we can overcome the versioning challenge while integrating with Azure DevOps at the same time, as described in the previous blog in 2019. Today, we release a new version of the DevOps implementation which uses native Power BI functionality. Stay tuned!
As we really like the metadata deployment and the ease of setup a pipeline in the Power BI Service, Ton and I decided to setup an Azure DevOps extension based on the recently released Power BI REST APIs for Deployment Pipelines. Although Microsoft promised to come-up with a native DevOps extension over time, we decided to go for it. Time to bridge the gap!
Read on for more details.
Comments closedMax Trinidad shows off a couple of products:
For more information click on Azure Dashboard. You can create up to 100 ‘Private’ dashboards per user.
The next tool has recently got some attention: AzViz PowerShell module. This is module has the ability to generate a visual representation of your Azure Resources.
Read on to see both tools in action.
Comments closedIn reality, you can create a dacpac for a database that’s inside an Azure Synapse Analytics dedicated SQL Pool using a lot of the methods that you use to create them for SQL Server databases.
Azure Data Studio can be an appealing alternative SQL Server Data Tools (SSDT) for tasks like this. Due to various reasons. For instance, it’s a multi-platform solution that is easy to install.
With this in mind, I decided in this post to cover how to create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure Data Studio.
Click through to see how.
Comments closedIf you missed the first part of the series here is the link here: Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User – Reporting/Analytics Made easy with FourMoo and Power BI
In this blog post I am going to investigate how well does PPU scale when comparing it to AAS.
When comparing AAS to PPU, I must find the same size AAS size to what we get with PPU.
Read on for Gibert’s findings.
Comments closedSteve Hughes hits on one of the tricky administrative bits of Azure Synapse Analytics:
So you can copy Azure SQL Database using the Azure Portal, PowerShell, Azure CLI, and T-SQL. However, this functionality is limited to Azure SQL Database and does not work for Azure Synapse databases (a.k.a. SQL Pools). Early in 2021, the ability to use the copy functionality to copy databases between subscriptions is also supported but requires security work to make sure the permissions in the database servers and networking allow that to happen.
There’s a lot involved in the process, leaving me to provide the sage wisdom that it’s easier not to put it in the wrong subscription to begin with if you can avoid it.
Comments closed