Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,507 reads
Blog Posts
SQL Rally Schedule
In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. ...
2012-04-13
1,021 reads
SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,497 reads
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,557 reads
A Strange Day at McDonalds
A few weeks ago I was running errands on a Saturday, with an almost final stop at Home Depot to...
2012-04-12
687 reads
April 2012 – Monthly SQL Server Checklist
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
892 reads
Be Extra Careful When Packing
Over the last couple of years I’ve gotten myself down to two small, carry-on bags for most of my trips....
2012-04-12
1,085 reads
Microsoft Brings Back the Old Certification Acronyms MCSE and MCSA, starting with SQL Server
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone....
2012-04-12
1,953 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel...
2012-04-12 (first published: 2012-04-09)
2,714 reads
Re-thinking security for customer service
This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...
2012-04-12
1,262 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