Obfuscating credit card or Social Security numbers

Here’s a function that will obfuscate a string of credit card or social security numbers. It can be useful to prevent information from being displayed in reports or other output from the database. You can download the script from the file attachment. Create_fn_ReplaceNumberSequence_BlogPost.sql

3

Below Periscope Depth…

I wanted to apologize to anyone who has wondered why my blog has gone cold in the last few months. My work load has kept me running in deep waters. It’s been difficult to come up to periscope depth lately so I can post new content. I’m hoping the holidays will give me a chance…

1

Installation of a SQL Server hotfix may hang or fail when SSIS is configured as a cluster resource

From SQL Server 2005 Books Online, Configuring Integration Services in a Clustered Environment: The Integration Services service is not a clustered or cluster-aware service, and does not support failover from one cluster node to another. Therefore, in a clustered environment, Integration Services should be installed and started as a stand-alone service on each node in…

1

A handy WMI script to check for pending file rename operations

Here’s a script that will check for and display any pending file rename operations. Windows stores the information on locked files that need to be renamed or deleted at startup. This is usually a result of an install or update that tries to replace files that are in use. This script was developed to use…

4

SQL Server Load Test Utility Released

A utility to generate unit tests for Visual Studio Team Suite has been posted to Codeplex. This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed to be used in a Visual Studio Load…

1

Finding Fragmented Indexes in a Database Running in SQL Server 2000 Compatibility Mode on 2005

The Index Physical Statistics report in SQL Management Studio is an easy way to identify fragmented indexes. But the report won’t run against a database set to 8.0 (SQL Server 2000) compatibility mode. Here’s a script that will generate a list of fragmented indexes for databases running with 8.0 mode: USE Your Database;      — change…

2

Finding dynamic SQL code that’s not compatible with SQL 2005

Upgrading a database from SQL Server 2000 to 2005 is not a difficult task. Microsoft provides the Upgrade Advisor tool to scan databases and report on SQL statements that will not execute in full compatibility code (9.0). But what about SQL code embedded in an application? What about dynamically generated SQL statements? The Upgrade Advisor…

0

Using the SQL Server Performance Dashboard Missing Indexes Report

The Microsoft SQL Server Performance Dashboard contains a drill-down report detailing information about missing indexes. Although you might think that this report makes it easy to implement new indexes and improve the performance of your database queries, it’s not that simple. Over-indexing a database table can lead to bigger performance problems such as having to…

2

Flushing them out of the walls…it’s finally time to upgrade to 2005!

It’s interesting how many companies are suddenly interested in upgrading from SQL Server 2000 to 2005. I can understand a legacy third party application that requires 2000 for compatibility. But many of these situations involve custom apps that would upgrade with little or no effort. There’s a light year or two or three between 2000…

0