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.
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
Hi, I noticed that one of the database information is missing in sys.master_files catalog...
I'm running an index maintenance job on 1 of my large database as the...