The Collaboration Commission – Part 1
Part 1 of my journey to answer the question, “can a team, which has already fallen into a pattern of mistrust and resentment, recover? “
Learning to Manage: Recovering from a crash
One year and nine months ago, I took my first formal management position. I stepped into the role thinking that I knew a bit about management. I felt as though my team leadership experiences in my past meant that I…
Musings of a DevOps Data Pro
Continuous delivery and automation are a couple of core concepts of DevOps. As a Data Professional, I have spent countless hours pushing through the resistance of people who feel the data tier should be left out of source control, automated…
Amazon Redshift Unexpected Commit
If you are familiar with sqlhammer.com, then you know that I heavily specialize in the Microsoft Data Platforms. My experiences with Microsoft, and specifically the SQL Server products, established an expectation that explicit transactions would always commit/rollback successfully or there…
NYC Yellow Cab Data in Azure SQL Data Warehouse
Microsoft Azure provides a convenient feature when creating a new Azure SQL Data Warehouse database. You can create the database from a backup of the Microsoft sample database, AdventureWorksDW. This is super fast and easy. It also has huge tables…
Active Forgiveness
Earlier this year, I wrote about Failure Integrity Power Transparency and Respect. This was taken from the perspective of a person who is learning how to navigate their failures or the failures of a group which includes them. In this…
SQLHammer in 2018
SQLHammer.com has been quieter than usual this year. I have not written nearly as many blog posts as I would like. The reason for this is because I have been very busy and I thought it was time to update…
Tell me your problems
I need your help. I am working on improving my department’s problem solving skills. This is going to manifest in a lot of one-on-one mentoring, team exercises, and formal presentations. The formal presentations I am going to build into sessions…
Failure Integrity Power Transparency Respect
The key to success is failure. There is much truth in that statement. It is also like a prism which can be perceived differently from many different angles. One angle is to say that, the difference between a successful person…
Transact-SQL STRING_AGG
Creating comma separated strings from a column, or delimited strings as I like to call it, is a very common problem in SQL. Beginning with SQL Server 2017 and Azure SQL Database, there is now another option to the existing…