Good Article on Data Warehousing Best Practices in SQL Server 2008
If you are involved data warehousing, or even if you are just a beginner, you may want to check out...
2009-05-28
1,507 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,949 reads
I Can Run Hyper-V!
I noted recently that I purchased a new desktop with the intention of moving to Windows 2008 and Hyper-V. That...
2009-05-28
1,646 reads
Minimalist Design - Part 3
One of the labs I frequently do with students is to design a database for a training business, something which...
2009-05-27
1,453 reads
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,261 reads
Catalog view: sys.tcp_endpoints
I was playing around with the endpoint catalog views this afternoon just looking at ways to do poor man's configuration...
2009-05-27
2,835 reads
Speaking at Augusta Developer's Guild
Tomorrow night, May 28th, I'll be speaking the Augusta Developer's Guild. This is a make-up from earlier in the year...
2009-05-27
1,388 reads
Using Windows 2008 as a Workstation
I have a new machine, albeit one with a bad video card, running Windows 2008 Server R2 with Hyper-V. My...
2009-05-27
1,525 reads
Speaking at SQLSaturday #7 in Birmingham on May 30, 2009
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,350 reads
The SQLServerCentral Outage
A lot of people have asked what happened over the Memorial Day weekend as SQLServerCentral was down. All I can...
2009-05-26
1,585 reads
Blogs
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...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
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