The Complexity of Metrics
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
Dealing with Mutually Dependent Databases in Flyway
How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.
Encrypt SQL Server Stored Procedures to Protect Source Code
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
Fear of "What If"
Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]
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?
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
How to Check previous data loaded records vs current day in a table
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...
Permissions Changes Not Doing Anything
Hi friends, So I have a Login to a server that is a windows...
Ask SSC