March 21, 2018

Simple way to convert English Number to Arabic Number in Programming.

There is a Simple way to convert English Number to Arabic Number in Programming.

1. You need to create one table where you can store Arabic and English Number in following Manner.

Arabic Table

2. Second step is to create function to convert value from English number to Arabic on which you pass number as string and replace English number to Arabic but referring above table.

3. After that return value from function and utilize that variable to your report.

4. I hope you will get idea to make program to get Arabic number from English number.

Apply Monopoly to become successful person in business and Job

You can watch to Apply Monopoly to become successful person in business and Job. If you achieve monopoly it means you have got end key to get success in life.

I want to share small clip or view that how Monopoly can change your life to become successful person .

There are Competition in all area but one reason can change your business which is monopoly .

Monopoly is difficult but if you think about your ability then you can achieve it to get your end key of success.

February 22, 2018

How to Get different places for Microsoft Dynamics Axapta Financial Dimension

How to Get different places for Microsoft Dynamics Axapta Financial Dimension. Its easy you can go to module and edit the form and you can check financial dimension tab in form like item master,AR, AP, Production control etc.

I am sharing practical clip here to check the same. If you like this then please do not forget to subscribe on youtube.

December 13, 2017

How to create View using Union query from one database to another database in SQL

To create View using Union query from one database to another database in SQL you can get hints from below example its very simple your column should be the same type and number of the column should be same to create union query view.

 USE [TestDB]  
 Create VIEW [dbo].[Test_FinancialDimension]  
       SELECT   [key_]  ,[NAME] ,[Value]   FROM MicrosoftDynamicsAX.dbo.dimattributecompanyinfo  
   FROM MicrosoftDynamicsAX.dbo.DimAttributeOMCostCenter  
      -- SELECT  [key_] ,[NAME],[Value]  FROM MicrosoftDynamicsAX.dbo.DimAttributeHcmWorker  
   FROM MicrosoftDynamicsAX.dbo.DimAttributeOMBusinessUnit  

November 22, 2017

Computer memory measurement details

Following are the Computer memory measurement details

0 or 1=1bit

8 bits = 1Byte

1024 Bytes =1 Kilobyte

1024 Kilobytes =1Megabyte
1024 Megabytes = 1 Gigabyte
1024 Gigabytes = 1 Terabyte
1024 Terabytes =1 Petabyte
1024 Petabytes =1 Exabyte
1024 Exabytes =1 Zettabyte
1024 Zettabytes=1 Yottabyte

1024 Yottabytes=1 Brontobyte
1024 Brontobytes=1 Geopbyte

Geopbyte is the current highest memory measurement.

September 22, 2017

Observing Tables sizes Records and Free space on SQL server database

I want to share one clip which will show you how to check each Table size for all tables, Total Number of records, Disk usage on tables, free spaces for tables in SQL Database.

You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables.

Just visit this clip to get all details.

September 4, 2017

IT Security:Information Technology Security tips and trick

Protect what matters

Prioritize your most sensitive accounts.
  • Email
  • Online banking and other payment websites
  • Amazon and other eCommerce website you use for shopping like flipkart
  • Any account where you’ve put in your card details
  • Any account that has sensitive info (social security number, address, phone no., etc.).
  • Secure them with strong passwords + two-factor authentication.

Always check for the website before sharing your personal data

Before you rush into filling in any sensitive data, such as personal information or credit cards details, make sure that you’re on a secure connection. Otherwise, your data can be accessible to anyone who knows how to get it.

How can you check that? It’s easy:
Look at the address bar. Does the link start with “https” instead of “http”? The extra “s” means that the website has a valid Secure Sockets Layer installed (short for “SSL“). This is a method to ensure that the data sent and received is encrypted and the online transaction isn’t intercepted in transit. It’s not something compulsory, but most legit websites will obtain SSL digital certificates. 
Another method is to look for the icon of a closed padlock. It’s usually located on the left of the web address, but it depends on the browser you’re using. Some browsers will also highlight the address bar in green. These are indicators that you are visiting an encrypted site and the connection is secure.

Online shopping safety  

  • Never do it from a device that isn’t yours or on a network you don’t own.
  • Your data could be copied and harvested by cyber criminals.
  • Make sure you’re spending your money by using safe network
  • Employing strong passwords 
  • Be careful about which websites you shop at
  • Never save your card details in an online account
  • Verify your transactions weekly to make sure there’s nothing fishy going on.

August 8, 2017

Security Awareness for your laptop,PC ,Mobile devices

1. Do NOT open any Email attachments from unknown sources like exe files , whether on your your own personal email accounts such as Yahoo, Gmail, etc. 

2. Do NOT click on any Links , sent from unknown sources, either via Emails or accessing your Facebook account.  Also, please refrain from accessing unknown Web Sites.  These can be infected with Ransom ware virus

3. Do NOT Disable your Anti-Virus under any circumstances .

4. Take regular  Backup of all your important Data and files .

5. Update all Patches - Antivirus, Operating System ,soft wares,Internet explorer etc MS Office, etc.

6. If you are unable to open any of your files that you use, please follow the instructions 
 If you notice any suspicious activity on your pc / laptop / laptop is running too slow, immediately disconnect your laptop from the network, shut off your pc / laptop

7. If you use / share any External Drives such as USB Thumb drives ,USB Hard Disks,CD,DVD etc please SCAN them with the Antivirus before using them.

June 2, 2017

Famous things to buy for KSA Visiting

Famous things to buy in  Saudi Arabia ,Places and Useful Information

1.Souks is The traditional open air markets, its an old markets of Jeddah along the Red Sea.You can buy  at Al-Basha Market for gold and precious jewels . in Jeddah,The Souk Al Nada is one of the oldest shopping streets  to buy gold, textiles, clothing, jewelry etc.

2. Bateel is good and modern dates and chocolate shops.

3. You can also buy carpet, some antiques ,traditional dress for women  in Saudi Arabia.

4. You can also buy local traditional perfume stores where Abdulsamad Atarjee is famous one.

5. You can also buy gold from Al faisaliah mall, kingdom tower mall and Al nemr mall etc.  But for reasonably priced gold jewelry, try to go to Batha, Filipino market,Deira ec.

6.If you are looking diamonds, then you can visits good jewelry stores in olaya.

7. If you want to buy tobacco,cigarette,paan etc in Jeddah then you can go to Al-Sharafiya market, Jeddah there you can get some shops.

8. If you are veg and visiting Jeddah then you can visit metro hotel ,village,jum jum hotel,India gate hotel in Jeddah there you can take good veg food.

9.Al-Balad Market, Jeddah is A beautiful historic place in Jeddah.If you are looking for deals and discounts then l-Balad Market is best place.You can find good watches, electronics, prayer mats, textiles,perfume ,dates and chocolate etc

10.Grand Al Saha,at Madina road, Saudi business center is good hotel to stay 270 SAR for single person room if you are 2 person then its 360 SAR charges for double bed single room.

May 14, 2017

TOP 10 facts You need to Know about India

TOP 10 facts to Know about India

Famous and Historic Places to visit In India

1. The Red Fort, Delhi
2. The Taj Mahal, Agra
3. Pangong Lake, Ladakh
4. Valley of Flowers, Nainital
5. Jaisalmer Fort, Jaisalmer
6. Ruins of Hampi, Karnataka
7. Ghats at Varanasi, Uttar Pradesh
8. Backwaters, Kerala
9. Old Goa, Goa
10. Umaid Bhavan Palace, Jodhpur
11. Jama Masjid, Delhi
12. Akshardham Temple, Delhi
13. Old Bombay, Mumbai
14. Ajanta and Ellora Caves, Aurangabad
15. The Golden Temple, Amritsar
16. Charminar, Hyderabad
17. Amber Fort, Jaipur
18. Rashtrapati Bhavan, Delhi
19. Mahabodhi Temple, Bodh Gaya
20. Meenakshi Amman Temple, Madurai
21. Khajuraho Temples, Chattarpur
22. Elephanta Caves, Mumbai
23. City Palace, Udaipur
24. Havelock Island, Andamans
25. Tirupati, Chittoor
26. Tawang Monastery, Tawang
27. Kaziranga National Park, Assam
28. Kesaria Stupa, Kesaria
29. Palitana Temples, Bhavnagar
30. City Palace, Jaipur
31. Sun Temple, Konark
32. Rani Ki Vav, Patan
33. Chaturbhuj Temple, Orchha
34. Cellular Jail, Port Blair
35. Borra Caves, Vishakhapatnam
36. The Ridge, Shimla
37. Tso Moriri Lake, Ladakh
38. Mysore Palace, Mysore
39. Bangalore Palace and Grounds, Bangalore
40. Gwalior Fort, Gwalior
41. Bhimbetka Rock Shelters, Raisen
42. Victoria Terminus (Chattrapati Shivaji Terminus), Mumbai
43. Jagannath Temple, Puri
44. Lingaraja Temple Complex, Khurda
45. Udayagiri Caves, Bhopal
46. Qila Mubarak, Bhatinda
47. Jallianwala Bagh, Amritsar
48. Chhatrapati Shivaji Maharaj Vastu Sangrahalay, Mumbai
49. Lake Palace, Udaipur
50. Ghats and Old City of Pushkar, Pushkar
51. Ranakpur Jain Temple, Ranakpur
52. Bada Imambara, Lucknow
53. Fatehpur Sikri, Agra
54. Humayun’s Tomb, Delhi
55. The Great Stupa, Sanchi
56. Jantar Mantar Observatory, Jaipur
57. The Great Living Chola Temples, Thanjavur
58. Mahabalipuram, Kanchipuram
59. Agra Fort, Uttar Pradesh
60. Cave Temples, Badami
61. Nalanda University, Bihar Sharif
62. Junagarh Fort, Bikaner
63. Cooch Behar Palace, Cooch Behar
64. Nizamat Imambara, Murshidabad
65. Belur Math, Belur
66. St. Paul’s Cathedral, Kolkata
67. Akbar’s Tomb, Agra
68. Chota Imambara, Lucknow
69. Sundarbans National Park, South 24 Parganas
70. Makkah Masjid, Hyderabad
71. Ramanathaswamy Temple, Rameswaram
72. Basilica of Our Lady of Good Health, Velankanni
73. Marina Beach, Chennai
74. Gagron Fort, Jhalawar
75. Sariska Tiger Reserve, Alwar
76. Gateway of India, Mumbai
77. Kumbhalgarh Fort, Rajsamand
78. Ranthambore National Park, Sawai Madhopur
79. Mehrangarh Fort, Jodhpur
80. Munnar Hills, Idukki
81. Loktak Lake, Moirang
82. Kodaikanal Lake, Kodaikanal
83. Nainital Lake, Nainital
84. Jaigarh Fort, Jaipur
85. Jim Corbett National Park, Nainital
86. Dharamshala, Kangra
87. Laxmi Vilas Palace, Vadodara
88. Gir National Park, Junagarh
89. Marine National Park, Gulf of Kutch
90. Tughlaqabad Fort, Delhi
91. Pattadakal, Bagalkot
92. Bishnupur Temples, Bankura
93. Monuments at Mandu, Dhar
94. Shalimar Bagh, Jammu and Kashmir
95. Lotus Temple, Delhi
96. Kakatiya Temple, Warangal
97. Silent Valley National Park, Palakkad
98. Srirangapatna, Mandya
99. Purana Qila, Delhi
100. Chittorgarh Fort, Chittaur

May 3, 2017

SQL Server Tips for Memory usage,replication,CU updates etc

1. To check which user is taking maximum memory usage in SQL 2014 You can try below command

select * from sys.sysprocesses


2. How to rename a column in subscription table in replication

You have to remove from replication: Rename. and then re-add to replication

3. Clear cache in SQL for TempDb.



 4. How to install the Service pack 3 on server,This is my recommendations .

Server: SQL server 2012 standard edition having sp1 and you want to install the SP3 and CU 7 at a time ?

Then you can install SP3 and check if that covers CU 7 as well, if not then you can install CU 7 after the SP3 Successfully installed.

But make sure to take the DB Backups prior to proceed

5. Resolve Authentication Error for Mailbox in SQL

Error is Mailbox unavailable. The server response was: Authentication is required for relay
in SMTP server

If You are providing the server address like Server ip without login details that means It is Anonymous authentication type.

The issue mentioned in this post as the SMTP doesn't allow anonymous authentication.

You need to  provide the credentials to authenticate to SMTP Server.