InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 01:00:01 GMT20http://www.sqlservercentral.com/Forums/Topic1413568-2572-1.aspxI am a SQL Server DBA for more than 7 years now. With the changing trend, I would like to move towards Cloud Computing.I see that SQL Azure is the happening thing today.How would I be able to transition myself from a DBA to a cloud computing expert, or atleast a novice to start with :-PAre there any good training materials which can start from the very basics or do we have good amount of training institutes in Bangalore, India?Wed, 30 Jan 2013 04:52:07 GMTBenki Chenduhttp://www.sqlservercentral.com/Forums/Topic1322904-2572-1.aspxHi,Most of our web applications use a SQL Db and SSRS reporting to provide standard reports on demand. The volume is low for all our clients - some as low as 20-30 reports per month.The pricing on Azure for SSRS seems to be telling me that if I deploy 1 report, no matter if its run or not, its going to cost me 0.88USD per hour. As this amounts to nearly 700USD per month verses the costs for everything else (roles, database, bandwidth) of about 200USD per month for a small application....please can someone tell me that I need another coffee!!! CheersPeterFri, 29 Jun 2012 02:02:14 GMTPeter Bannisterhttp://www.sqlservercentral.com/Forums/Topic1393377-2572-1.aspxHello All,I have deployed the SQL Database in to SQL Azure database : But I don't know, What will be the server-date and time: how do we know the date offset / DateZone of SQL Azure server ? I created the SQL server with southeast region: Is there any way to configure the Customized data zone.. ThanksSaravanan.s Thu, 06 Dec 2012 02:07:40 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic1395972-2572-1.aspxHi All,Is it possible to configure SSRS to run on two node SQL Sever cluster without using Network Load Balancing.If yes please suggest or provide step by step guide.RegardsRahulWed, 12 Dec 2012 21:41:55 GMTrahultrehan.techhttp://www.sqlservercentral.com/Forums/Topic1394439-2572-1.aspxHow can we restore the MS-SQL azure targeted database with latest BACPAC, i tried with all attempt, But i could not find the restore options for the targeted database... Thanks in advanced...Sun, 09 Dec 2012 21:23:56 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic1314230-2572-1.aspxHi All,I am looking for the advantages of Windows Azure/SQL Azure.Windows Azure is like a service oriented i.e., if we install sql server on Windows azure then that will be like SQL Azure?why we have two different stuffs?The above statements may be wrong, please correct if i am wrong.Please explain the above basic doubts.Tue, 12 Jun 2012 01:15:34 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1314920-2572-1.aspxHi All,How can we take the backup of database in SQL Azure?--- i have taken the backup of database by using "AS COPY OF" it has created a databaseNow, how can i restore this backup?ThanksWed, 13 Jun 2012 02:21:55 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1304724-2572-1.aspxI have two databases one is onpremise and other is on Sql Azure and i have createa sync group that synchronize a table from on premise to azure as bidirectional syncthat table has 7 crore rows and the sync run approx 8 to 9 hours and at random my tablegets lock and i am not able to select any row from that table.plz suggest me why dedlock occur and how to prevent this lock.Whats going worng is there any other way to synchrinize my table from onpremise to azure database.Thanks!!Wed, 23 May 2012 00:48:18 GMTshubham.saxena67http://www.sqlservercentral.com/Forums/Topic1303449-2572-1.aspxHi folks,I am considering migrating some of my existing smaller databases to SQL Azure/ Amazon RDS/ EC2. Has anybody successfully done this? I would like to understand the pros and cons. Also did you use any tools in the process? How are you managing your databases once they are in the cloud?regards,Dharshan.Mon, 21 May 2012 09:15:55 GMTdharshan_rhttp://www.sqlservercentral.com/Forums/Topic1272552-2572-1.aspxHi Is there a step by step introduction to SQL Azure with registration to a small sample for a developer?a Link or something would help.HennieMon, 26 Mar 2012 05:09:24 GMThennie7863http://www.sqlservercentral.com/Forums/Topic1272712-2572-1.aspxHi All,Could any help me any way by which i can transfer/upload data of sql server 2005 not 2008 to sql azure?Regards,VijayMon, 26 Mar 2012 08:34:22 GMTk.vizayhttp://www.sqlservercentral.com/Forums/Topic1237796-2572-1.aspxHi all,Does anybody know if it's possible to carry out a point-in-time restore of a SQL Azure DB? I've read various Technet articles but currently all I can see are the following options:1.) Take a copy of the DB and name as something different2.) Export out database to a BLOB file 3.) Use third party tools to synchronise schema/data between SQL Azure/SQL Server & vice versa.This is based on my understanding from the following articles:[url]http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-backup-and-restore-strategy.aspx[/url][url]http://blogs.msdn.com/b/davidmcg/archive/2011/09/29/data-backup-strategies-for-windows-and-sql-azure.aspx[/url]I've been tasked with the feasibility study of this for a project that our firm is working on by moving some of our business functionality to the cloud.Cheers,DanWed, 18 Jan 2012 03:29:57 GMTDanb7183http://www.sqlservercentral.com/Forums/Topic1178215-2572-1.aspxI need to find out how many times a table-value function has executed on my sql azure database. Any suggestions?thanks!Tue, 20 Sep 2011 13:37:46 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic928853-2572-1.aspxI'm doing a project at the moment to see how Azure works in practice, and I'm surprised how little interest there seems to be in SQL Server Azure on SQL Server Central compared to the more traditional editions (only eight Azure threads in total across the two forums!)I've been at it for a couple of days and having overcome the usual firewall issues now have a single table database in place which seems to work fine with OLE-DB and ODBC. Today I'm hoping to migrate a more substantial database to it and run up an application against it. The application will run in my environment rather than Windows Azure for now.Are any of you using it, and if so, how are you finding it in practice?TimThu, 27 May 2010 04:05:48 GMTTim Walker.http://www.sqlservercentral.com/Forums/Topic1074748-2572-1.aspxI know that the concept of a private cloud exists. Does anyone have any experience or knowledge about this? If so, is it installed and running on private hardware that is controlled by the company? I'm just getting started researching and I'm hoping for a bit of a short circuit if someone can just point me in the right direction.Tue, 08 Mar 2011 06:41:09 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic925708-2572-1.aspxHi Experts,Can anyone give some video on SQL Azure?Some pics on how it looks ?Any scope to work with SQL Azure??Fri, 21 May 2010 01:07:54 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1145925-2572-1.aspxWhile I am trying to connect to a SQL Azure database from SSMS of 2008 R2, I am getting the below errorA connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)I tried the following options,1. Cancelled the server explorer pop-up and clicked on new query and entered the FQDN servername - SQL authentication - Loginname( with and without @servername) - clicked options and entered the default database name.2. Pinged the server name and got the IP which ensure that domain name is resolving3. Able to telnet to the port 1433 for both the servername and IP.Kindly help. Thanks in advance.Thu, 21 Jul 2011 08:17:03 GMTSatheesh E.P.http://www.sqlservercentral.com/Forums/Topic1126202-2572-1.aspxI've been doing some research into how temporary tables work in SQL Azure, and I have a few questions that I can't find answers for.My questions:1. Can you build a local temp table with a user-defined data type?2. Can you build a local temp table with a user-defined function?3. Can you build a local temp table with named constraints?4. Is the collation of local temp tables that of tempdb, or of the current database?5. Are the object_id values for local temp tables positive or negative?6. Is the local temp table built in tempdb, or the current database?Note that most of these are things that change when using a contained database in Denali, and I suspect that some of these are also changed in Azure.Thanks!Edit: and if you happen to have a link that documents any of these, that would be most excellent!Wed, 15 Jun 2011 18:56:54 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1031665-2572-1.aspxHi Pals,I have a SSRS 2008 project developed and now it needs to be send for deployment.I am only aware of deploying the SSRS 2008 project from MS-Visual Studio (Build>Deploy etc.)Is there any other solution available.The server where deployments are needed is a production server and I believe, we need to have SSRS 2008 configured over there.Can anybody help?Tue, 07 Dec 2010 23:34:11 GMTVishal Singhhttp://www.sqlservercentral.com/Forums/Topic1021752-2572-1.aspxI need to pull down a SQLAzure DB from cloud storage to my local sql server instance. I need to get both schema and data. What's my best bet? SSIS? If so which task is most well sutied?Thanks!Tue, 16 Nov 2010 12:47:00 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic1014454-2572-1.aspxHello,I have a problem choosing between clustering and virtualization solutions.We have an SQL server instance which have some large databases in it. Most of serer resources consumes for this database. I mean, you can suppose an SQL instance with a large database in it. Is it better to use table partitioning and using SQL server clustering to provide avalaibility and high performance , or use server virtualization using some programs like VMWare.As I know virtualization is used to utilize resources. Eg. you can integrate many DB servers in One or two servers.So I think for one or two databases in one SQL server Instance, clustering would be a better solution.Have fun,Parissa BakhshiTue, 02 Nov 2010 07:20:53 GMTparissa_bakhshihttp://www.sqlservercentral.com/Forums/Topic941624-2572-1.aspxHi Experts,I have subscribed Windows Azure Platform Introductory Special but i didnt get any response or mail from MS...I have registered a complaint on monday and no response for that too.Can anyone please provide the MS custoemr support mail id?How to deactivate or cancel the subscription?Wed, 23 Jun 2010 03:58:10 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic866806-2572-1.aspxhi, I live at ameerpet, i want to join sql dba for training institute. please suggest a good institute. Thank you.Wed, 17 Feb 2010 01:35:36 GMTnandini_makkena83http://www.sqlservercentral.com/Forums/Topic844380-2572-1.aspxI love the concept of cloud computing, so I enjoyed playing for free on Azure platform.I just received an invitation that I need to start paying for the real thing. It will be unfair for people who test and contribute to the beta testing to loose the connection to what they have worked on for sometimes now.O well, I guess I have to wait until I found a contract that would be for Azure computing.:crying:Fri, 08 Jan 2010 08:33:32 GMTSohrabhttp://www.sqlservercentral.com/Forums/Topic865470-2572-1.aspxhi,I want to join sql dba. which institute is the best. please suggest a good institute.Mon, 15 Feb 2010 05:05:17 GMTnandini_makkena83http://www.sqlservercentral.com/Forums/Topic850459-2572-1.aspxHi everybody!I know that these locations for Azure are for the questions, suggestions, experience, issues infos, etc but this time I'm posting something to learn here for the Azure platform and all things coming from Microsoft.You can view it from [url=http://www.sqlservercentral.com/blogs/dugi/archive/2010/01/20/windows-azure-platform-training-kit.aspx]here[/url] and you can download all the stuff including the presentations, demos, scripts etc etc...Stay tuned!:smooooth:Wed, 20 Jan 2010 07:04:17 GMTDugihttp://www.sqlservercentral.com/Forums/Topic839714-2572-1.aspx[img]http://img707.imageshack.us/img707/4154/sqlazurelogo.jpg[/img]Microsoft SQL Azure Database is a cloud-based relational database service built on SQL Server technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. High availability and fault tolerance is built-in and no physical administration is required. SQL Azure Database supports T-SQL.[i]SQL Azure Database Features[/i]:Relational Database Management Services (RDBMS) -Creating, accessing and manipulating tables, views, indexes, roles, stored procedures, triggers, and functions. -Execute complex queries and joins across multiple tables. -Insert, Update, and Delete. -Constraints. -Transactions. -Temp tables. -Basic functions (aggregates, math, string, date/time). -A subset of the existing SQL Server built-in stored procedures and system views. -Support for tracking billable metrics in real time and for historical analysis.[i]Benefits[/i] -No need to install or patch software or other physical administration. -Automatic high availability and fault tolerance. -Simple provisioning and deployment of multiple databases. -Scale databases up or down based on business needs. -Multi-tenant. -Integration with SQL Server and tooling including Visual Studio. -Support for T-SQL based familiar relational database model.--------------------------------------------------------------------------------There is the article from Jacob Sebastian [url=http://www.sqlservercentral.com/articles/SQL+Azure/68333/]Getting started with SQL Azure[/url].Also you can search the SSC forum for all SQL Azure posts, articles etc!Have a nice SQLAzuring...Tue, 29 Dec 2009 00:29:47 GMTDugi