Wednesday, August 8, 2012
So the price is still right - and yes, it's free! Marina my colleague from work sent me a really great link so obviously I had to share it with all of you. In his blog about Microsoft SMS&P Partner Community Blog, Mr. Eric Ligman has published a very extensive list of free Microsoft eBooks on SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more. The list is very comprehensive and I recommend you go over it and also look at the additional post he's linking to for even more eBooks...
Saturday, July 28, 2012
I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...
Tuesday, July 3, 2012
This is a summary of a lecture given in the last BI User Group meeting in Israel by Mr. Itay Braun:
SSAS will give you better performance on top of a DWH of a few Terras (2+) rather than Tabular mode. That's because of the data summary and compression SSAS does to the data. Tabular is not necessarily faster than MOLAP.
Tabular mode is a new DB engine with 2 possible modes of interaction:
1. Tabular Mode
- Column store
- In memory
- Compression (~1:3)
- All the data copied
2. Direct SQL
- Queries translated into SQL running against the SQL DB
- Serves as Tabular mode's...
Tuesday, June 12, 2012
Via BI/BPM - The SeeQueL, I have recently learned of a great new site I would like to share with you: MSBIAcademy. MSBIAcademy is a site created by Rob Kerr, SQL Server MVP and CTO at BlueGranite. The site currently offers lessons on: Excel, Integration Services, Data Warehouse Design, SQL Server, Mobile, SharePoint, Analysis Services (both Tabular and Multidimensional) and PowerView! Quite the impressive list. Most lessons are on the latest version of SQL Server, but guide lines given in them are true for earlier versions as well.
I highly recommend you check out MSBIAcademy as in short lessons of...
Monday, April 30, 2012
In a short newspaper article a friend stumbled upon, he saw that Mr. Kamal Hathi, Director of Program Management at Microsoft is coming to Israel for the Think Next Convention. It was also detailed that Mr. Hathi was responsible for the SQL Server Business Intelligence technologies. As the time of the convention drew nearer, I felt more and more interested in trying to catch him for an interview about SQL Server 2012.
At the end, I had to finish my questions quickly as Mr. Hathi did not stay till the convention, but I did feel like I had quite...
Sunday, March 18, 2012
PASS are offering 24 Hours of PASS with 24 consecutive technical webcasts - all free and require only registration. The date for you to mark is March 21st 2012, depending on your time zone. This time around includes closed captions in 15 different languages. Sessions in 24 Hours of PASS are very SQL Server 2012 oriented and very varied in topic with something for everyone, ranging from: Tier-1 BI in the Age of Bees and Elephants - with Denny Lee, SQL Server 2012 Memory Management - with Neil Hambly, What to Look For in SQL Server 2012 Execution Plans...
Monday, March 12, 2012
SQL Server 2012 was released last weekend (and yes, I know this means I’m late to blog about it!). Along with it were released the Data Mining Add-In for Excel 2010 (with a 64 bit version) and PowerPivot v2.0. Whether your company just bought SQL Server 2012, you downloaded the Express Edition or the Evaluation, you could probably still use some help. The ”Introducing Microsoft SQL Server 2012 (second DRAFT preview)” EBook was released in January and is free to download – enjoy!
Tuesday, January 31, 2012
As SQL Server 2012 and PowerPivot v2 release is getting closer and closer, knowing DAX becomes more of a necessity than a just an option. Via Kasper de Jonge’s blog I had learned of a nice 30 minutes Introduction to DAX basics. You can download an example workbook and try your hand at creating a measure formula and adding up to adding filter context to your formula. The post also had a ling to the TechNet Wiki page for the DAX Resource Center which has loads of articles, downloads and videos, along with link to other blogs and sites...
Wednesday, January 25, 2012
I was in the BI User Group meeting today (and if you're in Israel, why didn't you come too?) and heard something quite exciting. The speaker was Yossi Elkayam from Microsoft Israel and what he mentioned twice was that the release date for SQL Server 2012 Denali is March 2012. He was saying that while stating next month's meeting will preview the new release scheduled for the month after that. He also mentioned that PowerPivot version 2 will be released in proximity to the release of SQL Server 2012 Denali. This was some really exciting news for me because...
Tuesday, November 8, 2011
has recently announced the SQL Server 2012
The main news is the new BI edition released with SQL Server 2012 which is
positioned between the Standard edition and the Enterprise edition. You can
read an SQL Server 2012
on the Adatis blog which lists the pros and cons of the new edition and payment
method. Amongst other things, they point out that:
Business Intelligence edition strips away
- Advanced Security (Advanced
auditing, transparent data encryption)
and provides a cut-down, basic (as opposed to advanced) level of High
felt like I read mostly good feedback from different bloggers on the matter,