Sql Server view example

These are some examples creating view from a table

create view prodlist (prid,prname,tam)
as
select prodid, prodname, totalamount
from products


select * from prodlist

How to log someone out of ssh terminal session

How to: Log someone out of the ssh terminal session but yourself? Kick off other users from linux terminal? Kill someone's ssh session?

How to set permissions on cifs mounted disks

How to set permissions on linux system when mounting samba or windows share disk using cifs protocol?

in the /etc/fstab set mount options dir_mode and file_mode

An example:

solr index query url

An example solr query
http://test.example.com:<port number>/solr/<core name>/select?q=test

Example response xml is

Some mysql queries for managing users

select host, user from mysql.user order by user;
lists mysql users

curl command man page

curl(1)  Curl Manual       curl(1)

NAME
       curl - transfer a URL

Apache Software Foundation Projects

Apache is a open source software development community. There are lots of software projects that are currently continuing to develop.


This is simple list of projects currently ongoing.

Sql Server System Databases

Master: Master database contains instance metadata and SQL Server system configuration settings but system objects are stored in resource database.

Model: Model database is a template for creating a new database.

Msdb: Msdb database is used by SQL Server Agent.

Resource: Resource database is a read-only database that contains all the system objects that are included with SQL Server.

Tempdb: Tempdb database is a resource that is available to all users is used to hold temporary objects.

fdisk command man page

FDISK(8)   Linux Programmer’s Manual      FDISK(8)

NAME
       fdisk - Partition table manipulator for Linux

date command man page

DATE(1) User Commands       DATE(1)

NAME
       date - print or set the system date and time

iostat command man page

IOSTAT(1)      Linux User’s Manual     IOSTAT(1)

NAME
       iostat - Report Central Processing Unit (CPU) statistics and input/out-
       put statistics for devices and partitions.

vmstat command man page

VMSTAT(8) Linux Administrator’s Manual     VMSTAT(8)

NAME
       vmstat - Report virtual memory statistics

NFS fstab options man page

NFS(5)   Linux Programmer’s Manual NFS(5)

NAME
       nfs - nfs and nfs4 fstab format and options

SQL Server replication concepts

Replication Objects:

Article: Objects that will be replicated in the database.

Subscription: Object that is used for receiving updates. Each subscriber must be associated with a publisher.

Publication: Object that is used for making data available for subscribers. A publication is made of articles.

tar command man page

TAR(1)      tar TAR(1)

NAME
       tar - The GNU version of the tar archiving utility

scp command man page

SCP(1)  BSD General Commands Manual SCP(1)

NAME
     scp - secure copy (remote file copy program)

du command man page

DU(1) User Commands DU(1)

NAME
       du - estimate file space usage

rm command man page

RM(1) User Commands RM(1)

NAME
       rm - remove files or directories

mv command man page

MV(1) User Commands MV(1)

NAME
       mv - move (rename) files

cp command man page

CP(1) User Commands CP(1)

NAME
       cp - copy files and directories

top command man page

TOP(1)      Linux User’s Manual TOP(1)

NAME
       top - display Linux tasks

df command man page

DF(1) User Commands DF(1)

NAME
       df - report file system disk space usage

ls command man page

LS(1) User Commands LS(1)

NAME

       ls - list directory contents

Categorize Blogspot Posts

If you have plenty of posts in the form of uncategorized then all you have to need is labeling your posts. Once labeling is finished Labels Gadget can be inserted on blog from Layout Tab. It’ll be needed to add it by clicking Add a Gadget.  Then it can be customized the by giving it a different title. Labels Gadget has options how the categories are sorted, and whether to show the number of posts corresponding to each category.

Sudoers Configuration (stop and start services)

So you want to allow other users to stop and start some of the services. From the linux point of view you can do this by using sudo.

Change ".bash profile" file contents of the user so that "service" and "chkconfig" commands will be in the PATH environment variable. "/sbin" folder must be included.

RMAN-06059 expected archived log not found

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 04/09/2012 13:43:10

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

Lucene Solr Backup Script

#!/bin/bash
solr_home="/opt/jboss/solr/";
solr_backup_folder="/solr_backup/";
today="$(date +%d%m%Y)";
todays_backup="backup.$(date +%Y%m%d)*"
index_name_tag1="corename=\"";
index_name_tag2="\"instanceDir";
instance_dir_tag1="instanceDir=\"";
instance_dir_tag2="\"/>";
logfile="/tmp/solr/solr_backup.log";
overall_result="ok";