DataGinger.com

by Categories

• Agent XPs (1)
• AlwaysOn (5)
• AWS (3)
• Backup (5)
• Clustering (1)
• Compression (1)
• Constraints (1)
• Disk Space (4)
• Encryption (1)
• Error Log (1)
• Errors (1)
• Files and FileGroups (6)
• Hadoop (1)
• Identity (1)
• Indexes (3)
• Install/Attach (1)
• Internals (2)
• Linux (2)
• LOB (3)
• Microsoft Excel (1)
• mongodb (1)
• Performance (4)
• PowerShell (2)
• Queries (6)
• REDSHIFT (2)
• Registered Servers (1)
• S3 (1)
• Security (9)
• Shrink (2)
• SQL Server Agent (2)
• SSIS (2)
• SSMS (2)
• T-SQL (11)
• TDE (2)
• TempDB (3)
• Transaction Log (3)
• Uncategorized (6)
• Videos (1)

by Month

• February 2023
• March 2018
• November 2017
• September 2017
• March 2017
• December 2016
• July 2016
• June 2016
• March 2016
• February 2016
• October 2015
• July 2015
• June 2015
• May 2015
• February 2015
• December 2014
• October 2014
• August 2014
• June 2014
• April 2014
• February 2014
• November 2013
• October 2013
• September 2013
• August 2013
• July 2013
• June 2013
• May 2013
• March 2013
• November 2012
• October 2012
• September 2012
• March 2012
• November 2011

Last 50 Posts

• Build a simple CI/CD pipeline to upload artifacts to AWS S3

• Mongodb – How to Iteratively Access Data Across all Databases and Collections

• Our Ginger Slides’ Primer – Thinking To Move Your Data From On-Premise SQL Server to AWS DynamoDB?

• AWS – Move Data from HDFS to S3

• AWS – No Password? No Problem! Generating Redshift Credentials via IAM Authentication

• Linux – How to generate and configure SSH Key authentication to connect to a remote system

• Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

• SQLServerZest is now DataGinger!

• PowerShell – Disk Space Monitoring and Early Warning Reports

• SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing

• SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists

• SQL Server – Script to generate Read-Only Routing URLs

• SQL Server – New Database Backup Encryption with SQL Server 2014

• SQL Server – Capture Execution Plan of a Currently Running Query/Process SPID

• SQL Server – How to Calculate Length and Size of any field in a SQL Table

• SQL Server – Changing Ownership for All the User Databases to “sa” Account

• SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup

• SQL Server – Ports used by Database Engine and other SQL Features

• SQL Server – Failed to bring availability group ‘[availability group name]’ online

• SQL Server – Aborted Online Index Operation & Observed Elevated Values for PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK Wait Types

• SQL Server – Script to Identify and Update Database Auto-Growth Setting

• SQL Server – Script to Configure TempDB Files per Number of Logical Processors

• PowerShell & SQL Server – Finding SQL Virtual Name From SQL Failover Clustering

• SQL Server – Using Tools to Analyze Query Performance

• SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL

• SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data

• SQL Server – Restoring a TDE Encrypted Database to a Different Server

• SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)

• SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL

• SQL Server – How to Add More Than One Column as a Primary Key

• SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

• SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script

• SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command

• SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account

• SQL Server – How to Move Database Files – Data File and Log File – From One Drive Location to the Other

• SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans

• SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups

• SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database

• SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information

• SQL Server – How to Insert Explicit Values Into An Identity Column

• SQL Server – Get the Default Data File and Log File Location using T-SQL Query

• SQL Server – Does the SQL Agent Service Account Must be a SysAdmin?

• SQL Server – How to Best Remove Extra TempDB Data Files and Log Files

• SQL Server – How to Search/Query the SQL Server Error Log

• SQL Server – Database Engine Error Severities in Brief

• SQL Server – Transaction Log File is Full; How to Shrink the Transaction Log

• SQL Server – Msg 2555, Level 16, State 1, Line 1 – Error DBCC SHRINKFILE with EMPTYFILE option

• SQL Server – Understanding ‘Agent XPs’ Server Configuration Option

• Microsoft Excel – PowerPivot Tutorial

• SQL Server – Is Compressing the Table Same as Compressing the Clustered Index on That table?