Data Analysis Expressions (DAX) in Power BI
Data Analysis Expressions (DAX) is a powerful formula and query language used in Microsoft Power BI, Excel Power Pivot, and Analysis Services to perform calculations and manipulate data. It allows users to create custom metrics, measures, and calculated columns, enabling
Taking Database Backup And Moving that backup from one server to another using PHP
While working on two servers, we can take the backup of database on one server using mysqldump command in php. Example : exec(‘mysqldump –host ‘.$dbhost.’ –user ‘.$dbuser.’ –password=’.$dbpass.” “. $dbname.’ > ‘.$dbname.’.sql’); After creating dump of database, user can move
Web crawlers, Robots.txt and Googlebot
What are web crawlers? Web crawlers are programs or scripts which search engines use to gather certain types of data from the websites and check links and update the indexes, so that search engines can show up-to-date results. Most of
Scaffolding in CakePHP
Scaffolding in CakePHP Application scaffolding in CakePHP is a technique that allows the developer to define and create a basic application that can create, retrieve, update and delete objects. Basically CRUD (create, Read, Update, Delete) data operations are common in
Jquery | Check if image exists for the url created at runtime
Suppose a website page displays the list of subjects along with information and corresponding image. Html “div” with classname “.subjects” are generated dynamically in accordance with database records of subjects with custom attribute assigned as “data-subjectid” to each div which
Add virtual field in cakephp 2.* in find methods
How to specify an extra field (not existing in the table) while fetching data from database using find method? Solution is explained below. Assign value to virtual field before find function call: $this->virtualFields[‘virtual_field_name’] = ‘any value’; Use virtual field in
Selenium IDE: Locate and verify GUI and CSS Elements
While using Selenium Ide, It is very hard to verify the GUI and CSS elements using record and run method. In record and run method you will not be able to use all of the commands due to lack of
RESTFul architecture best practices
1. Restful web service has its specific set of standard methods like: GET, POST, DELETE, PUT, OPTIONS. We should use HTTP methods as per standard. For example: use “Delete” method to delete the resource not for any other task. 2.
Ubuntu | Unable to login, failed to start session
Description: I am trying to login in my Ubuntu machine. I entered my correct password and it didn’t login me. It showed me “failed to start session” message in red color. I am also not able to login with guest
Quickbook Webconnector queue concept with Job priorities
Queue plays very important role in Quickbook integration via Web connector. Each new job is created in the queue with priority level according to which it is executed. For example when we add a new user or new product than
