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,819 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,419 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,306 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,941 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,610 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,721 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,491 reads
Understanding Indexes
This article contains an introduction to SQL Server indexes and how they are used in your queries.
2011-02-15
23,324 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,290 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
The DBScan algorithm tutorial
Comments posted to this topic are about the item The DBScan algorithm tutorial
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers