What is a cloud data warehouse?

What is a cloud data warehouse?

Amazon Redshift was announced in November of 2012 and became the first cloud data warehouse, opening a whole new segment of technology. What is a cloud data warehouse exactly? On-premises data warehouse While cloud data warehouses are relatively new, at…

SQL Data Warehouse – Fast row counts

SQL Data Warehouse – Fast row counts

A couple of years ago I published a script to calculate fast, light-weight, row counts for SQL Server on-premises. The need to view the row counts of tables has not diminished but new technologies have come to the fore-front. Azure…

Big Data Round Up

Big Data Round Up

This month’s T-SQL Tuesday was all about Big Data. See what the community has to say about Big Data with this collection of articles ranging from deep technical walk-throughs to musings about Big Data’s impact on our industry and the…

Inside the XEvent Profiler

Inside the XEvent Profiler

XEvent Profiler is a new feature of SQL Server Management Studio v17.3. I applaud the SQL Server Tools Team for this feature. I feel like it will go a long way towards putting the legacy SQL Profiler to bed. Sometimes…

T-SQL Tuesday #95 – Unstructured Cosmos

T-SQL Tuesday #95 – Unstructured Cosmos

T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party and selects a topic for us to write about. This month, I am hosting. I invited…

TSQL2sday #95 Invitation – Big Data

TSQL2sday #95 Invitation – Big Data

T-SQL Tuesday is a monthly blog party started by Adam Machanic. Everyone is invited to this party. Participation is easy. Simply write a blog post about the topic presented and post it on the second Tuesday of the month (October…