Stairway to SQL Server Replication - Level 9: The Replication Monitor
Introducing the replication monitor and how to use it to monitor replication health. It also introduces tracer tokens.
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.
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?