Database Management & Programming News, Articles & Tutorials for Database Administrators

Become More Efficient at Writing TSQL by Creating Code Snippets 06/30/2021

Snippets are a great way to jump start creating TSQL code for common tasks, like creating a table, a stored procedure, a trigger, an index, and more.

What Is a TSQL Code Snippet, How Would You It, and Why? 06/29/2021

With snippet, you can insert a block of code into an existing query window to help jump start your TSQL script writing.

Ten Favorite Keyboard Shortcuts in SQL Server Management Studio 06/28/2021

Every mouse click or menu choice takes your hands away from the keyboard, and slows down your work.  Use these 10 keyboard shortcuts to make your workflow fly.

Discarding Results of a Query Execution in SQL Server Management Studio 06/28/2021

Here's how to turn off those distracting results when you're simply testing a query.

Delaying Standby Database Recovery 06/10/2021

Does it ever make sense to delay database recovery from your Standby? With the right DB recovery strategy in place, delays might be your best move.

What Backups Do I Have? 05/12/2021

As a DBA you need to check periodically to make sure you have backups.  I would recommend you do this daily.

Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE 04/01/2021

To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.

TYPE Definition Change in Oracle 21c 03/04/2021

Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions.  Read on to see what types are available and how to use them.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).

Tip 74 – Changing Cost Threshold for Parallelism 02/24/2021

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will go parallel.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).