Our Ginger Slides’ Primer – Thinking To Move Your Data From On-Premise SQL Server to AWS DynamoDB?
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
400 reads
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
400 reads
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
313 reads
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
352 reads
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
756 reads
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
385 reads
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...
2016-12-07
349 reads
We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...
2016-07-15
395 reads
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,318 reads
Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,419 reads
Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an...
2015-10-01
465 reads
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
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...
Comments posted to this topic are about the item Your AI Successes
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