How Developers and DBAs Collaborate in a DevOps World (video)
You’re a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for...
2019-06-13
7 reads
Blog Posts
What is a distributed transaction?
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)
822 reads
Amazon’s Concept of Ownership and Technical Debt
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
383 reads
Containers: Create a Custom Container
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)
430 reads
Mass Backup All Sessions
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)
218 reads
SSDT (SqlPackage) thread crashes with error when publishing
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
79 reads
#tsql2sday – A Letter to My 20 Year-Old Self
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
39 reads
A letter to my 20 year-old self
This post is a part of #tsql2sday, a monthly community ritual where a topic is proposed by a community member and everyone is invited to join in. This month’s...
2019-06-11
12 reads
Azure Cosmos DB Local Emulator
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
88 reads
Import Local SQL Server Database to Azure – Pick the Best Method
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
17 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311
BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok...
ATM Bank BCA A. Yani, Pekanbaru TLP/WA 08216977749
Jl. Jend. Ahmad Yani No.41 C, Kota Baru, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau...
BCA KCP Kas Arifin Ahmad TLP/WA 08216977749
Komp. Hatta Centre, Jl. Arifin Ahmad Perkantoran Soekarno No.9 Blok D, Sidomulyo Timur, Marpoyan...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers