Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint
In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration...
2013-06-07
1,189 reads
Koen Verbeeck
Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks...
2013-06-06
3,384 reads
Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint
Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we...
2013-06-10 (first published: 2013-06-05)
2,282 reads
Building a SharePoint 2013 BI Demo Environment Part 3 – Installing the OS
This part of the series will focus on installing the Windows Server 2012 OS on the virtual machine. In most...
2013-06-03
1,104 reads
Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM
In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use...
2013-05-31
1,706 reads
Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction
Recently I had to give a Power View demo for a client. Giving a demonstration means of course you have...
2013-05-30
2,932 reads
T-SQL Tuesday #42: The Long and Winding Road
It’s the second Tuesday of the month, which means it’s time again for #TSQL2sday! It is the 42nd installment of...
2013-05-14
770 reads
Modify a Power View Data Source
I’m currently setting up a demo environment using SQL Server 2012 and SharePoint 2013 (more on that in later blog...
2013-05-14 (first published: 2013-05-08)
4,415 reads
Error while enabling Windows Feature: Netfx3
Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be...
2013-04-29
8,795 reads
Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
12,875 reads
Blogs
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Forums
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers