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.
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.
Blogs
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Forums
Database details missing in SYS.MASTER_FILES view
Hi, I noticed that one of the database information is missing in sys.master_files catalog...
Single index reorg took 2 full days or more to complete
I'm running an index maintenance job on 1 of my large database as the...
Ask SSC