Connection Pooling :At a Glance
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
8,099 reads
Blog Posts
Find unused indexes using sys.dm_db_index_usage_stats
The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...
2012-06-15
10,044 reads
Interview questions
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
11,967 reads
One week after #sqlsat132
It has been nearly one week since SQL Saturday 132 in Pensacola Florida. I was chosen to give my talk...
2012-06-15
711 reads
Slacking Off: The Right Side of the Brain
I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...
2012-06-15
1,010 reads
TechEd North America 2012 videos online
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a...
2012-06-15
1,045 reads
Contained Databases – Preventing Collation Conflicts
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation...
2012-06-14 (first published: 2012-06-07)
2,330 reads
Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices
With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...
2012-06-14
1,513 reads
NomCom, what it’s all about
I submitted my application for the NomCom last week and the polls opened up yesterday. I’ve seen an amazing amount...
2012-06-14
617 reads
PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
698 reads
Blogs
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...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
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