On Thursday April 19th 12PM noon Central, Todd McDermid will discuss "SSIS components for Data Warehouse Dimensional data processing".
2012-04-18
1,888 reads
On Thursday February 16th at 12PM noon Central, Steve Simon will discuss “No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2012-02-16
1,409 reads
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2011-11-17
1,229 reads
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
2011-08-18
754 reads
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
2010-12-07
984 reads
More Free Training is coming to a computer near you from the AppDev, BI, and DBA Virtual Chapters of PASS.
2010-10-12
992 reads
The DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training. Here's what they have on tap for you this week:
2010-09-21
719 reads
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
2010-08-06
1,762 reads
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
2010-07-13
554 reads
Steve Jones talks about the PASS Board of Directors election coming up this fall and hopes some of you will apply.
2010-06-10
61 reads
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
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