What SQL Statements Are Currently Executing?
This article describes a utility that allows you to identify what SQL statements are currently executing.
Comparing cursor vs. WHILE loop performance in SQL Server 2008
There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
SQL Azure with ASP Dot Net
Don Schlichting demonstrates the development of a SQL Azure ASP Dot Net application, leveraging our existing TSQL and Dot Net skills.
Get Out of Your Comfort Zone!
A guest editorial from Andy Warren today looks to inspire you with a few thoughts about how you might force yourself to grow a little next year.
SSIS Package Credentials
What do you do when you run an SSIS package and it works, but it fails when scheduled? You might have a credential problem. Robert Pearl brings us a solution to a cryptic message that prevents you from scheduling a package.
Profiling SSIS packages for component level change tracking
In this tip we will look at an add-in that helps you better identify changes between two versions of an SSIS package.
You pulled BUILTIN\Administrators, but are you auditing?
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
SQL Server Management Studio and SQL Azure
A new article from Steve Moore shows us how to use SQL Server Management Studio with your SQL Azure databases in the cloud.
It's about Perception
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
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