Attracting Talent
How can a company attract talent? First, be a good company to work for, and then be real.
SQL Saturday Precon - SSIS Design Patterns
SQL Saturday is hitting Dublin for the first time on March 24th.
Tips for Upgrading a Cluster to SQL 2008 - Part 2
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
SQL Server Ranking Functions
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
Disconnected database development: solving a problem that needn't exist
A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.
Financial Rounding of Allocations
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
Tabs or Spaces
Today Steve Jones talks about one of the classic software developer debates. When formatting code, how should you do it?
TSQL Challenge 78 - Parse single field into multiple fields
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
SQL Saturday #128 - Istanbul
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
Index Statistics in SQL Server: Stairway to SQL Server Indexes Level 14
A look at the information that helps SQL Server make better decisions.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers