Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
7 reads
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
7 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
112 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
9 reads
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database...
2019-02-07
835 reads
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database and their own custom web app. They want to...
2019-02-07
20 reads
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More...
2019-01-23
157 reads
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More often than not this leads to the “not seeing...
2019-01-23
6 reads
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read...
2019-01-04
152 reads
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...
2019-01-04
6 reads
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
125 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
Comments posted to this topic are about the item JSON Has a Cost, which...
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
exec('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