Category Archives: Databases

Everything related to databases. We love data and yes we love our databases too. Anything we do that relates to databases can be found here.

3 server settings you can enable in 3 seconds to improve performance

By | May 28, 2020

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 highlight five quick wins that every DBA can enable on their server to improve performance. The best part is they will take all of three seconds of… Read More »

How to Increase transfer rate when copying to External HDD

By | May 23, 2020

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 taking far too long. On further inspect I found out the transfer rate was far lower than promised. This post will explain how to identify and fix… Read More »

Series on Tuning SQL Server using Fill Factor to control page splits

By | May 21, 2020

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 things in SQL Server there is a trade-off. Is the impact of additional pages caused by a fill factor of 70% more damaging than the impact of… Read More »

Why you should continue to defrag your indexes:-What are page splits 1/4

By | May 18, 2020

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 reduce the number of page splits doesn’t really fix the issues and often makes things worse. Naturally this goes contrary to a number of practices DBAs have… Read More »

What does a brute force attack look like?

By | May 13, 2020

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? A brute force attack is different from other attacks because it’s relying purely on a numbers game to gain access to the system. Unlike social engineering attacks… Read More »

How to identify conversion issues using TRY_CAST () or TRY_CONVERT()

By | May 12, 2020

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 doesn’t have an option to help identify the error specifically. An example of this is the relief expressed by developers when Microsoft announces the release of the… Read More »

Backing up MySQL databases

By | May 9, 2020

WordPress uses MySQL as its database backend and as a result it is important to upgrade and patch MySQL database versions when possible. This is especially true for older versions of MySQL which get installed by default with older WordPress Installers like those found on Web Platform Installer. Before proceeding with any such changes it… Read More »

DB options: – Recovery intervals and Checkpoint

By | May 5, 2020

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 during an unexpected shutdown. It is important for DBAs to understand how this functionality works. We explore different type of checkpoints and the role they play in… Read More »

Using Snippets in SSMS

By | May 3, 2020

A little known 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 templates and code blocks from other sources. Often we have a readymade template which we customize as needed and that is it. Database administrators have mastered SQLCMD… Read More »

DB Options: – Parameterization

By | April 24, 2020

In this video we cover the two options available under parameterization in MSSQL database properties. Ad hoc queries are queries that aren’t stored procedures. Since the code is ad-hoc in nature we see that the WHERE condition often has hard coded values. Each time the hard coded value changes we see a new execution plan… Read More »