I also posted this on Stack Overflow. I got no answers there so I'm hoping someone here might be able to help. I have a table in which every row represents a user, I am also storing the user's timezone as text such as 'America/Denver', 'America/New_York', etc. Is it possible to write a query th...

I have some 100+ Oracle/SQL server databases to manage. Need is that how can I put up the availability of databases (up/down) projected on to a monitor from where it can be seen if a database goes down, I should get an alert on it. What tools can I use. I use EM12c for managing everything, I know...

Is it required to have an encryption key for SQL Server 2012 Reporting services?

We have a function that executes dynamic SQL (I know, SQL injection, the "Bobby Tables" attack, but that's a separate issue). It takes two parameters, interpolates the first into the second, and returns a boolean. When we execute it like this: SELECT util.dynsql('M','SELECT EXISTS (SELECT 1...

Following SQL Query: select 0 ID,'--Select--' NAME will return following result on SQL server ID Name 0 --Select-- I want the above mention query to return something like: ID Name 0 --Select-- 1 Fresh 2 3-5 3 5-8 4 10+

I am using Microsoft SQL Server 2008. My version of Server Management Studio is 2014. I am attempting to create a table in a database I imported from a Microsoft SQL Server 2005. Here is my code: CREATE TABLE testTableNicks AS ( SELECT * FROM Person WHERE name LIKE'%nick%' );...

I have a stored procedure that I've been testing on two different servers and it runs slower on the server with more memory and I can't figure out why. Setup 1 is my virtual environment, consisting of Windows 7 x64 with SQL Server Express x32 10.50.2500 and 4GB of memory, Setup 2 is a ...

I am setting up a new database and I want to import lots of data from multiple spreadsheet files. One of the fields in these documents contains an array of data, each item declared on seperate rows as follows: Field 1 ¦ Field 2 ¦ Field 3 ¦ Field 4 ¦ Field 5 ¦ ====================================...

I'm trying to convert my client database from MySQL to MySQLi and being a noob I'm having issues with it. Here's the code: <?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "clients"; // Create connection $conn = mysqli_connect($servername, $username, $password, $db...

I want to develop a J2EE application with a relational database (Oracle 12c), for now I am doing it in local, if someday I want to deploy my application as a webpage, is there any platform or web server ... I can migrate my application and database to for free ? Any ideas please ?