SQL Server Object Dependency Viewer Revisited
A year ago I blogged about building a SQL Server 2008 Object Dependency Viewer based on a script by PowerShell...
2010-08-07
1,679 reads
Chad Miller
Quickly Script Out Replication Redux
Dave Levy (Blog|Twitter) posted a script in a blog post in which he uses a bit of SQL PowerShell Extensions (SQLPSX)...
2010-08-03
1,401 reads
Making A SQLPS Module
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL...
2010-07-10
3,247 reads
Windows Search Enable Your Script Files
At the July 8th Tampa PowerShell User Group meeting, Ed Wilson (blog|twitter) gave a presentation on “PowerShell Best Practices.” One...
2010-07-10
648 reads
Scripting Linked Servers
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked...
2010-07-06
3,092 reads
Building A Remote Desktop Manager Cluster List
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a...
2010-06-30
1,608 reads
PowerShell ETL Presentation
My thanks to everyone in attendence and PASS AppDev VC for inviting me to speak. I’ll post a link to...
2010-06-23
984 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,026 reads
Building A Remote Desktop Manager Connection List
Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...
2010-06-15
2,284 reads
SQLIse A PowerShell SQL Server Query Tools Gets an Update
After the first release of SQLIse (“SQL Ice”)--a basic IDE for T-SQL that includes ability to edit, execute, parse, format...
2010-06-04
1,577 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