Check Windows Services Status with T-SQL
In this article we look at creating a SQL Server stored procedure that displays a list of all Windows services based on running or stopped state.
2020-11-24
T-SQL
Using Triggers to Replace Scalar UDFs on Computed Columns
Using Triggers to Replace Scalar UDFs with Brent Ozar.
2020-11-16
2020-11-09
592 reads
2020-11-06
829 reads
2020-11-05
535 reads
Handling the Duplication of Records
Learn how to easily identify and remove duplicate records when you discover them.
2020-11-03
7,512 reads
2020-11-03
743 reads
NoSqlOnSql
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]
2020-11-02
4,917 reads
2020-10-30
811 reads
2020-10-29
907 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