Events
Subscribe

PASS Summit 2018 Program Committee Member

20th October 2019
Derik Hammer

More In

Fast, light-weight, row counts

Often we need to know the number of records in a table. If you are looking for something very specific, such as the number of…read more →

How to: Configure SQL Server 2012 AlwaysOn – Part 1 of 7

How to: Configure SQL Server 2012 AlwaysOn Scope and Architecture This is the first post in a series to provide step-by-step instructions on how to…read more →

T-SQL Command Line Options – Part 5 – SQLPS

SQLPS.exe and SQLPS the module SQLPS, like SQLPSX, is a set of extensions to Powershell for interacting with SQL Server. SQLPS first appeared with SQL…read more →

Career & Leadership

The immediate idealist
January 25, 2021
Ephemeral barriers of the mind
January 25, 2021
Potassium and process ambiguity
January 25, 2021
Adaptation and the Mirror
January 25, 2021
IT Responsibility – Informed Consent
January 25, 2021

Cloud

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

HADR

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

Performance

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

© 2012-2020Derik Hammer All Rights Reserved.