SQL Server 2016 public preview arriving this summer
SQL Server 2016 was recently announced. Top new features include:
Always Encrypted protects data at rest and in motion. With Always...
2015-05-20
697 reads
SQL Server 2016 was recently announced. Top new features include:
Always Encrypted protects data at rest and in motion. With Always...
2015-05-20
697 reads
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
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
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
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
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
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
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,552 reads
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
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
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers