Changing Usernames
SQLServerCentral is changing usernames for some of our members in an effort to clean things up. Read more about what will be happening on Tuesday, Sept. 15, 2009.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
T-SQL Challenge #1
Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
Disaster Recovery for SQL Server Databases
High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers