Catalog View: sys.sql_logins
When it comes to logins to SQL Server, there are basically 3 types:
SQL Server-based loginsWindows user accountsWindows security groupsThe latter...
2009-04-22
6,933 reads
Blog Posts
Day of DotNutNuke in Tampa on June 13, 2009
My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa....
2009-04-22
708 reads
Human Data Quality
Disclaimer: I read and speak one language, having failed pretty well at learning Latin, Spanish, and then Japanese in my...
2009-04-22
1,050 reads
Internal Outsourcing
We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services...
2009-04-22
978 reads
PASS Connector Editorial for April 22, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-22
568 reads
Thoughts on SSC Blog Site Improvement
I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...
2009-04-22
751 reads
Bonuses – Once a Year
I worked at a company that had a yearly bonus. Actually I’ve worked at a few companies, but this one...
2009-04-21
763 reads
Brand <> Reputation?
I was reading a book recently and it equated brand with reputation. My first thought was "aha", that brand is...
2009-04-21
1,026 reads
FedEx'ing Easter Eggs
My wife has had a hard week. Actually a few weeks where she's worked a lot of hours, lots of...
2009-04-21
683 reads
Register A Server More Than Once In SSMS
In yesterday's post about using SQL 2008 Express as a Central Management Server I mentioned that you can't register a...
2009-04-21
552 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