Speaking at PASS Summit 2012
Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! ...
2012-06-19
1,000 reads
Devin Knight
Command Line Prompts for Checking Active Directory Membership
Using Active Directory groups are a great way to manage and maintain security for a solution. Think about if you...
2012-06-13
1,895 reads
New SSIS 2012 Expressions
SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.
LEFT
The LEFT...
2012-06-05
2,386 reads
SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...
2012-05-31
3,798 reads
Converting to the SSIS 2012 Project Deployment Model
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...
2012-05-22
9,602 reads
Upgrading Packages to SSIS 2012
Many of you may now or in the future have the need to upgrade your SSIS packages to the new...
2012-05-16
26,054 reads
SQL Rally Wrap Up
Another SQL Rally has wrapped up in Dallas, TX and it was great event. My favorite part about these larger...
2012-05-11
1,479 reads
Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision
We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”. Which tool(s) is the best...
2012-05-02
2,028 reads
OPASS April Meeting Recap
Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting. I spoke on Extending...
2012-04-24
1,137 reads
Choosing the Right Microsoft Reporting Technology Part 5: Power View
In part five of this on going series about choosing the right reporting tool we will discuss the newest of...
2012-04-17
1,622 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