Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
The Stewardship Approach to Data Governance: Chapter 8
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Simple Method for Importing Ragged files
This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
How Much Training Data Is Enough?
This tip shows you how you can apply the cross-validation feature in the upcoming SQL Server 2008 release to estimate if the training set size is sufficient for a given model.
SQL Server non-clustered indexes for query optimization
Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers