Join me for Dashboards in a Day
Seats are limited – act fast!
This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...
2015-02-23
1,243 reads
Patrick LeBlanc
Implementing Tabular Data Models: Microsoft Virtual Academy
Implementing Tabular Data Models
Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models
Cost: Free!
Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)
What will you do...
2014-11-03
1,992 reads
2014-04-16
657 reads
2013-11-14
658 reads
Parameterizing an Excel Spreadsheet
I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...
2013-05-16
2,962 reads
The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports
SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...
2013-05-16 (first published: 2013-05-13)
3,433 reads
SSRS 101 – Your First Report
I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL...
2013-05-06
1,378 reads
Configuring PerformancePoint in SharePoint 2013
Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following...
2013-04-29
1,885 reads
Creating a Shared Dataset with Report Builder
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically,...
2013-04-29
2,894 reads
SQL Lunch – GeoFlow: 3D Geospatial Visualization
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Lunch Details
#75-GeoFlow:...
2013-04-25
1,426 reads
Blogs
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Using Prompt AI to Help Setup Data Analysis
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Forums
Simplifying WHERE Condition with LIKE test on multiple columns
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Which Table I
Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
Comments posted to this topic are about the item Using Python notebooks to save...
Question of the Day
Which Table I
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers