Everything SQL related and then some
Adding a next and previous button to the post footer makes navigation much easier for the reader. Imagine a long post with a lot of content. The user will have to navigate to the top of the post in order to find the options for the next set of posts. This is obviously going to…
A great way to add content to a WordPress site is to use reusable blocks. A block as its name suggests is a unit of code representing a paragraph and image a widget or a video or any combination of the above. These blocks can be made reusable such that you could customise them…
Recently in a move to improve the subscription rate and overall search ranking of my site I decided to add a subscribe button to all my posts. The button would point the reader to my YouTube channel. This achieves 2 goals Improves the number of links to my channel as well as blog Makes it…
A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why a DBA should never restart the SQL Server service or the server itself. Luckily the solution is fairly simple. As mentioned in the Message the first step…
One of the most important things you can do to improve your Google search index ranking is to improve the load time of your website. What this means is to make sure that the site loads quickly. This is something you want to do not only for Google search. Waiting for a slow site to…
Most database administrators are at least to some extent familiar with what memory does for SQL server. This is especially true for scenarios such as configuring minimum memory in maximum memory, checkpoint, lazy writer etc. However, there is a shocking lack of understanding how the hardware itself plays a key role in the memory utilisation of the server. Ask any database administrator…
Microsoft Azure has become a cloud platform of choice for everyone at this point. One of its biggest advantages has been the ability to integrate seamlessly with existing enterprise solutions and on-premise systems. However, when it comes to file storage AWS has always had a leg up because of its S3 storage. Microsoft blob storage is definitely a contender now that we…
When using VS Code you will find a need for a Source Control or Version Management Software. Git is by far the most popular and free software used my many freelance developers as well as corporate giants. Another similar software is TFS or team foundation server by Microsoft. Luckily both are compatible with Azure and…
A fairly important aspect of retail software is inventory management. Often this requires some kind of counter that reduces the count of stock items based on the number of orders placed. This poses a particularly difficult challenge in relational databases because we need to ensure consistency. Think of a product table which has a stock…
I recently formatted my laptop and this resulted in all the software being removed from the operating system. Normally this wouldn’t be that big a deal except I have outlook 2013 being used as my primary mail client. Admittedly outlook 2013 is pretty old and not compatible with Office 365. This is mainly because Office…