Building robust functionality with maximum re-use of existing infrastructure and investment with little or no development is the goal for many businesses. This article is about using SQL Server DTS packages to achieve this goal. With minimum development, all the functionality required for data imports can be achieved with DTS programming in SQL Server.
2007-10-02 (first published: 2002-10-25)
92,463 reads
Data cleansing is something that constantly occurs in all RDBMSes, not just SQL Server. However it's easier on some platforms than others. New Author Sureshkumar Ramakrishnan has written a script that shows how you can easily remove duplicate rows in SQL Server. Read about his technique and see if it might come in handy in your environment..
2007-10-02 (first published: 2004-12-20)
47,417 reads
The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
2007-10-02 (first published: 2004-09-28)
40,372 reads
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
2007-10-02 (first published: 2002-08-14)
24,699 reads
Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.
2007-10-02 (first published: 2004-05-10)
48,370 reads
We crossed the 500,000 member mark last week and we're looking to give away some prizes!
2007-10-02
1,912 reads
New Author! And long time reader - Jeffrey was site member #712, almost 3 years and 130,000 members ago! This article describes the skills needed to progress from junior to intermediate to senior DBA.
2007-10-02 (first published: 2004-03-03)
39,009 reads
Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!
2007-10-02 (first published: 2003-04-25)
51,029 reads
Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..
2007-10-02 (first published: 2004-06-16)
42,142 reads
Mail processing in SQL Server 2005 has changed substantially, including a new name, DBMail! Corey Bunch birngs is an introduction to this new subsystem, including HTML formatting.
2007-10-02 (first published: 2006-01-03)
68,228 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers