Explore Databases on Experts Exchange

Expert Solutions for Your Tech Problems

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes tha...

Read more
  • 830K Content
  • 45K Contributors

Expert Spotlight
Gary PattersonVP Technology / Senior Consultant

Experienced, hands-on IT expert.  IBM i / iSeries / AS/400, Windows, Linux, security, performance, web, mobile, SQL, RPG, Java, .NET, more.

Article
SA

Deny SA account for Developers in Microsoft SQL Server

2020-05-13
This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.
Article

Storage savings with Microsoft SQL Server

2020-04-28
This article shows how to use different types of data compression in SQL Server and they drawbacks.
Article

Big Data: Concepts, Security and Use Cases

2020-04-26
The goal of Big Data is to automate multiple processes to assist in finding value. Big Data has turned out to be one of the most encouraging and winning innovations to anticipate future patterns.
Article

How to load JSON's data into SQL Server in different ways

2020-04-28
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.
Article

Office file dialogs

2020-04-12
Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module import, 1 line of code, all done... GLHFSS
Article
How to load Excel's data into SQL Server in different ways

How to load Excel's data into SQL Server in different ways

2020-03-292
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.
Article
Time Zones, and Microsoft Office - Part 2

Time Zones, Windows, and Microsoft Office - Part 2

2020-03-09
Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and select a time zone in Microsoft Access and Excel.
Article
Time Zones, Windows, and VBA - Part 1

Time Zones, Windows, and VBA - Part 1

2020-03-09
Obtaining and using time zones in Windows is not simple. It involves API calls and reading the Registry. Some information is localised, and some is not. Here you will find a complete set of functions that wraps the difficult steps, eases common tasks, and helps when designing user interfaces.
Article
Appointments

Synchronizing subforms - What record is displayed on top of a continuous subform after using scrollbar?

2020-01-31
While working on a calendar and appointment scheduling application, I found I needed to synchronize multiple sub-forms, displayed side-by-side, so users would be able to see the schedules of multiple care providers and identify gaps in their schedules, this was more difficult than I expected.
Article

JavaScript Compiler: SQL query

byZvonko
2020-01-22
Microsoft Windows comes with a built in JavaScript compiler. This article describes how to query SQL data source and write the response to a text file from a JavaScript compiled exe file.
Article

Forcing users out of an application

2020-01-21
If you've ever needed to repair a database or perform maintenance on it during the business day or tried to do so at night, only to find out that one or more users walked away from their computer with your application loaded, this article is for you.
Article

Dynamic Version Controlling of Oracle Metadata using shell script

2020-01-15
In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
Article
Appointment Calendar

Using multiple instances of a sub-form in a single form

2020-01-131
Creating multiple copies of a sub-form to use in a single form will bloat your database and require significant effort to maintain. Instead, use multiple sub-form controls with the same Source Object and make judicious use of SQL and VBA to filter the data in each sub-form.
Article
MAC Addresses

MAC addresses in Access and Excel

2019-11-03
The block of six octets of a MAC address represents a lot of challenges when it comes to reading, formatting, parsing, validation, and lookup of vendor information. The functions presented here let you read, generate, format, store, list, and report MAC addresses and derived BSSIDs for most tasks.
Article
Converting BYTES to CHAR on Oracle Database

Converting BYTES to CHAR on Oracle database

2019-10-14
In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
Article

Importing Tables from Older Unsupported Access databases

2019-09-12
A small utility that imports the tables from Older - Unsupported Microsoft Access Databases
Article

20 Varieties of Quartiles

2019-08-24
There is no single "correct" calculation method for quartiles. Excel features two methods, some math and statistic packages offer some more, but here is presented no less than twenty methods for various purposes using VBA and Microsoft Access.
Article
Spartan Hero

Defeating the device-independent bitmap (.dib) format

2019-08-21
A small Access Application that shows the handling of .jpg images to assign them to popular Microsoft Access Controls while stored in the Application itself in their original format.
Article

Ranking rows in Microsoft Access

2019-07-16
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.
Article
Date Time Picker

Microsoft Access Date/Time Picker

2019-06-272
Do you need a date time picker, how about just a time picker? Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a try.

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more