Puzzling TVFunctions
I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...
2012-07-17
916 reads
Blog Posts
SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,088 reads
SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,608 reads
T-SQL Tuesday #32 – A Life in the Day
It’s T-SQL Tuesday time again, delayed a week this month, so I had a whole extra week to get ready....
2012-07-17
1,376 reads
T-SQL Tuesday: A Day in the Life of a BI Developer
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
644 reads
BI Systems Architecture Diagrams
Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...
2012-07-16
636 reads
Building Your First Power View Report
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.
Fulfilling User Needs
Developing a...
2012-07-16
1,204 reads
Crystal Reports DataDate in SSRS
Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...
2012-07-16
1,374 reads
Encrypting Connections to SQL Server
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,669 reads
Finding Your Dream Job - sharing some thoughts of the day...
Everyone at some time or another thinks about finding or landing their dream job. It could be in the form...
2012-07-16
2,074 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
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
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