Databases

58K

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

I have a particular tablespace (12.1.x) with multiple datafiles. All but one of the datafiles are allocated 30 Gb, and about 40% consumed. Overall, the size of the available space is about 35%. However, the database is throwing a threshold exceeded warning, showing less than 15% available. Fragmentation is fairly high, but extents appear to be in line. As I write this, the thought occurred to me to recheck the shell script that checks and throws the threshold warning. Apples to apples, etc.

I figure it's about time we enabled row movement and began defragmenting. I am pinging for further ideas about validating the threshold warning.  TIA.
0
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

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

Hello. I create a Mysql database and a table on a web hosting company server. but I do not have an idea, How to verify connection and  bring a record or value from Mysql database. Can someone write a simple php code for me? I have following information. for example, Server IP address- 1.1.1.1, Database name-tempdataserver, Database user ID- tempuser, Password- temppaass.
Primary key column- stock, Primary key example- aapl, Column to display- CLOSE.

I  can connect  use Mysql for Excel and make a new table.
Thank you.
0
how can I check last 30 or 60 days database active connection history in sql server ? I need to decommission sql server.
0
Cannot see one database in the linked server. I have three servers. Server A is running SQL 2014. Servers B and C are running SQL 2017. I have created a linked server on server B and C back to server A. When I review the catalogs under the linked server on servers B and C all but one of the databases is there. The ones that are there all have the same names. If I create a database on server B and C with the same name, the database will appear but there are no tables. What must I do to be able to see all the databases on server A from within SQL on servers B and C? I am logged into all servers as 'sa'. I have set RPC and RPC Out to True on both servers B and C.
0
Can anyone explain to me about linear hashing. I am kind of confuse. If you can provide me an example to help me to get understand that will be great.
0
I am fumbling through trying to learn Access better.  I am trying to figure out how to use the charts on the forms but can't get it to start where I want.  

I took a table that has multiple years of sales data. I made a query where I summed the sales for all parent groups while grouping by date but I summed the data over specific date ranges that are dynamic. I created several fields like the example below.  I wanted to be able to compare sales from the last year to sales from the same point 1 yr ago and 2 yrs ago.

Last12M: Sum(IIf([orderDate] Between DateAdd("yyyy",-1,Date()) And Date(),[ZqryAmazonOrderHistory_ShipStationOrders].[quantity],0))
Last12M_1YrAgo: Sum(IIf([orderDate] Between DateAdd("yyyy",-2,Date()) And DateAdd("yyyy",-1,Date()),[ZqryAmazonOrderHistory_ShipStationOrders].[quantity],0))
Last12M_2YrAgo: Sum(IIf([orderDate] Between DateAdd("yyyy",-3,Date()) And DateAdd("yyyy",-2,Date()),[ZqryAmazonOrderHistory_ShipStationOrders].[quantity],0))

The query looks great.  I changed the date to be Date: Format([orderDate],"mmdd") so that I could chart the lines for 3 different years on top of one another.  

I am trying to create a form to display the graph of the sales among other things but I cannot get the chart in Access to start the data from the current month.  It always shows it as starting at 0101 and ending at 1231.  I have applied a sort order with the actual date to the query but the chart ignores that and even when I change it in the transpose …
0
I have an Access 2016 database with a table and query that I want to export to fixed width text files monthly (I give a data example below). The problem is that I can't guarantee that the access database structure will remain the same. Due to this I can't use the built in saved exports feature in access. I have copied and modified a script that will create a schema.ini for me on the fly with the proper schema formatting, including field names, field widths, etc. The problem is I am uncertain how to use it to export the data. I was reading this rather informative web page about how to work with a schema.ini file but it references how to use it for import, not export:


I was originally trying to use the TransferText method but I just keep running into errors with it. Most sites I am reading that are newer seem to recommend using ADO commands now.
DoCmd.TransferText acExportFixed, "schema.ini", tableName, "C:\TestFolder\TestFile.txt", True

I am willing to use any method that works and am open to suggestions.

An example of my issue is that in one month it would be that the database table has 2 fields, both width 10:
fieldID Integer
fieldUserName Char Width 10

Open in new window


But the next month it could have 3 fields and different sizes:
fieldID Integer
fieldUserFName Char Width 25
fieldUserLName Char Width 25

Open in new window


I have a script that can create a schema file on the fly to account for the structure changes but I am not sure how to export the data using the updated schema file.

Open in new window

0
I have an Access database that has several users. The database uses mscomct2.ocx and comdlg32.ocx. Two weeks ago there were some enterprise-wide updates that were theoretically unrelated to the database (they were for Windows and SAP). However, something in the updates had the effect of deleting mscomct2.ocx from all the computers which caused problems for the Access database.

Once we discovered this, we reinstalled and re-registered mscomct2.ocx on all the machines (they're all Windows 10) and they are now all working fine except for one of them.

On the one machine, if I go in to VBA and Tools / References, I see that those controls are there and they aren't showing up as missing. The files are also where they should be (\windows\syswow64) and they're the same versions as on the other PC's.

But when Access tries to use either of those controls, we get the following error:

Run-time error '-2147319779 (8002801d)':
Automation error
Library not registered.


So we're unable to use the portions of the database that need those controls. But just on that one computer.

We've tried unregistering and re-registering the controls.

Any suggestions on how to resolve this problem?

James
0
0
Hi Expers,

As I have done many times before, I just downloaded the latest version of WordPress (5.2.4) and  copied into a newly-created dev site folder, C:\inetpub\wwwroot\my-new-site.org

First, I got the following with PHP 7.1.10
WordPress database error Unknown column 'wp_' in 'field list' for query SELECT wp_

Open in new window


Again, this  is a new instasll.

I then changed my PHP version to 5.6.5, and i get
The site is experiencing technical difficulties.

Open in new window


With PHP 7.1.10 on this server, my previous WP websites are still functional.

Any advise would be appreciated.
0
CompTIA Network+
LVL 13
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

I want to know if it's a good idea to have database views be used for queries and reporting instead of the live database tables?  This database has 100's of tables, but I know that for their reporting, they will probably only need 5 or 6.  Thoughts?  Any body have any recommendations, suggestions for creating database table views?
0
We have an Access database that runs ok on a Windows Server, but we have significant performance issues when attempting to use the database when working from home over our VPN via Cisco AnyConnect. Since we all have laptops, and bring them home when working from home, there is no PC in the office to use RDP.

How do people normally get good performance when running MS Access remotely if they aren't using RDP?
0
Hello guys,

Is someone able to give me a hand regarding this task?


URL lookup service
-------------------------------

We have an HTTP proxy that is scanning traffic looking for malware
URLs. Before allowing HTTP connections to be made, this proxy asks
a service that maintains several databases of malware URLs if the
resource being requested is known to contain malware.

Write a small web service, in the language/framework your choice,
that responds to GET requests where the caller passes in a URL and
the service responds with some information about that URL. The GET
requests look like this:

GET /urlinfo/1/{hostname_and_port}/{original_path_and_query_string}

The caller wants to know if it is safe to access that URL or not.
As the implementer you get to choose the response format and
structure. These lookups are blocking users from accessing the URL
until the caller receives a response from your service.

Give some thought to the following:

* The size of the URL list could grow infinitely, how might you
scale this beyond the memory capacity of this VM? Bonus if you
implement this.

* The number of requests may exceed the capacity of this VM, how
might you solve that? Bonus if you implement this.

* What are some strategies you might use to update the service
with new URLs? Updates may be as much as 5 thousand URLs a day
with updates arriving every 10 minutes.

Regards
RM
0
Experts,

I have the following dataset
dd
I am going to add a row with a name 'newadd' in column Name.
I am going to update a row with name Boris to Blair
I am finally going to delete the row with name Michael in the name column.

When I run the following code everything shows apart from the where I deleted the row;

 SELECT
    ChVer = SYS_CHANGE_VERSION,
    ChCrVer = SYS_CHANGE_CREATION_VERSION,
    ChOp = SYS_CHANGE_OPERATION, PA.*
  FROM CHANGETABLE(CHANGES dbo.data_source_table, 15) AS ChTbl
 INNER JOIN dbo.data_source_table PA ON PA.PersonID = ChTbl.PersonID

Open in new window


As you can see, I am able see those rows that were updated or inserted, but I can't see the row that was deleted. Can someone let me know why I can't see the deleted row?
deg
0
I have a Sharepoint list (Calendar) and I want to get data into a different SQL Server Table every 5 minutes (live Linked Server would be awesome but in my dreams i think). I can build SQL job that runs every 5 minutes but I just cannot seem to grab the data. Options would be great.
0
PowerShell script to automate SQL Database Failover/Failback test

PowerShell Automation TASK:
1)      Create a PowerShell script to failover SQL Database servers from Primary Site to Data Recovery Site.

2)      Create a second PowerShell script to failback SQL Database servers from Data Recovery Site to Primary Site.

We have two SQL database servers in our Primary Site, one server is setup as primary SQL database server (SQLSER01), and the other one is setup as secondary SQL database server (SQLSER02). The primary server is replicated to the secondary server, the two servers are members of Availability group AG1.

Availability group AG1 (Primary site)
   SQLSER01
   SQLSER02

We have two SQL database servers in our Data Recovery Site, one server is setup as primary SQL database server (SQLSER03), and the other one is setup as secondary SQL database server (SQLSER04). The primary server is replicated to the secondary server, the two servers are members of Availability group AG2.

Availability group AG2 (Data Recovery site)
  SQLSER03
  SQLSER04

DistrAG
  Distributed group is the connection between the two Availability groups (AG1 & AG2).

Failover Process Steps:
1)      Connect to each SQL server in AG1 group in Primary Site, query servers to find out which one is primary database server and which one is secondary database server.

2)      Connect to each SQL server in AG2 group in Data Recovery site, query servers to find out which one is primary database server and …
0
Hi All,

Hope someone can help. Half way through a 2010-2013 SharePoint Migration. I have run the SPtest against the old database and it has come up with a few error. One of which being that reporting services is not configured. I have been looking at the guide here: https://docs.microsoft.com/en-us/sql/sql-server/install/install-reporting-services-sharepoint-mode-for-sharepoint-2013?view=sql-server-2014 

Which says the SQL feature needs installing before enabling within SharePoint, I have the install files for SQL 2014. When I run them I do not get the SharePoint reporting options, either when running a fresh sql install or adding new features.

What am I missing?

Cheers,
Paul
SQL-Install.png
0
I am trying to back up a reporting server using the following article:

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-2017


I can back up the DB just fine but when I get to the command to back up the logs I get an error  "Backup LOG " cannot be performed because there is no current database backup.

Reading the article below, it makes it seem the COPY_ONLY command is causing me the issue. Is this the case? If I do not run the COPY_ONLY command, am I going to be missing anything important?

https://sqlbackupandftp.com/blog/backup-log-cannot-be-performed-because-there-is-no-current-database-backup
0
Dear Experts,

Is Cognos auditing somewhere any information (date, who is doing the action) when a user is created or deleted. When I say "created or deleted",  I mean somebody adding a new entry in (for example) the Consumer group from the LDAP, or somebody deleting an entry from the Consumer group.

Any help / idea is welcomed, this is a "hot topic" for the moment for me. Or I'm currently thinking about adding my own audit table on database side, by adding a trigger on the table "cmobjprops33" that would store any modification in a custom table I would create.

Thanks!
Vinc
0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Can you upload a union all database command into a Sage 300 Dashboard? I keep on getting an error message (see attached). The crystal report works fine a report in Sage but not as a Dashboard.
0
Connecting VFP Database File to Excel (pivot table).
Dears,

I have a table in Visual Foxpro 9 that is being updated daily.
I would like to create a pivot table in Excel based on this table.

These are the steps I am following - but it is not working.. Please help.

1-Go to ODBC connection. Create a new one. Based on "Microsoft Dbase-Driver (*.dbf) _- Setup the name (DataCon) - Select version DBase IV - Select the directory where the Table is
2-go to excel - create a new document- Click on insert Pivot Table - Click on Choose connection -Browse for More-New source-ODBC DSN -Next - Select DataCon-Next- Select the table - raw-Name the connection (test.odc)-Finish
It gives me "ODBC DBase Driver - External Table is not in the expected format !
0
I'm getting some error like this:

MongoError: E11000 duplicate key error collection: auth.users index: email_1 dup key: { email: "damianjnc114444455@gmail.com" }

Any ideas?

my code

https://github.com/damianjnc/server-authentication/tree/665d5bd2ac7e2b346d2616d5013311a5ff0cc430
0
Hi,

I need to call a function on a linked server dynamically.

I've created a function that that can build my SQL and a proc that can execute the Query and return the value and i can run the proc row by row, but i have 80k records to loop through on a full reload and this isn't going to work (24hrs)..  I'm running it through this now, row by row, and i guess there is a lag on the linked  server connection but can anyone suggest a better way of doing this apart from copying the function into the Repository layer of my DW? Is there an alternative way of dynamically calling a function on a linked server apart from openquery, is there anything in my code that could be streamlined to improve performance, or is this the best i will get it?

Ideally i want to run something like this in the select

,MembershipStatus            = Repository.[Mapping].[f_GetStatus] (m.id,'HLX-CMS-HHS')


Here is my update routine in the staging proc (It works):

DECLARE @idColumn int, @MemberStatus NVARCHAR(100)
 
DECLARE @sql NVARCHAR(800)
DECLARE @t table(result varchar(50))
 
DECLARE MemCursor CURSOR FOR
SELECT DISTINCT Membershipid, MembershipStatus FROM HHS.DimMembership where NULLIF(MembershipStatus,'') is null
 
OPEN MemCursor
 
FETCH NEXT FROM MemCursor INTO @idColumn, @MemberStatus


WHILE(@@FETCH_STATUS = 0)
BEGIN

                  SET @SQL = (SELECT Repository.[Mapping].[f_GetStatusMembershipById] (@idColumn,'HLX-CMS-HHS'))

                  INSERT INTO @t
                  EXEC (@SQL)
                  
                  BEGIN TRY  
            …
0
Hi All,

I am a beginner of Laravel and I use MS SQL.
I want to create API to pass image for GET and POST.

The image will be stored to MS SQL database.

How could I do it?

Thank you.
0
Hello Experts
I have installed  sharepoint 2013 and like to rename the default databasename  given by microsoft  (sharepoint _config) after installation instead of reinstall again
what are the detailed steps to rename it and let sharepoint 2013 connect to the renamed database name normally
waiting for your kind advice
0

Databases

58K

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.