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...

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 packages in Visual Studio 2010 but they...

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!

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...

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!

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).

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?

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 not get a...

Tata Consultancy Services (TCS) Ltd., surveyed 1,217 big data and analytics, IT management, and sales and marketing professionals last year. Among their interesting finds were that of the companies that undertook big data in 2012, just over 40% predict seeing a return on investment (ROI) of more...

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,...

Plenty has been written on the revolutionary technology advances that make big data possible. But the real value comes when people change the way they make decisions. Is big data also the basis of the next big management revolution?

One of the key takeaways from this year's Enterprise Data World conference was how to have a successful career in data analytics. A good way to ensure it happens...conduct a self assessment. Would you agree? If not, what's the key to having a successful data analytics career?

The big data industry (Hadoop, NoSQL, and in-memory analytic engines) is booming as Wikibon predicts the market will exceed $47 billion by 2017. Wikibon analyst Jeff Kelly says while big data started out with the web companies, it's now taking off in almost every industry. Will the big data market...

When enterprises deal with big data, a fine line emerges between using public and personal information. While a company can't be responsible for personal data coming out in the public, simply using the data in models can lead to several legal and regulatory issues. What's the best way to deal with...

Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data...

A buzz is stirring through enterprises as they decide whether to use social media analytics. While it provides a lower-cost alternative with instantaneous feedback on different data services, many businesses are wondering if this is the right time to jump on the bandwagon. Does your company invest...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy