Practical guides and insights for modern data practitioners
In this post I share one way that you can run a Microsoft Fabric notebook from Azure DevOps. You can consider this post a follow-up to my last post about unit tests on Microsoft Fabric items. Since somebody asked me about automating notebooks and I wanted to show it in action. Please note, currently the … Read more
In this post I cover how you can utilize the DeploymentPipelines-DeployAll PowerShell script and Azure DevOps to update Microsoft Fabric Deployment Pipeline stages. By the end of this post, you will know what the changes are required to update Microsoft Fabric Deployment Pipeline stages with the DeploymentPipelines-DeployAll PowerShell script and the classic pipelines in Azure … Read more
In this post I want to cover how you can store dbatools PowerShell module as a package in Azure DevOps. By using the Azure Artifacts service. I want share some knowledge about this because did a demo of it at Malta Data Saturday. By the end of this post you will have a better understanding … Read more
In this post I thought I would talk about how SQL Server Professionals can benefit from using version control systems. Mostly because I have been involved in some discussions about it recently. I say SQL Server Professionals here because I want it to be all inclusive. Due to the fact this applies to database administrators … Read more
Recently I’ve seen recommendations about putting PowerShell modules on every SQL Server. I must admit it has got me thinking if this is indeed worthwhile. In addition, it makes me wonder if it’s actually better to put the Powershell modules on a select number of management servers instead? If you are wondering which modules I … Read more
My T-SQL Tuesday contribution for this month is about a PowerShell puzzle. Because this month’s T-SQL Tuesday invitation is from Matthew McGiffen. If you click on the T-SQL Tuesday logo, you can see he has invited us to do a post relating to puzzles. Indeed, I could have just discussed one of my sessions here … Read more
After some discussions the other week I thought I better talk about SQL Servers complex relationship with file permissions. As some of you probably know there have been many SQL Server related issues over the years due to file permission issues. Just the other day I was joking with somebody about the fact that the … Read more
In this post I want to cover deploying SQL Server services in Azure with Visual Studio subscription. Because somebody made a comment on Twitter previously which got me thinking. It was about the fact that they could not afford to run one of the SQL Server related services in Azure. So, I thought it’d be … Read more
In this post I want to cover the amount of PowerShell used to work with SQL Server. Because I was curious about the amount of PowerShell people currently use in the workplace. To get a good idea of how much PowerShell people use as part of their day job I ran a quick poll. Poll … Read more
After dealing with a few issues for a client and seeing a few questions on SQLHelp I thought I better do this post. Here’s my take on patching SQL Server on Windows essentials. Main points discussed in todays post are as below. Quick recap Important information about SP’s and CU’s When to apply these patches … Read more