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.
2014-05-02 (first published: 2010-11-08)
14,079 reads
Articles
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.
2014-05-02
3,423 reads
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.
2014-05-01
4,517 reads
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.
2014-05-01
8,755 reads
SQL Saturday #292: Detroit
SQL Saturday is coming to Detroit MI on May 17, 2014. Join us for a free day of SQL Server training and networking. Register while space is available.
2014-05-01
2,008 reads
Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime
This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe.
2014-04-30
3,013 reads
Duplicate Detection and Management
Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.
2014-04-29
6,711 reads
Moving from Practice to Production with Test-Driven Development
Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements.
2014-04-29
5,710 reads
Percentile calculations in DAX
It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.
2014-04-28
4,089 reads
Big Data Quality Metrics
This article outlines how to measure resource usage, and use these measurements to develop quality metrics for Big Data applications.
2014-04-28
4,186 reads
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
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...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
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