Events
Subscribe

SQLShack.com

20th October 2019
Derik Hammer

Began blog contributions to SQLShack.com.

More In

Bug: INSERTing into a MySQL Database via Linked Server

Recently I found myself involved in a project where a tab delimited text file (updated daily) was being imported into a MS SQL Server 2008…read more →

SQL Saturday #320 Raleigh in Review

This past Saturday, September 6th, I had the privilege of attending SQL Saturday #320, in Raleigh, NC. It was a great day. The highlight of the event…read more →

Do not use percentage based auto-growth

Having autogrowth enabled on your SQL Server instance is great! Even in IT shops where you diligently right-size your database files (which is a good idea),…read more →

Career & Leadership

Potassium and process ambiguity
October 27, 2020
Adaptation and the Mirror
October 27, 2020
IT Responsibility – Informed Consent
October 27, 2020
Defined Success and Role Clarity
October 27, 2020
The Collaboration Commission – Part 5
October 27, 2020

Cloud

Amazon Redshift Views, Sort Keys, and Outer Joins
October 27, 2020
Amazon Redshift Unexpected Commit
October 27, 2020
NYC Yellow Cab Data in Azure SQL Data Warehouse
October 27, 2020
Amazon Redshift Temporary Tables
October 27, 2020
What is a data lake?
October 27, 2020

HADR

Synchronizing SQL Server Instance Objects in an Availability Group
October 27, 2020
Top 10 Tips for Availability Groups
October 27, 2020
Connecting your Azure regions
October 27, 2020
Measuring Availability Group Synchronization Lag
October 27, 2020
Availability Group Architecture – DR on the Cheap
October 27, 2020

Performance

Amazon Redshift Views, Sort Keys, and Outer Joins
October 27, 2020
Linked Server Elimination
October 27, 2020
5 Extended Events Sessions Your SQL Server Instance Cannot Live Without
October 27, 2020
Inside the XEvent Profiler
October 27, 2020
SQL query performance tuning tips for non-production environments
October 27, 2020

© 2012-2020Derik Hammer All Rights Reserved.