Big Data Tag Directory

Browse Alphabetically:

Featured Big Data Questions

Should I use MongoDB for file storage?
I’m currently looking for the best available solution to create scalable storage for my big files. Some of the files range from 1-2 megabytes and others are 500-600 gigabytes. I was looking at Hadoop but it seems a bit complicated. Now I’m looking at MongoDB and its GridFS as my next file storage solution (I’m...

Answer Question   |  April 8, 2014  4:00 PM
File storage, Hadoop, MongoDB
asked by:
56,505 pts.

What’s the best NoSQL database for storing files?
I know this is a more general question but I have several big binary files and I’m looking for the best NoSQL database to store them in. Can anyone share their experience with NoSQL? Thanks!

Answer Question   |  March 23, 2014  4:00 PM
Binary files, NoSQL
asked by:
56,505 pts.

How can we store passwords in reversible form?
We have a PHP application that use to bash scripts / provide a username and password for remote systems. Currently, we’re trying to find a place to store these records that can be accessible by the PHP. We’re thinking of NoSQL but the problem is that the hashing / storing of these credentials is not...

Answer Question   |  March 21, 2014  1:05 PM
NoSQL, PHP
asked by:
56,505 pts.

How to plan cloud computing career for Java developer?
Hi, I am basically Java developer and have 5 years of Java Web Application Development experience. Now I am planning to take my career to the next level by choosing latest technologies like cloud computing and big data. What are the cloud technologies to start with keeping job opportunities in mind. Will Hadoop be a...

Answer Question   |  November 14, 2013  7:23 AM
Big Data, Cloud Compuiting, Hadoop, Java
asked by:
5 pts.

SSIS 2008
I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.

Answer Question   |  October 28, 2013  7:52 PM
SSIS, SSIS 2008, SSIS Testing
asked by:
5 pts.

SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB...

Answer Question   |  October 23, 2013  9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
asked by:
60 pts.

SQL server 2008 provide access to SSIS
Client needs access to SSIS sql server 2008   Thanks, Evgenia

Answer Question   |  October 23, 2013  2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
asked by:
5 pts.

How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005
Hello, I recently read Jeremy Kadlec great article titled, “Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard“. Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I can’t find out how to modify the...

Answer Question   |  October 18, 2013  3:56 PM
Copy Database Wizard, SQL Server 2005, SSIS
asked by:
5 pts.

How to transfer SSIS Tasks from 2008 R2 to 2012
I am about to switch from SQL Server 2008 P2 to SQl Server 2012. I use a number of custom SSIS Tasks on 2008 R2 and I’d like to know if it’s possible to transfer them to 2012; and of course if it is possible, how to do it. I tried just opening my DTSX...

Answer Question   |  October 4, 2013  6:34 PM
SQL Server 2008 R2, SQL Server 2012, SSIS
asked by:
56,505 pts.

Does SQL Server Data Tools work with SQL Server 2008 (SSIS)?
I’m trying to figure out if I can use SQL Server Data Tools (that comes with SQL Server 2012) to create SSIS packages for SQL Server 2008. Basically, I just want to use SSDT to create / maintain SSIS on both 2008/2012. Thanks!

Answer Question   |  October 4, 2013  1:19 PM
SQL Server 2008, SQL Server 2012, SSIS
asked by:
56,505 pts.

Loading flat file into a database table with SSIS
Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn’t exist anymore in the database Insert only new records in the database Automated Don’t overheat SQL database....

Answer Question   |  September 25, 2013  7:35 PM
SQL Server 2008, SQL Server database, SSIS
asked by:
56,505 pts.

SSIS on SQL Server 2012
We’re in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there’s a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

Answer Question   |  September 23, 2013  6:33 PM
SQL Server 2005, SQL Server 2012, SSIS, Visual Studio
asked by:
56,505 pts.

Security for SQL Server 2012 SSAS
So I just installed an instance with SSAS only. Now, I’m curious how security (login) will be maintained. I’ve created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

Answer Question   |  September 18, 2013  12:25 PM
SQL Server 2012, SQL Server security, SSAS
asked by:
56,505 pts.

asked by:
56,505 pts.

New Contest: You Could Win a New Xbox 360
Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most...

Answer Question   |  August 26, 2013  2:14 PM
DataCenter, DataManagement, Development, ITKE Community, ITKE Contests, ITKE Feedback, ITKnowledgeExchange, Linux, Lotus Domino, Microsoft Exchange, Microsoft Windows, Mobile, SQL Server, VoIP
asked by:
56,505 pts.

Seperation of AD and Exchange Organisation
I am currently working on a project where a company is seperating one of its entities out from all others. Their current structure is all in 1 AD forest and 1 Exchange Organisation. We need to build a whole new forest and Exchange Organisation for this entity. We dont have a problem with creating new...

Answer Question   |  August 13, 2013  1:20 AM
Active Directory, DataManagement, Migration
asked by:
0 pts.

Do you think you have the right analytics?
Is your company working on any big data projects? How much confidence do you have that you have the right analytics to derive value from it? How happy are you with the analytics knowledge in your organization?

Answer Question   |  August 1, 2013  5:23 PM
Analytics, Big Data, Data Analytics
asked by:
3,995 pts.

SSIS, CLR, sp_OAMethod or another method to call web method
I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could...

Answer Question   |  July 8, 2013  6:42 PM
CLR, sp_OACreate, SQL 2000, SQL Server, SSIS
asked by:
6,360 pts.

LAN connectivity problem with Compaq notebook
I have a Compaq EVO n1020v notebook. This works fine in our office LAN and sometimes it does not at all. Office LAN is a workgroup with ICS enabled in win 2K server. If I check the IP of the notebook it shows the IP of the LAN but never connects to the internet, can’t...

Answer Question   |  June 14, 2013  1:35 AM
Business/IT alignment, Cabling, CRM, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Desktop management applications, Desktops, DHCP, DNS, E-business, Ecommerce applications, Ethernet, Firewalls, Forensics, Hardware, Hubs, Incident response, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, NIC, OS, Patch management, Routers, Security, Servers, Software, SQL Server, Switches, TCP, Tech support, Training, VPN, Wireless
asked by:
10 pts.

Issue with passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I...

Answer Question   |  June 13, 2013  9:07 PM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
asked by:
15 pts.

Browse Alphabetically:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: