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,939 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
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,421 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
774 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,908 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,985 reads
2013-04-10
10,652 reads
How I prepared myself for the MCSE certification
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,482 reads
How I used Data Explorer to create a demo
Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...
2013-03-20
838 reads
What’s the deal with Excel & SSIS?
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,616 reads
2012-06-18
2,102 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers