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
423 reads
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
423 reads
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
341 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
379 reads
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
783 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
408 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
393 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
422 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,349 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,441 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
496 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers