All our topics

All posts tagged with "database"

Upgrade from PostgreSQL 10 to PostgreSQL 11
Monday, Nov 11, 2019 BY Ivan Kalafatic

During this year, I had to upgrade (migrate) several PostgreSQL servers. In order to reduce room for error (remember Murphy's law), I wrote this blog post, which will, hopefully, serve as future reference, both for myself and for people which will have to do the same.

database devops 4 Min Ready
Getting Started With LLBLGen - Part 2: Basic CRUD queries
Saturday, Jul 21, 2018 BY Domagoj Zakanj

Second post in a series that will teach you how to write some basic CRUD queries. database 12 Min Ready
Getting Started With LLBLGen - Part 1: Project Setup
Monday, Jul 9, 2018 BY Domagoj Zakanj

First post in a series that will teach you how to use LLBLGen, an entity modeling solution and ORM framework for .NET, from scratch. database 7 Min Ready
Asp.Net Identity Database First Approach
Friday, Nov 17, 2017 BY Luka Erkapic

How to create ASP.NET Identity tables using Entity Framework Database First Approach.

database 3 Min Ready
Web.config transformation on the fly and custom publish actions
Friday, Sep 8, 2017 BY Igor Drazic

Multiple configurations in VS projects are important for big projects. Having to change and maintain configuration files can be a nightmare if done manually, and it's prone to errors. This is where Web.config transformation feature comes in.

database devops 3 Min Ready
Missing, incorrectly set-up or unused indexes and their impact on SQL Server performance
Thursday, Jul 13, 2017 BY Goran Pavlovic

SQL Indexes and their impact on your SQL Server performance - a brief introduction to the most common mistakes made by developers.

database 5 Min Ready
Introduction to Azure Resource Manager
Friday, Jan 27, 2017 BY Slaven Vladisavljevic

Never heard of Azure Resource Manager? It's time to learn how to create standardized and repeatable deployment process on Microsoft Azure.

javascript cloud database 5 Min Ready
Unit of Work - a Design Pattern
Friday, Jan 13, 2017 BY Ante Ljubic

In software development, a design pattern is a reusable solution, description or a template for solving problems. Unit of work is one of them - a concept for dealing with certain issues related to database interactions.

database csharp 3 Min Ready
Windows Server 2012 Hyper-V Failover Clustering - Part 4: PostgreSQL
Monday, Feb 1, 2016 BY Denis Susac

The fourth and final part of our series on failover clustering with Hyper-V, ASP.NET and PostgreSQL describes how to set up a fault-tolerant, highly available Linux virtual machine running PostgreSQL. database devops 5 Min Ready
Windows Server 2012 Hyper-V Failover Clustering - Part 3: Installation
Thursday, Jan 28, 2016 BY Denis Susac

The third part of our series describing how to set up a foundation for the private cloud infrastructure describes how to install and configure failover clustering. database devops 6 Min Ready
Windows Server 2012 Hyper-V Failover Clustering - Part 2: Prerequisites
Monday, Jan 25, 2016 BY Denis Susac

The second part of our series describing how to set up a foundation for the private cloud infrastructure discusses how to install the prerequisites for Windows Failover Clustering feature. database devops 6 Min Ready
Windows Server 2012 clustering for high availability, with ASP.NET and PostgreSQL - Part 1
Friday, Sep 4, 2015 BY Denis Susac

Recently we have spent a lot of time setting up a foundation for the private cloud infrastructure that will be used for "in-house" installations of our applications. Here is what we've learned during the process.

The Geek Gathering
Monday, May 19, 2014 BY Denis Susac

This year's The Geek Gathering conference has just finished, the impressions have settled and we have received feedback from both attendees and speakers. Mono is in charge of the program - see what we covered this year.

devops cloud database 2 Min Ready
The Geek Gathering 2013
Thursday, Oct 17, 2013 BY Denis Susac

Apart from working on a couple of new and exciting products - more on this will be published over the course of the next few weeks - our team was also very involved in a local developer's community. See what's been happening lately and what we plan for the future.

database cloud javascript 1 Min Ready
Delegates in action, part 2: ASP.NET password encryption
Monday, Jun 10, 2013 BY Ivan Marusic

Here is a real-world example of a task that is beyond the scope of standard SQL scripts. We will change the ASP.NET membership password format in MonoX and take care of the existing entries.

database 1 Min Ready
How to prevent data loss during delete update in SQL Server
Monday, Apr 22, 2013 BY Goran Pavlovic

Making database backups prior to update/delete operations is the only way that ensures painless recovery of mistakenly deleted data. Here are a few tips that could save some time and money in the process.

database devops 2 Min Ready
SQL Tips & Tricks: changing column values in multiple tables
Friday, Mar 8, 2013 BY Ivan Marusic

Learn how to write a simple SQL script that modifies all fields with a specified name and type from all tables in a database.

database devops 1 Min Ready
Delegates in action
Sunday, Feb 17, 2013 BY Ivan Marusic

This blog covers one of the alternative solutions for dealing with tasks that require fetching and manipulating large amounts of data from the database. Of course, you can always rely on standard SQL scripts, but I feel that this approach allows for more flexibility.

database 1 Min Ready