sp_helptext vs object_definition()
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,766 reads
Blog Posts
SQL Agent Permissions
Problem
I was contacted by a user asking if it was possible for his team to be able to execute specific...
2016-12-21
2,570 reads
Database Backup History – Back to Basics
In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
Related Posts:
The Mystery of Missing...
2016-12-20
23 reads
Database Backup History – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
559 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
456 reads
Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
41 reads
Last Restore of a Database – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
669 reads
On Being Disruptive
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,727 reads
Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
566 reads
SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server
Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...
2016-12-20
3,637 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
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