Browse by Tags

SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform

Published 21 August 8 3:40 AM | SSQA.net

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...

Filed under: SOX, sql server, performance, ssis, audit, bids, pack, authentication, transact sql, transformation

SQL Server problem: Excessive paging and memory bottlenecks

Published 16 April 8 2:2 AM | SSQA.net

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...

Filed under: sql server, memory, audit, paging, bottlenecks, logical disk, pagesize

SQL Server Audit Trace - things you need to take care!

Published 6 March 8 3:17 AM | SSQA.net

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...

Filed under: SOX, sql server, microsoft, solution, dmv, trace, audit, tsql, trace flag, c2

SQL Server and data protection compliance laws, what affects you?

Published 15 February 8 3:59 AM | SSQA.net

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...

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?

Published 27 September 7 7:13 PM | SSQA.net

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,...

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?

Published 13 September 7 7:46 AM | SSQA.net

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...

Filed under: sql server, performance, databases, microsoft, security, audit, encryption, authentication, authorization, cryptography

Information and issues with Kerberos security within SQL Server 2005?

Published 31 August 7 4:45 AM | SSQA.net

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...

Filed under: sql server, security, windows, audit, clustering, authentication, failover, kerberos

Audit the activity such as SELECT statements - CDC

Published 30 August 7 6:2 AM | SSQA.net

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...

Filed under: sql server, microsoft, security, audit, 2008, cdc, monitoring, select

Software licenses - don't miss the bus, more important for an Audit

Published 11 August 7 5:21 AM | SSQA.net

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...

Filed under: sql server, audit, license, seminar, software

Trigger a trigger event when a new trigger is created

Published 29 May 7 4:50 AM | SSQA.net

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...

Filed under: sql server, login, audit, trigger, event, notification