Security Queries: Server-level
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
2,708 reads
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
2,708 reads
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,238 reads
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
2012-02-29
3,032 reads
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
2012-02-09
6,215 reads
Having flown a fair amount lately, I was thinking about the various levels of security within an airport. Part of...
2011-12-29 (first published: 2011-12-20)
3,519 reads
2015-08-06 (first published: 2010-11-02)
19,862 reads
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,429 reads
print 'Free Space' print '----------' exec master.dbo.xp_fixeddrives print 'Memory' print '------' exec master.dbo.xp_msver print 'Database Configuration' print '----------------------' exec master.dbo.sp_configure print'DB Size' print'-------' exec master.dbo.sp_databases print 'Linked Servers' print '--------------' exec master.dbo.sp_helplinkedsrvloginprint 'Windows info' print '------------' exec master.dbo.sp_server_info
2005-02-16
This is what I expected, although I was hoping to glean a trick or 2 from the list.Thanks anyway, I am already implimenting the suggestions above.
2005-01-18
I have two integers that I need a percentage number from such as 50/5000 = 5.00% I Know I ought to Cast out the datatype of the percentage etc... I do not remember what the formatting was... and didn't see it in my former posts many thanks for your help...
2005-01-14
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers