Backup Directly to a GCS Bucket in SQL Server 2022
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
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.
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Hi Experts. We recently set up a second location. our software at our first...
I am trying to migrate a DB from an old dying laptop to a...