Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
Review of the MeasureUp test preparation serivce actually used by the author for the SQL Server 7 Design exam(70-029).
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
You know it is time to reassess your relationship with
your computer when....
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Comments posted to this topic are about the item The Cloud Security Problem, which...
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
Good Afternoon, We recently procured a service management software for our company, which uses...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers