Publishing a Public Power BI Report from Google Sheets
Learn how you can share your Power BI report with others in the public. Steve shows how his data in Google Sheets is added to Power BI and then made public in a report.
Speakers Are Normal People
Today Steve encourages everyone to feel welcome in the data professional community.
Configure Contained Availability Groups for High Availability in SQL Server 2022
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
Dealing with Cross-Server Database Dependencies in Flyway Projects
How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
Dynamic ELT with Azure Data Factory - Part 3 of 3
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
Losing Track of Data
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
DevOps Process Improvement Course
However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them.
How to Import Data in Power BI Using R
This article shows how you can use an R script to import data into Power BI.
The Challenge of Deleting Data
Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.
Blogs
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process...
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Forums
Context_Info across databases
I have a stored procedure that works across databases. So the "integration" database will...
Interview Question
Hi Team , Today i had an interview call. there was a question asked...
AG failover databases go into Initializing / in recovery
We did a failover of an AG and two databases went into Initializing /...
Ask SSC