Kevin Terry

Coupling Outlook to SQL Server

SQL Server has drivers to read almost any data source, but they are not always the easiest to work with. New author Kevin Terry spent quite some time learning how he could pull data from Outlook using DTS and scripting. Most information on the internet requires Exchange to be on the same server as SQL Server to get the data, but this solution works with any configuration, and can pull any information, email address, contact information, etc. from Outlook.

5 (1)

2005-02-01

18,142 reads

Blogs

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

Read the latest Blogs

Forums

Extract date from String

By SQL Server

Folks: I have to extract the date from this string which is between files_...

Detereming Trends in SSAS Cube

By Freefall99

I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...

SSDT server setup and using 3rd party tools across servers

By dmusson17

Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers