Databases-Other

31K

Solutions

54

Articles & Videos

7K

Experts

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.

Refine results

Hi All,
I am trying to connect to an oracle database using access 2013
The  ODBC Data driver can connect successfully to the data source see below.


But when I try to use this data source within…

1812 views
Course: From Zero to Hero with Nodejs & MongoDB

Interested in Node.js, but don't know where to start or how to learn it properly? Confused about how the MEAN stack pieces of MongoDB, Expressjs, Angularjs, and Nodejs fit together? Or how it's even possible to run JavaScript outside of the browser?

we have an access 2010 application, with backend / frontend setup. When one of the analysts opens the master copy of the front end in design view, creates a query, saves it - when another user opens t…

318 views

Just need SSMS to install it on a server, without SQL Server installation. I was given the ISO from a co-worker, but seems like its the full SQL Server Install.


How can I install just the SSMS t…

723 views

I just installed SQL Server 2012 and configured it on a server. From the local server, I can connect. However, using SSMS from another server, I cannot connect to the SQL Server I created. I get the e…

618 views

Im searching for rows in a database where the date format can variate, depending on the date format in the end-users computer. How do i write a Mysql query from date to date that regardless of the com…

412 views

I have a working query that I would like to:

1.  Break into 10 chunks (JSON)
2.  Zip/compress each chunk
3.  then return the whole 10 chunks as JSON

Can anybody help?

1222 views

Hello EE,

What is the best practice for backing up SQL?
Transaction logs should be backed up often, but hourly, 15 minutes?
What other logs or image levels and how often?
Are there any guideline…

839 views

Can you make an ODBC link to SAP and pull data into access?

IF it is possibly, can you explain how to do it?

225 views

I need to report on date of death.  I think it goes into a fact table since it's something that has happened. But what if the date of death is null? How would I populate it. I don't want a null in fac…

1534 views

I have a successful connection and data pull, but I do not get the headers.
Can someone help with with the code to pull the headers into excel row 1?

(CODE)

528 views
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

I am trying to get the size for a particular Database in one of the the SQL Servers using SSMS. I goto the Database --> Reports --> Standard report and Disk usage... I am getting this error: " Index (…

328 views

I have a large Excel file with about 9000 lines of data.  The data on the sheet is formatted similar to this, but repeats with different names:


I need to change this to a format similar to this:…

1031 views

I even have SQL_MODE = 'STRICT_TRANS_TABLES' set, hoping I'd find some cause.

I can't find any reference to this in my search so far.
(CODE)

Any suggestions on what to look for?

I'm using My…

762 views

Hello Experts -

I am stuck with this script I am writing. I am trying to write a script in python that will grab all tables from sourcedb (access db) and insert into each table in destdb (access db…

435 views

I have exported Website data from Wordpress into a Linux LibreOffice  Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data  into the hosting database using PHP M…

429 views

I hear db2 can't snapshot... we just have to live with the fact that during backup some oprations (like changes to tables) might hang.... Is this true?

326 views

Hello,

I'm working with a legacy piece of software, and it appears that it contains data in a bunch of .mkt files.  All of the boilerplate file extension websites say that mkt files are associated …

635 views

I have  a table with field names "0616" "0716" "0816" etc for 24 months. These fields contain numbers.
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a C…

541 views

I'm trying to figure out this design.


I have a count measure "Count(ids)" in my fact table.  I also have the standard date dimension which is joins up to fine.  I'm trying to figure out where to …

636 views
Product Review - Android Remix

Come along for the ride with our Senior Product Manager, Brian Matis, as he reviews the Android Remix.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d882c47e-7988-4f2b-833b-3c3b207ee27e/sql-server-memory-dynamic-or-fixed?forum=sqldatabaseengine

is the dynamic memory concept for sql server…

350 views

Looking for a system to track equipment (in this case IT department items).

I know its a wide open question; just want to know what you use and why, cost, pros and cons on what your using, etc

L…

657 views

Hi there,
I currently store all of our users passwords in our database using AES encryption with unique salt per user combined with a site specific encryption key.

I'm looking at increasing our se…

352 views

Hi Experts,
I'm in a bind with our application upgrade.  It's failing due to collation conflicts in the database.  I analyzed our MSSQL collation properties by instance>database>columns and uncovered…

1366 views

Hello Experts -

A previous expert was able to help me generate the below query that will look for all the stores in our company and display data that adds two separate years together.

I understa…

1369 views

Hello Experts,
Our customer needs to distribute a small app to several distant locations....
Now this app will have a database...
1) Which is the best database to distribute many times (like little…

1069 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

335views

RELATED TOPICS view all topics

  1. MS SQL Server
    (155,667)
  2. Query Syntax
    (46,944)
  3. MS Access
    (214,667)
  4. MS SQL Server 2005
    (71,322)
  5. MySQL Server
    (46,095)
  6. Oracle Database
    (77,561)
  7. MS SQL Server 2008
    (48,246)
  8. PHP
    (116,541)
  9. Active Directory
    (71,936)
  10. Programming-Other
    (51,670)