Sign In
Driving The Database Engine
A blog about Microsoft SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
-
blogms official blogs
cloud computing database hosted DBA
cluster
CodePlex
Connected Show
consolidation migration upgrade sql server
Developers
Development
failure
hotfix
Kimball data warehouse toolkit business intelligence toolset SQL Server 2008 R2
microspotting microsoft employees
msdts
obfuscating numbers
Open Source
Pages
performance dashboard missing indexes report
performance dashboard reports sql server 2008
powerpivot excel sharepoint
SQLDiag
ssis
SSRS Reporting Services Fiddler troubleshooting client
tongue in cheek anti-SPID
visual studio team test database professional unit SQL Server
Archive
Archives
May 2011
(1)
April 2011
(1)
March 2011
(1)
June 2010
(2)
May 2010
(1)
October 2009
(2)
September 2009
(2)
August 2009
(1)
July 2009
(1)
June 2009
(1)
May 2009
(1)
April 2009
(3)
March 2009
(2)
February 2009
(3)
January 2009
(1)
December 2008
(2)
November 2008
(1)
September 2008
(1)
August 2008
(1)
July 2008
(2)
June 2008
(1)
May 2008
(4)
December, 2008
MSDN Blogs
>
Driving The Database Engine
>
December, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Driving The Database Engine
Creating a job to re-index all user databases in an instance of SQL Server 2005/2008 Enterprise Edition
Posted
over 4 years ago
by
Tom Mills Microsoft
11
Comments
Here is a script that will create a job to re-index each user database in an instance that is not in read-only mode. The script uses a cursor to identify the available databases and creates a job step with a script to perform online reindexing on that...
Driving The Database Engine
Obfuscating credit card or Social Security numbers
Posted
over 4 years ago
by
Tom Mills Microsoft
3
Comments
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...
Page 1 of 1 (2 items)