Data Engineering – Learn from the experts
-
Linked Server – Part 2
Introduction Some days back I’ve written “Linked server part 1” where we have discussed about configuring linked server. In this article I’m going to cover authentication protocols between linked server and the possible errors. Before we start let’s have a brief description about connection protocols & authentication mechanism
-
Schema changes in SQL Server 2005 Transactional Replication
Schema changes will be replicated by default. I am adding a column named street to the table Address using the below command,
-
How to Configure Peer to Peer replication – GUI
This article takes you with simple steps in configuring peer-to-peer replication. P2P replication is new to SQL server 2005 and though looks like complex in theory its one of the easiest to configure and maintain on long run. The following steps take you through the configuration process.
-
Backup compression in SQL Server 2008
Introduction Backup compression is one of the feature expected by every administrator to minimize the backup size and to squeeze the time taken for backup. In previous versions of SQL Server most of us are going for 3rd party tools like Quests Litespeed, Redgates SQL Backup etc. for which we need to pay additional amount.…
-
How To Check SQL SERVER Uptime Through T-SQL
Introduction Services uptime can be checked through WMI scripts and other methods also. As a DBA most of us would like to know the uptime of SQL Server, i.e how much time is SQL Server running till the server is on. You can do almost all the stuffs in T-SQL, hence Im writing the script…
Got any recommendations?