Blog

Learn about modern data architecture

The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...

Visually compare data in MySQL

by Dean Thomas

As with any database, there are many ways to compare the data within a MySQL database. We can compare data for: Accuracy: If we entered the data...

Learn more about database migrations

by Peter

Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database...

Discover why data modeling is data governance

by Peter

Data modeling is data governance. We define data governance as the execution and enforcement of authority over the definition, production, and usage...

Using C# and .Net to access Data Models

by William W.

In my previous blog post, I shared a PowerShell Script which uses the ER/Studio Data Architect COM automation interface.

During this post, we’ll create an application, using the Microsoft .NET Framework with the language C#, which can also connect to ER/Studio Data Architect.

Monitor top metrics in MySQL databases

by Mehul Lal

How MySQL databases perform can affect your organization. For example, if your site takes too long to load or has too many server errors, it can...

Tips for data warehouses and other extensive databases

by Peter

Whether on-premises or in the cloud, organizations often ask database administrators to create and manage optimal database designs for data...

DBTA 100 2023: The Companies That Matter Most in Data

by Crystal Berry

The need to balance data safety with new data initiatives, deliver business value, and change company culture around data tops this year’s list of...

Understand the return on investment (ROI) in data modeling

by Peter

For over three decades now, data modeling has been the leading discipline for understanding business data requirements and representing them in a...

Become a SQL Server Management Studio Hero

by Kyle

The world is full of exciting challenges, and we are constantly running daily, chasing our dreams. Especially in the software ecosystem, it is not...

Using PowerShell to organize Data Model Projects

by William W.

Years after years we are creating new models. Maybe we save all the different projects to the same folder. After a while, we can have many projects in this directory.

This blog post shares a PowerShell Script which copy|move the project files to subfolders created by using the Copyright Year of the projects.

Synchronize MySQL data

by Dean Thomas

Lost your work because you forgot to back it up? Having your database developers do a mountain of work in a short time frame is not the best way to...

Work with and support multiple database platforms

by Peter

In the ever-changing world of technology, we sometimes inherit environments with multiple database platforms and must continue to manage them. This...

Agile data modeling is not an option but essential

by Peter

The time has passed when data models could hide in an ivory tower (IT) and locked behind bars only for the IT in‐crowd to be consulted. It is their...

How did the database administrator role change in 2022?

by Mehul Lal

Organizations are experiencing the effects of rapid technological advancement across every sector and industry, causing them to rely on secure and...

Team Server REST API – Import into Google Sheets

by William W.

In my previous post, we have seen how to obtain the authorization to use the API.
In this one, we create a new blank spreadsheet in Google Sheets which uses the Team Server REST API to directly import and refresh the objects we want.

Design data intensive cloud native applications

by Peter

The cloud is transforming the way modern-day applications are being designed. Data is at the center of multiple challenges while architecting...

Model data for MongoDB and JSON

by Peter

Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...

Dealing with the Complexities of Regulatory Compliance

by Kyle

Why is Data Privacy Important? An incredible amount of digital information is generated daily, with an estimated 1.7 MB of data being created every...

Team Server REST API – Getting Started

by William W.

Team Server provides a REST based API to interact with it.
This blog post describes how we can connect to and use the Team Server REST API from an Excel workbook.

Key points to remember while using SQLyog

by Dean Thomas

SQLyog is a powerful MySQL development and administration solution, trusted by 2.5 million users around the world. With SQLyog, organizations have a...