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
395 reads
SqlServerZest.com - SQL in simple style
AWS – No Password? No Problem! Generating Redshift Credentials via IAM Authentication
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
307 reads
AWS – Move Data from HDFS to S3
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
347 reads
Mongodb – How to Iteratively Access Data Across all Databases and Collections
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
748 reads
Linux – How to generate and configure SSH Key authentication to connect to a remote system
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
379 reads
Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...
2016-12-07
344 reads
SQLServerZest is now DataGinger!
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
391 reads
PowerShell – Disk Space Monitoring and Early Warning Reports
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,313 reads
SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing
Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,412 reads
SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists
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
457 reads
Blogs
70 Years of Artificial Intelligence History in 15 Minutes
By Brian Kelley
How long has AI been around in different domains? What was it called before...
PostgreSQL Database Optimization: Shrinking Tables and Indexes Explained
By Rohit Garg
PostgreSQL is a powerful open-source relational database system, but over time, its tables and...
What a Summer Camp Kitchen Still Teaches Me
By Rayis Imayev
(2025-Aug-04) Taking my last week of vacation and then volunteering at a children's summer camp...
Forums
Page Compression, Unique Identifiers and Speed
Comments posted to this topic are about the item Page Compression, Unique Identifiers and...
The Double-Edged Sword of AI and Data Democratization
Comments posted to this topic are about the item The Double-Edged Sword of AI...
Direct Connection running Fast,Linked Server running Slow
Scenario 1 (Direct Connection - Fast): On Server B, when using SQL Server Management...
Question of the Day
Page Compression, Unique Identifiers and Speed
Would using a UNIQUEIDENTIFIER as a clustered primary key improves page compression and speeds up inserts compared to INT IDENTITY?