Visual Studio 2012 does not support BI
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not...
2012-07-25
16,077 reads
Blog Posts
Why You Should Speak at SQLSaturday (Or Any Other Free Event)
I talk to people about career planning and professional development quite a bit. It’s common to find them wanting to...
2012-07-25
1,068 reads
Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.
Using the GUI:...
2012-07-24 (first published: 2012-07-19)
2,757 reads
Improve DBA Operation Productivity – Part One
I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a...
2012-07-24
1,080 reads
PowerPivot diagram view missing
Some of you might be wondering why Diagram View is missing in some PowerPivot windows. This is related to Microsoft...
2012-07-24
2,381 reads
Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,972 reads
SQL 2012 evaluate installation requirements
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,302 reads
SQL FOREIGN KEY CONSTRAINT Syntax
You can enforce referential integrity (ensure you don't get orphans) by adding Foreign Key Constraint and in this tutorial you...
2012-07-24
932 reads
SQL Saturday 122: T-SQL 2012 presentation
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
991 reads
SQL Unique Constraint
In this blog psot we show how to restrict users from entering duplicated data by using SQL UNIQUE Constraint. In...
2012-07-24
781 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