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,533 reads
2004-05-05
1,758 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,279 reads
2004-04-23
1,769 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,860 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,708 reads
2004-03-10
1,648 reads
2004-03-08
2,303 reads
2004-03-08
10,971 reads
2004-01-23
1,091 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I am using the following sql to convert rows into columns for each pid,...
Comments posted to this topic are about the item Ingesting Data From REST API...
Comments posted to this topic are about the item Separate Reads
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers