Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory
Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.
2023-02-01
Articles
Introducing the MySQL common table expression
As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables.
2023-02-01
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.
2023-01-30
4,857 reads
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.
2023-01-30
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.
2023-01-30
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.
2023-01-27
4,272 reads
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.
2023-01-27
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.
2023-01-27
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.
2023-01-25
5,725 reads
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
2023-01-25
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers