<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: Ron Johnson
SQLServerCentral.com profile
Items 1 to 9 of 9
Data Insecurity: A Perspective on Data Encryption
The focus of this paper is on the protection of PII data stored within a database using encryption technologies.
Read more...
By
Ron Johnson
2013/03/07
|
Source:
SQLServerCentral.com
|
Category:
encryption
Rating:
|
Discuss
|
Briefcase
|
1,503 reads
Data Distribution with SQL Server Replication
This paper provides a foundation for understanding data replication as well as a discussion of the criteria for selecting an appropriate replication technology.
Read more...
By
Ron Johnson
2012/12/10
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
1,796 reads
Database Performance Transparency
Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.
Read more...
By
Ron Johnson
2012/02/08
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
6,649 reads
ETL Magic with SSIS – Part II
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
Read more...
By
Ron Johnson
2012/01/12
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
9,062 reads
ETL Magic with SSIS – Part I
The first part of two parts of a paper discussion the implementation of a "real-world" ETL example using SSIS.
Read more...
By
Ron Johnson
2012/01/05
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
15,123 reads
Indexes, Indexes, Indexes
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
Read more...
By
Ron Johnson
2012/07/04 (first published: 2011/07/05)
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
18,495 reads
Transparent Database Encryption in SQL Server: A Planning Guide
A planning guide for the implementation of TDE in SQL Server.
Read more...
By
Ron Johnson
2011/01/10
|
Source:
SQLServerCentral.com
|
Category:
transparent data encryption (tde)
Rating:
|
Discuss
|
Briefcase
|
6,443 reads
Performance Monitoring with Dynamic Management Views
In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.
Read more...
By
Ron Johnson
2011/11/17
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
9,648 reads
Understanding Indexes
This article contains an introduction to SQL Server indexes and how they are used in your queries.
Read more...
By
Ron Johnson
2011/02/15
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
22,483 reads
Items 1 to 9 of 9
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
