Skip to main content

Posts

SQL Server database backup using a Batch file

SQL Server database backup using a Batch file Using the code Test.bat file SET curr_dir=%cd% cd /D E: IF EXIST TEST ( cd TEST mkdir ScriptTEST DataTEST cd ScriptTEST ) ELSE ( mkdir TEST cd TEST mkdir ScriptTEST DataTEST cd ScriptTEST ) SET SRC="%~dp0TestBackUpSQL.sql" SET DEST="TestBackUpSQL.sql" if not exist %DEST% copy /V %SRC% %DEST% sqlcmd -i "E:\TEST\ScriptTEST\TestBackUpSQL.sql" 2. In here you need to enter the database name and the back up set will be generated with name+date+time of server. TestBackUpSQL.sql file DECLARE @pathName NVARCHAR ( 512 ), @databaseName NVARCHAR ( 512 ) SET @databaseName = ' Enter Your DataBase Name Here' SET @pathName = ' E:\TEST\DataTEST\Enter Your DB Back Up Name Here_' + Convert ( varchar ( 8 ), GETDATE(), 112 ) + ' _' + Replace(( Convert ( varchar ( 8 ), GETDATE(), 108 )), ' :' , ' -' )+ ' .bak' BACKUP DATABASE @datab

Demonetisation Drives Innovation: Now A Website To Know If Nearby ATMs Have Cash Or Not

Demonetisation Drives Innovation: Now A Website To Know If Nearby ATMs Have Cash Or Not It has been a week since PM  Narendra Modi’s drive  on curbing black money in India was launched. While the money launderers are busy finding loopholes in the decision, the ‘ aam janta ’ is lingering for cash around ATMs in the city. With over 200 people standing in a queue at a time, they are not even sure whether the ATMs have enough money. But as they say, necessity is the mother of invention,  Manjunath Talwar and Abhijit Khasnis , have come up with an online portal,  CashNoCash  – to determine if a nearby bank or ATM has cash available or not. The website allows a user to search the nearest ATMs based on their current location. Also, one can create alerts to send notifications when the ATMs gets refilled by cash As Manjunath shared with Inc42, “CashNoCash.com is a free service that allows you to find nearest cash points, their availability and waiting times. The status data is crowd

India to see 10 per cent salary increase in 2017: Survey

India to see 10 per cent salary increase in 2017: Survey NEW DELHI: Salaries are expected to rise by 10 per cent in 2017, while star performers will attract much more as companies are discernibly prioritising such employees, says a report. According to the 2016 Salary Budget Planning (Q3) Report released by global advisory, broking and solutions company Willis Towers Watson, salaries in India are projected to rise 10 per cent in 2017, same as the actual increase in 2016. Once average inflation for India of 5.7 per cent is taken into account, the projected increase in real terms for 2017 will be 4.3 per cent, down by a fraction from 4.4 per cent in 2016. The report noted that with tighter salary increase budgets, organisations are prioritising their top performers. Similar to trends in the Asia Pacific region, the report indicates that in India, 38 per cent of the budget for salary increase goes to top performers. Another 34 per cent is shared by above-average performers whi

Web of Trust (WOT) Add-on taken down by Chrome & Firefox

Web of Trust (WOT) Add-on taken down by Chrome & Firefox WOT is one of the most trusted and popular add-ons used by millions of users worldwide to check the safety ratings of the websites. German news site recently reported that the add-on is malicious and can remotely execute the arbitrary commands on any web page browsed by the users including privileged browser pages. While WOT hands over the users’ data in an anonymized form, it can be severely critical. As per the analysis reported by Rob, Security Technology student and AMO editor working on Firefox WebExtensions, WOT can also steal the banking credentials of the users besides installing a malware in their system. Downloaded for more than 140 million times, the extension WOT collects and sells the information like user ID, web address, location, time and date. Among other things, data stored by WOT also include the travel details of users, sexual preferences as well as illness of users. This information is sold

Angular 3 is hot on the heels of Angular 2

Angular 3 is hot on the heels of Angular 2 Angular 3 will have better tooling and will generate less code; Google also is promising a new major version twice a year     Fresh from the long-awaited release of its Angular 2 JavaScript framework in mid-September, Google will release Angular 3 in a few short months. Expected in March, Angular 3 will focus on improved tooling and a reduction in generated code, said Rob Wormald, of the Angular core team and a developer advocate at Google. It will feature a template compiler that provides feedback in an IDE on errors in a template, and it will generate 25 percent less code, thanks to improved compilation and changes in the framework's underlying mechanics. [ Use JavaScript in your dev shop? InfoWorld looks at  17 JavaScript editors and IDEs  and  22 JavaScript frameworks  ready for adoption. | Keep up with hot topics in programming with InfoWorld's  Application Development newsletter . ] While more than two years passed b

Top 10 Awesome Apps for Android November 2016

7 New Google Gadgets You Should Buy