Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2013-07-16
1,104 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
T-SQL Tuesday #44: The second chance
This month’s T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is...
2013-07-09
661 reads
SQL 2014 CTP1, where is my BIDS?
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...
2013-06-28
4,512 reads
Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site
In the final part of this series, we will create a BI subsite in our site collection. You can use...
2013-06-12
3,080 reads
Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services
Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in...
2013-06-11
4,699 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,300 reads
Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works...
2013-06-10
4,077 reads
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,207 reads
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,399 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,124 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