ways to find the name of a running job
From time to time, I need to check (in my script) which jobs are running at the moment.So far, I...
2008-10-23
1,798 reads
Blog Posts
What’s in a Name?
Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the...
2008-10-23
1,384 reads
37 Signals
I thought this was a great talk and interesting to watch. If you build software, I’d check it out
He has...
2008-10-22
708 reads
Good Ideas Take Time or How to Brainstorm - Part 1
Occasionally I'm asked how I come up with ideas for my blog to maintain the just about one a day...
2008-10-22
686 reads
Free SQL Server Health & History (SQLH2) Tool Updated for SQL Server 2008
Microsoft's free SQL Server Health & History tool (SQLH2) has had a minor update and can now be used with SQL...
2008-10-21
2,271 reads
Water & Cell Phones Don't Mix
Obviously, right?
I managed to knock my Blackberry Curve off the bar and into a bowl of water in the sink....
2008-10-21
619 reads
"The work never matches the dream of perfection the artist has to start with."
I know, another non-technical blog post. But this one is career-related as well.
In high school I was introduced to...
2008-10-20
1,346 reads
SQL Server Messages: fairies rearranging furniture.
SQL Server and Sybase are geared up
to send information to applications over two distinct channels, the results in
one channel that...
2008-10-20
902 reads
Todo List Follow Up - The Notepad
Recently I posted about Managing My Todo List and I had a question via email about what notepad I was...
2008-10-20
799 reads
Understanding Microsoft Licenses - A Short Follow Up
I posted Do You Understand Microsoft Licenses about a week ago, and today happened to run across a note about...
2008-10-20
535 reads
Blogs
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...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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