The Load of Real Time Data Warehouses
How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.
How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.
After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It says that: “To be is to be something in particular; to be nothing in particular or anything in general, is to be nothing at all.”
As I start this editorial, I am sitting at a PostgreSQL conference in New York City during the nighttime reception. The sound of 100 voices is not quite deafening, but it is certainly loud and understanding anyone in this group would be hard. It is also hard because I only know about four people at […]
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
Steve reminisces about the older technology of putting words on paper, often from the web.
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.
SQL Prompt has long been a customer favorite thanks to its ability to boost productivity. Discover how fellow database professionals are leveraging SQL Prompt to accelerate their coding speed and improve code quality.
How many of us clean up our databases and is it worth it? Steve has a few thoughts.
Learn how updates and concurrency can work in Fabric with Delta Parquet data.
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Comments posted to this topic are about the item The Cloud Security Problem, which...
I’m exploring Azure consulting services to enhance my cloud strategy, but I’m curious about...
I am planning to migrate a currently standalone database to SQL Always On. This...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers