The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this article, Vince Iacoboni describes another way to design slowly changing dimensions.
2020-08-24
In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.
2020-08-24
This tip looks at using artificial intelligence models with SQL Server to predict outcomes.
2020-08-21
In this article we look at different examples of creating SQL Server stored procedures.
2020-08-20
The latest version of SQL Change Automation now integrates with SQL Clone to let you use a snapshot of your database’s schema as a baseline. This simplifies migration development in complex databases, avoiding problems like invalid objects or circular dependencies, and you can verify migration scripts on a copy of the currently released database.
2020-08-20
Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar.
2020-08-19
Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26.
2020-08-19
In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.
2020-08-18
Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.
2020-08-17
Learn How to Get Started with SQL Server Management Studio with Brent Ozar.
2020-08-14
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Comments posted to this topic are about the item Midjourney, Healthcare?
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers