Bob Blackburn5 Dashboards For Azure Cost OptimizationIt is always a good idea to monitor and occasionally do a full audit of cloud costs. Recently there has been an increase in discussions…May 3, 2023May 3, 2023
Bob BlackburnCreate SQL Server Assessment Dashboard in Under an HourWe must periodically evaluate the state of our databases. Luckily for SQL Server, Microsoft provides us with a customizable assessment…Oct 10, 2022Oct 10, 2022
Bob BlackburnSQL Server Indexing: 5 Steps to Better PerformanceCustomers don’t want to wait more than a few seconds for an application to process and move to the next step. And we keep getting squeezed…Aug 11, 2022Aug 11, 2022
Bob BlackburnAdd Custom Code Snippets to Azure Data StudioIf you need an intro to Data Studio and the recent addition of notebooks for SQL, Python, Powershell and more see Azure Data Studio for…Nov 29, 2021Nov 29, 2021
Bob BlackburnUpgrade Data Factory CI/CD with YAML Pipelines and ApprovalsLast time we discussed ADF Pipelines in the classic (GUI) interface here. Moving forward it is recommended to use YAML Pipelines. I have…Aug 12, 2021Aug 12, 2021
Bob BlackburninPlumbers Of Data ScienceCreate a Databricks Load Template with Dynamic ParametersMoving to Azure and implementing Databricks and Delta Lake for managing your data pipelines is recommended by Microsoft for the Modern Data…Jun 24, 2021Jun 24, 2021
Bob BlackburninHitachi Solutions BraintrustManage Database Releases With Pre- and Post-Deployment ScriptsVisual Studio protects you and your data during deployments by making sure you do not delete data by accident. Such mishaps can be caused…Apr 27, 2021Apr 27, 2021
Bob BlackburninHitachi Solutions BraintrustManage Cross-Database Development in Visual StudioWhen streamlining our database development process, we first must get our databases under source control. Often, the code accesses other…Apr 19, 20211Apr 19, 20211
Bob BlackburninHitachi Solutions BraintrustCreate Your First Visual Studio Database ProjectDatabases should be under source control and have the ability for CI/CD just like application code. Visual Studio gives you this…Apr 12, 2021Apr 12, 2021
Bob BlackburninHitachi Solutions Braintrust3 Steps to Run PowerShell in Azure Data FactoryAzure Data Factory has many capabilities. But no tool is the best at everything. Sometimes you have an existing script that needs to be…Apr 7, 20213Apr 7, 20213