Software Applications Programming Errors and solutions.

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

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.

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.

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 install

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 bef

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 v

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 Cav

1. To check which user is taking maximum memory usage in SQL 2014 You can try below command select * from sys.sysprocesses sp_who2active 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. RUN THIS COMMAND ON TEMPDB  DATABASE ONLY DBCC FREEPROCACHE  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

1. 11.0.3368.0  Full version name  Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64)  May 22 2013 17:10:44  Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) 2.11.0.3128.0 Full version name  Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)  Dec 28 2012 20:23:12  Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) Remarks:- Version  11.0.3368.0 include Hot Fix for Microsoft Knowledge Base article number(s) 2833645 for  Microsoft SQL Server 2012 (SP1) 64 bit server-pack 1 This hotfix is also known as CU4 for SQL. You can search on google with name  KB2833645 to find download for this. 11.0.3128.0  this version is standard installation excluding CU4.

If you are search for some information about Power BI then Important points I am mentioning here for Power BI. Its just idea. Power BI 1.Power BI can connect to your cube and create report and view. 2.Power BI free but  pro edition(included refresh data option in pro license) 3.Power BI can connect by any device mobile ,laptop etc 4.Power BI can connect to real time data for dashboard. 5.Power BI can connect to premises data like axapta,your excel ,sql ,oracle data etc 6.Tools is POWER BI Desktop 7.Cost is 10 $ per user per month probable it may increase or decrease time to time. 8.Enterprise gateway used to linked data to organization.

Management Reporter 2012 Configuration Console . If you are facing issue in MR Url for particular user then you can publish MR server connection from configuration console using below steps. Choose the relevant ERP integration: From the menu in the right window, choose the   Publish server connection : You are probably prompted to enter the login credentials for the service user, enter them and all should go well: The server address should now be updated!

If you are trying to configure to send mail by code or any application through office 365 then setting of port is as below.

Cross join Each row from testtable1 will return with each row from testtable2 because there will be no join condition. without joining condition we can return multiple data from tables using cross join,but cross join based on  Cartesian  product.it will return total rows,for example employee table has 14 rows,dept table 4 rows,14*4=56 rows it will return. use to retrieve the data from more than one table with out any condition.no need to have any common column b/w to apply this join.because,20 employee and 4 dept so 20*4=80 it will return the 80 rows selected. This kind of thing is called as Cartesian Product. If where clause is used with CROSS JOIN, it works like an INNER JOIN in query . SELECT     col1,col2,col3 FROM       testtable1 CROSS JOIN     testtable2 Inner join SELECT     col1,col2,col3 FROM       testtable1 INNER JOIN     testtable2 ON testtable1.id1= testtable2 .id1 These 2 examples will return the same result: Cross join select * from testt