The Data Fabric – Future of Data Management
This article provides an overview of Data Fabric and its components.
2023-02-01
1,998 reads
This article provides an overview of Data Fabric and its components.
2023-02-01
1,998 reads
Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.
2023-02-01
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
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
2023-01-30
1,566 reads
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
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
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
3,180 reads
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
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
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
2,920 reads
By Steve Jones
The grade for January is a D. Details below, but just not making a...
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...