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,512 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,482 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,340 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,407 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
601 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,427 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
947 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,895 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
777 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers