Smart Car Charging
I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...
2012-03-01
882 reads
Blog Posts
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,030 reads
SQL Saturday # 103 in Curacao a Success
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,320 reads
sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,296 reads
A Script A Day - Day 25 - Performance Counters
Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV. There are many ways in which to...
2012-02-29
2,313 reads
A Script A Day - Day 26 - RESTART a Database Restore
Today’s script is another one based on database restores. There is a little known clause of the RESTORE DATABASE command...
2012-02-29
2,852 reads
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,480 reads
AdventureWorks in SQL Server 2012 RC0
The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version...
2012-02-29
1,933 reads
Azure is Down
I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once...
2012-02-29
1,745 reads
Download free eBook for SQL Server 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second...
2012-02-29
3,562 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