Tag: linked server

Create and Configure Oracle Linked Server in SQL Server

Database development

This article explains the step-by-step process of creating and configuring a linked server between...
Read More

SQL Server Database Tables Export and Import Methods

Database development, Tables

When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating...
Read More

Auto-Email System to Send Database Summary Report

Automation, Database administration

Database monitoring is the most essential job of any database administrator. Big organizations and companies have multiple database servers...
Read More

Monitoring Backups Across Instances

Database administration, Database Optimization & Structure

Introduction In the last two or three months, I have been asked twice for a solution native to SQL...
Read More

32-bit Excel and 64-bit SQL Server

Database administration, Work with data • One Comment

What could be simpler than to get data from an Excel table in SQL Server? There are many ways to accomplish this task. You can utilize...
Read More

Working with SQL Server in Hybrid Cloud Scenarios

Azure, Cloud

A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise information systems, as this approach combines...
Read More

Pitfalls of Linked Server Usage

Computer Environment, Languages & Coding

An interesting project related to the task queue processing come to the company I work for. It was...
Read More

Retrieving SQL Server Metadata with Help of T-SQL

Languages & Coding, T-SQL • 2 Comments

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
Read More