Data Engineering – Learn from the experts
-
Database Management Views & Functions – SQL 2005
DMV’s are system views and its a new feature started SQL server 2005 with nearly 80 DMVs. DMV’s are system view that surface the internal counters of the database engine help present an easily comprehendible dashboard of the database engine performance that can be used to monitor the health of a server instance, diagnose problems,…
-
Backup Maintenance Plan with Cleanup task
This article provides a complete description about configuring backup using maintenance plan including cleanup task. This will be useful to junior DBA’s and also for the persons who have no voice in SQL server. This article is applicable for both SQL 2005 & SQL 2008.
-
Transactional Replication
This article teaches you how to set up transactional replication using wizards and scripts. In most cases, youll set up the initial publication and subscribers using wizards; however, if you need to apply the same publication in multiple environments, youll appreciate the option of applying the scripts as opposed to going through wizards time and…
-
Transactional Replication – Configure Subscriber
Unlike previous versions, of SQL Server 2005 allows you to use the same wizard to create either pull or push subscriptions. Perform the below steps to Configure Subscriber
-
Transactional Replication – Configure Publication
Once youve configured a distributor, youre ready to create publications. Perform the below steps as follows, Step1 : Connect to an instance (Sansu) of SQL Server by using the SQL Server Management Studio (SSMS), navigate to the “replication” folder then local publications folder, right-click this folder, and select New Publication. This invokes the new publication…
Got any recommendations?