April 2018
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Categories

WordPress Quotes

A hero is no braver than an ordinary man, but he is braver five minutes longer.
Ralph Waldo Emerson

Recent Comments

April 2018
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (10)
Ansibile (17)
Apache (122)
Asterisk (2)
cassandra (2)
Centos (207)
Centos RHEL 7 (242)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (21)
Eassy (11)
EXCHANGE (3)
Fedora (6)
ftp (4)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
Hyper-V (10)
IIS (15)
IPTABLES (15)
JAVA (6)
JBOSS (31)
jenkins (1)
Kubernetes (1)
Ldap (4)
Linux (186)
Linux Commands (167)
Load balancer (5)
mariadb (13)
Mongodb (3)
MQ Server (21)
MYSQL (73)
Nagios (4)
NaturalOil (13)
Nginx (23)
Ngix (1)
Openstack (6)
Oracle (29)
Perl (3)
Postfix (19)
PowerShell (2)
Python (3)
qmail (36)
Redis (9)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
SFTP (1)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
swap (3)
TIPS on Linux (28)
tomcat (58)
Uncategorized (29)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

12 visitors online now
1 guests, 11 bots, 0 members

Hit Counter provided by dental implants orange county

Snapshot database in SQL Server

What is a database snapshot ?

Database snapshots are an Enterprise only feature which was introduced  in SQL Server 2005.A database snapshot is a view of what the source database looked like at the time when the snapshot was created.

How does a snapshot work:-

a. When you create a snapshot a sparse file is […]

Reset SA Password in Sql Server 2012

Step 1:- Change SQL SA password from a command prompt

Go to the command prompt of the server and type in command prompt osql –L C:\Users\Administrator>osql -L

Servers: localhost

Step 2:- Copy full name of SQL Server and type: OSQL -S <insert_servername_here> -E C:\Users\Administrator>osql -S localhost -E

Step 3:- Execute the following query: sp_password […]

Enable remote connections for SQL Server Express 2012

On my installation of SQL Server 2012 Developer Edition, installed with default settings, I just had to load the SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER and change TCP/IP from Disabled to Enabled.

 

down voteaccepted

Well, glad I asked. The solution I finally discovered was here:

How do […]

TCP IP Port in SQL Server 2012 and Firewall

TCP IP Port in SQL Server 2012

As an SQL Server Administrator you might need to find SQL Server TCP IP port configured for your SQL Server Instance. There are many reason to find it but most famous reasons is to give access to developer and set firewall exception if there is any. Generally 1433 […]