Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,493 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Restricting SecurityAdmin on SQL Server 2005/2008
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
2010-09-02
6,447 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,309 reads
SQL Saturday #48 - Columbia - Call for Speakers Ending
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,403 reads
Free SQL Server Training for the Week of August 30, 2010
The only scheduled event among the sources I have listed is the one for SQL Lunch, so it looks to...
2010-08-27
595 reads
Security Auditing Matching Up Logins And Users
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
2010-08-25
3,618 reads
It's the Procedure...
After going through all the materials provided to the NomCom for the PASS Board of Directors, I think I can...
2010-08-24
1,416 reads
Free SQL Server Training for the Week of August 23, 2010
Note: I got some of the dates mixed up, so I'm re-publishing this post.
Monday
SQL Lunch - Troubleshooting SSIS Package Development - Dustin...
2010-08-23
939 reads
Looking at the Numbers
Andy Leonard has done an awesome job collecting information and putting the numbers together for the recent candidate decision for...
2010-08-23
1,883 reads
SQL Saturday 51 Presentation - Fortress SQL Server
Thanks to everyone who attended my presentation at SQL Saturday #51 - Nashville. I apologize for going long and not getting...
2010-08-22
773 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers