Master Data Services 2014: Creating nightly load processes
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...
2014-01-02 (first published: 2013-12-23)
3,496 reads
SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!
Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...
2014-01-02
3,907 reads
Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional
OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows...
2013-12-07
8,359 reads
Setting your predicate arguments at run time Part: 2 MultiSelect
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-26
827 reads
Setting your predicate arguments at run time
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-24
941 reads
Monthly profit percentage techniques
Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...
2013-10-30
1,985 reads
Flexible Fiscal Data Sort
Flexible Fiscal Data Sorting
A few months ago, I faced the challenge of extracting data via SQL Queries (for our enterprise),...
2013-08-02
1,678 reads
Dynamic calculations of running totals
Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...
2013-06-24
1,290 reads
Monitoring SQL Server Agent job run times
Introduction
A few months back, I was asked how long a particular nightly process took to run. It was a super...
2013-05-10 (first published: 2013-04-18)
6,389 reads
Resolving data redundancy up front
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...
2013-04-22
1,277 reads
Blogs
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Using Prompt AI to Help Setup Data Analysis
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
Forums
Certificates expired - Can't restore after creating new certificate
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
advice on diving into devops for managing BI projects
hi , i know this is a sql server forum but i think my...
Simplifying WHERE Condition with LIKE test on multiple columns
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Question of the Day
Which Table I
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