Databases

56K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Restore Stored Procedure in SQL Server
In this article, we will discuss how to deal with a situation wherein you face an issue with a mandatory stored procedure in your critical database.
0
Powerful Yet Easy-to-Use Network Monitoring
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Exchange EDB to PST Converter
Use SysTools Exchange EDB to PST Converter to safely converts Dismounted, Offline or Orphan EDB file of Exchange 2019, 2016, 2013, 2010, 2007 Environment easily in PST file format. Now Converts Exchange mailboxes items such as emails, contacts, calendar details into .pst format without PowerShell.
0
Are you ready for a Linked Table Manager (LTM): - with a sizable form - which identifies which connections are valid and how many tables are associated with the connection - which doesn't ask you to select the BE multiple times when you've identified tables from multiple sources to refresh?
4
LVL 75
Comment Utility
The Hernandez book is certainly a classic.
And yes ... many Access databases start from Excel spreadsheets - once Excel self-destructs ... and ultimately become real databases :-)
0
LVL 20

Expert Comment

by:Andrew Leniart
Comment Utility
Hi Charlotte.

Andrew, my biggest pet peeve about Access training and "how-to" articles is that they address the tools in Access but rarely the underlying design principles that are essential in building a database.

Indeed. You make an excellent point, one that I hope Dale (author of this article) and other readers will take note of for future article submissions. Perhaps an article explaining just that? :) Yes, there are already many explanations to be found with Google.

The difficulty I see here is that the term "Database" is so broad that to a layman, can also sound such technical a term as to discourage the excitement of learning about it. A title like "Learn the underlying design principles involved in building a database" wouldn't likely attract my attention, nor dare I say it, most others who don't have a vested interest in learning Access or other related software.

Yet if I saw something I could relate to, like "Learn to organize your favorites so that all browsers can use them" and do that in Access, well, that might be something I'd click on and actually read. The trick is in finding a way to educate using a hook and subject matter that will entice people to want to read and want to learn more. That's why I think different ways of educating on the same topic is so important.

Take the question: What is a database?

If I "Google" that as kindly suggested to me earlier by Joe, then the first thing I get is that its "a structured set of data held in a computer, especially one that is accessible in various ways."

Sounds too much like programming to me and doesn't really entice me to continue digging in order to learn more. I think that's a core problem of why many don't turn to something like Access and use Excel instead - it's too much like programming.

It's only when the penny drops (and for me, it's by reading articles like this one out of need while editing) that you start to get more interested in digging further. Editing articles such as this one prompt me to ask the question, how can I relate what I do in Excel, to do it even better in something like Access?

I confess I have a vested interest in promoting for these types of articles, both as someone who wants to read them, and someone who gets to edit article submission here in a volunteer Page Editing capacity. We already have a ton of technical "how to" articles as you say, but I think that's a good thing and keep them coming I say!

Yet I think interestingly written articles that will attract the "Joe Averages" of the world, who use Excel to store information in mostly because it seems easier to come to terms with using, yet will never know until enticed to dig deeper just how much easier life could be by delving into the cryptic world of databases.

That's the type of "How to" article I'm trying to promote be written here. Is there a single way of doing that? I don't think so. I'm just trying to encourage readers who have the necessary knowledge to give it a go. Hope that makes sense? :)

Look for a book by Michael J Hernandez, "Database Design For Mere Mortals"

Thanks for the heads up. I'll most certainly do that.

Regards, Andrew
0
Sysadmin Day 2018 is coming up on July 27th, and, going along with the recent premiere of the new hit movie The Incredibles 2, we want to share a light-hearted and comical explanation of what sysadmins are and why they are so incredible.
2
Export Exchange Mailbox to PST
Getting Error, Export Database to PST file failed in In Exchange 2016/13/10 due to file size, bad items, syntax error of Powershell commands. Fix file status issue by directly exporting mailboxes of Exchange into pst format via the export utility.
0
Recover Exchange Mailbox
In Exchange Server 2003 and 2007 the command isinteg is used to check the health of database and to repair Exchange Database. If the command is not successful to restore a corrupt damaged Exchange Mailbox. try an automated solution as isinteg command supports Exchange 2007 and below versions only.
0
“The Microsoft Jet Database engine stopped the process…” while working with a Microsoft Access database. The database may be saved as MDB or ACCDB file depending on the Access version that you used to create the database file.
0
Repair Exchange Mailbox
Now Export Exchange 2010/07/03 Mailbox to Office 365 directly with Systools Exchange Recovery Tool. Repair Corrupt or Damaged Exchange Mailbox and move Database to O365 account to Mails, Contacts, Calendar, Tasks and Journal details.
0
Test data generation in software testing depicts the underlying conditions for a test and speaks to the medium through which the tester impacts the product. It is a critical piece of most Functional Testing.
0
Exchange Server Toolkit
Exchange Mailbox Toolkit is a Combination of 8 Essential Exchange Software required to solve problems related to Recovery of Exchange Mailboxes. Get Exchange Management Toolbox to Convert into a different file format and Import Exchange mailbox to PST format or vice versa of 2016/13/10 /07 versions.
0
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Repair Exchange Database
Check Mailbox Corruption in Exchange for the proper working of Exchange Server. Use IsInteg Or New-MailboxRepairRequest for regular health auditing and to check Integrity of Exchange Database(.edb) file. Repair corruption in EDB file via Eseutil Powershell commands in MS Exchange 2013/10/07 versions
2
Here is the list of top 5 best SQL recovery software with their key features and licensing details. One can choose the specific SQL database recovery program according to their need.
0
This tutorial is a great guide for newbies in SQL Server who never backup the database and for people with some experience, because you will learn some tips that you may not know.
1
SQL Backup Repair
Know how to repair corrupted backup files using SysTools SQL backup Recovery, Also understand the reasons behind .bak file corruption in SQL Server.
0
Recover Exchange Mailbox
Know how to repair Exchange Database of 2016/ 13/ 10/ 07 using eseutil /p, /r, /d Powershell commands. Also fix Dirty Shutdown and Event 501, 533, 1216 ID Error using inisteg and New-MailboxRepairRequest to repair Mailbox Database of Exchange 2016 /13/10/07 and other below versions.
0

Expert Comment

by:Sunil Sharma
Comment Utility
Facing Exchange Server mailboxes is really difficult to handle, but by using exchange server recovery tool, you can easily fix the issue very easily. The tool is well equipped to deal with (in dealing with) Exchange disasters situations. You can restore mailboxes from any of the backups created at any point of time, even the ones created using third-party backup tools.
0
Repair Corrupt Exchange Mailbox
Learn how to reduce mailbox database size of Exchange 2016,2013, 2010, 2007 and other versions. As Storage Limits for Exchange Mailboxes in Exchange versions are different. Try to use Defragment mailbox to remove whitespace to shrink the mailbox size of Exchange Mailboxes to increase performance.
0
This is about the change in the value setting for the rp_filter parameter in Linux.
0
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
0
Are you working to mount the dismounted Exchange 2013 database? Then the best course of action is to analyze the causes of Database issue, their probable solutions and decide for the appropriate course of action.
0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Contact Form 7
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
0
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
0
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
0
Attach SQL Database
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
1

Expert Comment

by:Rejin James
Comment Utility
Thanks for such an informative article! It was of great help to me. Had already tried the 1st two methods which you had mentioned so I directly skipped to trying the software you recommended. Initially the software took about 35 minutes to scan my file, but the best part is that it showed all the records of my database. That moment was a huge sigh of relief to me since I was able to see the crucial data after spending almost 2 days repairing the .mdf file. Now that I have recovered my data, I can finally sleep in peace. Stellar SQL Database Repair is definitely a brilliant software!
0
How to Perform Full Migration from Elastix to Issabel
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully transferring all configurations.
0

Expert Comment

by:sergio mak
Comment Utility
bonjour !!!
j'essaye d'installer issabel ,pas de soucy au niveaux de l'install,par contre je n'arrive pas à faire des appels sortant alors que mon trunk est registred
est il possible de faire un tuto sur la config du trunk de la route sortante et entrante je tourne en rond ca magace.
merci !!!
0
LVL 1

Author Comment

by:RoohAllah Godazgar
Comment Utility
bonjour !!!
j'essaye d'installer issabel ,pas de soucy au niveaux de l'install,par contre je n'arrive pas à faire des appels sortant alors que mon trunk est registred
est il possible de faire un tuto sur la config du trunk de la route sortante et entrante je tourne en rond ca magace.
merci !!!

Dear Sergio,
Would you please ask your question in English. I'm not familiar with French.
0
Block Chain Technology
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
1

Databases

56K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.