Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,097 reads
Articles
TSQL Challenge 41 - Extract email addresses from text data
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
2010-10-18
2,256 reads
Create a Performance Baseline Repository
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
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
847 reads
Sending multiple rows to the Database from an Application: Part I
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
Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010.
2010-10-15
4,254 reads
Data Distribution - Part 2
In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.
2010-10-14
4,318 reads
Free Training Webinar Series - October
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
A Haunting TSQL Tuesday Tale
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
Policy-based Management and Central Management Servers
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.
2010-10-14
2,380 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers