Find Resources & Connect with members on topics that interest you.

AI - Acquire and Implement

PO - Plan and Organize

DS - Deliver and Support

Please sign in to see your topics.

You must be logged in to join this group.

SQL Server

Welcome to the SQL Server topic!

In this topic you may collaborate with your peers by participating in discussions, adding links and documents, and starting or contributing to wikis.

ISACA members can participate by clicking on the “Join this Community” button. You must be signed into the site. Set your alerts to be notified of new discussion activity within this community. Not an ISACA member? Join now

 
This Topic Has:
372 Members
0 Online
8458 Visits

Community Leader

Ian Cooke

Ian Cooke

Title: IT Audit Manager

Points: 175760

Badge: Influential

 

NEW! Activity Badges

Badges help others understand your level of community activity and your reputation as a contributor within the Knowledge Center. Learn More.

Discussions: 329 total

Must be a Topic member to contribute
View All »
Any one knows about a good SQL auditing training that is being offered anywhere??
Adenauer987 | 11/10/2017 3:52:22 AM | COMMENTS(1)
Microsoft To Deliver Monthly Feature Updates to SQL Server 2017 https://redmondmag.com/articles/2017/09/29/sql-server-2017-monthly-feature-updates.aspx
Ian Cooke | 10/4/2017 3:14:10 AM | COMMENTS(0)
Microsoft touts SQL Server 2017 as 'first RDBMS with built-in AI' https://www.theregister.co.uk/2017/04/19/microsoft_first_rdbms_with_builtin_ai/
Ian Cooke | 4/21/2017 6:03:46 AM | COMMENTS(0)
Backing Up SQL Server Databases Hosted on Azure VMs http://www.databasejournal.com/features/mssql/backing-up-sql-server-databases-hosted-on-azure-vms.html
Ian Cooke | 4/7/2017 3:06:58 AM | COMMENTS(0)
CompSci boffins propose scheme to protect privacy in database searches http://www.theregister.co.uk/2017/03/28/function_secret_sharing/
Ian Cooke | 3/29/2017 3:40:45 AM | COMMENTS(0)
SQL Server 2016 SP1 CU2 Released http://sqlmag.com/sql-server-2016/sql-server-2016-sp1-cu2-released
Ian Cooke | 3/29/2017 3:29:13 AM | COMMENTS(0)

Documents & Publications: 7 total

Must be a Topic member to contribute
View All »
The following document lists the options available for developing ● SQL Server Database Security Standards; ● A SQL Server Security Audit Program; and ● SQL Server Security Checklists etc.
Posted by Ian Cooke 726 days ago
ICQs and Audit Programs
Posted by ISACA 1284 days ago
A SQL Server Script to Output tables of audit interest to a CSV format. This allows easy import to ACL, IDEA etc
Posted by Ian Cooke 1799 days ago
A SQL Server Script to Output tables of audit interest to a CSV format. This allows easy import to ACL, IDEA etc
Posted by Ian Cooke 1804 days ago
Some prints screens showing how to output Microsoft SQL Server queries to a CSV type file
Posted by Ian Cooke 1990 days ago
Books
Posted by ISACA 2419 days ago

Events & Online Learning: 0 total

No Results Found

Journal Articles: 1 total

Volume 1, 2015
by Ian Cooke, CISA, CGEIT, CRISC, COBIT Foundation, CFE, CPTS, DipFM, ITIL-F, Six Sigma Green Belt
There are a variety of commercial security tools available to audit Microsoft (MS) SQL Server databases.

Wikis: 2 total

Blog Posts: 6 total

Must be a Topic member to view blog posts
Let us have positive inspirational slogans for every situation. Last week I started the project meeting like this: I don't know you are all so good at tuning the website. The performance is now is wonderful. I could witness reduction of stress, anxiety an...
Posted By : Jayakumar Sundaram | 1 comments
Before we get into auditing SQL Server permissions a reminder of a few definitions might be helpful. In SQL Server anything that can be granted a right to perform an activity is called a principal. So fundamentally principals are logins, users, roles, ...
Posted By : Ian Cooke | 3 comments
As with configurations the company you are auditing should have a policy on password controls.  We have previously discussed that SQL Server allows two methods of authenticating to the database – Mixed Mode and Windows Authentication (see http://www.isa...
Posted By : Ian Cooke | 0 comments
Typically application access to a SQL Server database is via one of two methods.  Either all users access the same database using a single (proxy) user which is defined in an initialisation (.INI) file, registry etc. Or the users access the database ...
Posted By : Ian Cooke | 2 comments
The company you are auditing should have a policy on how their SQL Server databases are configured.  Much of this configuration will be reflected in the server configuration options.  The configurations can be seen by querying SYS.CONFIGURATIONS. A de...
Posted By : Ian Cooke | 1 comments
SQL Server allows two methods of authenticating to the database.  You can configure the database to use either Windows Authentication or Mixed Mode. Windows Authentication uses Microsoft Windows security to validate the account and password of the requ...
Posted By : Ian Cooke | 1 comments