SQL Server 2008 R2 SP1 CU3
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 3. This is Build 10.50.2789.0, and it has 22 listed...
2011-10-18
1,158 reads
Blog Posts
SQL Server 2008 SP3 CU1
Microsoft has been busy getting SQL Server Cumulative Updates released over the past couple of days. The latest release is...
2011-10-18
707 reads
SQL Server Collation
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find...
2011-10-18
537 reads
SQLInspireNYC Event - We're giving away SQL MVP Deep Dives Vol.2
Now the PASS has well passed, folks are setting their sites on our upcoming NYC SQLPeople event called SQLInspireNYC .
SQLPeople...
2011-10-18
931 reads
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,056 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,471 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,859 reads
Guest Appearance in DBA in Space
Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...
2011-10-17
1,443 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,234 reads
PASS Summit 2011 recap
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,460 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