String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
2010-10-19
4,427 reads
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,097 reads
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
2010-10-18
2,256 reads
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
2010-10-18
2,532 reads
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
847 reads
New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.
2010-10-15 (first published: 2009-08-18)
27,465 reads
This article demonstrates how to manage database projects with Visual Studio 2010.
2010-10-15
4,254 reads
In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.
2010-10-14
4,318 reads
A series of free webinars from Pragmatic Works that cover a variety of topics in October.
2010-10-14 (first published: 2010-09-21)
3,588 reads
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-14
2,804 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers