Quick Installs with Chocolatey–Screen Capture
I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...
2015-05-15
902 reads
Blog Posts
Speaking at SQL Saturday Rochester this weekend!
I’ll be presenting my session Easing into Scripting with Windows PowerShell this Saturday, May 16th at SQL Saturday Rochester.
SQL Saturday is a free, all-day event for learning about SQL Server and...
2015-05-15
2 reads
Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas
Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...
2015-05-15 (first published: 2015-05-05)
6,823 reads
Automating Storage Benchmarking with DiskSpd and PowerShell
My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how...
2015-05-14 (first published: 2015-05-05)
7,651 reads
Building a job to monitor other jobs
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...
2015-05-14 (first published: 2015-05-04)
6,477 reads
Database Growth
Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly...
2015-05-14
1,088 reads
Excel in T-SQL Part 2 – The Normal Distribution (NORM.DIST) Density Functions
Today’s blog will be the second in a multi-part series on replicating Excel functions in T-SQL, continuing with Excel’s NORM.DIST...
2015-05-14
10,777 reads
Getting Database Properties – DatabasePropertyEx()
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-05-14
2,736 reads
MDX #46–6 different ways to detect a particular member in MDX script
There are many great tips in MDX with SSAS 2012 Cookbook
The book MDX with SSAS 2012 Cookbook has many great...
2015-05-14
1,659 reads
Powershell for SSRS in SharePoint: Multiple data sources and shared datasets
I thought that I would leave any further attempts to improve my Powershell script that was used to deploy SSRS...
2015-05-14
3,836 reads
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