Sql Server view example

No comments:
These are some examples creating view from a table

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

select * from prodlist

How to log someone out of ssh terminal session

No comments:
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

No comments:
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

No comments:
An example solr query<port number>/solr/<core name>/select?q=test

Example response xml is

Some mysql queries for managing users

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

curl command man page

No comments:
curl(1)  Curl Manual       curl(1)

       curl - transfer a URL

Apache Software Foundation Projects

No comments:
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

No comments:
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

No comments:
FDISK(8)   Linux Programmer’s Manual      FDISK(8)

       fdisk - Partition table manipulator for Linux

date command man page

No comments:
DATE(1) User Commands       DATE(1)

       date - print or set the system date and time

iostat command man page

No comments:
IOSTAT(1)      Linux User’s Manual     IOSTAT(1)

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

vmstat command man page

No comments:
VMSTAT(8) Linux Administrator’s Manual     VMSTAT(8)

       vmstat - Report virtual memory statistics

NFS fstab options man page

No comments:
NFS(5)   Linux Programmer’s Manual NFS(5)

       nfs - nfs and nfs4 fstab format and options

SQL Server replication concepts

No comments:
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

No comments:
TAR(1)      tar TAR(1)

       tar - The GNU version of the tar archiving utility

scp command man page

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

     scp - secure copy (remote file copy program)

du command man page

No comments:
DU(1) User Commands DU(1)

       du - estimate file space usage

rm command man page

No comments:
RM(1) User Commands RM(1)

       rm - remove files or directories

mv command man page

No comments:
MV(1) User Commands MV(1)

       mv - move (rename) files

cp command man page

No comments:
CP(1) User Commands CP(1)

       cp - copy files and directories

top command man page

No comments:
TOP(1)      Linux User’s Manual TOP(1)

       top - display Linux tasks

df command man page

No comments:
DF(1) User Commands DF(1)

       df - report file system disk space usage

ls command man page

No comments:
LS(1) User Commands LS(1)

       ls - list directory contents

Categorize Blogspot Posts

No comments:
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)

No comments:
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

No comments:
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

today="$(date +%d%m%Y)";
todays_backup="backup.$(date +%Y%m%d)*"