Asking for Interview Questions
When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.
SQL 2000 DBA Toolkit Part 1
SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.
Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs
Data Protection and Disaster Recovery (DR) are IT tasks that seldom get the same level of attention as development… until disaster strikes. Only if planning is adequate can an organisation be resilient in the face of unexpected problems. There are several steps that are needed to achieve an adequate DR process and the ability to restore business operations after a disaster.
The Patch Wild, Wild West
Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.
Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?
Don't Be a Ghost
If you want to further your career, you can't be a ghost. Steve Jones talks about the ways in which so many people might end up hurting their careers by trying to keep their lives too private.
T-SQL Coding Style
When you write T-SQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your T-SQL? Join Greg Larsen as he discusses some of the coding styles you should consider when writing your T-SQL scripts and stored procedures.
Bad Data Costs Lives
Either data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.
Data mining introduction part 4: the Naïve Bayes algorithm
This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.
Data mining introduction part 4: the Naïve Bayes algorithm
This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.
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