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,092 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,029 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,954 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
710 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,007 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,328 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
616 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
696 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers