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

A Beginner’s Guide to SQL String Functions 11/21/2019

Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!

Don't Let the Streams Pool Fool You 11/18/2019

The Streams pool is used by more than just Streams. Read on to see what else uses it and what you could expect when streams_pool_size is set to 0.

A Toolbox Every DBA Should Have 11/14/2019

As a DBA it is important to have a toolbox that supports the work you do.  You need to have a toolbox that allows you to work smarter instead of harder. Read on to learn about some key tools every DBA should have in their toolbox!

Understanding Schema Optimization in MySQL 11/11/2019

Optimizing Schemas for your data can involve trade-offs. Delve into the intricacies of schema optimization and how to achieve them in MySQL.

Implementing SQL Server Integration Services with Azure Data Factory 11/04/2019

Read on to step through the process of implementing Azure Data Factories.

Using LogMiner To Find Current Changes 10/28/2019

LogMiner can be used to find data changes based on time or SCN and can be used to find only the most recent changes.  Read on to see how this can be accomplished.

Using Five Types of JOIN in MySQL 10/21/2019

Learn how to use the different types of joins available in a MySQL database.

Accelerating Database Recovery with SQL Server 2019 10/14/2019

Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on.... 

Planning for SAP HANA Deployments in Public Cloud Environments 10/07/2019

Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud. Read on...

Introduction to the Partition By Window Function 10/02/2019

Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!

New Preview of SQL Server Management Studio Available for Download 12/06/2018

On September 24^th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now 12/03/2018

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!