Dealing with Mutually Dependent Databases in Flyway
The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.
Encrypt SQL Server Stored Procedures to Protect Source Code
The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.
Publishing a Public Power BI Report from Google Sheets
I find Power BI to be a neat way to visualize data, one that allows interactivity to help analyze the results in a report. I decided to use Power BI last year to share some data with the kids I coach and worked on a way to help them understand some sta …
Dealing with Cross-Server Database Dependencies in Flyway Projects
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.
Configure Contained Availability Groups for High Availability in SQL Server 2022
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 01:13 Timbalero: Hi Brent. my fr …
Bite-Sized Office Hours: Q&A on TikTok
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? Enjoy short videos on TikTok? I’ve got just the thing: I’m taking the best Q&A from Office Hours and putting ’em out …
Dynamic ELT with Azure Data Factory – Part 3 of 3
In Part 1 of this series, we talked about the art of data ingestion where we discussed the first steps you would put in place when you’re ingesting data. In the second article, we looked at technical considerations that can set you up for success. I …
DevOps Process Improvement Course
The post DevOps Process Improvement Course appeared first on SQLServerCentral.
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting discoveries to add more to these secrets. The combination of possibilities is considerable, and I faced two new situations I hadn’ …
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python are standard tools used in Power BI. In a previous article, we learned how to import data in Power BI using Python. This time we will learn to use R. The a …
A Version Control Strategy for Database DevOps
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, name, position and so on. As well, each employee has a Position Number and Parent Position (or something like tha …