Better, Faster, and Cheaper
When building a system, you need to make choices. However, do you always need to make the choice of only two of the three "good, fast, or cheap" choices? Andy Warren has a few thoughts.
Index Utilization Trending
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
Lots of Security Concerns
This past week saw lots of security concerns, especially around data. Steve Jones has a few comments about the implications.
SQL Server Reporting Services Basics: Building SSRS Reports
Kathi Kellenberger describes the basics of SSRS before showing you how to build quick, simple reports.
How to centralize your SQL Server Event Logs
Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.
The Gadget Itch
What would build if you had time? Anything fun or interesting? What's on your mind if you're a maker?
Use Extended Events to Get More Information About failed SQL Server Login Attempts
You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help.
DAX: Topn is not a Filter
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
Searching for Strings in SQL Server Databases
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers