New SQL Monitor Custom Metric: Failed SQL Server logins
This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.
2013-08-02
3,642 reads
Articles
SQL Saturday #235 New York City, NY
Come to SQL Saturday New York on August 17 for a day of free SQL Server training and networking. Some of the speakers at this event include Chris Bell, Ben DeBow, Ashish Sharma, and Hilary Cotter
2013-08-02
2,661 reads
The Big Data DBA
Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards.
2013-08-02
3,540 reads
Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,433 reads
Disaster Recovery Tip #8: Maintain up-to-date contact information
A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.
2013-08-01
4,236 reads
Intervals and Counts - Part 1
When using SQL Server, you frequently need to work with data that represents intervals of time. For example, consider intervals representing sessions, contracts, projects, and so on. Tasks related to interval manipulation are typically quite intriguing, especially because coming up with efficient solutions isn't easy. Itzik Ben-Gan explains
2013-08-01
4,065 reads
SQL Saturday #234 Baton Rouge, LA
SQL Saturday is coming to Baton Rouge for a free day of SQL Server training and Networking on August 3.
There is also a pre-conference session presented by Bill Pearson on Practical Self-Service BI with PowerPivot for Excel on August 2nd.
2013-07-31 (first published: 2013-07-19)
2,648 reads
Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
16,706 reads
Baselining with SQL Server Dynamic Management Views
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.
2013-07-30
4,688 reads
SQL Saturday #236 St Louis, MO
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
2013-07-30 (first published: 2013-06-26)
4,464 reads
Blogs
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers