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 […]
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
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 […]
DB options: – Recovery intervals and Checkpoint
In this video we talk about recovery intervals. Specifically how checkpoint allows recovery intervals to be maintained. Checkpoint is a feature that allows SQL server to recover faster […]
Using Snippets in SSMS
A little know and used feature by database developers is Snippets. Database developers understandably do not use this feature because we have long been accustomed to using prebuilt […]