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 [...]
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 [...]
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s. A video of the session is available at the Pragmatic Works website. As a part of that session, I received a couple dozen questions about security that we didn’t have a chance to go over during [...]
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 syslockinfo returns information on lock requests. Whether the lock is granted, waiting to be [...]
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 sysprocesses returns information on the processes that are running on a SQL Server instance. [...]
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 [...]
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 sysservers provides information on linked servers, or servers an instance of SQL Server has [...]
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 sysremotelogins returns a row for every remote user with access to call remote stored [...]
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 sysreferences returns a row for every foreign key constraint in a database. The constraint [...]
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 [...]
_1262.png)
