While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.
Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
Buck Woody discusses the hard-earned knowledge and experience that you'll need to gain in order to stand out as a and professional and exceptional DBA.
It's important that you manage your career and not just leave it to chance. Steve Jones talks about what you might do to ensure that you'll be successful in the IT world.
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
Interviewing, Google as a monopoly, Cumulative Update 5 and more.
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
We've got a new contest running for the next week just for your production DBAs. Win a prize just for telling us a story.
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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