RE: Used Azure SQL DB? Why or why not?

2017-02-09 Thread Paul Glavich 
Hey Greg,

 

In the scenarios re: multiple DB to single with schema, it was mostly where one 
application was using one database for logs, one for main data, another one for 
something else, not really multi-tenanted. Also, it certainly isn’t a big 
issue, but in a lot of dev shops where multiple databases live, there is an 
assumption that you can do just the same in azure, and you sort of can but 
there are limitations. For example, if you have Db migration scripts (or system 
in place) that will ‘use [databasename]’, then this clearly wont work in azure. 
So then you have to have separate connections to each database (if you continue 
to use this convention), and manage it differently, so just a consideration.

 

Also by saying ‘performance aside’, merely highlighting this multi-db vs 
single-db-multi-schema is something to think about, without introducing a 
lengthier performance talk. However, I would like to know more about the 
pitfalls (from a perf perspective) of multiple schemas.

 

-  Glav

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (??)
Sent: Wednesday, 1 February 2017 11:01 AM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: RE: Used Azure SQL DB? Why or why not?

 

Hi Glav,

 

One caught my eye there. Can’t admit to like using schemas for tenants. I live 
in a world where “performance aside” isn’t an aside. That has way to much 
impact on query plans, caching, memory, etc. for my liking.

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web:  <http://www.sqldownunder.com/> www.sqldownunder.com | 
<http://greglow.me/> http://greglow.me

 

From: ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com>  
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Paul Glavich
Sent: Saturday, 28 January 2017 3:58 PM
To: 'ozDotNet' <ozdotnet@ozdotnet.com <mailto:ozdotnet@ozdotnet.com> >
Subject: RE: Used Azure SQL DB? Why or why not?

 

Hey Greg,

 

Use it all the time, and am working with a customer which is a greenfield 
project.

 

Things to note:

* Getting a good idea of performance related to what size/number of 
DTU’s. Initially, it is a pretty rough guess at best of times. Also, assuming 
all the queries written against it are good (which often is not the case) makes 
it harder to properly estimate. Over time and with adequate testing this issue 
becomes less though.

* Retry with exponential fall off pattern. EF has a strategy to do this 
BUT doesn’t support transactions. Want to use a transaction? Then disable the 
retry/fall off policy and do your own. Can use something like Polly also to do 
this but it is an extra.

* Syncing data between azure sql and an on premise sql. There are 
options but I think SQL Azure data sync is mostly it. If it doesn’t work well 
with that, well, make it up from there.

* Customer initially started using a central SQL Dev DB. Caused all 
sorts of pain. I created a set of migration scripts so that Db can be run 
locally, with migration scripts for SQL in Azure.

* Migrating thought process from multiple databases to a single Db with 
multiple schemas. Not that you can’t use multiple databases, but it is mostly 
easier (especially for migration scripts) to operate on one DB (performance 
aside).

 

Probably a few others, but that is a brain dump for now.

Also, I will be seeing you at ignite as I got asked to do a preso only recently.

 

See you there :)

 

-  Glav

 

From: ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com>  
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (??)
Sent: Saturday, 28 January 2017 1:20 PM
To: ozDotNet <ozdotnet@ozdotnet.com <mailto:ozdotnet@ozdotnet.com> >
Subject: Used Azure SQL DB? Why or why not?

 

To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web:  <http://www.sqldownunder.com/> www.sqldownunder.com | 
<http://greglow.me/> http://greglow.me

RE: Used Azure SQL DB? Why or why not?

2017-01-31 Thread 罗格雷格博士 
Hi Glav,

One caught my eye there. Can’t admit to like using schemas for tenants. I live 
in a world where “performance aside” isn’t an aside. That has way to much 
impact on query plans, caching, memory, etc. for my liking.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Paul Glavich
Sent: Saturday, 28 January 2017 3:58 PM
To: 'ozDotNet' <ozdotnet@ozdotnet.com>
Subject: RE: Used Azure SQL DB? Why or why not?

Hey Greg,

Use it all the time, and am working with a customer which is a greenfield 
project.

Things to note:

· Getting a good idea of performance related to what size/number of 
DTU’s. Initially, it is a pretty rough guess at best of times. Also, assuming 
all the queries written against it are good (which often is not the case) makes 
it harder to properly estimate. Over time and with adequate testing this issue 
becomes less though.

· Retry with exponential fall off pattern. EF has a strategy to do this 
BUT doesn’t support transactions. Want to use a transaction? Then disable the 
retry/fall off policy and do your own. Can use something like Polly also to do 
this but it is an extra.

· Syncing data between azure sql and an on premise sql. There are 
options but I think SQL Azure data sync is mostly it. If it doesn’t work well 
with that, well, make it up from there.

· Customer initially started using a central SQL Dev DB. Caused all 
sorts of pain. I created a set of migration scripts so that Db can be run 
locally, with migration scripts for SQL in Azure.

· Migrating thought process from multiple databases to a single Db with 
multiple schemas. Not that you can’t use multiple databases, but it is mostly 
easier (especially for migration scripts) to operate on one DB (performance 
aside).

Probably a few others, but that is a brain dump for now.
Also, I will be seeing you at ignite as I got asked to do a preso only recently.

See you there ☺


-  Glav

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (??)
Sent: Saturday, 28 January 2017 1:20 PM
To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>>
Subject: Used Azure SQL DB? Why or why not?

To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

RE: Used Azure SQL DB? Why or why not?

2017-01-31 Thread Ken Schaefer 
In the enterprise space, technology is 10% of the cost, and people/process is 
the other 90%.

BUs might go to random cloud providers, because they don’t understand the 
implications, or they just outsource the work to some agency. But for an 
enterprise platform, we have the whole gamut of considerations – probably helps 
if you use a framework like ITIL:

  *   Demand management
  *   Financial management
  *   Service Level management
  *   Service request management
  *   Information security management
  *   Capacity, performance, availability management
  *   Deployment
  *   Change, incident, problem
  *   Knowledge management
  *   Access management
Etc.

For each, we need to develop the end-to-end requirements, and then the 
processes. They have to be integrated into the existing tools, frameworks, 
policies and standards. If we have an existing enterprise info sec standard, 
and access management technology (probably not MS based in a large enterprise), 
then this new “add on” needs to integrate into this, or we need to build a 
bridge. We might save $100K/year on SQL Server licensing and hosting, but if it 
costs $1m to implement the bridge, then the business will prefer to spend that 
money on things that give a more immediate return – like Android Pay or 
something.



From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (??)
Sent: Saturday, 28 January 2017 1:20 PM
To: ozDotNet 
Subject: Used Azure SQL DB? Why or why not?

To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

RE: Used Azure SQL DB? Why or why not?

2017-01-31 Thread Ken Schaefer 
Sounds like a small(er) shop then.

Bigger shops usually don’t have technical people spending the money – they have 
a budget and need to fit that by whatever means they can, provided they can 
meet all the ROI, risk, regulatory hurdles and justify the transition cost.

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Tuesday, 31 January 2017 1:36 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

They are definitely the same ones who are the gatekeepers for the decisions. 
I've seen that the most. Protecting their jobs and trying to maintain the 
"seniority by age" mindset in the company. I've seen some gun devs just leave 
because they couldn't be bothered dealing with the nonsense.

On Tue, Jan 31, 2017 at 1:00 PM, Greg Low (罗格雷格博士) 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
So you think it is just job protection?

Are the people protecting their jobs the same ones who are gatekeepers for the 
decisions?
Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com>


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
<ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>> on behalf 
of DotNet Dude <adotnetd...@gmail.com<mailto:adotnetd...@gmail.com>>
Sent: Tuesday, January 31, 2017 7:22:25 AM
To: ozDotNet

Subject: Re: Used Azure SQL DB? Why or why not?

The arguments are everything they can come up with even if they're not true. 
Eg. Pricing. It's just people who have been here the longest trying to keep 
things unchanged and keeping their jobs and super high salaries.

On Saturday, 28 January 2017, Greg Low (罗格雷格博士) 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
I can guess, but what type of politics? What are the arguments?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of DotNet Dude
Sent: Saturday, 28 January 2017 12:44 PM
To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>>
Subject: Re: Used Azure SQL DB? Why or why not?

Everything Tony said plus politics :p

On Saturday, 28 January 2017, Tony Wright 
<tonyw...@gmail.com<mailto:tonyw...@gmail.com>> wrote:
Hi Greg,

The main thing I think stopping us has been on premises sql or dev edition sql. 
It just doesn't make sense to rely on the stability of the internet when 
developing, and an existing environment or dev edition is very little cost.

The other issue is that it ends up in an account belonging to a single person 
rather than being an organisational account.

The places where we've used Azure sql is when we've all wanted to all be able 
to access the database remotely with simplicity.

The main business driver for using sql Azure as opposed to on premises sql had 
been more about wanting sql to operate in a DMZ, nowhere near the 
organisation's confidential on premises data.

That said, we've just moved one application to using Windows Azure (started 
with table storage, moved to blob storage) simply because of the significant 
drop in cost of data.

Regards Tony

On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

RE: Used Azure SQL DB? Why or why not?

2017-01-31 Thread Ken Schaefer 
People going around installing random binaries on servers makes for support 
nightmares. Not to mention licensing/contractual/audit issues.

If it goes through “the bureaucracy”, as you term it, then it should be 
properly documented so that when issues arise, people know what’s on the server 
vs. what’s supposed to be there. If some auditor comes in and says “show me 
what’s installed, and show me what controls you have to ensure that the list is 
accurate” then having a bureaucracy and enterprise deployment platform makes 
sense. Even if it makes your job that little bit harder. Health care and 
finance are definitely industries in that bucket.

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Keogh
Sent: Tuesday, 31 January 2017 3:53 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

Another argument we got from the DBAs was "we are responsible for the integrity 
of the data so we're not relying on some thing in the cloud we know nothing 
about."

A major Melbourne hospital network said that to us recently. They demanded that 
the ASP.NET<http://ASP.NET> app be installed by their IT staff on their server. 
So instead of having it deployed live in 10 minutes it took 10 days to give 
them an MSI with instructions and get it through their bureaucracy (we think 10 
days was pretty good!).

Several months ago I tried to counter this argument by eventually finding an 
Azure page that listed the international security certifications. Among them 
was "Australian health data", but I don't think many hospitals would care. Does 
anyone know of significant Australian government, education or health services 
that are using Azure (or AWS or whatever) for managing big data?

GK

Re: Used Azure SQL DB? Why or why not?

2017-01-30 Thread Davy Jones 
That sounds like the app that I'm fighting with each day. 

I wish they would give us the time to sort it out and migrate to azure, perhaps 
then I would be able to work from home more often.

Davy

Sent from my iPhone

> On 31 Jan 2017, at 05:24, Greg Low (罗格雷格博士)  wrote:
> 
> Recently I saw one where for every command, instead of just executing the SQL 
> command, the framework did this:

Re: Used Azure SQL DB? Why or why not?

2017-01-30 Thread Greg Keogh 
>
> Another argument we got from the DBAs was "we are responsible for the
> integrity of the data so we're not relying on some thing in the cloud we
> know nothing about."
>

A major Melbourne hospital network said that to us recently. They demanded
that the ASP.NET app be installed by their IT staff on their server. So
instead of having it deployed live in 10 minutes it took 10 days to give
them an MSI with instructions and get it through their bureaucracy (we
think 10 days was pretty good!).

Several months ago I tried to counter this argument by eventually finding
an Azure page that listed the international security certifications. Among
them was "Australian health data", but I don't think many hospitals would
care. Does anyone know of significant Australian government, education or
health services that are using Azure (or AWS or whatever) for managing big
data?

*GK*

RE: Used Azure SQL DB? Why or why not?

2017-01-30 Thread 罗格雷格博士 
Sounds like “we know nothing about." is a big part of the issue…

On their worst day, they do a better job of this than any company I’ve ever 
been to. (And I’ve been to plenty)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Tuesday, 31 January 2017 3:33 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

Another argument we got from the DBAs was "we are responsible for the integrity 
of the data so we're not relying on some thing in the cloud we know nothing 
about."

On Tue, Jan 31, 2017 at 1:36 PM, DotNet Dude 
<adotnetd...@gmail.com<mailto:adotnetd...@gmail.com>> wrote:
They are definitely the same ones who are the gatekeepers for the decisions. 
I've seen that the most. Protecting their jobs and trying to maintain the 
"seniority by age" mindset in the company. I've seen some gun devs just leave 
because they couldn't be bothered dealing with the nonsense.

On Tue, Jan 31, 2017 at 1:00 PM, Greg Low (罗格雷格博士) 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
So you think it is just job protection?

Are the people protecting their jobs the same ones who are gatekeepers for the 
decisions?
Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com>


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
<ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>> on behalf 
of DotNet Dude <adotnetd...@gmail.com<mailto:adotnetd...@gmail.com>>
Sent: Tuesday, January 31, 2017 7:22:25 AM
To: ozDotNet

Subject: Re: Used Azure SQL DB? Why or why not?

The arguments are everything they can come up with even if they're not true. 
Eg. Pricing. It's just people who have been here the longest trying to keep 
things unchanged and keeping their jobs and super high salaries.

On Saturday, 28 January 2017, Greg Low (罗格雷格博士) 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
I can guess, but what type of politics? What are the arguments?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of DotNet Dude
Sent: Saturday, 28 January 2017 12:44 PM
To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>>
Subject: Re: Used Azure SQL DB? Why or why not?

Everything Tony said plus politics :p

On Saturday, 28 January 2017, Tony Wright 
<tonyw...@gmail.com<mailto:tonyw...@gmail.com>> wrote:
Hi Greg,

The main thing I think stopping us has been on premises sql or dev edition sql. 
It just doesn't make sense to rely on the stability of the internet when 
developing, and an existing environment or dev edition is very little cost.

The other issue is that it ends up in an account belonging to a single person 
rather than being an organisational account.

The places where we've used Azure sql is when we've all wanted to all be able 
to access the database remotely with simplicity.

The main business driver for using sql Azure as opposed to on premises sql had 
been more about wanting sql to operate in a DMZ, nowhere near the 
organisation's confidential on premises data.

That said, we've just moved one application to using Windows Azure (started 
with table storage, moved to blob storage) simply because of the significant 
drop in cost of data.

Regards Tony

On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

RE: Used Azure SQL DB? Why or why not?

2017-01-30 Thread 罗格雷格博士 
The way I look at it, is that if you develop for Azure SQL DB, it’s going to 
run pretty much anywhere and if it happens to be on a low latency network, all 
the better.

I hate seeing hardware being used to mask code issues.

The biggest problem is frameworks (and apps built on them) that encourage 
chatty behaviour. Worse are frameworks that are poorly configured.

Recently I saw one where for every command, instead of just executing the SQL 
command, the framework did this:


1.   Create a cursor for the command

2.   Perform a fetch on the cursor to get the data

3.   Perform another fetch on the cursor (which failed)

4.   Close the cursor

5.   Create the same cursor again

6.   Use it to query the parameters and data types

7.   Close the cursor again.

And it did this ON EVERY SINGLE COMMAND 

But even at a large customer that I was at a week or so ago, every command did 
this:


1.   sp_prepexec the command

2.   Retrieve the handle for the command’s execution plan

3.   Execute the command based upon the handle

4.unprepared the command.

And the way they handled transactions was:


1.   Turn on implicit transactions

2.   Perform commands that might or might not do things that should be 
transactional

3.   Regularly execute code that performed a commit, if there happened to 
be a transaction, and often some time later.

In a trace of 250,000 SQL batches, over 180,000 were part of this “transaction 
management”

Apps like these will never work properly in cloud-environments of any type, but 
the problem isn’t the cloud environment.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Craig van Nieuwkerk
Sent: Saturday, 28 January 2017 4:50 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

I have been using SQL Azure for about 4 years for our SAAS app. All development 
is done against an on premise SQL Server so there is no problem if we lose 
internet. Developing against a remote DB would be painfully slow anyway.

The biggest issue I find is that SQL Azure will highlight any performance 
issues than can often be masked by an on premise solution where the answer to 
performance is to throw more hardware at it.

We use Visual Studio database project to manage the schema so migration is 
pretty painless.

Craig

On Sat, Jan 28, 2017 at 4:06 PM, Greg Keogh 
<gfke...@gmail.com<mailto:gfke...@gmail.com>> wrote:
I haven't used SQL Azure in a live app yet, but have some personal and testing 
DBs up there. In a couple of weeks I'll share a DB with another developer who 
lives over an hour drive away, so instead of swapping zips of DB backups, we'll 
now connect to the same Azure DB, which is really convenient and easy.

Watch the cost ... I mentioned this last year that a low performance DB can be 
about $30/month, and hundreds/month at the upper end. All our DBs are cheapies 
because luckily we don't need high performance or capacity.

Desktop apps connecting directly to Azure DBs can suffer if you do stupid 
things like select thousands of rows to put in a grid. In this case don't 
design apps that demand huge slabs of data (or use async wisely). If your whole 
suite is in the cloud where public Azure services are privately querying the 
Azure DB then it of course it's blazing fast.

Over the last year I have tried to convince or suggest to several people that 
they consider putting their DBs into the cloud, and in every case I have been 
met with resistance sometimes bordering on hostile, or even mockery. So clearly 
there is a perception problem that may take some time to break down. I pointed 
out that using SQL Azure or similar would mean they no longer needed to buy, 
install and manage the software, or buy a whopping great box, air-conditioner, 
power backup and case of failure, and they can scale up or out as needed, etc, 
but it all falls on deaf ears and everyone chickens out.

Tony was worried about internet connection stability leaving people idle, but I 
reckon if your internet is down everyone stops working anyway and it's a 
disaster. Develop on a local DB.

In summary, I'm biased because I'm utterly sick of hosting software myself when 
it can done by someone in the cloud where I have little worry about failure, 
security or performance. In recent years I've moved 5 web sites, 2 SQL 
databases, most backups, email forwarding and email into online hosting, and 
it's bloody fabulous as I have less and less to manage and worry about on the 
office LAN and server. Only one web site I host is preventing me from actually 
removing my server completely (due to dependence on native DLLs), but I'm 
working on gettin

Re: Used Azure SQL DB? Why or why not?

2017-01-30 Thread DotNet Dude 
They are definitely the same ones who are the gatekeepers for the
decisions. I've seen that the most. Protecting their jobs and trying to
maintain the "seniority by age" mindset in the company. I've seen some gun
devs just leave because they couldn't be bothered dealing with the nonsense.

On Tue, Jan 31, 2017 at 1:00 PM, Greg Low (罗格雷格博士) <g...@greglow.com> wrote:

> So you think it is just job protection?
>
> Are the people protecting their jobs the same ones who are gatekeepers for
> the decisions?
>
> Regards,
>
> Greg
>
> Dr Greg Low
> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
> SQL Down Under | Web: www.sqldownunder.com
>
> --
> *From:* ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> on
> behalf of DotNet Dude <adotnetd...@gmail.com>
> *Sent:* Tuesday, January 31, 2017 7:22:25 AM
> *To:* ozDotNet
>
> *Subject:* Re: Used Azure SQL DB? Why or why not?
>
> The arguments are everything they can come up with even if they're not
> true. Eg. Pricing. It's just people who have been here the longest trying
> to keep things unchanged and keeping their jobs and super high salaries.
>
> On Saturday, 28 January 2017, Greg Low (罗格雷格博士) <g...@greglow.com> wrote:
>
>> I can guess, but what type of politics? What are the arguments?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
>> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>>
>>
>>
>> *From:* ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-bounces@ozdot
>> net.com] *On Behalf Of *DotNet Dude
>> *Sent:* Saturday, 28 January 2017 12:44 PM
>> *To:* ozDotNet <ozdotnet@ozdotnet.com>
>> *Subject:* Re: Used Azure SQL DB? Why or why not?
>>
>>
>>
>> Everything Tony said plus politics :p
>>
>> On Saturday, 28 January 2017, Tony Wright <tonyw...@gmail.com> wrote:
>>
>> Hi Greg,
>>
>>
>>
>> The main thing I think stopping us has been on premises sql or dev
>> edition sql. It just doesn't make sense to rely on the stability of the
>> internet when developing, and an existing environment or dev edition is
>> very little cost.
>>
>>
>>
>> The other issue is that it ends up in an account belonging to a single
>> person rather than being an organisational account.
>>
>>
>>
>> The places where we've used Azure sql is when we've all wanted to all be
>> able to access the database remotely with simplicity.
>>
>>
>>
>> The main business driver for using sql Azure as opposed to on premises
>> sql had been more about wanting sql to operate in a DMZ, nowhere near the
>> organisation's confidential on premises data.
>>
>>
>>
>> That said, we've just moved one application to using Windows Azure
>> (started with table storage, moved to blob storage) simply because of the
>> significant drop in cost of data.
>>
>>
>>
>> Regards Tony
>>
>>
>>
>> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com> wrote:
>>
>> To my developer buddies: I'm preparing a session for Ignite where I'm
>> discussing using Azure SQL DB for greenfield (new) applications. Would love
>> to hear opinions on if you've used it, and what you found/learned, and if
>> you haven't used it, what stopped you ?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
>> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>>
>>
>>
>>

Re: Used Azure SQL DB? Why or why not?

2017-01-30 Thread 罗格雷格博士 
So you think it is just job protection?

Are the people protecting their jobs the same ones who are gatekeepers for the 
decisions?

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com>


From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> on behalf 
of DotNet Dude <adotnetd...@gmail.com>
Sent: Tuesday, January 31, 2017 7:22:25 AM
To: ozDotNet
Subject: Re: Used Azure SQL DB? Why or why not?

The arguments are everything they can come up with even if they're not true. 
Eg. Pricing. It's just people who have been here the longest trying to keep 
things unchanged and keeping their jobs and super high salaries.

On Saturday, 28 January 2017, Greg Low (罗格雷格博士) 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
I can guess, but what type of politics? What are the arguments?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Saturday, 28 January 2017 12:44 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

Everything Tony said plus politics :p

On Saturday, 28 January 2017, Tony Wright <tonyw...@gmail.com> wrote:
Hi Greg,

The main thing I think stopping us has been on premises sql or dev edition sql. 
It just doesn't make sense to rely on the stability of the internet when 
developing, and an existing environment or dev edition is very little cost.

The other issue is that it ends up in an account belonging to a single person 
rather than being an organisational account.

The places where we've used Azure sql is when we've all wanted to all be able 
to access the database remotely with simplicity.

The main business driver for using sql Azure as opposed to on premises sql had 
been more about wanting sql to operate in a DMZ, nowhere near the 
organisation's confidential on premises data.

That said, we've just moved one application to using Windows Azure (started 
with table storage, moved to blob storage) simply because of the significant 
drop in cost of data.

Regards Tony

On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com> wrote:
To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

Re: Used Azure SQL DB? Why or why not?

2017-01-30 Thread DotNet Dude 
The arguments are everything they can come up with even if they're not
true. Eg. Pricing. It's just people who have been here the longest trying
to keep things unchanged and keeping their jobs and super high salaries.

On Saturday, 28 January 2017, Greg Low (罗格雷格博士) <g...@greglow.com> wrote:

> I can guess, but what type of politics? What are the arguments?
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
> fax
>
> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com
> <javascript:_e(%7B%7D,'cvml','ozdotnet-boun...@ozdotnet.com');> [mailto:
> ozdotnet-boun...@ozdotnet.com
> <javascript:_e(%7B%7D,'cvml','ozdotnet-boun...@ozdotnet.com');>] *On
> Behalf Of *DotNet Dude
> *Sent:* Saturday, 28 January 2017 12:44 PM
> *To:* ozDotNet <ozdotnet@ozdotnet.com
> <javascript:_e(%7B%7D,'cvml','ozdotnet@ozdotnet.com');>>
> *Subject:* Re: Used Azure SQL DB? Why or why not?
>
>
>
> Everything Tony said plus politics :p
>
> On Saturday, 28 January 2017, Tony Wright <tonyw...@gmail.com
> <javascript:_e(%7B%7D,'cvml','tonyw...@gmail.com');>> wrote:
>
> Hi Greg,
>
>
>
> The main thing I think stopping us has been on premises sql or dev edition
> sql. It just doesn't make sense to rely on the stability of the internet
> when developing, and an existing environment or dev edition is very little
> cost.
>
>
>
> The other issue is that it ends up in an account belonging to a single
> person rather than being an organisational account.
>
>
>
> The places where we've used Azure sql is when we've all wanted to all be
> able to access the database remotely with simplicity.
>
>
>
> The main business driver for using sql Azure as opposed to on premises sql
> had been more about wanting sql to operate in a DMZ, nowhere near the
> organisation's confidential on premises data.
>
>
>
> That said, we've just moved one application to using Windows Azure
> (started with table storage, moved to blob storage) simply because of the
> significant drop in cost of data.
>
>
>
> Regards Tony
>
>
>
> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com> wrote:
>
> To my developer buddies: I'm preparing a session for Ignite where I'm
> discussing using Azure SQL DB for greenfield (new) applications. Would love
> to hear opinions on if you've used it, and what you found/learned, and if
> you haven't used it, what stopped you ?
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>
> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>
>
>
>

Re: Used Azure SQL DB? Why or why not?

2017-01-27 Thread Craig van Nieuwkerk 
I have been using SQL Azure for about 4 years for our SAAS app. All
development is done against an on premise SQL Server so there is no problem
if we lose internet. Developing against a remote DB would be painfully slow
anyway.

The biggest issue I find is that SQL Azure will highlight any performance
issues than can often be masked by an on premise solution where the answer
to performance is to throw more hardware at it.

We use Visual Studio database project to manage the schema so migration is
pretty painless.

Craig

On Sat, Jan 28, 2017 at 4:06 PM, Greg Keogh  wrote:

> I haven't used SQL Azure in a live app yet, but have some personal and
> testing DBs up there. In a couple of weeks I'll share a DB with another
> developer who lives over an hour drive away, so instead of swapping zips of
> DB backups, we'll now connect to the same Azure DB, which is really
> convenient and easy.
>
> Watch the cost ... I mentioned this last year that a low performance DB
> can be about $30/month, and hundreds/month at the upper end. All our DBs
> are cheapies because luckily we don't need high performance or capacity.
>
> Desktop apps connecting directly to Azure DBs can suffer if you do stupid
> things like select thousands of rows to put in a grid. In this case don't
> design apps that demand huge slabs of data (or use async wisely). If your
> whole suite is in the cloud where public Azure services are privately
> querying the Azure DB then it of course it's blazing fast.
>
> Over the last year I have tried to convince or suggest to several people
> that they consider putting their DBs into the cloud, and in every case I
> have been met with resistance sometimes bordering on hostile, or even
> mockery. So clearly there is a perception problem that may take some time
> to break down. I pointed out that using SQL Azure or similar would mean
> they no longer needed to buy, install and manage the software, or buy a
> whopping great box, air-conditioner, power backup and case of failure, and
> they can scale up or out as needed, etc, but it all falls on deaf ears and
> everyone chickens out.
>
> Tony was worried about internet connection stability leaving people idle,
> but I reckon if your internet is down everyone stops working anyway and
> it's a disaster. Develop on a local DB.
>
> In summary, I'm biased because I'm utterly sick of hosting software myself
> when it can done by someone in the cloud where I have little worry about
> failure, security or performance. In recent years I've moved 5 web sites, 2
> SQL databases, most backups, email forwarding and email into online
> hosting, and it's bloody fabulous as I have less and less to manage and
> worry about on the office LAN and server. Only one web site I host is
> preventing me from actually removing my server completely (due to
> dependence on native DLLs), but I'm working on getting rid of it soon. I'll
> buy one of those quiet little media boxes to hold my gigawatts of music and
> videos.
>
> *Greg K*
>
> On 28 January 2017 at 13:30, Tony Wright  wrote:
>
>> Hi Greg,
>>
>> The main thing I think stopping us has been on premises sql or dev
>> edition sql. It just doesn't make sense to rely on the stability of the
>> internet when developing, and an existing environment or dev edition is
>> very little cost.
>>
>> The other issue is that it ends up in an account belonging to a single
>> person rather than being an organisational account.
>>
>> The places where we've used Azure sql is when we've all wanted to all be
>> able to access the database remotely with simplicity.
>>
>> The main business driver for using sql Azure as opposed to on premises
>> sql had been more about wanting sql to operate in a DMZ, nowhere near the
>> organisation's confidential on premises data.
>>
>> That said, we've just moved one application to using Windows Azure
>> (started with table storage, moved to blob storage) simply because of the
>> significant drop in cost of data.
>>
>> Regards Tony
>>
>> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)"  wrote:
>>
>>> To my developer buddies: I'm preparing a session for Ignite where I'm
>>> discussing using Azure SQL DB for greenfield (new) applications. Would love
>>> to hear opinions on if you've used it, and what you found/learned, and if
>>> you haven't used it, what stopped you ?
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> Greg
>>>
>>>
>>>
>>> Dr Greg Low
>>>
>>>
>>>
>>> 1300SQLSQL (1300 775 775 <1300%20775%20775>) office | +61 419201410
>>> <+61%20419%20201%20410> mobile│ +61 3 8676 4913 <+61%203%208676%204913>
>>> fax
>>>
>>> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>>>
>>>
>>>
>>
>

Re: Used Azure SQL DB? Why or why not?

2017-01-27 Thread Greg Keogh 
I haven't used SQL Azure in a live app yet, but have some personal and
testing DBs up there. In a couple of weeks I'll share a DB with another
developer who lives over an hour drive away, so instead of swapping zips of
DB backups, we'll now connect to the same Azure DB, which is really
convenient and easy.

Watch the cost ... I mentioned this last year that a low performance DB can
be about $30/month, and hundreds/month at the upper end. All our DBs are
cheapies because luckily we don't need high performance or capacity.

Desktop apps connecting directly to Azure DBs can suffer if you do stupid
things like select thousands of rows to put in a grid. In this case don't
design apps that demand huge slabs of data (or use async wisely). If your
whole suite is in the cloud where public Azure services are privately
querying the Azure DB then it of course it's blazing fast.

Over the last year I have tried to convince or suggest to several people
that they consider putting their DBs into the cloud, and in every case I
have been met with resistance sometimes bordering on hostile, or even
mockery. So clearly there is a perception problem that may take some time
to break down. I pointed out that using SQL Azure or similar would mean
they no longer needed to buy, install and manage the software, or buy a
whopping great box, air-conditioner, power backup and case of failure, and
they can scale up or out as needed, etc, but it all falls on deaf ears and
everyone chickens out.

Tony was worried about internet connection stability leaving people idle,
but I reckon if your internet is down everyone stops working anyway and
it's a disaster. Develop on a local DB.

In summary, I'm biased because I'm utterly sick of hosting software myself
when it can done by someone in the cloud where I have little worry about
failure, security or performance. In recent years I've moved 5 web sites, 2
SQL databases, most backups, email forwarding and email into online
hosting, and it's bloody fabulous as I have less and less to manage and
worry about on the office LAN and server. Only one web site I host is
preventing me from actually removing my server completely (due to
dependence on native DLLs), but I'm working on getting rid of it soon. I'll
buy one of those quiet little media boxes to hold my gigawatts of music and
videos.

*Greg K*

On 28 January 2017 at 13:30, Tony Wright  wrote:

> Hi Greg,
>
> The main thing I think stopping us has been on premises sql or dev edition
> sql. It just doesn't make sense to rely on the stability of the internet
> when developing, and an existing environment or dev edition is very little
> cost.
>
> The other issue is that it ends up in an account belonging to a single
> person rather than being an organisational account.
>
> The places where we've used Azure sql is when we've all wanted to all be
> able to access the database remotely with simplicity.
>
> The main business driver for using sql Azure as opposed to on premises sql
> had been more about wanting sql to operate in a DMZ, nowhere near the
> organisation's confidential on premises data.
>
> That said, we've just moved one application to using Windows Azure
> (started with table storage, moved to blob storage) simply because of the
> significant drop in cost of data.
>
> Regards Tony
>
> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)"  wrote:
>
>> To my developer buddies: I'm preparing a session for Ignite where I'm
>> discussing using Azure SQL DB for greenfield (new) applications. Would love
>> to hear opinions on if you've used it, and what you found/learned, and if
>> you haven't used it, what stopped you ?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
>> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>>
>>
>>
>

Re: Used Azure SQL DB? Why or why not?

2017-01-27 Thread Tony Wright 
Hi Greg,

I believe that's it. Or could be due to the complication with trying to
find out how to get an organisation account, or who controls that account,
or whether the person that holds that account is a friendly. Sometimes its
easier just to bypass the bureaucracy and go direct - more control!

Internet stability is not an issue where I am, nor is it in most places
that I have worked. That said, the perception that it could become a
problem is definitely there - take down the internet and that means a team
of up to 8 people not being productive (or as productive, even if you
decide to immediately run a review session if the web goes down.) If it
goes down for a day at roughly $1000 a developer, that's $8000 a day.

The last few jobs I've had have no real geographically distributed teams.
PwC had a Sydney and Melbourne team but most developers, except for the K2
team, were co-located (co-located is the preferred way under Agile) The
prior one that outsourced - Origin - flew their team to us on a cycling 3
month basis (Wipro) and everything was in-house.

Regards,
Tony



On Sat, Jan 28, 2017 at 2:33 PM, Greg Low (罗格雷格博士) <g...@greglow.com> wrote:

> Hi Tony,
>
>
>
> Why does it end up with someone’s account rather than an org account? Is
> that because of MSDN credits being used or something?
>
>
>
> Is Internet stability a big issue where you work?
>
>
>
> I’m also guessing they don’t have a geographically distributed developer
> team? (Or they all VPN/Citrix in or something?)
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>
> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-bounces@
> ozdotnet.com] *On Behalf Of *Tony Wright
> *Sent:* Saturday, 28 January 2017 12:31 PM
> *To:* ozDotNet <ozdotnet@ozdotnet.com>
> *Subject:* Re: Used Azure SQL DB? Why or why not?
>
>
>
> Hi Greg,
>
>
>
> The main thing I think stopping us has been on premises sql or dev edition
> sql. It just doesn't make sense to rely on the stability of the internet
> when developing, and an existing environment or dev edition is very little
> cost.
>
>
>
> The other issue is that it ends up in an account belonging to a single
> person rather than being an organisational account.
>
>
>
> The places where we've used Azure sql is when we've all wanted to all be
> able to access the database remotely with simplicity.
>
>
>
> The main business driver for using sql Azure as opposed to on premises sql
> had been more about wanting sql to operate in a DMZ, nowhere near the
> organisation's confidential on premises data.
>
>
>
> That said, we've just moved one application to using Windows Azure
> (started with table storage, moved to blob storage) simply because of the
> significant drop in cost of data.
>
>
>
> Regards Tony
>
>
>
> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com> wrote:
>
> To my developer buddies: I'm preparing a session for Ignite where I'm
> discussing using Azure SQL DB for greenfield (new) applications. Would love
> to hear opinions on if you've used it, and what you found/learned, and if
> you haven't used it, what stopped you ?
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>
> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>
>
>
>

RE: Used Azure SQL DB? Why or why not?

2017-01-27 Thread 罗格雷格博士 
Hi Tony,

Why does it end up with someone’s account rather than an org account? Is that 
because of MSDN credits being used or something?

Is Internet stability a big issue where you work?

I’m also guessing they don’t have a geographically distributed developer team? 
(Or they all VPN/Citrix in or something?)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Tony Wright
Sent: Saturday, 28 January 2017 12:31 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

Hi Greg,

The main thing I think stopping us has been on premises sql or dev edition sql. 
It just doesn't make sense to rely on the stability of the internet when 
developing, and an existing environment or dev edition is very little cost.

The other issue is that it ends up in an account belonging to a single person 
rather than being an organisational account.

The places where we've used Azure sql is when we've all wanted to all be able 
to access the database remotely with simplicity.

The main business driver for using sql Azure as opposed to on premises sql had 
been more about wanting sql to operate in a DMZ, nowhere near the 
organisation's confidential on premises data.

That said, we've just moved one application to using Windows Azure (started 
with table storage, moved to blob storage) simply because of the significant 
drop in cost of data.

Regards Tony

On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" 
<g...@greglow.com<mailto:g...@greglow.com>> wrote:
To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

RE: Used Azure SQL DB? Why or why not?

2017-01-27 Thread 罗格雷格博士 
I can guess, but what type of politics? What are the arguments?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Saturday, 28 January 2017 12:44 PM
To: ozDotNet <ozdotnet@ozdotnet.com>
Subject: Re: Used Azure SQL DB? Why or why not?

Everything Tony said plus politics :p

On Saturday, 28 January 2017, Tony Wright 
<tonyw...@gmail.com<mailto:tonyw...@gmail.com>> wrote:
Hi Greg,

The main thing I think stopping us has been on premises sql or dev edition sql. 
It just doesn't make sense to rely on the stability of the internet when 
developing, and an existing environment or dev edition is very little cost.

The other issue is that it ends up in an account belonging to a single person 
rather than being an organisational account.

The places where we've used Azure sql is when we've all wanted to all be able 
to access the database remotely with simplicity.

The main business driver for using sql Azure as opposed to on premises sql had 
been more about wanting sql to operate in a DMZ, nowhere near the 
organisation's confidential on premises data.

That said, we've just moved one application to using Windows Azure (started 
with table storage, moved to blob storage) simply because of the significant 
drop in cost of data.

Regards Tony

On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" 
<g...@greglow.com<javascript:_e(%7B%7D,'cvml','g...@greglow.com');>> wrote:
To my developer buddies: I'm preparing a session for Ignite where I'm 
discussing using Azure SQL DB for greenfield (new) applications. Would love to 
hear opinions on if you've used it, and what you found/learned, and if you 
haven't used it, what stopped you ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410<tel:+61%20419%20201%20410> 
mobile│ +61 3 8676 4913<tel:+61%203%208676%204913> fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> 
|http://greglow.me<http://greglow.me/>

Re: Used Azure SQL DB? Why or why not?

2017-01-27 Thread DotNet Dude 
Everything Tony said plus politics :p

On Saturday, 28 January 2017, Tony Wright  wrote:

> Hi Greg,
>
> The main thing I think stopping us has been on premises sql or dev edition
> sql. It just doesn't make sense to rely on the stability of the internet
> when developing, and an existing environment or dev edition is very little
> cost.
>
> The other issue is that it ends up in an account belonging to a single
> person rather than being an organisational account.
>
> The places where we've used Azure sql is when we've all wanted to all be
> able to access the database remotely with simplicity.
>
> The main business driver for using sql Azure as opposed to on premises sql
> had been more about wanting sql to operate in a DMZ, nowhere near the
> organisation's confidential on premises data.
>
> That said, we've just moved one application to using Windows Azure
> (started with table storage, moved to blob storage) simply because of the
> significant drop in cost of data.
>
> Regards Tony
>
> On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)"  > wrote:
>
>> To my developer buddies: I'm preparing a session for Ignite where I'm
>> discussing using Azure SQL DB for greenfield (new) applications. Would love
>> to hear opinions on if you've used it, and what you found/learned, and if
>> you haven't used it, what stopped you ?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
>> mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com |http://greglow.me
>>
>>
>>
>