Database Management - Blogs

Database Management

Data Replication: What is it and What are the Advantages of Using it?

Clay.Jackson

Data replication is the process of updating copies of your data in multiple places at the same time. Learn the benefits and why it’s so important.
- 15 Oct 2020
SQL CASE Statement: What is it and What are the Best Ways to Use it?

Rajendra Gupta

Learn the many use cases for the SQL CASE statement and how it applies business logic to SQL Server.
- 15 Oct 2020
Data Preparation and Analysis: Using Data Efficiently in the Era of Dark Data

John.Pocknell

Data preparation breaks down silos and makes data more useful. Learn about the role of data modeling and dark data in your analytics process.
- 29 Sep 2020
How to Work with Data Using MongoDB Query Language

Prashanth Jayaram

Learn how to query and analyze unstructured data using MongoDB query language.
- 21 Sep 2020
SQL Server Execution Plan — What is it and How Does it Help with Performance Problems?

Rajendra Gupta

Learn about your primary diagnostic tool for poor query performance—the execution plan and see how estimated and actual SQL Server execution plans can differ.
- 17 Sep 2020
The Anatomy of SQL Server Deadlocks and the Best Ways to Avoid Them

Rajendra Gupta

You are bound to run into SQL Server deadlocks when managing SQL Server. Learn what they are, why they occur and the best ways to avoid them.
- 24 Aug 2020
The Best Ways to Use SQL Delete Statement in a SQL Table

Rajendra Gupta

There are several best practices to consider when using a SQL delete statement to remove data from a SQL table. Learn how to use it properly.
- 21 Aug 2020
Hotwire discusses business continuity and risk mitigation during cloud migration

Richard Schiller

Hotwire delivers webcast to discuss AWS cloud migration using SharePlex, resulting in no transaction data loss or downtime.
- 20 Aug 2020
Cloud vs. On-Premises Databases: How Does Performance Tuning Differ?

Prashanth Jayaram

When it comes to cloud vs. on-premises databases, does performance tuning differ? Learn what elements of each database type impact performance.
- 7 Aug 2020
Data Protection and Data Privacy — How Do You Really Protect Your Users’ Information?

John.Pocknell

Data privacy regulations are evolving. Learn how database professionals and developers need to approach data protection and privacy in these changing times.
- 6 Aug 2020
11 SQL Server Index Best Practices for Improved Performance Tuning

Rajendra Gupta

These 11 SQL Server index best practices will help you ensure peak database performance and improve your approach to performance tuning.
- 6 Aug 2020
Database Management Career Tips from Brent Ozar and Pinal Dave

Rebecca Hirschfield

Who better to provide database management career tips then SQL Server experts Brent Ozar and Pinal Dave? Hear their candid advice.
- 5 Aug 2020