A Fine Slice Of SQL Server
Sheldon Hull has a hoarding problem to solve:
In my case, I’ve run into 50TB of old backups due to tooling issues that prevented cleanup from being successful. The backup tooling stored a sqlite database in one subdirectory and in another directory the actual backups.
I preferred at this point to only perform the lifecycle cleanup on the backup files, while leaving the sqlite file alone.
Click through to see how to do this using Powershell.
Comments closedAs Synapse engineer or Synapse Support Engineer you may need to start and test some Pools, and you want this to be the most cost efficient possible. Leaving some Synapse with a lot of DWU left turned on during the weekend because you forget to pause the DW after you shutdown your computers is not a good approach and we can quickly resolve this by using Powershell + Automation accounts.
This is also a good introduction to Azure Automation if you aren’t familiar with it.
Comments closedMikey Bronowski continues a series on generating Excel documents with Powershell:
Last week I have mentioned the new functions waiting to be included into the module. This week I would like to write about another set of functions:
– Add-ExcelHyperlink
– Get-ExcelHyperlink
– Remove-ExcelHyperlinkThose are fresh too and were inspired by a query I have got from Garry Bargsley (blog|twitter) who needed adding hyperlinks to the existing cells without using HYPERLINK() Excel function.
Read on to see how.
Comments closedJeffrey Hicks gives us an update on the Powershell landscape:
The PowerShell community is beginning another year in the world of PowerShell 7. Most of you know what that means. However, there are newcomers to our community practically every day. Or I know there are occasional or reluctant users who might not pay enough attention to understand the world of PowerShell as it stands today. I wrote this post as a kind of virtual sticky note for the PowerShell community. Feel free to reference this post in your own work so that you don’t have to explain or define “Windows PowerShell” and “PowerShell”.
Click through to learn how to differentiate the two.
Comments closedMarc Lelijveld wants to pull some metrics:
In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow owner. For example, you may bump into refresh time-outs or unfortunate errors. There are many good reasons to think about why you want to have more insights in your refresh metrics.
Having that said, it can be a pain to look at these metrics every day. Power BI already offers a way to send automatic notification in case of a refresh failure. Though, I would personally prefer to have more insights in all my refresh metrics, whether they are failing or succeeding.
In this blog I want to share a way how you can export all refresh metrics for your datasets and dataflows using a PowerShell script.
Click through to see how and to get a copy of the script.
Comments closedEric Cobb takes a look at some nice functionality in dbatools:
There may be times that you want to ensure certain settings are applied to a database, or multiple databases. For example, if you restore a Production database to a QA environment, you may need to change the Recovery Model. Or if you’re migrating databases to a new SQL Server version you want to make sure to update the Compatibility Level. With dbatools this is really, really easy. Here are some examples:
Read on for examples around setting the database owner, changing the compatibility level, and setting the recovery model.
Comments closedShane O’Neill implements a linear backoff strategy:
Pushups are hard! Even when I’m not trying to rep out as many as I can, they still take a toll on the body. Soon a five-minute break is not enough, and I’m taking longer and longer rests.
Fine, if that’s the way we’re going to do this, then I’m going to go with the flow.
I can confirm that pushups are hard. Also, click through for a link to the backoff script.
Comments closedJess Pomfret shares a few Powershell tips:
My goal was to gain more stars than last year, which I succeeded at. I only got 6 total stars last year. Now my goal for next year will be to beat this year’s performance. I did learn several neat things while working on these puzzles and those I thought were worth sharing.
Read on for those things.
Comments closedMikey Bronowski wants things to look just right:
Conditional formatting is important, however by default we change the look of the cells that have specific values. What about changing the entire row if a specific cell meets certain conditions?
Read on to see how.
Comments closedMikey Bronowski has a festive post:
This blog post is part of the Festive Tech Calendar.
If you want to practice the whole thing I have prepared an interactive notebook for you that could be opened with Azure Data Studio for example (link to the notebook). For more things about the PowerShell module check this post out.
I would like to invite you to the world of magic!
Click through for an image-rich and extremely detailed post.
Comments closed