SQL Server Education (by the geeks, for the geeks)
In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and PowerView add-ins …
PowerPivot and PowerView now available in Excel 2013 Read MoreTo get comma separated list in SQL as well as in MDX use below queries. 1 – SQL Select Name from Sales.SalesReason GO Select Name from Sales.SalesReason SELECT SUBSTRING ( ( …
Get comma separated list in SQL and MDX. Read MoreWhy we need to change the Look & Feel of the Report Manager? Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can …
SQL Server – Change the Look & Feel of the Report Manager. Read MoreWhile replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. 1- Certain data like aggregated data from MDX Query. …
SQL Server – SQL+MDX in one Apartment (Hybrid Query). Read MoreVertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 …
SQL Server – VertiPaq Engine Renamed as xVelocity in SQL Server 2012. Read MoreOnce you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools. Comparison of SQL Server …
No More BIDS Exist in SQL Server 2012 Read More