The Data Fabric – Future of Data Management
This article provides an overview of Data Fabric and its components.
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.
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.
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.
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
Storing a text file in a VARCHAR(MAX) column
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC