Building a Kimball Data Warehouse
Learn about the Kimball method for data warehouses and how you can get started building one.
2023-06-14
6,916 reads
Articles
Calculating Prime Numbers With One Query
This article looks at calculating prime numbers less than n with one query.
2023-06-14
7,185 reads
Are PostgreSQL memory parameters magic?
Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. Some parameter tuning can improve the database performance, and we are usually talking about 10%, 20%, and in rare cases, up to 50% performance improvement.
2023-06-14
T-SQL Scripts to generate the HTML-formatted database storage report
This article will show how to generate an HTML formatted report of your disk space.
2023-06-12
6,638 reads
Flyway for SQL Server Data Tools Users
If you are using SSDT for authoring, building, debugging, and publishing a database project, how do you change to, or preferably migrate towards, a Flyway-based database development? Flyway doesn't need to replace any code part of SSDT, but if allowed to manage every release candidate, it does allow for much cleaner branching, merging, and deployments.
2023-06-12
Multiple Relationships on the same Table in a Power BI Data Model
This article will cover how to create multiple relationships between the same tables in Power BI to build the data model you need.
2023-06-12
PostgreSQL Copy
In this article you will learn how to use the COPY command in PostgreSQL to copy a database or a table.
2023-06-09
4,953 reads
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders
Is your team looking to modernize and migrate your data but have questions about the complex organizational challenges? This webinar panel on June 29th covers all aspects of data modernization and migration that senior IT leaders should be aware of, including organization culture, communication, and politics. Why not send it to your boss?
2023-06-09
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
Learn how to query data stored in text files from Azure Synapse Analytics using the Serverless pool that is included with each workspace.
2023-06-07
1,406 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?