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,934 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
569 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
SQLSaturday #14 in Pensacola Update
Karla just emailed that the schedule is set, details at http://www.sqlsaturday.com/schedule.aspx, but to save you time here are the speakers...
2009-04-21
625 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
SQL Server Security Basics: Logins vs. Users
When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...
2009-04-21
22,745 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
764 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
684 reads
Interviewed by Tom Larock
Tom has been doing a series of interviews on his blog lately and I ended up on the list. Interviewing...
2009-04-20
522 reads
Revisiting the Task List
I've written a few posts in the past about time management, and thought I'd post an update with some lessons...
2009-04-20
590 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries