Blog Posts

What is a distributed transaction?

• by Kenneth Fisher

• SQLStudies

A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading

2019-06-13 (first published: 2019-05-28)

579 reads

Amazon’s Concept of Ownership and Technical Debt

• by Brian Kelley

• Databases – Infrastructure – Security

I’m reading Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader. In talking about Amazon’s pursuit of a second headquarters, John Rossman wrote the following regarding ownership: Amazon’s second leadership...

2019-06-12

172 reads

Containers: Create a Custom Container

• by Grant Fritchey

• The Scary DBA

Creating a custom container is where things get truly exciting. There’s actually a ton of work and knowledge around this. To start with, I’m going to keep it simple....

2019-06-12 (first published: 2019-05-24)

348 reads

Leadership Part 2: Talent acquisition and Employee Retention

• by jphillips-46546

• Another SQL Geek

The two most costly human capital expenses an organization will have is the onboarding and offboarding of staff. Just take a moment to think about that and if your...

2019-06-12

9 reads

Mass Backup All Sessions

• by Jason Brimhall

• SQL RNNR

Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...

2019-06-12 (first published: 2019-05-23)

171 reads

Simulating Load

• by Steve Jones

• The Voice of the DBA

I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...

2019-06-12

9 reads

SSDT (SqlPackage) thread crashes with error when publishing

• by Kamil

• SQL Player Blog

In this post, I will show you one of the scenarios when SSDT (SQL Server Data Tools) can fail unexpectedly while publishing database project to target server or preparation...

2019-06-12

5 reads

#tsql2sday – A Letter to My 20 Year-Old Self

• by Brian Kelley

• Databases – Infrastructure – Security

Self, I am writing this to you in my mid 40s. I know when I was 20, I wasn’t thinking about 30, much less 40. Here’s some advice I’d...

2019-06-11

9 reads

Azure Cosmos DB Local Emulator

• by Arun Sirpal

• All About SQL

Technically you do not have to create a cosmos DB and incur costs to test cosmos DB based applications, you could use the local emulator. This means that you...

2019-06-11

53 reads

Import Local SQL Server Database to Azure – Pick the Best Method

• by Prashanth Jayaram

• PowerSQL By Prashanth Jayaram

It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server...

2019-06-11

146 reads