Resource Governor
This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints
In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker. This article describes the initial setup of components required to demonstrate a distributed implementation, with initiator and target services residing on two separate computers.
SQL Server 2008- SSIS Data Profiling task
By using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
An interview with the Exceptional DBA of the Year
Dan McClain was voted the Exceptional DBA of 2008 by the SQLServerCentral.com community. Learn a bit more about this talented professional in his own words.
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
Reporting Services: Read Data from SSAS and SQL Server in One Dataset
Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.
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