A curious case of a missing configuration group.
G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...
2011-05-12
1,492 reads
Blog Posts
Clean Code is Easier to Read – SQL Prompt
I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name...
2011-05-12
1,834 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,550 reads
Notes from SQLRally Orlando
Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...
2011-05-12
692 reads
Please vote for my SQLPASS precon and sessions
A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...
2011-05-12
624 reads
SQL Rally Day 1 PreCon
Yesterday was the first day of the SQL Rally conference in Orlando, FL.It was a great first day because I...
2011-05-12
821 reads
You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
748 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC (virtual chapter). There was good attendance and there were...
2011-05-11
3 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC...
2011-05-11
664 reads
Dealing with Frustration in the Workplace
Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...
2011-05-11
3,031 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