Fixing Impostor Syndrome
Lessons on impostor syndrome from a marketer apply to technologists as well.
2022-09-09
265 reads
Career Growth
Look Beyond What You See
One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. […]
2022-08-08
202 reads
2022-07-22
158 reads
2022-07-13
221 reads
2022-07-06
197 reads
Returning To An Employer
Leaving an employer on good terms is important, and Steve thinks employers ought to consider hiring former employees, even if they were let go in a layoff.
2022-06-29
202 reads
Onboarding Remote Employees
The pandemic has meant a lot of people started new jobs remotely. Steve has a few thoughts on this process.
2022-06-22
197 reads
2022-06-17
118 reads
Becoming a Better DBA
Steve has some advice on how to be a better DBA, or really better at whatever career you choose.
2022-06-15
262 reads
Azure Data Factory Interview Questions and Answers
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,439 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
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
exec etl.GettheProduct
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