All our topics
All posts tagged with "database"
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.
Second post in a series that will teach you how to write some basic CRUD queries.
First post in a series that will teach you how to use LLBLGen, an entity modeling solution and ORM framework for .NET, from scratch.
How to create ASP.NET Identity tables using Entity Framework Database First Approach.
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.
SQL Indexes and their impact on your SQL Server performance - a brief introduction to the most common mistakes made by developers.
Never heard of Azure Resource Manager? It's time to learn how to create standardized and repeatable deployment process on Microsoft Azure.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Learn how to write a simple SQL script that modifies all fields with a specified name and type from all tables in a database.
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.