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,720 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
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,955 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,429 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
780 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
9,080 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)
13,158 reads
2013-04-10
10,718 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,502 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
847 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,630 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers