Migrating data from one SQL Server database to another can be challenging. Steve Jones has a new series that looks at various techniques that he's used to move data into a new database. This one looks at how you can quickly take Excel based data and insert it into a new database without using DTS.
2004-07-08
10,540 reads
2004-05-05
1,762 reads
Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.
2005-09-23 (first published: 2004-05-03)
40,322 reads
2004-04-23
1,779 reads
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
2004-04-08
9,878 reads
This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.
2017-08-23 (first published: 2004-03-24)
56,858 reads
2004-03-10
1,654 reads
2004-03-08
2,313 reads
2004-03-08
10,994 reads
2004-01-23
1,097 reads
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,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
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
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers