There are a number of dials and knobs in SQL Server that allow the DBA to fine tune almost every aspect of the server. In this post I […]
How to Increase transfer rate when copying to External HDD
Recently I had to purchase an additional external hard disk to back up my data. While creating a system image of the laptop I noticed that it was […]
Tuning SQL Server using Fill Factor to control page splits
Is it better to take a hit on performance due to Fill Factor or Page Splits? That is the question being answered in this video. As with most […]
Why you should continue to defrag your indexes:-What are page splits 1/4
Recently I came across a video in which it was suggested the Page Splits/sec counter was not useful in identifying Page splits and that using fill factor to […]
Plotting Graph database in Power BI – Greek Mythology
During the lockdown I started rereading Stephen Fry’s Mythos. A modern interpretation of the Greek myths with the trademark Fry Humor. Greek mythology like most ancient literature is […]
Script showing how partitioning improves performance – With Video
In this post I have provided the link and script for the video demonstrating how Partitioning improves performance. Video on how to use the script The Script
What does a brute force attack look like?
Ever wondered if your server is being targeted for a brute force attack? What does it look like? How to prevent it? What is a brute force attack? […]
How to identify conversion issues using TRY_CAST ()
A common issue with the ELT process is that you find out errors after they have been loaded. This is usually not any issue unless the database specifically […]
How to navigate between pages in PowerBI
In this post we explore the way to navigates between pages in PowerBI. The latest release of PowerBI has made this process very simply and most developers will […]
How to Backup MySQL databases
WordPress uses MySQL as its database back end and as a result it is important to upgrade and patch MySQL database versions when possible. This is especially true […]