Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
422 reads
Blog Posts
Results of Microsoft Certification Poll
In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if...
2010-04-23
1,195 reads
Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
511 reads
Script of the week
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
392 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
401 reads
A DMV a Day – Day 22
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,754 reads
An Introduction to SQL Server 2008 Change Data Capture
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008, which can be downloaded here.
As...
2010-04-22
2,117 reads
Consulting and the MBA
The year is 1991. Nirvana’s Smells like teen spirit is the must-have album of the year. And everyone who is...
2010-04-22
549 reads
e-Ink Improvements
I saw this article on the improvements from E-ink that are coming. There are two videos, one of a better...
2010-04-22
713 reads
I’m on TV at the Tweet-up
I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released...
2010-04-22
731 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
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