This past Thursday, February 22, AT&T had a major outage on their U.S. network. For upwards of 10 hours, hundreds of thousands of customers could not make phone calls, send or receive texts, or use mobile data for apps or browsing websites. Aside from not being able to communicate as normal, it also appeared to […]
2024-02-24
110 reads
There are a number of ways to run SQL Server for free (or low cost) for development. Read a bit about how to do this.
2024-02-23
6,607 reads
Good visual design matters, and Steve notes that his Tesla needed an update because their design didn't meet the specification.
2024-02-21
129 reads
Today is a day off from Redgate for Steve, but he's working elsewhere on this holiday.
2024-02-19
92 reads
It’s been a goal for several years to write (or help write) a book on a topic I love. While I can’t share details yet, there’s some movement on this dream and I’m excited about it. And I’m even more excited that I get to do it alongside someone that I’ve respected for a long […]
2024-02-17
85 reads
2024-02-16
251 reads
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
2024-02-14
440 reads
At Redgate, the teams change every year and Steve has a few reasons why this is good.
2024-02-12
187 reads
Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]
2024-02-10
80 reads
Today Steve wonders if you have a go-to person at work or maybe if you are that person. Or if that is even a good thing in a company. It might be better if there were more tools available to help others.
2024-02-09
430 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