Skip to main content

Posts

Students Project ACKNOWLEDGEMENT format

ACKNOWLEDGEMENT It is our pleasure to present this project report on Abc First of all, let us thank Mr. TDN, the principal of XYZ Institute , for his  kind consideration. I express my deep gratitude and sincere thanks to the Head of the Department of Computer Technology of XYZ Institute ,Prof. TTT for his encouragement and support throughout the project.  I express my profound  gratitude to our project guide Mrs. yyy for her support given to us. We would like to give our sincere thanks to our ABC Technology staff of XTZ who lead us to satisfactory and timely completion of the project with their great technical support. We hope our work would be taken as a step towards the improvement of the present  condition.

Interview Cracking Steps and common questions

Interview Cracking Steps 1) Resume : Mention all the skills and achievements. Be true to yourself and do not exaggerate. Develop good command on all the topics which you have mentioned in the resume.  Review your resume thoroughly and make sure it is error free and properly formatted. 2) List down the topics which you are strong at. Leverage this point to highlight your skills during your interview. Show your contributions as a team member which help to perform tasks easier. 3) List down the topics which you are weak at 4) Make a note of your recent achievements like issues, new implementations, automation, standardization and documenting. Make sure you have some stories to tell. This will help in giving a good idea about your skills and the interview would be held in these areas mostly. Interview: Common questions 1) Tell me about yourself- Make sure you are well prepared for this. This gives and idea about yourself as well as you communication skills. 2) Tell me the

SQL Queries from Multiple tables and Questions

Question -Employee_Details EmpID NVARCHAR(10) Emp_FirstName NVARCHAR(100) Emp_LastName NVARCHAR(100) DateOfJoining Datetime Employee_Salary EmpID NVARCHAR(10) Refers to Employee Details PayPeriodId INT Refers to Master_PayPeriod SalaryAmount Money DateofSalaryCreditedtoAccount Datetime Master_PayPeriod PayPeriodID INT PayMonthYear Datetime Employee Details Sample Data 000001 ABC XYZ 01-Jan-2000 000002 Rahul Y 13-Dec-2000 000003 Amit S 12-Apr-2000 000004 Shobit K 01-Jan-2000 000005 Harshit J 13-Dec-20

Error code 9002 Log file is full in SQ 2012

This is sample of queries to check in MS SQL 2012 How to Fix Error "ERROR 9002 LOG FILE IS FULL" You can check following way.

Fixed Microsoft SQL Server Error 18456 Login Failed for User sa

If you are getting Microsoft SQL Server Error 18456 Login Failed for User sa error to connect with system admin (SA) Login. Then you can apply below step to resolve this issue Go to SQL Server Properties - Security - Server Authentication section- check Sql Server and Windows authentication mode After that restart SQL server services then it will work fine.

PMP Eligibility-Project Management Professional Certification

ERP

What is SQL and Database?

SQL TOP, RANK, ROW_NUMBER ,DENSE_RANK Functions

To use  SQL TOP, RANK,  ROW_NUMBER ,DENSE_RANK Functions  you can see below image. Select top 5 records from table. In below query We used SQL TOP, RANK,  ROW_NUMBER ,DENSE_RANK .You can check this with your table.

Top 20 SQL Query Interview Question to learn

Clips for Power BI With data connect,Database Shrinking, Cube Deployment in Ax 2012

Tips to Free Up Disk spaces Default Cube Deployment in Ax 2012 Power BI With data connect Data base Shrinking Enable database log on table in Axapta