Create and Configure Oracle Linked Server in SQL Server
This article explains the step-by-step process of creating and configuring a linked server between...
SQL Server Database Tables Export and Import Methods
When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating...
Auto-Email System to Send Database Summary Report
Database monitoring is the most essential job of any database administrator. Big organizations and companies have multiple database servers...
Monitoring Backups Across Instances
Introduction In the last two or three months, I have been asked twice for a solution native to SQL...
32-bit Excel and 64-bit SQL Server
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...
Working with SQL Server in Hybrid Cloud Scenarios
A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise information systems, as this approach combines...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
