What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
13,894 reads
Articles
Transparent Data Encryption (TDE) in SQL Server 2008
Tapas Pal shows you how to encrypt your SQL Server database for a pre-existing, business critical web application using Transparent Data Encryption (TDE), a new full database encryption technique introduced in SQL Server 2008.
2010-06-14
2,995 reads
Default trace - A Beginner's Guide
This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.
2010-06-11 (first published: 2008-11-11)
53,747 reads
How to Conduct Effective Data Warehouse and Business Intelligence Software Evaluations
Denise Rogers discusses the essential tasks in conducting effective software evaluations revolving around data warehousing and business intellegence. Each step has a dependency on the previous one, starting with establishing the framework of the evaluation and adding progressively elaborate data that facilitates a decision making process that is resolute.
2010-06-11
4,369 reads
Make a 100+ Server Inventory in 30 minutes
Learn how you can generate a server inventory in 30 minutes for all of your servers with this new article from Stanley Chan.
2010-06-10
11,347 reads
Who Wants to Lead the Community?
Steve Jones talks about the PASS Board of Directors election coming up this fall and hopes some of you will apply.
2010-06-10
61 reads
Exploring Derived Column Transformation in SQL Server Integration Services
Marcin Policht examines SQL Server Integration Services' component, Derived Column Transformation,and how its usefulness is enhanced by its ability to implement fairly elaborate mathematical, logical, and string operations.
2010-06-10
2,976 reads
2010-06-09
8,420 reads
Speeding Up Incremental ETL Processes in SSIS by Using MD5 Hashes
Speeding up incremental ETL processes in SSIS by tracking changes to records in an MD5 Hash
2010-06-08
20,141 reads
SQL Server and the XML Data Type : Data Manipulation
The introduction of the xml data type, with its own set of methods for processing xml data, made it possible for SQL Server developers to create columns and variables of the type xml. Deanna Dicken examines the modify() method, which provides for data manipulation of the XML data stored in the xml data type via XML DML statements.
2010-06-08
3,264 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers