Azure SQL Server Database
SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have...
2014-12-04 (first published: 2014-12-01)
6,783 reads
Business Intelligence and Enterprise Architecture
SQL Server Management Studio Reports
SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within...
2014-11-21 (first published: 2014-11-17)
7,618 reads
SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,182 reads
SQL Pass Summit 2014
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...
2014-10-30
1,164 reads
SQL Server TABLESAMPLE
Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...
2014-10-28 (first published: 2014-10-20)
7,475 reads
SQL Server Checksum
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...
2014-10-14
2,374 reads
Common Table Expressions (CTE)
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...
2014-10-08 (first published: 2014-10-03)
9,020 reads
SQL Server 2014 Cardinality Estimator
SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...
2014-09-25
996 reads
Schema on Read vs Schema on Write
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,212 reads
Business Intelligence Strategy – Beginning Steps
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...
2014-09-01
745 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers