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,835 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,455 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,341 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,972 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,635 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,740 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,546 reads
Understanding Indexes
This article contains an introduction to SQL Server indexes and how they are used in your queries.
2011-02-15
23,350 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,363 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers