Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,283 reads
Blog Posts
Webcast on SQL Server Auditing on October 9th
Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...
2012-10-04
1,059 reads
2012 PASS Board of Directors Elections - It's Time To Vote!
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,190 reads
Blog Changes
I have made a few changes to the blog over the past couple weeks The changes have come about as...
2012-10-03
648 reads
Dealing with orphaned users
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,706 reads
Get a Free SQL Server Indexing Book
What would you say if I offered you the best indexing book on the market for SQL Server 2012?
Wow, right?...
2012-10-03
703 reads
PASS 2012 Countdown – 5 Weeks To Go – Addendum
One thing to add for the 5-week countdown… are you an alumni to the PASS Summit? If so, why don’t...
2012-10-03
512 reads
PASS First Timers Guide and Schedule – 2012 edition
Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...
2012-10-03
1,217 reads
ReFS || next generation file system for Windows
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
601 reads
SQL Saturday #149 Minneapolis 2012
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 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