SQL Saturday #168 - Tampa BI Edition
A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.
2012-11-16
1,605 reads
A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.
2012-11-16
1,605 reads
A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.
2012-11-06
5,763 reads
SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.
2012-11-02 (first published: 2012-10-25)
3,899 reads
Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.
2012-10-16 (first published: 2012-09-13)
5,790 reads
Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar.
Wednesday, October 17 2012 4:00pm - 5:00pm BST
2012-10-15 (first published: 2012-09-20)
5,512 reads
A free one day training event in Salt Lake City, Utah on Oct 20, 2012.
2012-10-11
2,057 reads
Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.
2012-10-08 (first published: 2012-09-27)
5,894 reads
A short interview with Sundar Raghavan of Amazon Web Services about SQL Server and their support and offerings of cloud data services.
2012-09-27
1,586 reads
Win one of two $50 Amazon vouchers by entering our database management survey. We’re finding out more about how SQL database professionals are doing backup and recovery, using cloud services and more. Answer the short survey for a chance to win.
2012-09-27 (first published: 2012-09-24)
2,706 reads
A database security survey for a CS student. If you can spare a few minutes, I know he'd appreciate it.
2012-09-26
2,132 reads
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.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
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...
Comments posted to this topic are about the item Your AI Successes
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