Skip to main content

Posts

Showing posts from April, 2012

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

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:Msdbdatabase 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.

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.

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.

scp command man page

SCP(1)  BSD General Commands ManualSCP(1)

NAME
     scp - secure copy (remote file copy program)

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";