FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with...
2011-08-09
6 reads
Blog Posts
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
671 reads
Functionality and User Experience are important, too
There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...
2011-08-09
811 reads
How to setup CMS
If you need to setup a Central Management Server or just want to check it out, then here is how...
2011-08-09
967 reads
PASS Update #61
Just a few quick updates.
First, on the SQLSaturday site we’ll be shortly rolling out an updated logo and layout for...
2011-08-09
625 reads
Server Side Paging with new OFFSET feature in SQL Server Denali
Ever since I was a web developer back in the days, server side paging has been an issues. Back then...
2011-08-09
1,726 reads
SQL MCM Training – Day 1
Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am
and now (05:30pm) Kimberly is...
2011-08-09
1,698 reads
Data Warehousing with SSIS
As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with...
2011-08-08
1,580 reads
Download free SSMS Add-In to create custom folders for database objects
I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in...
2011-08-08
3,167 reads
Droid Apps
A friend of mine recently got his first smart phone, an Android. My wife has also recently moved into the...
2011-08-08
760 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