Help others and enter to win a prize
My home state of Colorado has been devastated by wildfires. My vacation this summer was semi-cancelled with a fire closing...
2012-07-23
1,283 reads
Blog Posts
O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,283 reads
PowerPivot default measure aggregation
One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default...
2012-07-23
688 reads
PowerPivot hide fields and unhide in Excel 2013
In this PowerPivot tutorial I show how to improve user experience by hiding fields from PivotTable (client tool) so user...
2012-07-23
815 reads
Should We Customize the SQLSaturday Hashtag on Twitter?
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
775 reads
SQL CHECK CONSTRAINT Syntax
We have now added SQL CHECK CONSTRAINT to Exam Guide 70-461 Querying SQL Server 2012 and SQL Tutorial
2012-07-23
916 reads
SQL DEFAULT CONSTRAINT Syntax
This time we show how to use SQL DEFAULT CONSTRAINT to provide values for fields that are not given a...
2012-07-23
619 reads
SQL PRIMARY KEY CONSTRAINT Syntax
In this tutorial we show how to use ALTER TABLE and add Primary key constraint. This tutorial support our Exam...
2012-07-23
745 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 2
It's already a long time since I have blogged how
to configure your Windows- and SQL Servers for SQL Server 2012...
2012-07-23 (first published: 2012-07-19)
5,316 reads
SQL Server 2012 and summertime in London
The week just passed I have been teaching Learning Tree course 2108 SQL Server 2012 Database Administration in London. It...
2012-07-23
1,016 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers