Skip to main content

Posts

Difference between 11.0.3368.0 and 11.0.3128.0 for SQL Server 2012

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.

Some Important Information for Power BI Tool

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 Publish connection

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!

IMAP and POP setting for Office 365 on mail sending

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

Using CROSS JOIN vs INNER JOIN in SQL Server all version same concept

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

GST:Subsuming of Existing taxes and Meaning

GST Stands for Goods and Service Tax. Other coverage you can see on below image.

Software engineer salary Career path

This is Career path for Software.. Salary is depends on experience . I can not define salary for all level but As I am technical so I can define probable salary for Axapta Technical Experience wise. 1.Ax Fresher Technical- Starting salary should be 3.5 lacs per year and most companies use bond sign also.. 2. If person is experience for upto 3 year than salary range goes to 4.5 lacs to 7 lacs . 3 If person experience is 4 to 10 year  then salary range goes to 7 to 17 lacs.  4. If experience is more that 10 year then salary goes to 18 lacs to 25 lacs. 5. If person reached to 25 lacs then chances of salary start for decrements. Its also depend upon institute and course salary may have variation.