Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Roy Ernest

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2012/05/31 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 8,832 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2012/01/16 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 7,689 reads

What, When and who? Auditing 101

In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.   Read more...
By Roy Ernest 2011/11/28 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 8,498 reads

How to make Net Meeting a success

This article is a basic guide line to chapter leaders who are planning to have Net meetings as part of the User Group meetings.  Read more...
By Roy Ernest 2011/01/20 | Source: SQLServerCentral.com | Category: net meeting
Rating: |  Discuss |   Briefcase | 1,050 reads

How the Resource Governor Helped Our Report Server

Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.  Read more...
By Roy Ernest 2010/06/28 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 5,231 reads

Transparent Data Encryption (TDE) SQL Server 2008

Transparent data encryption, otherwise known as TDE is one of the new features introduced in SQL Server 2008.  Read more...
Rating: |  Discuss |   Briefcase | 14,748 reads

Row Level Versioning

Row Level Version is one of the most coolest features introduced by SQL 2005.  Read more...
By Roy Ernest 2009/03/06 (first published: 2008/04/07) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 26,795 reads

Why Object Qualification is important.

You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.  Read more...
By Roy Ernest 2008/03/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,399 reads

Importance of UPSERT

A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.  Read more...
By Roy Ernest 2008/01/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,169 reads
   Items 1 to 9 of 9