Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS...
2010-11-11
638 reads
Glenn Berry
Full-Text Search Enhancements in SQL Server Denali
Since Microsoft announced the existence of CTP1 of SQL Server Denali during Ted Kummert’s keynote address at PASS 2010 yesterday,...
2010-11-10
836 reads
Why is SQLSaturday Such a Big Secret?
One of the small mysteries of the universe that I have been pondering lately is the fact that so many...
2010-11-10
422 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
458 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-09
1,296 reads
Official Blogger at 2010 PASS Summit
I will be one of the “official” bloggers during the 2010 PASS Summit, which means that I get to sit...
2010-11-09
472 reads
Live Streaming Keynotes From PASS Summit 2010
I just wanted to help spread the word that the PASS Summit Keynotes will be streamed live via LiveMeeting next...
2010-11-05
592 reads
Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
868 reads
Speaking at SQL Server Connections in Las Vegas Next Week
I will be giving two presentations next week at the SQL Server Connections conference in Las Vegas. There is a...
2010-10-31
1,578 reads
Adding Data Compression to an Existing Clustered Index in SQL Server 2008 R2
Working at an ISV like NewsGator Technologies, I get to work on products like Social Sites for SharePoint 2010, that...
2010-10-28
2,595 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