Another Method of Testing for Updated Columns in a Trigger
This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!
When's Your Anniversary
Ever need to find out what anniversary dates are coming up? What about a list of birthdays in the near future? This article looks at querying for repeating dates.
Deleting Duplicate Rows
This article presents one technique to be used for removing duplicate rows in a table.
Transcript of SQL Technet Chat
This is a transcript of a recent chat that included our own Brian Knight!
Amazing FUD
How often do you hear FUD either for or against Microsoft? Know what FUD is? Steve Jones recently ran across an article looking at reasons why you don't want Microsoft products in your enterprise, specifically servers. Here's a few comments and a link to the article.
More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
myLittleAdmin v2.5 available
myLittleTools.net is pleased to announce the release of its web-based MS SQL and MSDE database administration tool. Several tools have been added, including "BackUp and Restore database" tools, "CSV Import" tool, "Generate INSERT scripts" tool, "Detach/attach database" tool. Several toys have also been added, including the possibility to display database space used with SVG graph, or a new skin.
Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
Review of AdeptSQL
Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers