InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:56:03 GMT20http://www.sqlservercentral.com/Forums/Topic1454513-3154-1.aspxHi guys, our company is looking to put their CRM solution on the cloud. I have a number of cubes and reports that use this data. What do we need to keep in mind, as far as AS goes, if we do move CRM?The warehouse does not use CRM as the only source. There are flat files and some other sources. So I dont think I'll be moving AS just yet. (As far as I know, azure has no AS anyway?)Would it not be better to have the AS cube on the cloud,if possible, so only report or the info consumed from the cube needs to be pulled?Are there any articles on the subject I can read? if so, where?thanks a milIanMon, 20 May 2013 06:54:37 GMTIan C0ckcrofthttp://www.sqlservercentral.com/Forums/Topic1445333-3154-1.aspxDear all,In my day to day job, I work in corporate environment as DBA/Developer contractor with usual things like ASP.Net, Sharepoint, etc...At "night" (...), I also work for smaller businesses, in particular for my preferred customer (aka my wife).So far, I supplied them a (single user) BI solution made of a SQL Server back-end (2012 Express) with MS Access 2010 front-end for data maintenance and Excel 2010 Powerpivot for reporting.The problem is that I work on "shoe string" budgets and have no server (backups???) so I would like to improve by moving the database to SQL Database (cloud).I have played a bit and it looks like everything would still work fine with both PowerPivot and Access but I am a bit worried about the security aspect of the connection string and the fact that some of the new users are "mobile" and might not have a permanent IP address (hence SQL Database firewall configuration issue).I wonder whether I should not shift my Access front-end for some kind of (simple) cloud based app.My requirements are quite simple.Have you got any suggestions? I am trying to avoid difficult learning curves. A couple of years ago, I was writing ASP.Net / Ajax front-end but I am extremely rusty now.Is Microsoft Light Switch the way to go?Many ThanksEricPS: I'd rather stay in the Microsoft world (again for lurning curve reason)Tue, 23 Apr 2013 03:46:58 GMTEric Mamethttp://www.sqlservercentral.com/Forums/Topic1430271-3154-1.aspxWe are planning to move our warehouse database (which is around 1TB) to the cloud. Currently we are looking at Amazon RDS and EC2 (as these supports multiple features which SQL Azure doesn't support). Also we need high availability along with failover cluster, and backups. Can you guys please suggest when to use RDS and when to use EC2?Wed, 13 Mar 2013 03:53:14 GMTTarun Jaggihttp://www.sqlservercentral.com/Forums/Topic1429557-3154-1.aspxMy employer began using SQL Azure several months ago, but during the past 2-3 months the quality of service has markedly decreased. To date we've experienced at least one system-wide outage (defeats the purpose of a cloud solution to begin with); we've also been struggling for weeks with how to handle with Azure's aggressive connection management behavior. Plus, there's the Azure-enforced T-SQL limitations to deal with: no more SELECT... INTO in stored procedures, unable to change column data types of columns in an existing clustered index without recreating an entire table, etc etc. And while we're not ready to jump ship just yet, I have been asked to investigate alternatives. An Amazon cloud solution -- some combination of EC2/RDS/EBS/S3 for for web hosting, OLTP and backups -- seems like a pretty good place to start, especially since they offer a free 30-day trial. I've seen plenty of suggestions for migrating from SQL Server to Azure, but not so much on migrating away from SQL Azure and into Amazon RDS. Does anyone have ideas or suggestions on where to look?Mon, 11 Mar 2013 19:09:06 GMTAspNychttp://www.sqlservercentral.com/Forums/Topic1421568-3154-1.aspxhello All,I have a little question about DBA job future in near time, as there is a gradual shift fto cloud computing, I get a doubt sometime will cloud computing consume DBA jobs. The reason why I am asking is i have recently shifted from .Net to SQL server DBA and I got the job in no time, I am very much interested in troubleshooting rather then praogramming. So sometimes I get this thought did i took the right step or not, had I been taken cloud computing to secure my future can someone answer this coz I am relatively have very very little or no knowledge about cloud computing.Question:1. Will cloud computing consume DBA jobs.2. Is there a way I can do some cloud computing courses which will be related to DBA, I heard about hadoop, and azure,can someone please suggest...Thanks in advanceTue, 19 Feb 2013 05:12:27 GMTsqlpantherhttp://www.sqlservercentral.com/Forums/Topic1413786-3154-1.aspxHi all, We provide database support for a client who are planning an AX deployment to a cloud provider. The issue I see is the expected size of the databse will reach 1 terrabyte (anticipated in first 12-24 months). Currently the cloud provider has a max presentable disk size of 250GB. I see 2 strategies:1. Multiple datafiles of 250GB.2. Using a windows dynamic drive to make multiple 250GB drives appear as a much larger drive(theoretically capable of housing fils larger than 250GB). The question is how does SQL treat such a dynamic drive. Can it create files of larger than 250GB if that is the maximum underlying presented disk size. The cloud provider says yes, 250GB plus files can be created - but what is actually happening under the hood? My suspicion is that capping data file size at 250GB is the safer route. Does anyone have any input on this?Ta,RobWed, 30 Jan 2013 15:42:00 GMTSQL RObhttp://www.sqlservercentral.com/Forums/Topic1370383-3154-1.aspxHi,Can any one give me information about the Cloud computing and how is related to SQL dba.i heard that in comming day they wont require any individual technical capabilities when it goes to cloud…...Can any one help me to know about the Clould and on which area a DBA has to focus.....Many Thanks,Tue, 09 Oct 2012 07:17:27 GMTbala2http://www.sqlservercentral.com/Forums/Topic1328795-3154-1.aspxcan any one explain how to restore backup taken from cloud server to restore other cloud server.ThanksNitin :-)Thu, 12 Jul 2012 05:12:42 GMTnitin.lokhandehttp://www.sqlservercentral.com/Forums/Topic1304215-3154-1.aspx[font="Verdana"]Hi all, What performance impact the SP_PREPEXEC cause and why should it be avoided? Do we can quantify the impact?Any findings please :)Thanks![/font]Tue, 22 May 2012 08:42:54 GMTAbrar Ahmad_http://www.sqlservercentral.com/Forums/Topic1303245-3154-1.aspx[font="Verdana"]Hi folks,Do we can assume that the Cloud Computing is a threat to conventional RDBMS, especially for the field of database developers? Because of the software development concepts such as RSaaS (Running Software As A Service) and DBaaS (Database as a service), furthermore the technologies like Hibernate and NHibernate!!! :ermm:Any expert eye-sight?(Also worth mentioning) Thanks Steve for incorporating Cloud Computing its due presentation on SSC Forums! :w00t:[/font]Mon, 21 May 2012 03:53:25 GMTAbrar Ahmad_