Boolean Hell – Missed rows when grouping in SQL

I was recently asked about the concept of Boolean hell and thought it would be a good post to discuss. Most database professionals should be familiar with the concept even if they don’t know the exact name of it. I think the best way to explain this will be with an example so let’s have…

What is the role of the DBA in a Cloudy world?

  What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions and trainings as well as consulting. The fact is the answer is very straight forward but at the same time not an easy one to hear. I’ve…

No process is on the other end of the pipe

Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to 1024 MB (on purpose). The error message mentioned that memory could be an issue as shown below in bold. The client was unable to establish a connection…

Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.]

Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.] One of the best features of Azure is the ability to authenticate with Azure Active Directory. This is easy to implement and therefore a very nice way to implement authentication without the hassle of…

Adding a reusable block to the WordPress Site

  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…

Adding a subscribe button to your WordPress site

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…

SEO – Expire Headers for WordPress site hosted on IIS

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…

Memory for Servers – Hardware

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…

Create an Azure SFTP Site

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…

Installing GitHub on VS Code

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…

Managing inventory in SQL Server –Part 1

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…