If you are using Azure SQL Server and you have already configured a clustered environment to implement a high-availability architecture in Azure SQL database you will have one active node.The rest will be accessible only in read-only mode.When you connect to some of the inactive nodes through SQL Server Management Studio and try to open … Continue reading Connect to inactive node on clustered environment through SSMS (SQL Server)
Author: Svilen Peev
Software product as a musical instrument
Let me introduce you Bob and Chris. Bob is a musician. Chris is a software developer. Bob plays different instruments. But today he decides to play a rock song, so he chooses a guitar.Meanwhile Chris, who is a great full stack developer, is thinking of creating a public web site to promote his services as … Continue reading Software product as a musical instrument
10 tips for a pleasant and productive software engineer’s everyday
Photo by JESHOOTS.COM on Unsplash 1. Stand up every hour Yeah, it sounds trivial, but it is quite important not only for your health, but also for your focus. You can create a habit to stand up frequently or to make an effort to remind yourself by setting a timer. A pretty nice thing is the height adjustable … Continue reading 10 tips for a pleasant and productive software engineer’s everyday
int type exceeding values loop
There is an interesting fact about the Integer type in C# in the cases where its values exceed outside of the limits. C# wraps around the int values and if you exceed the max value it starts from the min again. I will best illustrate this with the example below: Lets use the 32 bit … Continue reading int type exceeding values loop
Parsing text from PDF using c#
While working on a project, I came across a requirement to extract some information from a PDF document. The tricky part was that only particular pieces were needed and not the whole text. Technology-wise I was using .NET as a platform and C# as a programming language. I was thinking of a way to accomplish … Continue reading Parsing text from PDF using c#
Software development entropy
The chaos The law of entropy is driving the whole universe. The term means that all things strive to chaos and disorder. The molecules of everything are constantly trying to scatter in space. Only an applied external force is keeping all parts arranged and in some kind of order.So remember the chaos is everywhere around … Continue reading Software development entropy
Search for an object in SQL Server
Photo by Oleg Ivanov on Unsplash If you have a big database structure with lots of databases, plenty of tables, views, stored procedures, functions, etc., sometimes you are lost in all the objects in your server. The good news is that there are ways to handle this situation. sys.objects view You can easily find an object in your … Continue reading Search for an object in SQL Server
Interview me
Photo by Chris Liverani on Unsplash We all have been through the process of hiring. We have been participating in interviews and have tried to sell ourselves. Our aim is to show our skills set and to advertise the professional individuals we are. We want to shine, we want to be appreciated, we want to … Continue reading Interview me
Apollo client
In the previous post for Querying data with GraphQL we used a ASP.NET Core HTTP client. But as I have mentioned there is an option to fetch the data with JavaScript using a client called Apollo. Apollo is a very good choice of library if you are building an application with GraphQL because of its … Continue reading Apollo client
Querying data with GraphQL
You can use GraphQL to access data from your back-end service and apply a query on it in order to return the needed information only. It is an open source specification, invented by Facebook, which serves as a middle man, a communication between the client and the back-end.Its syntax is similar to JSON: { person(id: … Continue reading Querying data with GraphQL