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 […]

Lost In Translation

Lost in Translation – Deprecated System Tables – sysprotects

Posted by & filed under , , , .

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprotects returns rows for permissions within a database.  The view provides information on GRANT […]

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 […]