Browse Blog Posts by Tags

All Tags » audit (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Tools to enhance SQL Server security, analyze that!

There are various methods you could apply to secure SQL Server platform, that includes the areas of physical hardware and networking systems connecting clients to the database servers, and the binary files that are used to process database requests! It...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 14 2009
Filed under: Filed under: sql server, security, tools, audit, feature, lock down, verison, vulnerability, sql injection
Auditing and Logging - make use of SSIS in SQL Server

For a mintue I was thinking why I should post in this section, the variability is as per the law applicable to Financial sector to make sure the financial statement that a company reports is legitimate and that there’s no room for someone to manipulate...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 28 2009
Filed under: Filed under: sql server, package, ssis, audit, logging, transformation
Live Webcast: New Auditing Features in SQL Server 2008

Date: Wednesday, December 17, 2008* Time: 3:00 - 4:00 PM Central Speaker: SQL Server MVP, Hilary Cotter *Want to attend but can’t make this date? No worries! Each webcast will be archived for up to 6 months. Register now and we’ll notify you when the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Dec 10 2008
Filed under: Filed under: sql server, webcast, mvp, audit, idera, new features
SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 21 2008
Filed under: Filed under: SOX, sql server, performance, ssis, audit, bids, pack, authentication, transact sql, transformation
SQL Server problem: Excessive paging and memory bottlenecks

Paging and Memory bottlenecks are quite common when a performance problem strikes on your SQL Server. As we discussed here previously and relevant blog posts below talks about them: Paging and Available Memory for Operating sysem, what you need to know...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Apr 16 2008
Filed under: Filed under: sql server, memory, audit, paging, bottlenecks, logical disk, pagesize
SQL Server Audit Trace - things you need to take care!

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Mar 6 2008
Filed under: Filed under: SOX, sql server, microsoft, solution, dmv, trace, audit, tsql, trace flag, c2
SQL Server and data protection compliance laws, what affects you?

Are you aware whether your Enterprise has legal compliance on Sarbanes-Oxley or HIPAA ? First off what you should know about legal compliance is when it comes to the compliance matter on almost every business person's mind, Sarbanes-Oxley, there's...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 15 2008
Filed under: Filed under: SOX, business continuity, sql server, microsoft, audit, environment, database management, laws, legal, compliance, hippa, data protection
How to read Database transaction log in SQL Server?

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 27 2007
Filed under: Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution
SQL Server 2005 using Cryptography & Encryption what they are for?

Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 13 2007
Filed under: Filed under: sql server, performance, databases, microsoft, security, audit, encryption, authentication, authorization, cryptography
Information and issues with Kerberos security within SQL Server 2005?

What is the Kerberos Authentication? What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 31 2007
Filed under: Filed under: sql server, security, windows, audit, clustering, authentication, failover, kerberos
Audit the activity such as SELECT statements - CDC

Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 30 2007
Filed under: Filed under: sql server, microsoft, security, audit, 2008, cdc, monitoring, select
Software licenses - don't miss the bus, more important for an Audit

Managing software licenses is a difficult job that is only going to get more complicated. Most organizations today face a number of serious challenges in this arena, from the complexity of vendor licensing models , to cost overruns, to missed deadlines...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, Aug 11 2007
Filed under: Filed under: sql server, audit, license, seminar, software
Trigger a trigger event when a new trigger is created

Trigger a trigger event when a new trigger is created, for a moment I was muffled with number of times you need to mention to call the subject. So looking at the need you will have to ask whether it is possible or not. Coming to the subject, yes it is...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 29 2007
Filed under: Filed under: sql server, login, audit, trigger, event, notification
Ecora Auditor Lite

A Channel 9 itguy321 bloggere írt az Ecora cég Auditor Lite or Documentor for VMware termékéről. Rövid leírás: Document Your Entire IT Infrastructure… Absolutely Free . Imagine generating detailed configuration reports for virtually your entire infrastructure with just a mouse click! Ideal for Consultants...

Posted to Kurbli by Kurbli on Mon, Aug 21 2006
Filed under: Filed under: opsys, Tools, Audit

Page 1 of 1 (14 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.