Events
Subscribe

Blog syndication on ToadWorld.com

20th October 2019
Derik Hammer

More In

Update zero base column to one base

Problem: A co-worker requested help with a query today... Derik, I have an Email table with a list of email addresses per person record. There is…read more →

July SQL Server Updates

July Updates for SQL Server SQL Server 2012 Service Pack 1 Cumulative Update #5 is now available. KB Article: KB #2861107. Build Number is 11.0.3373. Applicable to…read more →

Amazon Redshift Temporary Tables

My company is in the middle of a migration to Amazon Redshift. Data warehouse design standards have been in question now that our platform is…read more →

Career & Leadership

Architects and Gardeners
June 29, 2022
The immediate idealist
June 29, 2022
Ephemeral barriers of the mind
June 29, 2022
Potassium and process ambiguity
June 29, 2022
Adaptation and the Mirror
June 29, 2022

Cloud

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

HADR

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

Performance

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

© 2012-2020Derik Hammer All Rights Reserved.