Famous Last Words: “That Should Never Happen”

When it comes to managing data, there is often a difference between what should happen and what can happen. That space between should and can is often challenging, forcing data professionals to balance risk with business value. A couple of common examples: "There should not be any sales transactions without a valid customer, but because the OLTP [...]

Read more ›

Webinar: Introduction to SQL Server Temporal Tables

SQL Server Temporal Tables
Join us on Wednesday, December 20th at 12:30pm CST as we host a webinar entitled, “Introduction to SQL Server Temporal Tables.” In this webinar, we will cover the [...]

Flexible Consistency

Flexible Consistency
During last week's PASS Summit day 2 keynote, Rimma Nehme discussed some off the architecture behind Cosmos DB, the globally-distributed flexible database system rolled out [...]

Delivering Trustworthy Data and Analytics

Organizations of every size and in every vertical have a vested interest in unlocking the power of data. Among other benefits, reliable and timely data delivery will reveal [...]

Cloud Adoption Concerns (And How To Overcome Them)

Cloud technology has become very pervasive, with 89 percent of organizations globally identifying it as part of their IT strategies while another 75 percent say they have [...]

[POSTPONED] Event: Is Your Data-Driven Organization Ready for Azure?

UPDATE 8/29/2017: Due to the ongoing weather situation in Houston and its likely long-term impact, we have decided to postpone this event. Our thoughts go out to our [...]

Which Is More Secure: On-Prem or Cloud Data?

The short answer is this: Data, regardless of storage location or medium, is as secure as you make it. The use of cloud-based data processing and storage has grown [...]

Designing in Absolutes

Designing in Absolutes
There are absolutes that are true of data modeling and architecture, but these are fewer in number than most people think. There is a liberal use of the words "always" and [...]

Data Lineage Tracking in ETL Processes

Anyone who has worked in data integration for a significant length of time has almost certainly been confronted with the following question: “Where did this data come [...]

Benefits of Cloud-Based Database Applications

I still remember the week I realized that the cloud would most likely live up to its hype. It was a couple of years ago at the PASS Summit, and Microsoft had shifted their [...]

When Data Warehouse Projects Fail

Getting a data warehouse over the finish line is hard. Data warehouses are complex organisms, requiring intense collaboration and technical expertise across every level of [...]