SQL Server Migration
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
2018-07-20 (first published: 2015-10-12)
7,664 reads
checklist
DTS handling multiple CSV file format
Hi, I need to write a DTS that is able to read a file that can have different format. E.g., I have a CSV file created by the Performance Monitor (it is a counter log) on a server running Windows 2003 (64-bit) that I need to load to a SQL Server table. This process has been running […]
2004-08-18
1 reads
RE: ActiveX Script Problem
That's why I was suggesting the openrowset, because what you do is force sqlserver to make the inner join instead of coding it yourself (which is exponentially slower as you add records in the tables... and even slower because ado is object based and not sql based). As for the execution method I'm really no […]
2004-08-17
RE: synchronizing sql server 2000 w/ exhange server contacts
Yes, this can be done.You need to have the OLEDB provider for Exchange and create a remote server connection to Exchange from SQL Server. start here:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_wss.asp
2004-08-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers