PASS Summit 2018 – Day 2 – 11/8/2018
It is day 2 of the summit already, am at the bloggers table again, waiting for the rest of the...
2018-11-08
157 reads
Blog Posts
PASS Summit 2018 – Keynote Day 2 Commentary
It’s the second main-session day of the Summit for the Professional Association of SQL Server. I had a great breakfast this morning with Brent Ozar, along with Nathan and...
2018-11-08
3 reads
PASS Summit 2018 – Keynote Day 2 Live Blog
It’s keynote time again! The second full day of the conference starts now, and like yesterday, I’ll be live-blogging during...
2018-11-08
191 reads
Signing Stored Procedures That Access Multiple Databases
A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Recently Manish...
2018-11-08 (first published: 2018-10-30)
2,552 reads
Speakers wanted for Richmond (VA) SQL Server Users Group – 2019
The Richmond SQL Server User Group, located in Richmond, VA, is looking for speakers for the 2019 calendar year. Due...
2018-11-08
653 reads
SQL work-vacation, Thursday! (#Workation #PASSSummit)
Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here...
2018-11-08
187 reads
The 5 Scariest Moments for a SQL Server Developer
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d...
2018-11-08 (first published: 2018-10-30)
4,983 reads
A Busy Summit
I’m only at the PASS Summit for two days, but they will be busy. If you’re at the event and...
2018-11-07
244 reads
A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps...
2018-11-07
280 reads
A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps us provide outstanding service to our customers, identify potential...
2018-11-07
12 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