Serverless Computing

    Serverless computing Technology helps you to build and run applications and services without thinking about servers.  Serverless computing include as BaaS [Backend-as-a-Service] and FaaS [Function-as-a-Service]. Backend-as-a-Service (BaaS) helps developers to work on the frontend of their applications and leverage backend services without building or maintaining Function as a service (FaaS) – cloud computing service that makes it easier for cloud application developers to run and manage micro services.  Below are server less computing offers by different cloud vendors: AWS API

» Read more

WordPress Backup- WARNING: Job restarts due to inactivity for more than 5 minutes

Problem : while running the WordPress backup through BackWPup plugin getting the following error message. WARNING: Job restarts due to inactivity for more than 5 minutes. ( refer below screenshot for the same)  this happen generally when backup is taking longer time than as usual or backup size is very big. After this warning message, the backup will failed. This problem can be solved by changing the value Maximum script execution time. There is no specific value that we need

» Read more

How to Upgrade the PowerShell in Windows

Below is step by step guide to upgrade the PowerShell Shell Version on Windows 7, first we will check current version of PowerShell. As we know there are multiple way to anything in PowerShell. (Get-Host).Version $Host.Version PSVersionTable.PsVersion Get-Host | Select-Object Version Now we will upgrade PowerShell version to 5.1 and see the below table to get the right version as per your OS. Now we will download the Windows Management Framework 5.1  https://www.microsoft.com/en-us/download/details.aspx?id=54616 After downloading, first we have to change

» Read more

10 reasons why USA is the best country for immigrants

There has been a lot of confusion on the topic of migrating to USA from past few years. But eventually lots of immigrants have been shifted to USA for multiple reasons. Some of them are happily living there permanently and some of them are doing job for their better future, and others are exploring the beauty of USA to spend some quality with their friends and family. However, debates have been raged over some really strong statements made by their

» Read more

Compress SQL Server Backup in Right Way

Databases have the nasty habit of growing to mammoth sizes with continued usage over years. And it is common knowledge that databases that grow too large become prone to problems such as corruption, mismanagement etc. It thus becomes important to keep tabs on their growing sizes before they reach the point of no return. That’s why organizations engage in frequent backing up and shrinking of entire databases (which is not a very safe option). However, just as the databases can

» Read more

SQL Server – Single Instance vs. Multiple Instances

Single Instance Pros Only one instance needs to be administered on the single machine. There is no duplication of components or processing overhead, such as having to run multiple database engines on the same computer. This means that the overall performance of a server with a single instance may be higher than a server running multiple instances. A single instance of SQL Server is capable of handling the processing growth requirements of the largest Web sites and enterprise data-processing systems,

» Read more

PacktPub – PostgreSQL Cookbook Review

PostgreSQL Cookbook published with over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL cookbook written by Chitij Chauhan who is leading expert in the area of database security, with expertise in database security products such as IBM Infosphere Guardium, Oracle Database Vault and Imperva. You can know more about the Book here bit.ly/1CkxzNe With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL

» Read more

Effective Database Maintenance and Management – Index Fragmentation

We have said before that indexes are easily the most important database structures insofar as database performance tuning is concerned. Therefore, you must pay keen attention to their configuration, structure and arrangement in order to get the best level of performance out of them. Theory of index fragmentation Fragmentation does not only occur at the file-system level and inside log files; data files can also be affected by fragmentation – specifically within the sections that store index and table data.

» Read more

Top 7 Things Website Owners Should Know When Backing Up Their Website

In today’s world of internet blogging/websites, taking a few moments to make an easy, quick and convenient backup of your database will save you untold hours, days or even weeks of hard work. Listed below are seven important things you’ll need to know about backing up your website, before disaster strikes unexpectedly. 1- How Many Times Should You Backup? It’s your call. How important that data is, and how often you want to backup may depend on how often you

» Read more

Unable to connect the SQL Server Instance – 26 – Error Locating Server/Instance Specified

Problem\Issue: User is not able to connect the SQL Server Named Instance ServerName\InstanceName Additional Error Messages: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) Environment: SQL Server default single instance is running on

» Read more

SQL Server – How to read the SQL Server Error log files using TSQL

There is undocumented system stored procedure sp_readerrorlog which allows us to read the SQL Server error log files directly using T-SQL. This procedure has total 7 parameters as given below: Parameter Values First Parameter Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc. Second Parameter Log file type : 1 – Reads SQL Server error logs, 2 – Reads SQL Server Agent error logs Third Parameter Search string

» Read more

Leveraging Validator Toolkit for ASP.NET MVC to Build Client and Server-Side Form Validation

After having gained an incredible amount of popularity as one of the finest web development frameworks, Asp.net is now available with a validator toolkit that enables the developers to build both, client side and server-side form validation. The MVC programming model available for Asp.net has made its mark in the world of Asp.net development. In today’s blog, I’ll be covering details about the validator toolkit that’s available for Asp.net developers. What’s the Validator Toolkit for Asp.net MVC used for? While

» Read more
1 2 3 26