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 "never" handed out as technical advice, and while it is usually well-meaning, can lead to a design myopia that limits one's ability to adapt to atypical application needs. "You should [...]

Read more ›

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 [...]

Upcoming Webinars on SQL Server Reporting Services 2016

With last year’s release of SQL Server, those of us who trade in the reporting and analytics space got a big gift: A brand new version of SQL Server Reporting Services. [...]

Keeping Data Quality Simple

A universal truth in business is that bad data costs money, and can even be dangerous. Data quality processes are often an afterthought rather than a central component of the [...]

Data Warehousing: It’s About The Business

Data warehouses are complex creations. The ETL and data cleansing processes that sanitize and reshape the data, the relational database in which the data warehouse resides, [...]

Partnership with Straight Path Solutions

I am happy to announce that Tyleris Data Solutions is partnering with Straight Path Solutions to assist our clients with data needs that extend beyond business intelligence [...]

DevConnections 2016

I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This year I will present one workshop and two regular [...]

Data Warehouse: On-Premises or Cloud?

I've been fielding this question a lot these days: "We're building a data warehouse - should we build it here or in the cloud?" It's a fair question, but it's not the question [...]

Introducing the Pinch Hit Service

I am happy to announce the launch of a new service designed to help with very short term consultation needs. Although most consulting engagements are weeks or months in [...]