PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 reads
Blog Posts
PowerShell- Monitor Group Of Services on ‘N’ Servers & Notify Stopped Services
This post explains how to monitor a multiple services on a list of servers and send alert when the given...
2014-11-06
751 reads
Questions for the Board Q&A
Each year for the past few years the PASS Board of Directors has conducted a Q&A session with members at...
2014-11-06
973 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are...
2014-11-06
579 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are under that rock, I am curious how you are...
2014-11-06
2 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
50 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
7 reads
VM Right-Sizing PASS 2014 Session Wrap Up
Today I presented my SQL Server virtual machine “right-sizing” session at the SQL PASS 2014 Summit to a fantastic audience....
2014-11-06
566 reads
#SQLPASS #Summit14 Day 1 Keynote Highlights !
PASS President Thomas LaRock on stage !
PASS President Thomas LaRock kicked off the summit keynote.
Tom talked about the history of...
2014-11-05
877 reads
Book: Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
I was fortunate to be a technical reviewer for a new book, SQL Server 2014 Business Intelligence Development by Reza...
2014-11-05
1,974 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