The tag has no wiki summary.

learn more… | top users | synonyms

10
votes
3answers
137 views

Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?

I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases ...
0
votes
0answers
12 views

FTP map disapears after a while [migrated]

I'm deploying an C# mvc application with a couple of content maps to save my images in. I made them all in the ~Content/Images/ map and they work fine but after a while, sometimes just 15 minutes, a ...
-1
votes
0answers
18 views

Accessing a NAS using MySQL/Etc [closed]

Probably an easy question, but I want to make a webapp to sort of View/Sort/Etc... Movies/Music/Files on a NAS (It's a Synology Station on a Home Network). There shouldn't be any reason a database ran ...
1
vote
1answer
296 views

MySQL Tables crashing randomly

This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this? How do I keep MySQL tables from crashing and MySQL from crashing? Repairing USR_wp537 ...
1
vote
1answer
114 views

Using multiple Active Directory accounts to connect to SQL Server

I have web applications (Classic ASP and .NET) that connect to SQL Server using SQL authentication. Each one has their own login. I want to convert these to Windows Authentication. The new AD users (1 ...
0
votes
0answers
159 views

Optimizing MySQL for a shared hosting setup

This is my current setup: [mysqld] default-storage-engine=MyISAM local-infile=0 symbolic-links=0 max_connections = 500 max_user_connections = 25 key_buffer = 64M myisam_sort_buffer_size = 32M ...
1
vote
1answer
293 views

SQL Server connection from iis website: “error: 26 - Error Locating Server/Instance Specified”

I've just moved all my databases from one server to another clustered server. The new SQL Server 2008 R2 (enterprise edition) install is using named instances on a non-standard port. SQL is running ...
2
votes
1answer
261 views

Good articles for SQL Server Health Check specifically for Web Applications

I am searching for Database Health check articles specifically for a web application back-end server and SQL Server 2005/2008. My current checklist includes: - Index Fragmentation - SQL Server ...
3
votes
1answer
239 views

Does MVC architecture design pattern effect MySQL database performance?

Our current site is entirely developed in the cakePHP framework with the MVC architecture. If we notice more than around 19-20 users viewing the site at once, it begins to crawl to a hault and begin ...
4
votes
2answers
1k views

Best way to build a server inventory db and web interface?

My team is looking to build a rich inventory of servers at our enterprise. We are trying to consolidate several different excel documents into one database. I found a great utility called AppGini ...
2
votes
1answer
86 views

Oracle Control and Webserver

How does the Database Control work, since Apache is not running on this computer? The Url says https://localhost:1158/em/console/logon/logon. I do have a WAMP apache server on here but I have to shut ...
2
votes
1answer
402 views

How to configure so the Oracle wallet password can be authenticated with a web based Oracle application?

Does anyone know how to configure it so that the Oracle wallet password can be authenticated with a web based Oracle application? I’m trying to make secure LDAP connections with an Oracle web based ...
14
votes
3answers
496 views

How to store 'n' days of web server logs in Sql Server?

For faster reporting and performance analysis, we want to insert our web server logs into Sql Server. This will allow us to see traffic patterns, issues, slowdowns in near real-time. We have a daemon ...