The Standard Limitation
SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.
2013-08-07
398 reads
Editorials
Separation of Duty
We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.
2013-08-06
123 reads
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
2013-08-05
117 reads
2013-08-05
195 reads
The School Year
This Friday Steve Jones looks forward to the rest of the year. It's almost time for school and do you have plans? Should you be making some plans?
2013-08-02
103 reads
The Human Touch
Humans are often the weakest links in any computer process, but we do need human input. Steve Jones talks about a few issues, and how we should be changing our workflow to reduce issues.
2013-08-01
122 reads
Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
2013-07-30
271 reads
How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
2013-07-29
542 reads
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
2013-07-29
146 reads
Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2013-07-25 (first published: 2008-10-13)
255 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