Category: Varinder Sandhu

CollabNet Subversion Edge – Configuration

Others, Varinder Sandhu

In the previous post, you have seen the complete installation of Subversion Edge. After Installation, once you will login the web-based console for configuration managing the server. You can see in the below screenshot, Your SVN Server is down yet. Now, first we see some important configuration parameter (Highlighted in Red) that we have to set as per our requirement before starting SVN Server. There are lots of other configuration parts that you may need to setup as per requirement

» Read more
, ,

Installation CollabNet Subversion Edge – Step by Step

Others, Varinder Sandhu

CollabNet Subversion Edge is a Subversion server distribution that includes a complete software stack of Apache, Subversion and ViewVC as well as a powerful web-based console for managing the server. In this Post, we will see the intallation steps for CollabNet Subversion Edge. Go to URL : http://www.collab.net/downloads/subversion  and download latest version Subversion Edge and within minutes be up and running with a fully featured, web and cloud enabled Subversion (SVN) platform. Here we downloaded the Subversion Edge 4.0.6 (Windows

» Read more
, , ,

SQL Server 2012 – Installation of SSRS Reporting Services Native Mode Report Server (SSRS)

SQL, SQL-Reporting Services, SQL-Server 2012, Varinder Sandhu

You will get the step by step tutorial to install the SQL Server with Full or Partial features. Many time people are looking specific feature that we need to install for Reporting service Native Mode Report Server. So the purpose if this post is give idea of feature required for SQL Server Reporting Service Installation as shown in given snapshot:

» Read more
, , ,

Reviewer – Reporting with Microsoft SQL Server 2012

SQL, SQL-Reporting Services, SQL-Server 2012, Varinder Sandhu

I pleased to announce that Reporting with Microsoft SQL Server 2012 has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about Reporting with Microsoft SQL Server 2012

» Read more
, , , , , ,

SQL Server 2012 – Get Backup History of the database

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

The msdb database is system database used by SQL Server Agent for scheduling alerts and jobs. msdb.dbo.backupset – Contain the information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily – Contains the metadata for the physical backup files as they relate to backup sets Using the above mentioned tables, we will find the backup history of database Script: SELECT s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS Backup_Size, CAST(DATEDIFF(second, s.backup_start_date,s.backup_finish_date) AS VARCHAR(4))

» Read more
, , ,

SQL Server – Migrate/Transfer Maintenance Plan from one Instance to another

SQL, SQL-SSIS, SQL-Tips and Tricks, Varinder Sandhu

There are very few simple steps to migrate/ transfer the maintenance plan from one SQL Server instance to another. Maintenance Plan is nothing but SSIS package which SQL Server creates and deploys it under MSDB Database. I have created one maintenance plan to for the demonstration; you may migrate/ transfer as many you have with the same steps (as shown in the below image). Now connect to SQL Server Integration Services and Navigate to Stored Packages >>MSDB >> Maintenance Plans

» Read more
, , ,

SQL Server – Integration Services – Access is denied

SQL, SQL-Server 2012, SQL-SSIS, Varinder Sandhu

If you are facing the access denied error while connecting to Integration Services as shown below : Error detail: Connecting to the Integration Services service on the computer “ComputerName” failed with the following error:  “Access is denied.” (shown in given image) Connect the SQL Server Management Studio with “Run as administrator” option. After that you will able to connect SQL Server Integration Services Service.

» Read more
, , ,

XCOPY VS ROBOCOPY – Command Line Tool

Others, Utilities, Varinder Sandhu

XCOPY and ROBOCOPY both are the command line tools for copying multiple files or entire directory trees from one directory location to another and for copying files across a network.  XCOPY stands for extended copy and ROBOCOPY means “Robust File Copy“. XCOPY is included in most versions of Windows and ROBOCOPY is available as part of the Windows Resource Kit starting with Windows NT 4.0. We can say that, ROBOCOPY replaces XCOPY with more switches/options. XCOPY Syntax: XCOPY <source folder location>

» Read more
, ,

Schedule Automatic Backup in SQL Server 2012 – Part2

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

In the previous post, we have scheduled automatic backup in SQL Server 2012 – Part1. As we have scheduled daily backup of database and backup file will be generated every day. It is a good practice that to delete backup files after a certain period of time as per requirement. Now we will add the Maintenance Clean Up Task along with the Back Up Database Task. Configure Clean Up Task From the Maintenance Plan Tasks tool box pane in the left

» Read more
, , , ,

Schedule Automatic Backup in SQL Server 2012 – Part1

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

You know it is very important to back up your SQL server database backup on the regular basis. So in this post, we will see how to schedule automatic backup in SQL server 2012. We will go step by step to schedule so that we all can understand each and every step clearly. Before scheduling automatic backup we have make sure the following two points: User should have the SYSADMIN privileges to schedule automatic backup. SQL Server Agent service should

» Read more
, , ,

Configure the Environment Variable for JDK and JBoss

Others, Varinder Sandhu

With the help of this post, we are going to configure the Java & JBoss. Basically we will configure the Environment Variable for JDK and JBoss. Configuration : 1 Install the JDK Set the JDK/BIN Path in the Path variable under Environment Variable Set the JBOSS Path in the JBOSS_HOME variable under Environment Variable Configuration : 2 Install the JDK Set the JDK Path in the Java_Home variable under Environment Variable Set the Java_Home variable in the Path  variable as

» Read more
, , ,

Audit columns – Created by and Updated By

Oracle, SQL, Varinder Sandhu

I have seen two database designs to store the value in Created by and Updated By columns as: Store the PK of user in Created by and Updated By columns Store the user name in Created by and Updated By columns Now you may have question: What is best practice to store the value in the Created by and Updated By columns and why? My opinion is PK of user (user id) is preferred over user name. There are various

» Read more
, , ,
1 2 3 4 … 23