by Lisa Waugh | May 18, 2023 | Uncategorized
It is easy to learn how to query a database for information. SQL is a declarative language, meaning we tell the engine what to get, not how to get it. Some queries are fast, others are slow. We have all heard that an index will make the query faster, and often the...
by Lisa Waugh | May 11, 2023 | Uncategorized
Today, many roles within an organization work with the ever growing amounts of data in databases. No longer are databases the purview of just the information technology professionals, such as application developers and database administrators. Business-oriented roles,...
by Lisa Waugh | May 4, 2023 | Uncategorized
The current uncertainty in the economy is causing many organizations to look for ways of making their operations more productive. These organizations are focusing on short-term survival without compromising their prospects for expansion in the future, causing them to...
by Lisa Waugh | Apr 27, 2023 | Uncategorized
Choosing a database development and management tool does not need to be a complicated process, but you should at least determine what features are important and would be most productive on a day-to-day basis. Most tools have many features that you may never use, but...
by Lisa Waugh | Apr 20, 2023 | Uncategorized
Wherever data takes the organization, the database must follow. And wherever the database goes, database administrators and developers must take the lead in ensuring a high level of database performance. The database administrator and database developer must...
by Lisa Waugh | Apr 13, 2023 | Uncategorized
Generating useful data analytics involves multiple time-consuming and tedious steps, including: Accessing usable data that can help business users make informed decisions. Running complex queries against different database platforms to get useful datasets. Creating...