Friday, January 1, 2016

Happy New Year Friends

Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.


Thursday, December 31, 2015

SQL Recovery Software: An Ultimate Tool For SQL Database Recovery

SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server, etc. the data in the database may go damaged or corrupted. The recovery of the data can be made possible with SQL Recovery Software. The tool attains an easy recovery of the database files from corruption or damage; no matter how deep the infection is. Both the MDF and NDF files get repaired using the tool and all the triggers, store procedures, tables, functions, etc. in the database are also recovered within seconds.
More On Software
SQL Repair tool restores all the data from the damaged database file of any server such as; Server 2014, 2012, 2008, etc. With the software all the hard deleted data items can be restored without any changes to the data.Being a Windows based software, the tool supports all the versions; Windows 8.1 and below.The Advance scan option recovers entire data when the corruption infection is severe and there is Quick scan mode for minor damage recovery. The tool is supported with the auto-detection option for the selection of NDF files as well as the SQL Server version. Once the restoration of the database files are done, software allows to export the files back to the Server.
Overview Of The Tool
Function Recover SQL Database from corruption
Version 6.2
Size 6.10 MB
Server Support SQL Server 2014, 2012, 2008 / 2008 R2, 2005, etc.
Windows Version Supports Windows 8.1 and below

Outstanding Features of SQL Recovery Software

Scan Modes
The tool is implemented with advanced algorithms for the recovery of the files. The “Scan Mode” option helps to recover the corrupted or damaged Server database files. The tool supports two scan modes; Quick and Advance. If the database file is less corrupted, users can go for “Quick” scan mode or else if the damage is severe, “Advance” scan restores all the data without loss.

Detects Server Version
Suppose, if you don’t know the version of the SQL Server where the database file is saved, there is “Auto detect SQL server file (.mdf) version” choice which will automatically search for the server file version once when the checkbox is ticked. Else, the user can mention the server version directly from the radio options provided but, one should be careful while opting since wrong selection of the server may lead to inconsistency.
NDF File Scan Option
The users can either add multiple files or folders for scanning and recovering. If the added files are to be removed, the tool is sufficient with that feature too. The eminent feature of the NDF option is that, it automatically detects the NDF files when the “Autodetect the SQL server secondary database (.ndf) files” option is selected. If the user doesn’t know the location of the file, auto-detect feature will be of useful; both to search the file and save time. Else, the user can select and provide the files using the “Let me choose the SQL Server secondary database (.ndf) files” choice

Hierarchical Structure
After the restoration of the database files, it shows the content of the files in hierarchical manner. The software will show all the contents such as; stored procedures, tables, triggers, functions, rules, etc. and each of the contents is expandable too. The structuring makes the viewing comfortable and easy.

Export Modes
Once when the files or folders are recovered from the damage, the tool allows exporting the recovered files back to the database itself. Either the user can export to “SQL Server Database” or to “SQL Server Compatible SQL Scripts”. If the user chooses the first option then, will have to provide the server name, database name, the credentials of the server. But, the latter option is usually opted when the server is not present or files are not to be exported to the server for time being. The “SQL Server Compatible SQL Scripts” choice will save the files in scripts and user can later transport the scripts.

Dual Export Option
While exporting the database files to the server or when saving in script forms, the tool facilitates the users with two options. User can export the files either “With only Schema” or “With Schema & Data” options. Both these options are applicable for both the exports i.e. to SQL Server Database or SQL Server Compactible SQL Scripts.

Versions & Its Extents
Demo Version
The capability of the application can be checked using the demo version available. If the user is satisfied will the working then, can go for the purchase option. But, the demo version is limited to the recovery of the files. The exporting and saving cannot be done with the demo version.
License Version
Along with the demo version, the full version is also available in the office website. The Licensed version recovers all the added files or folders and enables to export and save the restored files back to the server, if needed.
Pros & Cons
Pros:
  • Supports the recovery of both .ndf and .mdf files from damages or corruptions.
  • Enables to scan multiple .ndf files at a time.
  • Automatically selects the SQL Server version for the MDF files, if unknown.
  • Two scanning modes for the recovery of the files.
  • Selects the NDF files automatically, if the user doesn’t know the location.
  • Exports retrieved files back to Server database or saves in Compatible SQL Scripts.
  • Provides facility for exporting either schema only or both schema and data together.
Cons:
Doesn’t scan and recover LDF files of the database
The Verdict
In the technical point of view, the tool is equipped with all the sufficient features for the recovery of the database files. On the basis of its working, software can be rated as 9.6/10. Though the tool doesn’t recover LDF files, it efficiently restores both MDF and NDF files which are more important than the LDF files. For the repairing of the database files from damage, users can depend on the SQL Recovery Software without a second thought.

Saturday, August 15, 2015

Happy Independence Day - Jai Hind

Wishing you a very

Happy Independence Day


" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.



     Some facts about India 
  1. Indus Valley Civilization is the world’s oldest civilization.So, India is the world’s oldest, most advanced and continuous civilization.
  2. India has the world’s third largest active army, after China and USA but India has never invaded or attacked a country.
  3. Today, India is the world’s third largest economy.
  4. The Tirupati Balaji temple and the Kashi Vishwanath Temple both, receive more visitors than the Vatican City and Mecca combined.
  5. Every 12 years, a religious gathering called the Kumbh Mela occurs in India. It is the world’s largest gathering of people.
  6. Varanasi, also known as Benaras, was called "the Ancient City" when Lord Buddha visited it in 500 B.C., and is the oldest, continuously inhabited city in the world today.
  7. India has third largest Muslim population in the world and has more mosques (300,000 mosques) than any other nation in the world.
  8. Jews and Christians have lived continuously in India since 200 B.C. and 52 A.D. respectively
  9. Two major religions, Buddhism and Jainism, were established in India.
  10. Takshila is said to be the first every university in the world; it started around 700 BC.
  11. Indian Railways employs more than 1.3 million people. That’s more than the population of many nations.
  12. India is the largest democracy in the world. More than 54 crore people voted in the 2014 General Election – more people than the population of USA, UK, Australia and Japan combined.
  13. India has the largest English speaking population in the world.
  14. India’s space program is one of the top 5 space programs in the world and off course we invented water on the moon.
  15. Chess was invented in India.
  16. And discovered the number zero.
  17. And the value of pi. 
  18. And trigonometry, algebra, calculus.
  19. Ayurveda is the earliest school of medicine known to mankind. The Father of Medicine, Charaka, consolidated Ayurveda 2500 years ago.
  20. Cataract surgery and plastic surgery are invented in India
  21. Around the 17th century, India was one of the richest countries in the world.
  22. India is one of the only three countries that makes supercomputers (the US and Japan are the other two).
  23. India has the largest amount of vegetarians in the world. So much so that Pizza Hut had to open their first pure vegetarian restaurant in the country and KFC had to introduce a “vegetarian” menu for India.
  24. India gave the world Yoga, that has existed for more than 5,000 years.
  25. Martial Arts was first created in India.

Proud To Be An Indian


Friday, August 14, 2015

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-

SELECT
       tbl.name as [Table Name]
     , trig.name as [Trigger Name]
     , trig.is_disabled 
FROM [sys].[triggers] as trig
INNER JOIN sys.tables as tbl
ON trig.parent_id = tbl.object_id 

In case, if we need to find out all the triggers defined on a particular table then we can use the below SQL script

SELECT
       tbl.name as [Table Name]
     , trig.name as [Trigger Name]
     , trig.is_disabled 
FROM [sys].[triggers] as trig
inner join sys.tables as tbl
on trig.parent_id = tbl.object_id 
where tbl.name='Tblname'

/*  where Tblname name is the name of the table*/


Related article

SQL Triggers - An Introduction

Keep learning and don't forget to gives feedback on the article. You can also send feedback to me on my mailid  askvivekjohari@gmail.com