Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
575 reads
Patrick LeBlanc
Scripting Indexes
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the posting the author explained...
2010-01-15
1,457 reads
MVPs on the SQL Lunch
On January 19th and February 25th the SQL Lunch will have two well known authors, speakers and MVPs presenting at...
2010-01-14
610 reads
SSRS Data Driven Subscriptions Cryptic Job Names
When you create and schedule a Data Driven Subscription for a SQL Server Reporting Services (SSRS) report a job is...
2010-01-14
825 reads
SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)
Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions!...
2010-01-12
806 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-12
623 reads
Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,571 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-05
535 reads
SQL Lunch #7 – Top Tablix Tips
SQL Lunch # 7 – Top Tablix Tips
Speaker: Jessica Moss
Topic: Top Tablix Tips
Add to Outlook: Add to Calendar
Description:
SQL Server Reporting Services 2008...
2010-01-04
1,456 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-28
1,523 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