development

Dealing with nested stored procedures can be tricky on transaction. This article will show you how to avoid common mistakes.

When a lock occurs you can tell the compiler how long it should wait before giving up. Here's how to use this setting

When developing custom SQL it's important that your code does not block the main application. This article explains how you can use deadlock priority to control this.

In this article I will try to explain schemas and how they can help you organise your code. I will also give you some examples of how I use them in my applications.

When writing code that fetches data your could either use SQL queries in your code, or you could call a stored procedure to fetch data. Here's a couple of reasons for why a stored procedure in many cases is the better option.

Dive into the intricate steps of the Git workflow, beginning with the spark of an agile user story and culminating in a collaborative pull request. Whether you're a seasoned developer or just starting out, our in-depth guide sheds light on the best practices and nuances of working with one of the most powerful version control systems. Ready to enhance your Git prowess? Read on to unlock the secrets of seamless software development and collaboration.