The Complexity of Metrics
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
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.
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 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 […]
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.
Today Steve encourages everyone to feel welcome in the data professional community.
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.
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.
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Comments posted to this topic are about the item Coding Magic Values
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...
Hi friends, So I have a Login to a server that is a windows...