SQLonCall: Mock Interview, Part I
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
Dealing with NULL database values in ASP.NET.
In this column, I'll dig into check-in notes and policies. You'll learn how check-in notes work and how to write your own custom policy implementations.
This tip provides insight into the inner workings of the Microsoft Naive Bayes algorithm, showing how the algorithm computes the score used to filter out correlations.
The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.
Volunteers are important to ensuring the success of so many organizations. IT-based organizations, such as user groups, are no different. Steve Jones leads you through a few of the stages of being a volunteer and hopes more of you will participate in your local area.
What's the routine of a normal DBA job? Too many people work alone and don't get feedback or comments on what they should be doing from other DBAs. Andy Warren has jotted some notes down on what you should make sure is a part of your job.
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
Learn how to reorganize permissions in SQL Server 2005 in a multiple database environment.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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...
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