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

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,589 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,925 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,781 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...
Rating: |  Discuss |   Briefcase | 9,340 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...
Rating: |  Discuss |   Briefcase | 15,367 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,868 reads

Transparent Database Encryption in SQL Server: A Planning Guide

A planning guide for the implementation of TDE in SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 6,506 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 | 10,797 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,738 reads
   Items 1 to 9 of 9