Detecting When a Login Has Implicit Access to a Database
Yesterday I blogged about how to figure out what database principals corresponded to what server principals. The key is to...
2009-02-23
1,877 reads
Blog Posts
New Video Appearing on Front Page of JumpStart TV
All of the videos I've done are up under my profile. However, the video for The difference between GRANT, DENY...
2009-02-23
1,498 reads
PASS Update #6
It's been pretty busy since my last post. Just in one week I had at least 12 hours devoted to...
2009-02-23
718 reads
Rocky Mountain Tech Trifecta
This past weekend was the Rocky Mountain Tech Trifecta, and I attended and presented as well. Actually I only attended...
2009-02-23
922 reads
Working at home
It’s usually nice, sometimes challenging, always interesting.
The other day both Tia and I were working in the “spare” office when...
2009-02-23
753 reads
Database Mirroring FAQ: Will the Mirror automatically fail back to the original Principal when it comes back online?
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,487 reads
Mapping Database Principals to Server Principals
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL...
2009-02-22
9,843 reads
SQLSaturday #13 in Atlanta - Another Update & Shared Knowledge
Stuart says that as of Feb 20 registration is at 150 with a cap of 200, and plenty of speakers...
2009-02-22
676 reads
Looking Forward to Getting My Kindle 2
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,369 reads
Adobe Acrobat/Reader 0day - Disable JavaScript
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,065 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers