Azure Data Lake
At the recent Microsoft Build Developer Conference, Executive Vice President Scott Guthrie announced the Azure Data Lake. It is a...
2015-05-13
1,542 reads
James Serra's Blog
Azure SQL Data Warehouse
Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology. This has only been available as an on-prem...
2015-05-06
1,340 reads
TechEd is now Microsoft Ignite
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously...
2015-05-04
553 reads
Types of NoSQL databases
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...
2015-04-15
1,750 reads
What is a data lake?
A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its...
2015-04-08
2,642 reads
Creating a large data warehouse in Azure
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...
2015-03-30 (first published: 2015-03-19)
7,698 reads
Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different...
2015-03-12 (first published: 2015-02-26)
9,543 reads
Presentation slides for “Building a Big Data Solution”
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...
2015-02-24
977 reads
Power BI Made Simple
In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...
2015-02-18
1,107 reads
What is Advanced Analytics?
Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in...
2015-02-11
1,561 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers