Browsed by
Category: SQL Server

Announcing the new ITUnity web show: BIFocal

Announcing the new ITUnity web show: BIFocal

I was sitting in the speaker room at SharePoint Fest Seattle having a Skype chat with John White. We were collaborating on some Business Intelligence content that we could deliver at conferences either together or independently, but still ensure that we were providing a consistent message. At some point during this chat one of us suggested that this amusing & informational back and forth that we were having would make for a pretty decent podcast. Dan Holme, CEO of ITUnity,…

Read More Read More

SQL Server 2012 SP1 is here & it’s huge for SharePoint 2013 BI

SQL Server 2012 SP1 is here & it’s huge for SharePoint 2013 BI

This is a massive deal for SharePoint 2013 BI.  Here is an excerpt from What’s New in SQL Server 2012: “Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013 ) Business Intelligence highlights (with SQL Server SP1, Office and SharePoint Server 2013 Preview) are: Enable self-service BI as a natural part of users day-to-day activities in Excel 2013: Access and mash-up data from any source (PowerPivot). Documentation related to PowerPivot in Excel 2013 (http://go.microsoft.com/fwlink/p/?LinkID=255958). Stunning visualizations…

Read More Read More

PowerPivot & Claims Based Authentication–Is there hope in SQL 2012?

PowerPivot & Claims Based Authentication–Is there hope in SQL 2012?

I promised an update on this in my previous article and it is time to share what I have learned. The issue: As many of us have painfully found, PowerPivot v1 on a Claims Based Authentication web application is not supported in SharePoint 2010.  I had a case open with Microsoft last year that had the aspirations of rectifying that situation.  We had hoped that working with the PowerPivot team (a part of the SQL Server Product team) and the…

Read More Read More

The SQL Server 2012 Launch is almost here!

The SQL Server 2012 Launch is almost here!

We are a mere 2 days away from the Virtual Launch of SQL Server 2012 and there is a ton of great information & free training (and some pay for) that is primed and ready to go for us to digest. Here is a list of some of the events that you can partake in: SQL SERVER 2012 VIRTUAL LAUNCH EVENT This is it people! What we have been waiting so long for has finally arrived. There is a full…

Read More Read More

SQL Server 2012 Release Candidate is here!

SQL Server 2012 Release Candidate is here!

We are creeping slowly toward the release of SQL Server 2012 and all of its new, fun features for SharePoint 2010!  The first Release Candidate of SQL Server 2012, known as RC0, dropped today and is publicly available for download.   Here are a some links worth checking out: Download SQL 2012 RC0 – Get the software here! SQL Server 2012 Release Candidate is now Available! – SQL Server Reporting Services Team Blog Announcing Microsoft SQL Server 2012 Release Candidate 0…

Read More Read More

SQL Server 2012 Announcements & a new Blogger

SQL Server 2012 Announcements & a new Blogger

The big news of the day in the technology world… no, not the Blackberry outage… no, not iOS 5 being released…  the big news about SQL Server Code Name: “Denali” becoming official SQL Server 2012!  Product release is slated for the first half of 2012 (not specifically Q1 as many of us had hoped) Project Crescent has been rebranded as Power View and announced that there will be a browser based version that will work on iOS & Android devices,…

Read More Read More

What’s new in SQL Server Code Name “Denali” CTP3

What’s new in SQL Server Code Name “Denali” CTP3

Be sure to check out the What’s New (SQL Server “Denali”) site for full details, but here are the highlights in this PUBLIC release (no TAP NDA material here!) are: SQL Server Installation Installing Prerequisites During SQL Server Code-Named “Denali” Setup Windows PowerShell 2.0 is a prerequisite, but not installed by the SQL Server Setup wizard .NET Framework 3.5 SP1 is a requirement, but is not installed by the SQL Server Setup wizard, it  requires you to download and install…

Read More Read More

SQL Server Default Trace

SQL Server Default Trace

In every version since SQL 2005 there has been a “background trace” enabled by default on all SQL Server installations.  This was a bit of a shocking revelation to me, as I am not a DBA, since every time I have called Microsoft dozens upon dozens of times and talked to tier 3 support / product team members for SQL Server and none of them have mentioned this fact when we have been diagnosing issues in SQL.  We have always…

Read More Read More

SharePoint 2010 & SQL 2008 R2 build numbers and helpful patching links

SharePoint 2010 & SQL 2008 R2 build numbers and helpful patching links

In an effort to make life simpler I have compiled a short list of useful link to build numbers and patching sites for SharePoint 2010 and SQL 2008 R2. The Microsoft SharePoint Updates PagesSharePoint 2010 – http://technet.microsoft.com/en-us/sharepoint/ff800847.aspx SharePoint 2007- http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx This is your official sites for downloading the SharePoint updates from Microsoft.  Highly useful rather than waiting on the blogger community to send you a link, or get the TechNet bulletin, your carrier pigeon to arrive, or any of the…

Read More Read More

All PowerPivot Features supported only in Classic Mode Authentication

All PowerPivot Features supported only in Classic Mode Authentication

Surprised?  I was this week as well.  I have had a case open with Microsoft since October that we have been playing with back and forth trying to figure out why automated refreshing of a PowerPivot workbook wasn’t working.We let the case go off and on for a quite a while because in the opening days we found that if we ran the PowerPivot Service Application Pool in the context of the farm admin account, that manually refreshing the data…

Read More Read More