Viewing 15 posts - 1 through 15 (of 286 total)
Maximize your maximums, minimize your minimums.
January 13, 2024 at 10:18 am
GRANT: Are we starting to move from a high trust society to a low trust one? I don't think so. I think society, as a whole, is as trustworthy...
June 4, 2023 at 12:55 am
Yes, B5 had dated wizbang special effects, but B5 was not intend to be eye candy.
The stories within stories were epic in time, spanning generations.
The character development was awesome, some...
September 18, 2022 at 8:40 pm
It wasn't an article, Jeff.
I copied the text excerpt from a Help function write-up in Solarwinds DPA (Database Performance Analyzer) product which my company uses to monitor our...
January 12, 2019 at 4:54 pm
Gila, Drew,
Thank you both for your responses.
January 12, 2019 at 12:07 pm
Thanks for the query, Drew.
I believe you are correct. However, I commented out this line of code: --CREATE NONCLUSTERED INDEX PK_Test ON #Test(id) and re-executed the query.
The...
January 9, 2019 at 4:39 pm
I agree, GilaMonster, triggers look like my only option.
My research shows that these tables in the msdb database are most likely the best candidates for change-data-capture triggers to...
September 27, 2017 at 1:27 pm
Thanks for sharing that, Eric.
Yes, that should be enough information to conclusively identify the perpetrator.
May 31, 2017 at 3:43 pm
Sue, Michael, Ed, Lowell, thanks to all of you for your posts and ideas on how to break this problem.
Some of what you recommended has been done (we're...
May 31, 2017 at 10:46 am
"...something I wrote to enumerate the people who inherit permissions from a group.,,"
Thanks for posting that script, Lowell. I've been looking for a script that would do exactly...
May 31, 2017 at 10:39 am
And...
/********************************************************************/
-- SERVER LOGINS PROPERTIES
/********************************************************************/
select
-- sp.create_date as [Create Date],
-- sp.modify_date as [Modify Date],
sp.[name] as [Login Name],
sp.[type_desc] as [Login Type...
May 30, 2017 at 2:05 pm
At the risk of posting thing people already know, I'll start posting some of my work and tools I produced to get "under the hood" of SQL Server.
May 30, 2017 at 1:58 pm
Thanks for all of your replies. I've been so busy I haven't been able to reply.
I'm already doing some things that you recommend ("sa" login disabled, elimination of...
May 30, 2017 at 10:37 am
You are almost certainly missing the correct permissions.
Having sysadmin permissions will enable you to see the SQL Agent jobs. However, that is most likely too powerful a set...
May 1, 2017 at 4:49 pm
Thanks to all of you for your responses. My initial post may have seemed a little flippant but it was not. I needed to determine an appropriate setting for "Maximum...
January 23, 2017 at 5:11 pm
Viewing 15 posts - 1 through 15 (of 286 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy