Category: Uncategorized
-
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.
-
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…
-
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…
-
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…
-
A Comeback in 2022
I’m lazy and a bit selfish. What a way to start off a post, eh!? I was getting some content out in 2019 and 2020, as well as starting to hit a stride with presentations at SQL Saturdays. Then a new bug came and rocked everyone, COVID-19. SQL Saturdays disappeared, as well as gatherings in…
-
Standing up Azure SQL Managed Instance & Connect to Storage Account
This is a quick article, related to connecting an Azure SQL Managed Instance to an Azure Storage Account. When creating an Azure SQL Managed Instance, you have the options of creating a public endpoint and/or configuring the connection type of the private endpoint (as shown below). The default connection type for private endpoint is Proxy,…
-
Recent and Upcoming Presentations
The first set of blogs I posted on this site center around Row Level Security in Microsoft SQL Server. In addition to these posts, I’ve decided to present the topic at PASS events, including multiple SQL Saturdays. Below are the events I’ve already presented at in 2020 and am hoping to present at later this…