This is part two in a five part series this week, Moving into Consulting 101.
Today's consulting topic is friendly advice on how to handle yourself in front of clients,...
2021-03-31 (first published: 2021-03-23)
948 reads
Introduction to this blog series
After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...
2021-03-30 (first published: 2021-03-22)
1,387 reads
Say you have a temp table and you want to see the columns names.
For example, I was trying to convert a query from using a #temp table to a...
2021-03-04 (first published: 2021-02-26)
431 reads
I'll be presenting at two virtual SQL data platform communities this week on a couple well-rehearsed topics, each with fresh updates.
Tuesday, February 23, 2021
12:00 PM to 1:30 PM EST
DBA...
2021-02-22
11 reads
I'll be presenting at 7AM Central Time in the first timeslot of the main three-day PASS Virtual Summit 2020 conference. It's long been a goal of mine to present...
2020-11-04
17 reads
Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
Some do.
Recently, by far the most frequent and common disaster recovery...
2020-11-09 (first published: 2020-11-03)
725 reads
Honored to be a part of not just SQLSaturday #1000, but the long proud history of the free community series of SQLSaturdays celebrating their 1000th+ event. (I spoke at...
2020-10-19
18 reads
Enjoyed the heck out of tonight's October special edition of the virtual Baton Rouge .NET and SQL User Groups meeting, where we had a lot of active chat, three...
2020-10-15
23 reads
Looking forward to presenting at SQLSaturday Memphis virtually this weekend!
Both my wife and I are on the schedule for Saturday, and the organizers chose interesting nontechnical topics for both...
2020-09-29
9 reads
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...
2020-09-23
12 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...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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