Using Views and Synonyms for Abstraction - SQL School Video
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
Blog: Disabling Log Shipping When the Secondary Server Doesn't Exist
Had a bit of an oddity show up during some testing today when trying to disable log shipping on the primary server using SSMS. My test scenario was such that our secondary server was not available any longer (had been renamed) and when I tried to disable the log shipping...
SQL Server Integration Services an Introduction - Part 2
This article is part 2 of a 4 part series that introduces SQL Server Integration Services (SSIS). This article shows how to use the Data Flow Task in SSIS.
Moving Tables and Indexes to Filegroups En Masse
Longtime author and SQL Server expert David Poole brings us a method to
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
It's minus twenty-five outside and I'm writing about Transaction Log Files
I originally wrote this in French while working at LaCaisse.com "Why do you care, as a DBA (or a developer for that matter), about what is happening in the transaction...
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
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