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,931 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
707 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,048 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
975 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
563 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
743 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,019 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
545 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers