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,874 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
713 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,486 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,823 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
672 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
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers