SQLBits 2023 Recap – Part 1
After several months of planning and preparation (…just on my part – organizers spent much longer), SQLBits 2023 came and went this past week at the ICC Wales, near the beautiful community of Newport. This was my first trip to SQLBits, and I didn’t know what to expect. It was a really great conference, from…
Azure Pipelines – Deploy SQL Changes with Service Principal
Automating deployments with Azure Pipelines comes with security challenges. One of those is deploying DACPACs for Azure SQL DB/MI. We’ll cover how to setup Azure DevOps and Azure SQL to be more secure, using a service principal.
SQL Saturday Auston 2023 – Recap
For those who attended my session, “Introducing Automated Deployments with Azure DevOps,” thank you. I think we had a good discussion on multiple pieces covered in the slides. Speaking of the slides, here is a link to them – https://endrephome.files.wordpress.com/2023/03/sqlsaturdayaustin2023-devops.pptx In the main demo, a deployment pipeline was created to build AND release code to…
Azure Data Factory Deployment Mistake
Recently, I was working with a release pipeline to add our Azure Data Factory solution. This was the first attempt to release Azure Data Factory components. Of course, there were many issues to resolve. The release pipeline handles both databases from multiple Git repositories and now ADF code, so it’s no longer an out of…
SQL Saturday Boston Wrap-Up
SQL Saturday Boston was a major success, both for the event and for myself. The organizing committee did a great job bringing together a stellar group of speakers who covered many great topics. A HUGE thank you to New England SQL Server User Group for the opportunity to speak about PowerShell. Thank you to each…
Azure Dev Ops – Job-Focused vs Task-Focused
This is the first post in the series, Azure Dev Ops Odds and Ends. The starting page has information about the code environment I’m working with, as well as links to other posts in this series. The first step to consolidate builds into a single pipeline was to gather code from four repositories into a…
Azure Dev Ops Pipeline Odds and Ends
When one works in a smaller company, there is an expectation of wearing many hats. As the Data Operations Team Lead, I’m no different. In addition to working with SQL Server, Azure infrastructure, Azure Data Factory and more, I have started to tackle Azure Dev Ops. Specifically, I’m working to enhance, or streamline, existing build…
Data Saturday Atlanta Wrap-Up
Data Saturday Atlanta was a major success, both for the event and for myself. Rie Merritt (@IrishSQL) and the organizing committee did a great job bringing together a stellar group of speakers who covered many great topics. A HUGE thank you to Atlanta Azure Data User Group for the opportunity to speak about PowerShell. Thank…
Database Helpers for PowerShell
PowerShell has a lot of great functionality to pull data from various sources on a server, like event logs, WMI objects, Registry, etc. However, preparing data for logging in a database is an area PowerShell is lacking. As supporting material for SQL Saturday/Data Saturday presentations, here are a couple functions, with basic functionality, to aid…
Working with Data in .Net
As a PowerShell developer (yes, I consider PowerShell coding development, when it’s for pre-ETL processing), there are a handful of very useful namespaces .Net. System.Data – “basic” data containers are classes in this namespace, include DataTable and DataSet. These are generic types, regardless of source or destination database or data source. System.XML – If you’re…