Call today 0845 643 6463

Uncategorised

  • How to add text to images using Python

    March 13th, 2023 in Blog, Just For Fun, Python, Uncategorised

    In this blog post, I will be showing how to add text to an image in Python. I used this code to generate hundreds of images with different text for one of our clients. The full script is downloadable at the bottom with the required extras. Firstly, install the Python library Pillow. Pillow is a PIL fork, install Pillow using pip and import PIL into the Python script.           In Python, select the image that you would…

    » Read more

  • What are SQL Server Index Fragmentation and Index Fill Factor?

    November 9th, 2022 in Azure, Blog, SQL Server, Uncategorised

    What is index fragmentation and how does it occur? It is important to know that SQL Server data is stored in data pages, with each page holding 8KB of data. There are two types of fragmentation, both are a result of these pages not being used as efficiently as possible. When you UPDATE or INSERT data on a page that is already full, SQL Server creates a new page. The information from the original page will be split 50/50 with half being added to…

    » Read more