MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
14,216 reads
Articles
Sign up to PASS Data Community Summit 2022
There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Register now.
2022-11-07
SQL Server Indexes to Improve Query Performance
In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.
2022-11-07
Cassandra Springboot Integration
In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.
2022-11-04
2,526 reads
Join a community like no other at Summit
There's not long until PASS Data Community Summit takes place. There's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE
Register now
2022-11-04
Leveraging the Script Activity within Azure Data Factory
Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.
2022-11-04
Assert Transformations in Azure Data Factory
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
4,207 reads
Introducing the MySQL INSERT statement
In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.
2022-11-02
Sign up to PASS Data Community Summit 2022
There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE.
2022-11-02
SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling
This article shows how one can use SSIS to find differences in SAP.
2022-10-31
2,113 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers