<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
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,390 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,552 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,335 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,047 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,153 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...
By
Roy Ernest
2009/05/04
|
Source:
SQLServerCentral.com
|
Category:
transparent data encryption (tde)
Rating:
|
Discuss
|
Briefcase
|
14,181 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,333 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,356 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
|
8,994 reads
Items 1 to 9 of 9
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
