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.
2013-03-07
1,826 reads
Ron Johnson
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.
2012-12-10
2,441 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.
2012-07-04 (first published: 2011-07-05)
19,317 reads
Database Performance Transparency
Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.
2012-02-08
6,953 reads
ETL Magic with SSIS – Part II
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
2012-01-12
9,623 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.
2012-01-05
15,735 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.
2011-11-17
13,519 reads
Understanding Indexes
This article contains an introduction to SQL Server indexes and how they are used in your queries.
2011-02-15
23,337 reads
Transparent Database Encryption in SQL Server: A Planning Guide
A planning guide for the implementation of TDE in SQL Server.
2011-01-10
7,342 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Bagaimana cara koreksi tanggal lahir di Tiket.com
Koreksi tanggal lahir Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui...
Bagaimana Cara koreksi nama di Tiket.com
Koreksi nama Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui whatsapp...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers