Keep it Simple and Smart
I pleased to announce that SQL Server 2012 Reporting Services Blueprints 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 “SQL Server 2012 Reporting Services Blueprints”
» Read moreI faced the WordPress login issue. When I tried to login my site and wp-admin page re-direct to 404 page. We know that the 404 error normally generates when the requested page is not found in the server. After trying couple of things finally I got the issue. If you are facing the issue following steps help you to diagnose/fix the issue First of all check wp-admin/index.php file is present under your WordPress installation. If the file is placed at
» Read moreMany time we faced the performance issue because of Locks on rows and it cause the delay to finishing the other transactions. So with the help of following steps you will able to find the locking objects and can release the object locks in Oracle Database. Let us create the example to understand clearly Terminal – 1 Step -1: Here we have execute the Update Statement in the SCOTT Schema without Commit Terminal – 2 Step -2: Now we try
» Read moreWith the help of these steps you will be able to find the specific network port number along with process ID of the process which is using it in command prompt. Netstat: The netstat command is a used to display detailed information about how your computer is communicating with other computers or network devices. With the help of this you will be able to find specific network port number. Steps: click on Start > run> cmd<Enter> netstat -aon | find
» Read moreIn the previous post (NuoDB – Cloud Database), we have seen all the basics you need to know before downloading NuoDB. Now we will see the how to download and install NuoDB on Windows. First of all we have to download the required installer file. Please download the free Version for evaluation Download Page: http://www.nuodb.com/explore/sql-cloud-database-editions/ After click on the download button, you will get Form, please fill all the required fields and submit the Information. After that accept the online
» Read moreLet’s try to get the answer of some questions to understand about Big Data What is Big Data? This is really very interesting topic; we all know data is growing every single day. The McKinsey Global Institute estimates that data volume is growing 40% per year, and will grow 44x between 2009 and 2020. Now we can think at what volume data is growing. But the volume of data is not the only characteristic that matters. So here we have
» Read moreLet us explore the NuoDB Cloud Database. What is NuoDB? NuoDB is relational database technology solutions. It is a NewSQL database built on a patented emergent architecture with full support for SQL and ACID guarantees. NuoDB have all features that you want: 100% SQL, 100% ACID, 100% Elastically Scalable Let‘s see the demo Video, this short video will demonstrate all the basics you need to know before downloading NuoDB
» Read moreData Pump Export is a utility for unloading data and metadata into dump file. The same exported dump file can be imported only by Data Pump Import utility. With the help of this Data Pump Export we can export the data of one machine and import into another machine. Dump File : The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in
» Read moreWhile trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below snapshot Issue 2: Not able to find the TNS Name in the dropdown as shown in below snapshot Cause: TNS entry missing in the environmental variables Resolution: Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as Oracle Home\NETWORK\ADMIN
» Read moreData migration is the process of transferring data between storage types, formats, or computer systems. But here we are specifically talking about database (i.e. Sybase, MySQL, DB2, SQL Server and Oracle) migration. Data migration is usually performed programmatically to achieve an automated migration. Most of the times when we change the software system and implement a new database or change the database vendor then we will need to migrate the data from an existing database to a new database in
» Read moreCreating a tablespace and user is a very common task after creating an oracle database. Before going further must read the post Schema vs. User In this post we will see how to create tablespace and user with example Tablespace Each tablespace in an Oracle database consists of one or more files called data files. A permanent tablespace contains persistent schema objects. Objects in permanent tablespaces are stored in data files. Script 1: Create Tablespace CREATE TABLESPACE "test01" LOGGING DATAFILE
» Read moreDo you want to edit the hosts file in window 7? Hosts file is system file which is used map the hostnames and an IP addresses for bypassing the DNS Server. Path of hosts file in Windows 7 %systemroot%\system32\drivers\etc\ Steps to Edit the Hosts File Open the Notepad with the option “Run as administrator” Now Navigate the system32\drivers\etc\ folder and open the hosts file Now make your changes to the Hosts file and save hosts file.
» Read more