Skip to main content

Posts

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.

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] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create VIEW [dbo].[Test_FinancialDimension] AS ( SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.dimattributecompanyinfo union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeOMCostCenter --union -- SELECT [key_] ,[NAME],[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeHcmWorker union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DIMATTRIBUTEOMDEPARTMENT union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeOMB...

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.

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.

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. O...

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 pleas...

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 ...