Prologika Forums

Making sense of data

Prologika (Teo Lachev's Weblog) » All Tags » SQL Server 11 (RSS)

Browse by Tags

Blogs

Prologika (Teo Lachev's Weblog)

Home

Books

Learn PowerPivot and Analysis Services-Tabular at your own pace with our latest book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling). It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.

For more information or to register click here!

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

SQL Server 2012 Semantic Search

Suppose your company has a web application that allows customers to enter comments, such as to provide feedback about their product experience. How do you derive knowledge from these comments? Perhaps, customers are complaining a lot about a particular...

Published Sun, Feb 10 2013 7:16 PM by tlachev

Filed under: SQL Server 11
Book Review “Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model”

I've recently had the pleasure to read the book "Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model" by Marco Russo, Alberto Ferrari, and Chris Webb. The authors don't need an introduction and their names should...

Published Sun, Nov 25 2012 8:04 PM by tlachev

Filed under: Analysis Services, Books, SQL Server 11
SharePoint 2013 and SQL Server 2012

As I mentioned before, Microsoft released SharePoint 2013 and Office 2013 and the bits are now available on MSDN Subscriber Downloads. I am sure you are eager to try the new BI features . One thing that you need to be aware of though is that you need...

Published Fri, Oct 26 2012 3:50 PM by tlachev

Filed under: SharePoint, SQL Server 11
SQL Server 2012 CU3 Available

Microsoft just released Cumulative Update 3 of SQL Server 2012. Among other bug fixes, this CU includes critical fixes for columnstore indexes that we've reported to Microsoft. If you use SQL Server 2012 columnstore, you must install CU3. The important...

Published Tue, Sep 4 2012 8:07 AM by tlachev

Filed under: SQL Server 11
Finding Reporting Services Service in SharePoint

SharePoint is a like an ocean – the further you go, the deeper it gets Ancient proverb Scenario : Configure SQL Server 2012 Reporting Services on a multi-server SharePoint farm with the following topology: WEB1 – Web front-end Server 1 WEB2...

Published Fri, Mar 2 2012 4:47 PM by tlachev

Filed under: Reporting Services, SharePoint, SQL Server 11
Subscription and Alerts Issues with Analysis Services in SQL Server 2012

As you probably now, Reporting Services doesn't allow you to create subscriptions with data sources that use Windows security because subsbscriptions are run in unattended mode. Moving to SQL Server 2012, we'll add Data Alerts to the list. This...

Published Tue, Jan 17 2012 8:08 AM by tlachev

Filed under: Reporting Services, Analysis Services, SQL Server 11
Using the Hash Group Hint to Speed up ColumnStore Indexes

As I mentioned in my blog post on this subject, I've found a good use of SQL Server 2012 columnstore indexes to speed up significantly ETL processes that need to aggregate large datasets. But we run into a snag, which got promoted to a bug by Microsoft...

Published Tue, Dec 20 2011 10:52 PM by tlachev

Filed under: SQL Server 11
Columnstore Indexes To Speed ETL

SQL Server 2012 introduces columnstore indexes. Using the same in-memory VertiPaq engine that powers PowerPivot and Analysis Services Tabular, columnstore indexes can speed up dramatically SQL queries that aggregate large datasets. For a great introduction...

Published Wed, Dec 7 2011 7:48 PM by tlachev

Filed under: Integration Services, SQL Server 11, Data Warehousing
What's New in Power View RC0

I was just about to write a blog about the new features in the Release Candidate (RC) build of Power View and I saw that Robert had written a great blog already. It's great to see the product coming along so nicely. Can't wait to be able to use...

Published Tue, Nov 22 2011 8:29 PM by tlachev

Filed under: Reporting Services, SQL Server 11
SQL Server 2012 RC is Here

The public release of Microsoft SQL Server 2012 RC0 is now available .

Published Fri, Nov 18 2011 8:06 AM by tlachev

Filed under: SQL Server 11
PowerPivot for Excel SQL Server 2012 RC0 is Here

Microsoft just published the RC0 (release candidate) bits of PowerPivot for Excel SQL Server 2012. Kudos for Microsoft for making the RC bits public this time. Stay tuned for an announcement for the arrival of the SQL Server 2012 RC bits soon. The RC...

Published Thu, Nov 17 2011 2:12 PM by tlachev

Filed under: Business Intelligence, PowerPivot, SQL Server 11
Report Server Settings in SQL Server 2012 SharePoint Integration Mode

Well, rules have changed. As Jaime Tarquino from the SSRS team explained in his blog , "SQL Server 2012 Reporting Services SharePoint Integrated Mode", there is no rsreportserver.config file anymore moving to Reporting Services 2012 in SharePoint...

Published Tue, Nov 15 2011 8:19 PM by tlachev

Filed under: Reporting Services, SharePoint, SQL Server 11
Business Intelligence Edition in SQL 2012

To expand on my announcement about SQL Server 2012 editions, I welcome the new BI edition for the following reasons: The BI edition will include all BI features, including features that would previously require an enterprise edition, such as SSAS partitioning...

Published Fri, Nov 4 2011 1:37 PM by tlachev

Filed under: SQL Server 11
SQL Server 2012 Licensing and Editions

Microsoft has spoken about SQL Server 2012 editions and licensing. We now have a brand new BI edition. http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx

Published Thu, Nov 3 2011 5:12 PM by tlachev

Filed under: SQL Server 11
Reporting Services Data Alerts

SQL Server 2012 introduces a Reporting Services feature called Data Alerts. Data alerts notify a selected list of recipients about data changes on the report. Behind the scenes, data alerts use the report data feeds feature which was introduced in SQL...

Published Sat, Oct 29 2011 8:11 PM by tlachev

Filed under: Reporting Services, SQL Server 11

1 2 Next >

Powered by Community Server (Commercial Edition), by Telligent Systems

3DZL:andrewbelon.com