Articles

Written by Daniel Eliasson on 02 September 2023.

Why You Should Use a Separate Database for Reporting and KPIs

Intrigued by the idea of optimizing your database performance and security? Want to learn how to set up a separate reporting database without a hitch? Click to read more and discover how you can take your data strategy to the next level.

sql, sqlserver, Manhattan SCALE, security, performance, kpi, reporting services

Hits: 616

Written by Daniel Eliasson on 01 September 2023.

Unit Testing in C# with FakeItEasy and Fluent Assertions

Curious about elevating your C# skills to the next level? Want to write code that not only works but is also easily maintainable and bug-free? Click to read more about the indispensable tool that is unit testing.

Hits: 649

Written by Daniel Eliasson on 05 November 2022.

SQL Schema explained

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.

sql, sqlserver, storedprocedures, development, schemas

Hits: 818

Written by Daniel Eliasson on 28 October 2022.

How to set lock timeout

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

sql, sqlserver, storedprocedures, development

Hits: 780

Written by Daniel Eliasson on 28 October 2022.

How to use deadlock priority

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.