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
402 reads
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
315 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
355 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
758 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
387 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
352 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
397 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,321 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,422 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
467 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers