Report Builder in SQL Server 2014

Monday, February 9, 2015

If you've been reading this blog over time, you probably noticed quite a bit of my development was done with Report Builder. Yes, that's the report model shipped with SQL Server 2005. Though my team is currently working on SQL Server 2008 R2, we're only now starting to develop BI solutions with other tools. We're set for a bit of a headache with our Report Builder 1.0 in SQL Server 2014. Report Model has been one of a set of deprecated features on SQL Server 2012 (and obviously also on SQL Server 2014). SQL Server has released PowerView in SQL Server...

Free eBooks on SQL Server, SharePoint, Office and more

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

A Comparison between SQL Server 2012 BI Tools

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

The Tabular Model in SQL Server 2012

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

Free Lesson for SQL Server and SharePoint

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

Mr. Kamal Hathi on SQL Server 2012, PowerPivot, SharePoint and Azure

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

Free SQL Server Training With 24 Hours of PASS

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

SQL Server 2012 Released and a Free EBook

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!

Introduction to DAX basics

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

SQL Server 2012 Denali Release Date

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