Posts Categorized: Reblog

Padlock

Security Questions: Differences between “Grant” and “With Grant?”

Posted by & filed under , , , , .

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic.  Hopefully, this will […]

Padlock

Security Questions: Grant Permissions to All Stored Procedures

Posted by & filed under , , , , .

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic.  Hopefully, this will […]

LegoPieChart.jpg

Querying Performance Counters in SQL Server

Posted by & filed under , , , .

In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query.  The query just returned the contents of the dynamic management view, but didn’t provide the data from the view in a manner that immediately useful for all performance counters. The reason the data isn’t entirely […]