Re: [OT] Office 365

[Stephen Price]

Actually did some more reading and it looks like the business version gives
you access to Lync (for business), Sharepoint and I think collaborative
office editing. As well as the Home stuff. All of which I am not using so
don't need. I think Office 365 Home is the way to go for me right now.

On Sun, 1 Nov 2015 at 15:32 DotNet Dude  wrote:

> >From what I've heard (which is very little)
> the business version gives you more control in the "dashboard" to
> customise stuff. I also don't think you're meant to use non-business
> versions for commercial use, whatever that means. 
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
>> Hey all,
>>
>> I know a few here use Office 365 (from previous threads) and was
>> wondering if anyone is using the Office 365 Business? Trying to work out
>> what it gives you and so far it looks exactly the same as the Home version
>> except its more expensive. Perhaps business support is the extra?
>>
>> I'm currently using the freebie given to me via my msdn account and its
>> great. Its called Office 365 Developer Subscription. Its not documented
>> anywhere that that is, but it says I'm using Office 365 Personal except I
>> have +1 install (2 total) when compared with the real Office 365 Personal
>> product.
>> I have a few more machines than that, and have decided to drop Dropbox
>> (its in the name... they have been telling to do it all along...) and make
>> OneDrive my main cloud storage. So wanted a couple more installs (and
>> figure if i'm not paying for Dropbox anymore that can pay for Office 365.
>>
>> Going to go with Office 365 Home, but curious what the Office 365
>> Business Premium gives you. They only compare it with the other Business
>> products, can't find a Home vs Business comparison. Not one that spells it
>> out...
>>
>

Re: [OT] Office 365

[DotNet Dude]

People still use sharepoint? Lol

On Sunday, 1 November 2015, Stephen Price  wrote:

> Actually did some more reading and it looks like the business version
> gives you access to Lync (for business), Sharepoint and I think
> collaborative office editing. As well as the Home stuff. All of which I am
> not using so don't need. I think Office 365 Home is the way to go for me
> right now.
>
> On Sun, 1 Nov 2015 at 15:32 DotNet Dude  > wrote:
>
>> >From what I've heard (which is very little)
>> the business version gives you more control in the "dashboard" to
>> customise stuff. I also don't think you're meant to use non-business
>> versions for commercial use, whatever that means. 
>>
>> On Sunday, 1 November 2015, Stephen Price > > wrote:
>>
>>> Hey all,
>>>
>>> I know a few here use Office 365 (from previous threads) and was
>>> wondering if anyone is using the Office 365 Business? Trying to work out
>>> what it gives you and so far it looks exactly the same as the Home version
>>> except its more expensive. Perhaps business support is the extra?
>>>
>>> I'm currently using the freebie given to me via my msdn account and its
>>> great. Its called Office 365 Developer Subscription. Its not documented
>>> anywhere that that is, but it says I'm using Office 365 Personal except I
>>> have +1 install (2 total) when compared with the real Office 365 Personal
>>> product.
>>> I have a few more machines than that, and have decided to drop Dropbox
>>> (its in the name... they have been telling to do it all along...) and make
>>> OneDrive my main cloud storage. So wanted a couple more installs (and
>>> figure if i'm not paying for Dropbox anymore that can pay for Office 365.
>>>
>>> Going to go with Office 365 Home, but curious what the Office 365
>>> Business Premium gives you. They only compare it with the other Business
>>> products, can't find a Home vs Business comparison. Not one that spells it
>>> out...
>>>
>>

Re: [OT] Office 365

[DotNet Dude]

>From what I've heard (which is very little)
the business version gives you more control in the "dashboard" to customise
stuff. I also don't think you're meant to use non-business versions for
commercial use, whatever that means. 

On Sunday, 1 November 2015, Stephen Price  wrote:

> Hey all,
>
> I know a few here use Office 365 (from previous threads) and was wondering
> if anyone is using the Office 365 Business? Trying to work out what it
> gives you and so far it looks exactly the same as the Home version except
> its more expensive. Perhaps business support is the extra?
>
> I'm currently using the freebie given to me via my msdn account and its
> great. Its called Office 365 Developer Subscription. Its not documented
> anywhere that that is, but it says I'm using Office 365 Personal except I
> have +1 install (2 total) when compared with the real Office 365 Personal
> product.
> I have a few more machines than that, and have decided to drop Dropbox
> (its in the name... they have been telling to do it all along...) and make
> OneDrive my main cloud storage. So wanted a couple more installs (and
> figure if i'm not paying for Dropbox anymore that can pay for Office 365.
>
> Going to go with Office 365 Home, but curious what the Office 365 Business
> Premium gives you. They only compare it with the other Business products,
> can't find a Home vs Business comparison. Not one that spells it out...
>

Re: [OT] Office 365

[Stephen Price]

Not people, no. Managers.
On Sun, 1 Nov 2015 at 4:04 PM, DotNet Dude  wrote:

> People still use sharepoint? Lol
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
>> Actually did some more reading and it looks like the business version
>> gives you access to Lync (for business), Sharepoint and I think
>> collaborative office editing. As well as the Home stuff. All of which I am
>> not using so don't need. I think Office 365 Home is the way to go for me
>> right now.
>>
>> On Sun, 1 Nov 2015 at 15:32 DotNet Dude  wrote:
>>
>>> >From what I've heard (which is very little)
>>> the business version gives you more control in the "dashboard" to
>>> customise stuff. I also don't think you're meant to use non-business
>>> versions for commercial use, whatever that means. 
>>>
>>> On Sunday, 1 November 2015, Stephen Price 
>>> wrote:
>>>
 Hey all,

 I know a few here use Office 365 (from previous threads) and was
 wondering if anyone is using the Office 365 Business? Trying to work out
 what it gives you and so far it looks exactly the same as the Home version
 except its more expensive. Perhaps business support is the extra?

 I'm currently using the freebie given to me via my msdn account and its
 great. Its called Office 365 Developer Subscription. Its not documented
 anywhere that that is, but it says I'm using Office 365 Personal except I
 have +1 install (2 total) when compared with the real Office 365 Personal
 product.
 I have a few more machines than that, and have decided to drop Dropbox
 (its in the name... they have been telling to do it all along...) and make
 OneDrive my main cloud storage. So wanted a couple more installs (and
 figure if i'm not paying for Dropbox anymore that can pay for Office 365.

 Going to go with Office 365 Home, but curious what the Office 365
 Business Premium gives you. They only compare it with the other Business
 products, can't find a Home vs Business comparison. Not one that spells it
 out...

>>>

RE: [OT] Office 365

[Ken Schaefer]

What alternatives would you recommend?

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Sunday, 1 November 2015 7:04 PM
To: ozDotNet 
Subject: Re: [OT] Office 365

People still use sharepoint? Lol

On Sunday, 1 November 2015, Stephen Price 
> wrote:
Actually did some more reading and it looks like the business version gives you 
access to Lync (for business), Sharepoint and I think collaborative office 
editing. As well as the Home stuff. All of which I am not using so don't need. 
I think Office 365 Home is the way to go for me right now.

On Sun, 1 Nov 2015 at 15:32 DotNet Dude 
> 
wrote:
>From what I've heard (which is very little)
the business version gives you more control in the "dashboard" to customise 
stuff. I also don't think you're meant to use non-business versions for 
commercial use, whatever that means. 

On Sunday, 1 November 2015, Stephen Price 
>
 wrote:
Hey all,

I know a few here use Office 365 (from previous threads) and was wondering if 
anyone is using the Office 365 Business? Trying to work out what it gives you 
and so far it looks exactly the same as the Home version except its more 
expensive. Perhaps business support is the extra?

I'm currently using the freebie given to me via my msdn account and its great. 
Its called Office 365 Developer Subscription. Its not documented anywhere that 
that is, but it says I'm using Office 365 Personal except I have +1 install (2 
total) when compared with the real Office 365 Personal product.
I have a few more machines than that, and have decided to drop Dropbox (its in 
the name... they have been telling to do it all along...) and make OneDrive my 
main cloud storage. So wanted a couple more installs (and figure if i'm not 
paying for Dropbox anymore that can pay for Office 365.

Going to go with Office 365 Home, but curious what the Office 365 Business 
Premium gives you. They only compare it with the other Business products, can't 
find a Home vs Business comparison. Not one that spells it out...

Re: [OT] SSL testing

[Greg Keogh]

>
> I noticed a mate's shopping site over the weekend returning the following
> in the connection info for the certificate:
>

I just tested my own domain with its 6 month old certificate. I also got a
series of frightening warnings:





*This server supports SSL 2, which is obsolete and insecure. Grade set to
F. This server is vulnerable to the POODLE attack. If possible, disable SSL
3 to mitigate. Grade capped to C.Certificate uses a weak signature. When
renewing, ensure you upgrade to SHA2.The server supports only older
protocols, but not the current best TLS 1.2. Grade capped to C.This server
accepts the RC4 cipher, which is weak. Grade capped to B.*

The long and detailed list of test results are quite complicated. I'm not
happy about getting an F for flunk grade, but I'm not sure what I can do
about it, or if I'm even supposed to do anything.

Comments ... anyone knowledgeable on these matters?

*Greg K*

Re: [OT] Routers and modems and wifi, oh my

[mike smith]

Kogan are offering triple qantas points on dlink purchases.  (kind of a
triple strike, I know)

Mike

On Mon, Nov 2, 2015 at 2:45 PM, David Connors  wrote:

> I'd approach each requirement separately.
>
> For VOIP:
> To use existing phones get a PAP2T for $30. Check with your VOIP provider
> it is compatible - can be a bastard to get going with UDP/STUN/etc. I've
> disconnected our VOIP service because with all these unlimited mobile plans
> now it doesn't make sense to have a phone that just rings with SPAM anyway.
>
> For wireless:
> Cisco 1252AG-N-K9 is unbelievable value second hand. Heaps end up on ebay
> regularly as people upgrade their networks to 802.11AC (which it does not
> support - don't let that worry you as it is faster than the NBN and
> certainly faster than your DSL 2 line).  We use 60 of them at TechEd
> *cough* Ignite and always get very good feedback. You need to get one with
> 2.4GHz and 5GHz dipoles and either a PowerCube4 PoE injector (this is NOT
> standard PoE) or power supply and ensure it has autonomous firmware on it
> (otherwise it needs a wireless LAN controller $$$).
> ~$100-200 depending on what it comes with.
>
> For ADSL2+
> Cisco 877-M-K9. That'll do your routing, NAT, port mappings etc.
>
> http://www.ebay.com.au/itm/Cisco-877-M-K9-Annex-M-Router-Power-pack-Lead-Console-cable-/161858837540?hash=item25af89dc24:g:ODcAAOSwEetV98By
> That one has a BIN of $140.
>
> With the AP and router above,* these are not resigrade devices and you
> won't be able to 'follow your nose' to configure them*. The web ui on the
> 1252 is appalling and there is no web ui on the 877. You'll be in the world
> of serial cables for factory reset, TFTP servers for firmware updates, etc.
> There are heaps of templates out there for the 877 with every ISP on
> whirlpool. I can give you an autonomous config for a 1252AGN easily enough.
>
> HTH
>
> David.
>
>
>
> On Mon, 2 Nov 2015 at 12:50 David Burstin  wrote:
>
>> Up to $400 for a solution that works well (meaning good wifi, voip line
>> doesn't disappear randomly, reliable LAN).
>>
>> I have never configured on of those devices (Cisco IOS or JunOS), but
>> would gladly give it a go.
>>
>> On 2 November 2015 at 13:38, David Connors  wrote:
>>
>>> How much money do you want to spend and what is your pain threshold for
>>> configuring a Cisco IOS or JunOS device?
>>>
>>> On Mon, 2 Nov 2015 at 12:37 David Burstin 
>>> wrote:
>>>
 Hi folks,

 I am looking at getting a new router as my current Billion one is
 playing up too often (losing LAN, wifi disappearing, other fun stuff).

 The functionality I need is basically an ADSL modem, router, wifi and
 voip. The Billion one covered this, but the wifi was just crap. I would
 have no problem having multiple devices (eg modem and voip separate from
 router and wifi).

 Probably the most important thing for me is that the wifi reaches
 beyond 10 meters.

 All suggestions welcome - even smart-ass ones (as long as they are
 funny).

 Cheers
 Dave

>>> --
>>> David Connors
>>> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>>>
>>
>> --
> David Connors
> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>



-- 
Meski

 http://courteous.ly/aAOZcv

"Going to Starbucks for coffee is like going to prison for sex. Sure,
you'll get it, but it's going to be rough" - Adam Hills

Re: [OT] Routers and modems and wifi, oh my

[David Burstin]

Thanks David. Very helpful. I will start looking into the AP and router
config tomorrow, just to make sure I am not biting off more than I am
willing to chew.

Cheers

On 2 November 2015 at 14:45, David Connors  wrote:

> I'd approach each requirement separately.
>
> For VOIP:
> To use existing phones get a PAP2T for $30. Check with your VOIP provider
> it is compatible - can be a bastard to get going with UDP/STUN/etc. I've
> disconnected our VOIP service because with all these unlimited mobile plans
> now it doesn't make sense to have a phone that just rings with SPAM anyway.
>
> For wireless:
> Cisco 1252AG-N-K9 is unbelievable value second hand. Heaps end up on ebay
> regularly as people upgrade their networks to 802.11AC (which it does not
> support - don't let that worry you as it is faster than the NBN and
> certainly faster than your DSL 2 line).  We use 60 of them at TechEd
> *cough* Ignite and always get very good feedback. You need to get one with
> 2.4GHz and 5GHz dipoles and either a PowerCube4 PoE injector (this is NOT
> standard PoE) or power supply and ensure it has autonomous firmware on it
> (otherwise it needs a wireless LAN controller $$$).
> ~$100-200 depending on what it comes with.
>
> For ADSL2+
> Cisco 877-M-K9. That'll do your routing, NAT, port mappings etc.
>
> http://www.ebay.com.au/itm/Cisco-877-M-K9-Annex-M-Router-Power-pack-Lead-Console-cable-/161858837540?hash=item25af89dc24:g:ODcAAOSwEetV98By
> That one has a BIN of $140.
>
> With the AP and router above,* these are not resigrade devices and you
> won't be able to 'follow your nose' to configure them*. The web ui on the
> 1252 is appalling and there is no web ui on the 877. You'll be in the world
> of serial cables for factory reset, TFTP servers for firmware updates, etc.
> There are heaps of templates out there for the 877 with every ISP on
> whirlpool. I can give you an autonomous config for a 1252AGN easily enough.
>
> HTH
>
> David.
>
>
>
> On Mon, 2 Nov 2015 at 12:50 David Burstin  wrote:
>
>> Up to $400 for a solution that works well (meaning good wifi, voip line
>> doesn't disappear randomly, reliable LAN).
>>
>> I have never configured on of those devices (Cisco IOS or JunOS), but
>> would gladly give it a go.
>>
>> On 2 November 2015 at 13:38, David Connors  wrote:
>>
>>> How much money do you want to spend and what is your pain threshold for
>>> configuring a Cisco IOS or JunOS device?
>>>
>>> On Mon, 2 Nov 2015 at 12:37 David Burstin 
>>> wrote:
>>>
 Hi folks,

 I am looking at getting a new router as my current Billion one is
 playing up too often (losing LAN, wifi disappearing, other fun stuff).

 The functionality I need is basically an ADSL modem, router, wifi and
 voip. The Billion one covered this, but the wifi was just crap. I would
 have no problem having multiple devices (eg modem and voip separate from
 router and wifi).

 Probably the most important thing for me is that the wifi reaches
 beyond 10 meters.

 All suggestions welcome - even smart-ass ones (as long as they are
 funny).

 Cheers
 Dave

>>> --
>>> David Connors
>>> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>>>
>>
>> --
> David Connors
> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>

RE: Sql Server Patch Scripts

[Grant Castner]

Hi Tony,
We use dbup (https://dbup.github.io/) - it allows you to create a small visual 
studio project so that you can track scripts as well as check them in.
 
Cheers,
Grant


Grant Castner
Phone: 0458 770 749
Twitter: https://twitter.com/grantcastner
LinkedIn: au.linkedin.com/pub/grant-castner

 
Date: Mon, 2 Nov 2015 14:48:56 +1100
Subject: Sql Server Patch Scripts
From: tonyw...@gmail.com
To: ozdotnet@ozdotnet.com

Hi all,
Almost every system I have developed has been against a SQL Server database, 
and every environment has needed to be patched as greenfields projects 
introduce new changes.
The reality is that I have found providing patch scripts for sql server quite 
problematic and have never been very happy about what we do to apply patch 
scripts. 

I want to know what scripts have been applied to a database, and I also want to 
know that scripts applied are transactional (that is, if a script "breaks" when 
applied, nothing has changed.) I also want to be able to add data to be 
inserted into tables to my scripts.
What are people currently doing to solve these issues?
Warm regards,Tony 

Re: [OT] Routers and modems and wifi, oh my

[David Connors]

How much money do you want to spend and what is your pain threshold for
configuring a Cisco IOS or JunOS device?

On Mon, 2 Nov 2015 at 12:37 David Burstin  wrote:

> Hi folks,
>
> I am looking at getting a new router as my current Billion one is playing
> up too often (losing LAN, wifi disappearing, other fun stuff).
>
> The functionality I need is basically an ADSL modem, router, wifi and
> voip. The Billion one covered this, but the wifi was just crap. I would
> have no problem having multiple devices (eg modem and voip separate from
> router and wifi).
>
> Probably the most important thing for me is that the wifi reaches beyond
> 10 meters.
>
> All suggestions welcome - even smart-ass ones (as long as they are funny).
>
> Cheers
> Dave
>
-- 
David Connors
da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363

Re: Sql Server Patch Scripts

[David Burstin]

We use SQL Server projects for patching, version controlled with git.

For schema changes, we run a compare on the project and the dev database
(assuming that is where the schema changes are) and create an upgrade
script from that.

For actual data changes to be applied, we create separate scripts in the
sql project specifically for those.

This seems to work pretty well for us. YMMV.

Cheers
Dave

On 2 November 2015 at 14:53, Grant Castner  wrote:

> Hi Tony,
> We use dbup (https://dbup.github.io/) - it allows you to create a small
> visual studio project so that you can track scripts as well as check them
> in.
>
> Cheers,
> Grant
>
>
> Grant Castner
> Phone: 0458 770 749
> Twitter: https://twitter.com/grantcastner
> LinkedIn: au.linkedin.com/pub/grant-castner
>
>
> --
> Date: Mon, 2 Nov 2015 14:48:56 +1100
> Subject: Sql Server Patch Scripts
> From: tonyw...@gmail.com
> To: ozdotnet@ozdotnet.com
>
>
> Hi all,
>
> Almost every system I have developed has been against a SQL Server
> database, and every environment has needed to be patched as greenfields
> projects introduce new changes.
>
> The reality is that I have found providing patch scripts for sql server
> quite problematic and have never been very happy about what we do to apply
> patch scripts.
>
> I want to know what scripts have been applied to a database, and I also
> want to know that scripts applied are transactional (that is, if a script
> "breaks" when applied, nothing has changed.) I also want to be able to add
> data to be inserted into tables to my scripts.
>
> What are people currently doing to solve these issues?
>
> Warm regards,
> Tony
>

Re: [OT] Routers and modems and wifi, oh my

[Stuart Kinnear]

Friend of mine installed an ubiquiti in the roof of his house. I was quite
impressed with the range, walking outside with good wifi.

I'll leave it to you to do the research :
http://ubiquitishop.com.au/3_unifi_access_points.products

- Stuart



On 2 November 2015 at 13:36, David Burstin  wrote:

> Hi folks,
>
> I am looking at getting a new router as my current Billion one is playing
> up too often (losing LAN, wifi disappearing, other fun stuff).
>
> The functionality I need is basically an ADSL modem, router, wifi and
> voip. The Billion one covered this, but the wifi was just crap. I would
> have no problem having multiple devices (eg modem and voip separate from
> router and wifi).
>
> Probably the most important thing for me is that the wifi reaches beyond
> 10 meters.
>
> All suggestions welcome - even smart-ass ones (as long as they are funny).
>
> Cheers
> Dave
>



-- 
-
Stuart Kinnear
Mobile: 040 704 5686.   Office: 03 9589 6502

SK Pro-Active! Pty Ltd
acn. 81 072 778 262
PO Box 6082 Cromer, Vic 3193. Australia

Business software developers.
SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office.
-

Sql Server Patch Scripts

[Tony Wright]

Hi all,

Almost every system I have developed has been against a SQL Server
database, and every environment has needed to be patched as greenfields
projects introduce new changes.

The reality is that I have found providing patch scripts for sql server
quite problematic and have never been very happy about what we do to apply
patch scripts.

I want to know what scripts have been applied to a database, and I also
want to know that scripts applied are transactional (that is, if a script
"breaks" when applied, nothing has changed.) I also want to be able to add
data to be inserted into tables to my scripts.

What are people currently doing to solve these issues?

Warm regards,
Tony

[OT] SSL testing

[Tom Rutter]

Folks

I noticed a mate's shopping site over the weekend returning the following
in the connection info for the certificate:

*Your connection to www.somesite.com  is encypted
using an obsolete cipher suite.*

Did some googling, didn't understand much of it but landed on ssllabs.com
which runs a test on the site. It gave the site an F rating with the
following info

- This server supports anonymous (insecure) suites (see below for details).
Grade set to F.
- This server supports weak Diffie-Hellman (DH) key exchange parameters.
Grade capped to B.
- This server accepts the RC4 cipher, which is weak. Grade capped to B.
- This server supports TLS_FALLBACK_SCSV to prevent protocol downgrade
attacks.

Should my mate be concerned? The people who created and run his site I
assume don't know or do know and aren't concerned. Anybody here used
ssllabs before or an alternative and how much should you care about the
rating? Even the microsoft store only gets a B with various warnings about
inconsistent server configurations.

Cheers

Re: [OT] Office 365

[Michael Ridland]

Wouldn't this all depend on your requirements?

Thanks

*Michael Ridland | Technical Director | Xamarin MVP*

XAM Consulting - Mobile Technology Specialists

www.xam-consulting.com

Blog: www.michaelridland.com



On Mon, Nov 2, 2015 at 2:19 PM, Ken Schaefer  wrote:

> Serious question – I have to look at this at work right now. We have
> SharePoint, but if there’s alternatives out there that people recommend
> (for a corporate environment), then I’d be keen to look into them
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [mailto:
> ozdotnet-boun...@ozdotnet.com] *On Behalf Of *DotNet Dude
> *Sent:* Monday, 2 November 2015 12:57 PM
> *To:* ozDotNet 
> *Subject:* Re: [OT] Office 365
>
>
>
> Damn I've been busted u... lotus notes
>
>
>
> On Mon, Nov 2, 2015 at 12:50 PM, Ken Schaefer 
> wrote:
>
> What alternatives would you recommend?
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [mailto:
> ozdotnet-boun...@ozdotnet.com] *On Behalf Of *DotNet Dude
> *Sent:* Sunday, 1 November 2015 7:04 PM
> *To:* ozDotNet 
> *Subject:* Re: [OT] Office 365
>
>
>
> People still use sharepoint? Lol
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
> Actually did some more reading and it looks like the business version
> gives you access to Lync (for business), Sharepoint and I think
> collaborative office editing. As well as the Home stuff. All of which I am
> not using so don't need. I think Office 365 Home is the way to go for me
> right now.
>
>
>
> On Sun, 1 Nov 2015 at 15:32 DotNet Dude  wrote:
>
> >From what I've heard (which is very little)
>
> the business version gives you more control in the "dashboard" to
> customise stuff. I also don't think you're meant to use non-business
> versions for commercial use, whatever that means. 
>
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
> Hey all,
>
>
>
> I know a few here use Office 365 (from previous threads) and was wondering
> if anyone is using the Office 365 Business? Trying to work out what it
> gives you and so far it looks exactly the same as the Home version except
> its more expensive. Perhaps business support is the extra?
>
>
>
> I'm currently using the freebie given to me via my msdn account and its
> great. Its called Office 365 Developer Subscription. Its not documented
> anywhere that that is, but it says I'm using Office 365 Personal except I
> have +1 install (2 total) when compared with the real Office 365 Personal
> product.
>
> I have a few more machines than that, and have decided to drop Dropbox
> (its in the name... they have been telling to do it all along...) and make
> OneDrive my main cloud storage. So wanted a couple more installs (and
> figure if i'm not paying for Dropbox anymore that can pay for Office 365.
>
>
>
> Going to go with Office 365 Home, but curious what the Office 365 Business
> Premium gives you. They only compare it with the other Business products,
> can't find a Home vs Business comparison. Not one that spells it out...
>
>
>

Re: [OT] Routers and modems and wifi, oh my

[David Connors]

I'd approach each requirement separately.

For VOIP:
To use existing phones get a PAP2T for $30. Check with your VOIP provider
it is compatible - can be a bastard to get going with UDP/STUN/etc. I've
disconnected our VOIP service because with all these unlimited mobile plans
now it doesn't make sense to have a phone that just rings with SPAM anyway.

For wireless:
Cisco 1252AG-N-K9 is unbelievable value second hand. Heaps end up on ebay
regularly as people upgrade their networks to 802.11AC (which it does not
support - don't let that worry you as it is faster than the NBN and
certainly faster than your DSL 2 line).  We use 60 of them at TechEd
*cough* Ignite and always get very good feedback. You need to get one with
2.4GHz and 5GHz dipoles and either a PowerCube4 PoE injector (this is NOT
standard PoE) or power supply and ensure it has autonomous firmware on it
(otherwise it needs a wireless LAN controller $$$).
~$100-200 depending on what it comes with.

For ADSL2+
Cisco 877-M-K9. That'll do your routing, NAT, port mappings etc.
http://www.ebay.com.au/itm/Cisco-877-M-K9-Annex-M-Router-Power-pack-Lead-Console-cable-/161858837540?hash=item25af89dc24:g:ODcAAOSwEetV98By
That one has a BIN of $140.

With the AP and router above,* these are not resigrade devices and you
won't be able to 'follow your nose' to configure them*. The web ui on the
1252 is appalling and there is no web ui on the 877. You'll be in the world
of serial cables for factory reset, TFTP servers for firmware updates, etc.
There are heaps of templates out there for the 877 with every ISP on
whirlpool. I can give you an autonomous config for a 1252AGN easily enough.

HTH

David.



On Mon, 2 Nov 2015 at 12:50 David Burstin  wrote:

> Up to $400 for a solution that works well (meaning good wifi, voip line
> doesn't disappear randomly, reliable LAN).
>
> I have never configured on of those devices (Cisco IOS or JunOS), but
> would gladly give it a go.
>
> On 2 November 2015 at 13:38, David Connors  wrote:
>
>> How much money do you want to spend and what is your pain threshold for
>> configuring a Cisco IOS or JunOS device?
>>
>> On Mon, 2 Nov 2015 at 12:37 David Burstin 
>> wrote:
>>
>>> Hi folks,
>>>
>>> I am looking at getting a new router as my current Billion one is
>>> playing up too often (losing LAN, wifi disappearing, other fun stuff).
>>>
>>> The functionality I need is basically an ADSL modem, router, wifi and
>>> voip. The Billion one covered this, but the wifi was just crap. I would
>>> have no problem having multiple devices (eg modem and voip separate from
>>> router and wifi).
>>>
>>> Probably the most important thing for me is that the wifi reaches beyond
>>> 10 meters.
>>>
>>> All suggestions welcome - even smart-ass ones (as long as they are
>>> funny).
>>>
>>> Cheers
>>> Dave
>>>
>> --
>> David Connors
>> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>>
>
> --
David Connors
da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363

Re: Sql Server Patch Scripts

[Craig van Nieuwkerk]

I do this as well with projects. It works well if you only have to deploy
to a couple of databases. If you have many databases (>3) then I find the
migrations approach described by Grant works very well.

On Mon, Nov 2, 2015 at 3:15 PM, David Burstin 
wrote:

> We use SQL Server projects for patching, version controlled with git.
>
> For schema changes, we run a compare on the project and the dev database
> (assuming that is where the schema changes are) and create an upgrade
> script from that.
>
> For actual data changes to be applied, we create separate scripts in the
> sql project specifically for those.
>
> This seems to work pretty well for us. YMMV.
>
> Cheers
> Dave
>
> On 2 November 2015 at 14:53, Grant Castner 
> wrote:
>
>> Hi Tony,
>> We use dbup (https://dbup.github.io/) - it allows you to create a small
>> visual studio project so that you can track scripts as well as check them
>> in.
>>
>> Cheers,
>> Grant
>>
>>
>> Grant Castner
>> Phone: 0458 770 749
>> Twitter: https://twitter.com/grantcastner
>> LinkedIn: au.linkedin.com/pub/grant-castner
>>
>>
>> --
>> Date: Mon, 2 Nov 2015 14:48:56 +1100
>> Subject: Sql Server Patch Scripts
>> From: tonyw...@gmail.com
>> To: ozdotnet@ozdotnet.com
>>
>>
>> Hi all,
>>
>> Almost every system I have developed has been against a SQL Server
>> database, and every environment has needed to be patched as greenfields
>> projects introduce new changes.
>>
>> The reality is that I have found providing patch scripts for sql server
>> quite problematic and have never been very happy about what we do to apply
>> patch scripts.
>>
>> I want to know what scripts have been applied to a database, and I also
>> want to know that scripts applied are transactional (that is, if a script
>> "breaks" when applied, nothing has changed.) I also want to be able to add
>> data to be inserted into tables to my scripts.
>>
>> What are people currently doing to solve these issues?
>>
>> Warm regards,
>> Tony
>>
>
>

Re: [OT] Office 365

[DotNet Dude]

Damn I've been busted u... lotus notes

On Mon, Nov 2, 2015 at 12:50 PM, Ken Schaefer  wrote:

> What alternatives would you recommend?
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [mailto:
> ozdotnet-boun...@ozdotnet.com] *On Behalf Of *DotNet Dude
> *Sent:* Sunday, 1 November 2015 7:04 PM
> *To:* ozDotNet 
> *Subject:* Re: [OT] Office 365
>
>
>
> People still use sharepoint? Lol
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
> Actually did some more reading and it looks like the business version
> gives you access to Lync (for business), Sharepoint and I think
> collaborative office editing. As well as the Home stuff. All of which I am
> not using so don't need. I think Office 365 Home is the way to go for me
> right now.
>
>
>
> On Sun, 1 Nov 2015 at 15:32 DotNet Dude  wrote:
>
> >From what I've heard (which is very little)
>
> the business version gives you more control in the "dashboard" to
> customise stuff. I also don't think you're meant to use non-business
> versions for commercial use, whatever that means. 
>
>
> On Sunday, 1 November 2015, Stephen Price 
> wrote:
>
> Hey all,
>
>
>
> I know a few here use Office 365 (from previous threads) and was wondering
> if anyone is using the Office 365 Business? Trying to work out what it
> gives you and so far it looks exactly the same as the Home version except
> its more expensive. Perhaps business support is the extra?
>
>
>
> I'm currently using the freebie given to me via my msdn account and its
> great. Its called Office 365 Developer Subscription. Its not documented
> anywhere that that is, but it says I'm using Office 365 Personal except I
> have +1 install (2 total) when compared with the real Office 365 Personal
> product.
>
> I have a few more machines than that, and have decided to drop Dropbox
> (its in the name... they have been telling to do it all along...) and make
> OneDrive my main cloud storage. So wanted a couple more installs (and
> figure if i'm not paying for Dropbox anymore that can pay for Office 365.
>
>
>
> Going to go with Office 365 Home, but curious what the Office 365 Business
> Premium gives you. They only compare it with the other Business products,
> can't find a Home vs Business comparison. Not one that spells it out...
>
>

[OT] Routers and modems and wifi, oh my

[David Burstin]

Hi folks,

I am looking at getting a new router as my current Billion one is playing
up too often (losing LAN, wifi disappearing, other fun stuff).

The functionality I need is basically an ADSL modem, router, wifi and voip.
The Billion one covered this, but the wifi was just crap. I would have no
problem having multiple devices (eg modem and voip separate from router and
wifi).

Probably the most important thing for me is that the wifi reaches beyond 10
meters.

All suggestions welcome - even smart-ass ones (as long as they are funny).

Cheers
Dave

Re: [OT] Routers and modems and wifi, oh my

[David Burstin]

Up to $400 for a solution that works well (meaning good wifi, voip line
doesn't disappear randomly, reliable LAN).

I have never configured on of those devices (Cisco IOS or JunOS), but would
gladly give it a go.

On 2 November 2015 at 13:38, David Connors  wrote:

> How much money do you want to spend and what is your pain threshold for
> configuring a Cisco IOS or JunOS device?
>
> On Mon, 2 Nov 2015 at 12:37 David Burstin  wrote:
>
>> Hi folks,
>>
>> I am looking at getting a new router as my current Billion one is playing
>> up too often (losing LAN, wifi disappearing, other fun stuff).
>>
>> The functionality I need is basically an ADSL modem, router, wifi and
>> voip. The Billion one covered this, but the wifi was just crap. I would
>> have no problem having multiple devices (eg modem and voip separate from
>> router and wifi).
>>
>> Probably the most important thing for me is that the wifi reaches beyond
>> 10 meters.
>>
>> All suggestions welcome - even smart-ass ones (as long as they are funny).
>>
>> Cheers
>> Dave
>>
> --
> David Connors
> da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
>

RE: [OT] Office 365

[Ken Schaefer]

Serious question – I have to look at this at work right now. We have 
SharePoint, but if there’s alternatives out there that people recommend (for a 
corporate environment), then I’d be keen to look into them

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Monday, 2 November 2015 12:57 PM
To: ozDotNet 
Subject: Re: [OT] Office 365

Damn I've been busted u... lotus notes

On Mon, Nov 2, 2015 at 12:50 PM, Ken Schaefer 
> wrote:
What alternatives would you recommend?

From: ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of DotNet Dude
Sent: Sunday, 1 November 2015 7:04 PM
To: ozDotNet >
Subject: Re: [OT] Office 365

People still use sharepoint? Lol

On Sunday, 1 November 2015, Stephen Price 
> wrote:
Actually did some more reading and it looks like the business version gives you 
access to Lync (for business), Sharepoint and I think collaborative office 
editing. As well as the Home stuff. All of which I am not using so don't need. 
I think Office 365 Home is the way to go for me right now.

On Sun, 1 Nov 2015 at 15:32 DotNet Dude 
> wrote:
>From what I've heard (which is very little)
the business version gives you more control in the "dashboard" to customise 
stuff. I also don't think you're meant to use non-business versions for 
commercial use, whatever that means. 

On Sunday, 1 November 2015, Stephen Price 
> wrote:
Hey all,

I know a few here use Office 365 (from previous threads) and was wondering if 
anyone is using the Office 365 Business? Trying to work out what it gives you 
and so far it looks exactly the same as the Home version except its more 
expensive. Perhaps business support is the extra?

I'm currently using the freebie given to me via my msdn account and its great. 
Its called Office 365 Developer Subscription. Its not documented anywhere that 
that is, but it says I'm using Office 365 Personal except I have +1 install (2 
total) when compared with the real Office 365 Personal product.
I have a few more machines than that, and have decided to drop Dropbox (its in 
the name... they have been telling to do it all along...) and make OneDrive my 
main cloud storage. So wanted a couple more installs (and figure if i'm not 
paying for Dropbox anymore that can pay for Office 365.

Going to go with Office 365 Home, but curious what the Office 365 Business 
Premium gives you. They only compare it with the other Business products, can't 
find a Home vs Business comparison. Not one that spells it out...

Re: Sql Server Patch Scripts

[Tony Wright]

I have previously used FlyWay to perform database migrations, and in fact
there is even a course on Pluralsight for this.

I am currently generating scripts via Visual Studio Database Projects, but
there appear to be a few problems with this. Firstly, it doesn't seem to
scale well. It seems ok with a single database, but once you have multiple
databases in an environment operating at different versions, there doesn't
seem to be a way of knowing what version a database is at, and therefore
know which scripts to run to get it up to date. There is also no automated
way to get the database up to date by running a batch of the right scripts.
I'm also not convinced that the scripts run transactionally. I seem to
recall database scripts failing but leaving behind database objects - the
only solution of which was to either restore the database from backup and
apply a fixed script, or rerun Sql Compare to give me the new diff script.

I would have loved to use FlyWay and put the scripts generated by Visual
Studio Sql Compare into FlyWay versioned scripts, but that doesn't work, as
FlyWay doesn't run the scripts in SqlCmd mode, and therefore the variables
generated in the script all fail. Yes, I can go to some effort to modify
those scripts, but I'd rather not have to make too many changes to the
generated scripts (I am already reviewing those scripts every time it gives
the "data may be changed..." error).

I will take a look at DbUp. Does anyone know if that can handle SqlCmd mode
scripts?

On Mon, Nov 2, 2015 at 3:22 PM, Craig van Nieuwkerk 
wrote:

> I do this as well with projects. It works well if you only have to deploy
> to a couple of databases. If you have many databases (>3) then I find the
> migrations approach described by Grant works very well.
>
> On Mon, Nov 2, 2015 at 3:15 PM, David Burstin 
> wrote:
>
>> We use SQL Server projects for patching, version controlled with git.
>>
>> For schema changes, we run a compare on the project and the dev database
>> (assuming that is where the schema changes are) and create an upgrade
>> script from that.
>>
>> For actual data changes to be applied, we create separate scripts in the
>> sql project specifically for those.
>>
>> This seems to work pretty well for us. YMMV.
>>
>> Cheers
>> Dave
>>
>> On 2 November 2015 at 14:53, Grant Castner 
>> wrote:
>>
>>> Hi Tony,
>>> We use dbup (https://dbup.github.io/) - it allows you to create a small
>>> visual studio project so that you can track scripts as well as check them
>>> in.
>>>
>>> Cheers,
>>> Grant
>>>
>>>
>>> Grant Castner
>>> Phone: 0458 770 749
>>> Twitter: https://twitter.com/grantcastner
>>> LinkedIn: au.linkedin.com/pub/grant-castner
>>>
>>>
>>> --
>>> Date: Mon, 2 Nov 2015 14:48:56 +1100
>>> Subject: Sql Server Patch Scripts
>>> From: tonyw...@gmail.com
>>> To: ozdotnet@ozdotnet.com
>>>
>>>
>>> Hi all,
>>>
>>> Almost every system I have developed has been against a SQL Server
>>> database, and every environment has needed to be patched as greenfields
>>> projects introduce new changes.
>>>
>>> The reality is that I have found providing patch scripts for sql server
>>> quite problematic and have never been very happy about what we do to apply
>>> patch scripts.
>>>
>>> I want to know what scripts have been applied to a database, and I also
>>> want to know that scripts applied are transactional (that is, if a script
>>> "breaks" when applied, nothing has changed.) I also want to be able to add
>>> data to be inserted into tables to my scripts.
>>>
>>> What are people currently doing to solve these issues?
>>>
>>> Warm regards,
>>> Tony
>>>
>>
>>
>