In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start menu. It is not necessary to run the wizard, you can do everything yourself using the standard SharePoint configuration wizards. However, using the Configuration Wizard will install some extra components, such as scheduled data refresh, data providers and very important: the PowerPivot Management Dashboard.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as "the PowerPivot instance". The first step is to create a service account for this instance. I named it SP2013BISPPowerPivot. The next step is attaching the SQL Server image to our virtual machine and launching the SQL Server setup. Go through the usual steps of the setup wizard until you need to choose the installation type.
Just got a question on my A first look at sequences in SQL Server Denali post. The question is the following: How can you add a new column to existing table (already populated) and make it a sequence column? Let’s take a look. First create this very simple table CREATE TABLE bla (id INT) INSERT BLA VALUES(1) INSERT BLA VALUES(2) INSERT BLA VALUES(3) INSERT BLA VALUES(4) INSERT BLA VALUES(5) What you want to do is have the sequence start at 6, here is how to do that.
Time for this week’s puzzle/teaser. I want to return the results in ascending order but without using ORDER BY If you run this code CREATE TABLE Puzzle (Col1 varchar(20) NOT NULL PRIMARY KEY CLUSTERED, Col2 varchar(20) NOT NULL UNIQUE NONCLUSTERED); INSERT INTO Puzzle (Col1, Col2) SELECT 'Z', 'AA' UNION ALL SELECT 'A', 'BB' UNION ALL SELECT 'B', 'CC' UNION ALL SELECT 'C', 'DD' UNION ALL SELECT 'M', 'EE'; SELECT Col1 FROM Puzzle; DROP TABLE Puzzle; you get these results
Let's get started with the next step in the series: installing SharePoint. We will install only the software, but we do not configure it. We will do this later with the PowerPivot Configuration Tool, which is explained in another blog post. The first step is to create a farm account. This is the most important account in your SharePoint environment. I made this account administrator on the virtual machine and also sysadmin in the SQL Server instance.
In this blog post we'll go over the installation of the SQL Server instance. This database engine will serve multiple purposes: it will host the SharePoint databases, the Reporting Services databases, the SSIS catalog and of course databases containing demo data. First of all we are going to enable the .NET 3.5 framework, which is a prerequisite for SQL Server. You can find a description on how to enable this feature in this earlier blog post of mine: Error while enabling Windows Feature: Netfx3.
This part of the series will focus on installing the Windows Server 2012 OS on the virtual machine. In most cases, you have an image file with the installation media available. In the VM settings, go to the DVD drive and attach the image. Now start the VM. While the VM is starting, connect to it using the Hyper-V manager. A window resembling a remote desktop connection opens (remark however that this window is not the same as a remote desktop connection).
Today is the five year anniversary of LessThanDot. Although Chrissie already blogged about it here: Lessthandot turned 5 today, I decided to do a post as well. This site was started by some friends and myself. Initially we were just people who met online, after starting the site we decided to meet in person. Here is a picture of one such meeting, as you can see we are all the same height 🙂
This site went live on the first of june 2008 after more then a year of preparation. And now the difficult part begins. According to about.com. For a 5-year-old, there will be many steps forward as well as steps back as she navigates new challenges and broadens her world. We have changed servers a couple of times since she was born. We even changed providers since then. We welcomed new members and we lost members.
Microsoft has made available the SQL Server 2012 System Views Maps for download The Microsoft SQL Server 2012 System Views Map shows the key system views included in Microsoft SQL Server 2012, and the relationships between them. The map is similar to the prior versions of Microsoft SQL Server System Views Maps and includes updates for the Microsoft SQL Server 2012. Note that not all possible relationships are shown.