Powershell Goodies
If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...
2014-04-25
1,683 reads
Blog Posts
Reblog: April 18 to April 24
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-04-25
1,323 reads
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,116 reads
Another Question Of the Day
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
562 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,949 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,781 reads
Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
682 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,378 reads
Collation: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-04-23
540 reads
FileTable–Adding a file to a folder
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...
2014-04-23 (first published: 2014-04-16)
3,635 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