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
648 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
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,502 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,076 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,692 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,295 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,069 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,200 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,391 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,118 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,712 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers