linked server Archives - {coding}Sight https://codingsight.com/tag/linked-server/ Blog for SQL Server DBAs and Developers Thu, 15 Jun 2023 09:31:40 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png linked server Archives - {coding}Sight https://codingsight.com/tag/linked-server/ 32 32 Create and Configure Oracle Linked Server in SQL Server https://codingsight.com/create-and-configure-oracle-linked-server-in-sql-server/ Wed, 24 Mar 2021 10:43:25 +0000 http://codingsight.com/?p=12439 This article explains the step-by-step process of creating and configuring a linked server between Oracle 19c and SQL Server 2019. Pre-requisites to create a linked server For demonstration, I have installed SQL Server 2019 on my workstation. Along with it, I installed Oracle 19c and created an instance named EMPLOYEE. In my further articles, I …

The post Create and Configure Oracle Linked Server in SQL Server appeared first on {coding}Sight.

]]> SQL Server Database Tables Export and Import Methods https://codingsight.com/sql-server-database-tables-export-and-import-methods/ Mon, 22 Apr 2019 23:30:58 +0000 https://codingsight.com/?p=6744 When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating with other data sources. For example, there is rarely a day when you won’t be requested to import data from an Excel, Access or CSV file into your SQL Server table. Or, conversely, export …

The post SQL Server Database Tables Export and Import Methods appeared first on {coding}Sight.

]]> Auto-Email System to Send Database Summary Report https://codingsight.com/auto-email-system-to-send-database-summary-report/ Thu, 03 Jan 2019 16:07:07 +0000 https://codingsight.com/?p=5895 Database monitoring is the most essential job of any database administrator. Big organizations and companies have multiple database servers that are located either in the same data center or in the geographically different data centers. There are many standard tools for database monitoring. Those tools use the SQL Server dynamic management views and system stored …

The post Auto-Email System to Send Database Summary Report appeared first on {coding}Sight.

]]> Monitoring Backups Across Instances https://codingsight.com/monitoring-backups-across-instances/ Thu, 29 Nov 2018 10:08:27 +0000 https://codingsight.com/?p=5710 Introduction In the last two or three months, I have been asked twice for a solution native to SQL Server that consolidates a backup report for several SQL Server instances across an enterprise. This question came from friends that did not necessarily want to spend money buying a tool but were more inclined to leverage …

The post Monitoring Backups Across Instances appeared first on {coding}Sight.

]]> 32-bit Excel and 64-bit SQL Server https://codingsight.com/32-bit-excel-and-64-bit-sql-server/ https://codingsight.com/32-bit-excel-and-64-bit-sql-server/#comments Mon, 30 Oct 2017 14:46:05 +0000 http://codingsight.com/?p=2465 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 Integration Services (former DTS) or import and export wizard, which is the same under the hood. Another way is to create a simple ADO.NET app. You can use the …

The post 32-bit Excel and 64-bit SQL Server appeared first on {coding}Sight.

]]> https://codingsight.com/32-bit-excel-and-64-bit-sql-server/feed/ 1 Working with SQL Server in Hybrid Cloud Scenarios https://codingsight.com/working-with-sql-server-in-hybrid-cloud-scenarios/ Wed, 19 Jul 2017 07:06:00 +0000 http://codingsight.com/?p=1830 A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise information systems, as this approach combines the advantages of public and private clouds. It is possible to flexibly attract external resources when needed and reduce infrastructure costs. On the other hand, you keep full control over data and applications that the …

The post Working with SQL Server in Hybrid Cloud Scenarios appeared first on {coding}Sight.

]]> Pitfalls of Linked Server Usage https://codingsight.com/pitfalls-of-linked-server-usage/ Thu, 25 May 2017 11:44:53 +0000 http://codingsight.com/?p=1491 An interesting project related to the task queue processing come to the company I work for. It was previously developed by another team. We needed to detect and resolve issues that occurred at high load on the queue. In short, the project consisted of several databases and applications located on different servers. A ‘Task’ in …

The post Pitfalls of Linked Server Usage appeared first on {coding}Sight.

]]> Retrieving SQL Server Metadata with Help of T-SQL https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/ https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/#comments Mon, 12 Jan 2015 07:57:54 +0000 http://codingsight.com/?p=121 This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own …

The post Retrieving SQL Server Metadata with Help of T-SQL appeared first on {coding}Sight.

]]> https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/feed/ 2