IndyTechFest 2010 Offers Free Training
For the third year in a row, IndyTechFest will offer free training for SQL Server DBAs and Developers, .NET Developers,...
2010-05-12
581 reads
Blog Posts
Running Totals Using Reporting Services
Sometimes one may need to see a running number that represents a quantity for a period of time. For example,...
2010-05-12
1,457 reads
SQL Saturday 38 Presentation
This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible....
2010-05-12
399 reads
SQL Server 2008 R2 backup/restore - simple Tip
Simple, but I think somebody will ask:
Can restore the SQL Server 2008 R2 database to SQL Server 2008 ?
Simple answer,...
2010-05-12
10,244 reads
SSRS - Time Saver using Templates
Creating a Reporting Services Template
Many companies like to have a consistent look and feel across their applications. Some even make...
2010-05-12
572 reads
Using the Report Items Collection in Reporting Services
Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has...
2010-05-12
489 reads
Daily SQL Server 2008 New Feature – Day 4
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-11
404 reads
Exceptional DBA
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
927 reads
Five Things SQL Server Should Drop
Joining in the current meme started by Paul Randal (blog | twitter), here is my list of five features or settings...
2010-05-11
12,528 reads
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
The post How Do I Move SQL Database Files Around?...
2010-05-11
2 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