RE: Xamarin Hack Day
Sounds like a plan already! 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Monday, 7 July 2014 5:59 PM To: ozDotNet Subject: Re: Xamarin Hack Day If anything happens in Melbourne, please remember to advertise it here. Strange turn of events, just after I read this thread this morning, my wife says to me hey, do you want to go to Melbourne? So if I can organise it to overlap a Melbourne Xamarin hack day that'd be awesome! :) cheers, Stephen On Mon, Jul 7, 2014 at 3:30 PM, Preet Sangha preetsan...@gmail.com mailto:preetsan...@gmail.com wrote: I'm in auckland, but might be able to get to melbourne - I've done now xamrin at all but fancy a trip to the far city On 7 July 2014 18:45, ghunt...@ghuntley.com mailto:ghunt...@ghuntley.com wrote: I’m keen for a Melbourne event as well and would fly down from Sydney to present/brains trust, etc. Regards, Geoff From: Michael Ridland mailto:rid...@gmail.com Sent: Monday, 7 July 2014 4:39 PM To: ozDotNet mailto:ozdotnet@ozdotnet.com Hi Sorry to jump in late, I've been away the past week. I organised(with some great help from SSW) the Sydney Xamarin Hack day. I know that many of the key people in the Sydney event have already spoken of a Melbourne event. When I originally came up with the idea and event, the plan was to have it more casual with everyone hacking and no presentations. SSW encouraged me to make it more organized with some presentations and agenda. The format http://xamarinhackday.com/agenda/ we came up with seemed to work well and most people had a great day, I definitely did. Like Andrew said venue, speakers, agenda, catering, swag, publicity. Though I never managed to organize a free lunch there was a pub next door in which most attendees got lunch from. I'm keen for a Melbourne event. Hey why not all cities, make it even more fun. Thanks Michael http://www.michaelridland.com On Mon, Jul 7, 2014 at 12:57 PM, Preet Sangha preetsan...@gmail.com mailto:preetsan...@gmail.com wrote: What does it take to organise one of these things? What's the expectation from attendees? On 7 July 2014 14:28, Andrew Coates (DX AUSTRALIA) andrew.coa...@microsoft.com mailto:andrew.coa...@microsoft.com wrote: There has recently been an offer to organise one in Melbourne! Watch this space (and others) Cheers Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 tel:%2B61%20%282%29%209870%202719 • Mob +61 (416) 134 993 tel:%2B61%20%28416%29%20134%20993 • Fax: +61 (2) 9870 2400 tel:%2B61%20%282%29%209870%202400 • http://blogs.msdn.com/acoat http://blogs.msdn.com/acoat Sent from the http://office.com/preview new Office From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Bec Carter Sent: Wednesday, 2 July 2014 4:34 PM To: ozDotNet Subject: Re: Xamarin Hack Day I am not offering :p On Tue, Jul 1, 2014 at 9:17 PM, Andrew Coates (DX AUSTRALIA) andrew.coa...@microsoft.com mailto:andrew.coa...@microsoft.com wrote: You offering to organise one? :) Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 tel:%2B61%20%282%29%209870%202719 • Mob +61 (416) 134 993 tel:%2B61%20%28416%29%20134%20993 • Fax: +61 (2) 9870 2400 tel:%2B61%20%282%29%209870%202400 • http://blogs.msdn.com/acoat http://blogs.msdn.com/acoat Sent from the http://office.com/preview new Office From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Bec Carter Sent: Tuesday, 1 July 2014 3:18 PM To: ozDotNet Subject: Re: Xamarin Hack Day Any Xamarin events in Melbourne? On Fri, Jun 13, 2014 at 3:37 PM, Michael Ridland rid...@gmail.com mailto:rid...@gmail.com wrote: In case you missed it there's a Xamarin Hack day happening next Saturday. All are welcome. http://xamarinhackday.com/ -- regards, Preet, Overlooking the Ocean, Auckland -- regards, Preet, Overlooking the Ocean, Auckland
RE: Optus to sell Office365
I don't want to see it forced through any reseller. I just want to have the option to deal directly with Microsoft. Other people in the loop just complicate support for me. I can do that with Google and with any number of other global providers, so why not Microsoft? If I was running a milk bar or a cafe, I might feel differently. Both options should be available (ie: dealing with a partner if you need that type of help, or not dealing with one if you don't need that type of help). And partners that push the products should be part of the ongoing return on the products. I used to like the model that some companies used when ADSL first appeared. Customers could deal directly with them if they wanted. Partners could be involved in getting people signed up, and if they did, they were part of the revenue stream from that point on (indefinitely in relation to those connections). Bottom line is that I shouldn't be penalised for being based in Australia. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of ILT (O) Sent: Friday, 27 June 2014 7:56 PM To: ozdotnet@ozdotnet.com Subject: Optus to sell Office365 I know the Small Business IT professionals groups around Australia have been p!ssed off with O365 sales being Telstra-controlled for so long, so this http://www.smh.com.au/it-pro/cloud/optus-gearing-up-to-fight-telstra-on-mic rosoft-365-turf-20140623-zse9x.html announcement (SMH, today) is good news. Optus gearing up to fight Telstra on Microsoft 365 turf Optus is preparing to tread on Telstra's turf in the cloud computing market after securing a long overdue partnership with Microsoft. There's more interesting information in that SMH IT Pro article. _ Ian Thomas Victoria Park, Western Australia
Programatically paying BPAY invoices
Hi Folks, Anyone know if there are any interfaces that allow you to programmatically pay a BPAY account (and get a receipt instantly)? 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
RE: [OT] Browser use
Yep, unfortunately though the experience for users isn’t good or obvious. In the case of the ATO website, even that doesn’t work. You get prompted to install Java (even though you already have it). When you install it, it just says to install it again. If you call them, they say “use Chrome”. Most people got used to hitting the compatibility link (the broken link tab thing) when they had issues with web sites but for some reason, they’ve all decided to remove that from the browser too. You need to enable the full menu, then choose the compatibility settings, and then add the site. That’s far less discoverable for most people. And for some sites, that works, for many others it doesn’t. 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 From: ILT (O) [mailto:il.tho...@outlook.com] Sent: Thursday, 22 May 2014 1:51 PM To: GregAtGregLowDotCom; 'ozDotNet' Subject: RE: [OT] Browser use GregL - I thought I saw, 2-3 weeks/months ago? - that IE11 can be put into Edge Mode (IE8) – but of course that requires your visitors to be aware of that. _ Ian Thomas Victoria Park, Western Australia From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Thursday, May 22, 2014 11:33 AM To: 'ozDotNet' Subject: RE: [OT] Browser use I never thought I’d change my default browser but I had to do so with IE11. Moved to using Chrome as a default. I eventually I got to a point where I just had to get things done and whether or not Microsoft believe they did the right thing by removing the agent string entries, they “broke the internet” for too many people. I don’t think they understood the politics of this. If someone is browsing ok, and updates to IE11 and then so many sites don’t work, they won’t blame the sites, they’ll blame what they just updated. There were lots of Microsoft’s own properties that wouldn’t work with IE11. You can’t even lodge a BAS return here in Australia with IE11 and if you talk to the ATO, they just say “Use Chrome”. Wish it wasn’t so. Last month was the first month where I noted more Chrome use than IE use at our web site, and we’re a Microsoft related site. That’s a big change for us from 6 months ago. It used to be an IE majority for us. Apart from the lack of compatibility with so many existing sites, I quite like many things about IE11. I just can’t get work done when it’s my default browser. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com Sent: Thursday, 22 May 2014 11:23 AM To: 'ozDotNet' Subject: RE: [OT] Browser use Just want to spread my use of technology amongst many companies instead of a few…it also inspires competition and innovation. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Thursday, 22 May 2014 1:18 PM To: ozDotNet Subject: Re: [OT] Browser use So you would rather support a small non powerful company that uses your data any way they want? The underdog so to speak? Personally, I'd rather use the browser that does everything I want it to and none of the things I don't. Targeted advertising? Sure I want that. I *WANT* to see ads for the latest and greatest Tablet or Monitor. I *don't* want to see tampon ads. Sign me up. Shut up and take my money! If said company becomes an issue, I'll change. I'm a fickle customer, more so than they are. I'm using them more than they are using me. On Thu, May 22, 2014 at 10:25 AM, anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com wrote: I use Firefox, Chrome is great but I do not want to support a company that is so powerful and use your data what ever way they want. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Craig van Nieuwkerk Sent: Thursday, 22 May 2014 12:06 PM To: ozDotNet Subject: Re: [OT] Browser use I am pretty much with you. I find IE works better with VS so use it for most development unless I need to do a lot of client side debugging in which case I use Chrome. I then use Chrome for everyday use. I only use Firefox for cross browser testing. Craig On Thu, May 22, 2014 at 12:01 PM, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: I disagree. I think? I find I use
RE: [OT] Browser use
I never thought I’d change my default browser but I had to do so with IE11. Moved to using Chrome as a default. I eventually I got to a point where I just had to get things done and whether or not Microsoft believe they did the right thing by removing the agent string entries, they “broke the internet” for too many people. I don’t think they understood the politics of this. If someone is browsing ok, and updates to IE11 and then so many sites don’t work, they won’t blame the sites, they’ll blame what they just updated. There were lots of Microsoft’s own properties that wouldn’t work with IE11. You can’t even lodge a BAS return here in Australia with IE11 and if you talk to the ATO, they just say “Use Chrome”. Wish it wasn’t so. Last month was the first month where I noted more Chrome use than IE use at our web site, and we’re a Microsoft related site. That’s a big change for us from 6 months ago. It used to be an IE majority for us. Apart from the lack of compatibility with so many existing sites, I quite like many things about IE11. I just can’t get work done when it’s my default browser. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com Sent: Thursday, 22 May 2014 11:23 AM To: 'ozDotNet' Subject: RE: [OT] Browser use Just want to spread my use of technology amongst many companies instead of a few…it also inspires competition and innovation. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Thursday, 22 May 2014 1:18 PM To: ozDotNet Subject: Re: [OT] Browser use So you would rather support a small non powerful company that uses your data any way they want? The underdog so to speak? Personally, I'd rather use the browser that does everything I want it to and none of the things I don't. Targeted advertising? Sure I want that. I *WANT* to see ads for the latest and greatest Tablet or Monitor. I *don't* want to see tampon ads. Sign me up. Shut up and take my money! If said company becomes an issue, I'll change. I'm a fickle customer, more so than they are. I'm using them more than they are using me. On Thu, May 22, 2014 at 10:25 AM, anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com wrote: I use Firefox, Chrome is great but I do not want to support a company that is so powerful and use your data what ever way they want. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Craig van Nieuwkerk Sent: Thursday, 22 May 2014 12:06 PM To: ozDotNet Subject: Re: [OT] Browser use I am pretty much with you. I find IE works better with VS so use it for most development unless I need to do a lot of client side debugging in which case I use Chrome. I then use Chrome for everyday use. I only use Firefox for cross browser testing. Craig On Thu, May 22, 2014 at 12:01 PM, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: I disagree. I think? I find I use Chrome and IE. For development it depends what I'm doing. If I want to hit a breakpoint in VS then IE does that. If I want to use the debugger in the browser then I use Chrome. IE keeps changing their Developer tools and even though they are improving I still find Chrome more productive for debugging. For actual USE I use Chrome for most things but occasionally something doesn't work right and I switch. Pluralsite for example seems to hang after a while in Chrome. No issues in IE. Not used Firefox in some years. Toggling between two is fine. A third becomes too much. On Thu, May 22, 2014 at 9:53 AM, David Burstin david.burs...@gmail.com mailto:david.burs...@gmail.com wrote: I was using Firefox on some machines, but recently moved to Chrome as a political statement, not because I love Google but rather because I wanted to show my dissatisfaction with Firefox's political correctness/censorship http://readwrite.com/2014/04/03/brendan-eich-mozilla-resigns-ceo#awesm=~oEX2WzjEhsumsR . (And in case you were wondering, I do support marriage equality but even more than that I support peoples right to disagree with me. Agree?) On 22 May 2014 11:43, Bec Carter bec.usern...@gmail.com mailto:bec.usern...@gmail.com wrote: This thread got me wondering if anybody here actually uses a browser other than Chrome. By *use* I mean to personally browse and not to just test sites across different browsers. Even on my now dead Macbook I used Chrome and just find it nicer than Safari or IE. Just curious :-) On Wed, May 21, 2014 at 6:10 PM, noonie
RE: GUIDs
Hi Greg, I’ve never seen the point of NEWSEQUENTIALID(). It can only be used as a database default. If you’re already round-tripping to the database, you might as well pick up an int or a big int. To me, the reason for using GUIDs is when you want to generate the IDs in a different tier, confident that you can just throw them into the database later. Any of the sequential versions (even if client-generated), don’t give you that confidence. The biggest mistake I see people making is assuming that their database representation needs to match the layer above. Even if you use a GUID in the layers above, there’s no need to have them sprinkled throughout the database, fragmenting every table and to be joining on them. You could isolate that to one table. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Saturday, 3 May 2014 10:09 AM To: ozDotNet Subject: Re: GUIDs I did read a web page years ago where a chap reported that using sequential Guids http://technet.microsoft.com/en-us/library/ms189786.aspx produced significant performance improvements -- Greg K On 2 May 2014 23:56, piers.willi...@gmail.com mailto:piers.willi...@gmail.com wrote: Probably worth saying that using guids as a primary key is not for everyone. The key is bigger, so that has a size and performance impact on all your indexes and foreign keys, and as a clustering key it means new records are scattered throughout the file rather than being appended to the tail, leading to logical fragmentation. (But if you need to replicate, synchronize or pre-allocate the key offline in the app tier they can make a lot of sense) From: Michael Ridland mailto:rid...@gmail.com Sent: Friday, May 2, 2014 7:37 PM To: ozDotNet mailto:ozdotnet@ozdotnet.com Guids are also great for offline distributed clients. AutoInc numbers will be a thing of the past. On Friday, May 2, 2014, Jano Petras jano.pet...@gmail.com mailto:jano.pet...@gmail.com wrote: Hi Anthony, Guids are easiest way forward - due to their uniqueness and native support by the DB engine. The only time I would consider using something else would be if there was a requirement for those unique row IDs to be 64bit integers for example or if there is a storage space concern - in this case I would consider using horizontal partitioning and allocating range of IDs to different instances reserving each one with a predefined range of values. On 2 May 2014 16:16, anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com wrote: Anyone doing database replications, are you using guids? Have any recommendations or experiences? I don’t usually use guids but working on systems that may need to scale, so thinking of switching to guids to avoid any future scalability issues Thanks in advance :) Anthony
RE: SQL server session state
HI Stuart, It doesn’t have anything but a minor effect on tempdb. I’m not sure why you’re imagining it will grow unchecked. They normally just create the asp.net session state tables with a database. It works fine and allows for high availability options. Alternately, there are memory-based services that you can install on a server that then provides session state storage for other servers. That can be faster for small server farms but doesn’t offer the HA options as easily. The only real issue I’ve seen with the asp.net session state database is when it grows to large numbers of sessions, some of the sprocs aren’t very well written and need to be modified. For example, they have a sproc that cleans up expired sessions. That’ll work fine until there are a large number to clean up at once. When that happens, they clearly hadn’t thought much about blocking. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stuart Kinnear Sent: Thursday, 1 May 2014 4:32 PM To: ozDotNet Subject: SQL server session state I am considering using SQL server to maintain session state, to improve session lifetime in events such as IIS reboot. I was wondering if there are any downfalls in doing this. What I am bothered about is that over months of use the tempDB could grow unchecked. Is this something I need to worry about, are there real benefits ? -- - 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. -
RE: payment gateways
Same here. Very happy with them on most things. Their shared payment page is the easiest but it’s got limitations. For example, you could ask people which sort of card, and apply an appropriate surcharge but you can’t then lock down which sort of card they use at checkout. They could say they will use a Visa in your processing, let you work out an amount, but then they’ll choose Amex at checkout (which should have been more expensive). They don’t have any answer for this sort of thing except to use the API which is actually pretty good. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Anthony Borton Sent: Monday, 21 April 2014 12:50 PM To: ozDotNet Subject: RE: payment gateways Hey Stephen, Easter being spent with jetlag and man-flu :) I’m using eWay on two sites and have found them to be very good. Never had a problem with them and I’ve found their support to be great on the couple of occasions I have used it. Cheers Anthony Borton Senior ALM Trainer/Consultant Visual Studio ALM MVP Enhance ALM Pty Ltd From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Monday, 21 April 2014 12:24 PM To: ozDotNet Subject: payment gateways Hey all, Hope good Easter is being had by all :) I'm going to need some kind of payment gateway and would love to know if anyone has any good/bad experiences with them. Looking for something that deals with Australian banks, as well as has a good .Net friendly API. Have been looking at what eWay can do but don't want to rush in with the first I've come across without some research. cheers, Stephen
RE: payment gateways
Hi Geoff, Yep, it’s the classic one. I looked at RAPID when it came out but decided against it for some reason. Can’t recall why. Sounds like I’ll talk to you further about it then. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Geoff Appleby Sent: Monday, 21 April 2014 1:48 PM To: ozDotNet Subject: Re: payment gateways Hey Stephen, As an Eway employee I probably can't recommend any where else, but it's nice to hear others saying good things about us :) Since I'm a Dev and not in sales I can't offer any sort of special pricing, but I can help with any implementation questions that may come up. (And who knows, mentioning me may not hurt? I can't promise anything and I've only been with the company 6 months...) Hey Greg, are you using the classic shared payment page or the responsive one that's a part of RAPID? If you use RAPID, I have help :) I added a new feature just recently (went live maybe 4 weeks ago I guess) where you can predefine surcharges for transactions based on credit card type, and we'll automatically adjust the total for you based on the card number entered. You can define them on the shared page settings page in MyEway. This only works if you're redirecting customers to the responsive shared page, not direct payment calls. HTH :) (and I'm happy answer any further questions if I'm able) --Geoff On Apr 21, 2014 12:24 PM, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: Hey all, Hope good Easter is being had by all :) I'm going to need some kind of payment gateway and would love to know if anyone has any good/bad experiences with them. Looking for something that deals with Australian banks, as well as has a good .Net friendly API. Have been looking at what eWay can do but don't want to rush in with the first I've come across without some research. cheers, Stephen
RE: What would you ask Satya?
Ah cool, I’ve downloaded it but not seen it yet. 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 From: Andrew Coates (DPE AUSTRALIA) [mailto:andrew.coa...@microsoft.com] Sent: Wednesday, 9 April 2014 9:05 AM To: ozDotNet; GregAtGregLowDotCom Subject: RE: What would you ask Satya? FYI, this was for the QA section with Satya at the end of the //build keynote. Cheers, Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 • Mob +61 (416) 134 993 • Fax: +61 (2) 9870 2400 • http://blogs.msdn.com/acoat http://blogs.msdn.com/acoat Sent from the http://office.com/preview new Office From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Andrew Coates (DPE AUSTRALIA) Sent: Wednesday, 26 March 2014 11:21 AM To: g...@greglow.com mailto:g...@greglow.com ; ozDotNet Subject: RE: What would you ask Satya? Thanks Greg – I particularly like the services question. Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 ∙ Mob +61 (416) 134 993 ∙ Fax: +61 (2) 9870 2400 ∙ http://blogs.msdn.com/acoat http://blogs.msdn.com/acoat Sent from the http://office.com/preview new Office From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Tuesday, 25 March 2014 2:56 PM To: ozDotNet Subject: RE: What would you ask Satya? Given his engineering background, I’d love to hear his thoughts on building products that actually solve problems. One of the real challenges in recent years seems to be the endless focus on shiny new things that make good 7 minute demos rather than working on existing products until they solve real problems. So many new features look promising but the teams then seem to lose interest in doing the rest of the work to make them truly functional. (That doesn’t apply to all teams but it seems to be a common affliction). I suppose what I’m getting at is that rather than chasing features, is there an interest in chasing the ability to solve problems end-to-end? Also, has he moved past wanting to build products to only wanting to build services? What balance is he aiming for? Does he see the company building software for sale five years from now or will everything be service-based? 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Andrew Coates (DPE AUSTRALIA) Sent: Wednesday, 26 March 2014 1:57 AM To: ozDotNet Subject: What would you ask Satya? If you had an opportunity to ask Satya Nadella a question in front of several thousand developers, what would you ask him?
RE: What would you ask Satya?
Given his engineering background, I'd love to hear his thoughts on building products that actually solve problems. One of the real challenges in recent years seems to be the endless focus on shiny new things that make good 7 minute demos rather than working on existing products until they solve real problems. So many new features look promising but the teams then seem to lose interest in doing the rest of the work to make them truly functional. (That doesn't apply to all teams but it seems to be a common affliction). I suppose what I'm getting at is that rather than chasing features, is there an interest in chasing the ability to solve problems end-to-end? Also, has he moved past wanting to build products to only wanting to build services? What balance is he aiming for? Does he see the company building software for sale five years from now or will everything be service-based? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Andrew Coates (DPE AUSTRALIA) Sent: Wednesday, 26 March 2014 1:57 AM To: ozDotNet Subject: What would you ask Satya? If you had an opportunity to ask Satya Nadella a question in front of several thousand developers, what would you ask him?
RE: [OT] Weird symptoms and SSD
Hi Greg, Always horrible to hear that. What sort of drive was it? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Tuesday, 25 March 2014 2:00 PM To: ozDotNet Subject: [OT] Weird symptoms and SSD Folks, I have a warning post: Since I installed a fresh Windows 7 on an SSD as Xmas I've been suspicious of how one time in 20 it will stop and say Bad boot drive and I have to power off and on again and then it always starts okay. No other symptoms have been observed. Well today, I was shutting down my PC when it blue screened on the way down, it said SERVICE_EXCEPTION. Just to be safe I rebooted it normally to check it was okay. First problem. IE 32-bit shortcut says it's invalid, but I can see the iexplore.exe in the correct place. Double-clicking it does nothing. The 64-bit iexplore.exe tells me The file or directory is corrupted and unreadable. Then I notice most of my Start menu All Programs are gone. The Administrative Tools menu is empty. I searched for an hour but none of the advice is relevant or useful. Last known good config recover did nothing. I even thought I had a virus, but found no evidence. Finally I did a chkdsk C: /F and rebooted and I saw about 20 repairs (including iexplore.exe) and now it seems to be back to normal. However I suspect the SSD is about to die unpredictably and all of my mysterious symptoms were side effects. I'm just posting this in case it might be useful for someone in a similar situation. Now I'm going to the shops to get a new SSD and psych myself up for a possible Windows reinstall over the whole weekend. At Xmas it took 4 x 12 hour days to get to a satisfactory working state. Greg K
RE: Microsoft Web farm Framework Training in Canberra
Hi noonie, Great for some things. I particularly liked K Scott Allen's ones in and around MVC, HTML5, CSS3, etc. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of noonie Sent: Monday, 24 March 2014 10:12 AM To: ozDotNet Subject: Re: Microsoft Web farm Framework Training in Canberra Greetings, I have found this course:- http://pluralsight.com/training/Courses/Description/web-farms Anyone done this one? What's the general feeling on the Pluralsight training model in this community? -- Regards, noonie On 18 March 2014 09:15, noonie neale.n...@gmail.com mailto:neale.n...@gmail.com wrote: Greetings, I'm looking for a course, preferably at our site, for training in Microsoft's Web Farm Framework. Particularly set-up, administration and writing applications that play nicely in that environment. I estimate that there would be six participants with a mix of web admins and .net developers. Any recommendations? -- Regards, noonie
RE: [OT] Noise cancelling earphones for a quiet programming environment?
+1 for the Bose gear. I wear them all the time on long flights and love them but have also used them in other environments and they are great. The noise reduction quality is amazing. +1 also to the idea of drowning out part of the other noise. While they work well without anything even plugged in, clearly you'll lose the other distractions better if you have sounds of your own. For the same reason, I often will have the TV, or music, etc. on when I'm home alone working just to provide background noise. Otherwise, every little sound seems to be distracting. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Jorke Odolphi Sent: Monday, 24 March 2014 9:28 AM To: ozDotNet Subject: Re: [OT] Noise cancelling earphones for a quiet programming environment? http://worldwide.bose.com/axa/en_au/web/quietcomfort_20i/page.html I have a set of these - there is an 'active' mode that basically reduces people talking to sounding like a faint version of the peanuts teacher (I hope that's not too old a reference for people:) I can vouch it works amazingly well in an open office, when I have them on ppl have to wave at me to get attention - I have a mechanical keyboard and I can't hear that either - YMMV of course - if you go to the bose store they're pretty good at helping you test for your situation, especially at that price tag. I had the guy do loud sniffles for me so I could see if it worked for that: From: Kirsten Greed kirst...@jobtalk.com.au mailto:kirst...@jobtalk.com.au Reply-To: ozDotNet ozdotnet@ozdotnet.com mailto:ozdotnet@ozdotnet.com Date: Sunday, 23 March 2014 1:20 pm To: ozDotNet ozdotnet@ozdotnet.com mailto:ozdotnet@ozdotnet.com Subject: [OT] Noise cancelling earphones for a quiet programming environment? Hi All So that I can concentrate better, I am trying to filter out the mouse clicking sound from person at the desk next to me. Has anyone any tech recommendations on how to do this? Thanks Kirsten
RE: Favicons
Andrew. You're the man! That site is awesome. I'd used IcoFX to create these before and my attempts were lousy. But that site lets you import a PNG, crop it, etc. then convert to a favicon. Amazing. So simple yet so powerful. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Andrew Coates (DPE AUSTRALIA) Sent: Thursday, 27 February 2014 8:03 PM To: ozDotNet Subject: RE: Favicons There's always http://ie.microsoft.com/testdrive/Browser/IconEditor/Default.html http://ie.microsoft.com/testdrive/Browser/IconEditor/Default.html as well - online icon editor/creator. Cheers Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 Mob +61 (416) 134 993 Fax: +61 (2) 9870 2400 http://blogs.msdn.com/acoat http://blogs.msdn.com/acoat Sent from the http://office.com/preview new Office From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Thursday, 27 February 2014 7:52 PM To: ozDotNet Subject: Re: Favicons IcoFX Looks like the ticket. Thanks, will check it out. :) On Thu, Feb 27, 2014 at 4:35 PM, Geoff Appleby geoff.appl...@gmail.com mailto:geoff.appl...@gmail.com wrote: +1 IcoFX. Haven't needed to use it in a couple of years but it's simple but powerful. On Thu, Feb 27, 2014 at 7:24 PM, Joseph Cooney joseph.coo...@gmail.com mailto:joseph.coo...@gmail.com wrote: Iconfx or icofx (can't quite recall the name) was open source until recently and there are free versions still around. I think the gimp can make windows icons too. Joseph On Feb 27, 2014 4:55 PM, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: Ok thanks. New can of worms. ;) It seems to be working (on a different computer atm) but when I dragged it to the taskbar (how you can pin a website) it shows a large version of the default one. I think I need to add those multiple sizes to the ico. If I edit my current one in VS it shows the small one but not alternate sizes (like how the default one does...) Which leads me to a new question, what's the best (easiest/cheapest) way to import images into an ico file. Any freebie ICO editors about? I don't fancy doing it by hand in Visual Studio. Hmm I wonder if VS has an import image in its editor? Not looked before... On Thu, Feb 27, 2014 at 2:30 PM, Ken Schaefer k...@adopenstatic.com mailto:k...@adopenstatic.com wrote: From memory, if IE fails to find a favicon.ico file in the past, it doesn't ask for one again (basically, why generate another request that will result in a 404?) Not sure what the timeout period is, but if you bookmark the site/add to favourites, it makes another request for favicon.ico. Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Stephen Price Sent: Thursday, 27 February 2014 3:19 PM To: ozDotNet Subject: Re: Favicons Oh ok... I cleared the cache. I could see it with Chrome but not IE. Not sure what's up with that. Cached somewhere as you say but clearing the cache vis F12 dev tool menu didn't seem to help. Maybe need to close browser entirely. I added the route then took it out... so not sure if your screenshot was with or without. I think I'll add it back in and do some more testing. Looking with fiddler, it's not that its failing to download/find the favicon.ico file, it looks more like the browser isn't even asking for it. (IE11) thanks for the help. On Thu, Feb 27, 2014 at 12:07 PM, Fredericks, Chris chris.frederi...@hp.com mailto:chris.frederi...@hp.com wrote: It may be local to you, a cached page somewhere. The icon is showing in IE11 on my desktop and in IE8 and Chrome 33.0 on my laptop: -- Geoff Appleby Facebook: http://www.facebook.com/geoff.appleby image001.png
RE: Advice to Microsoft (not mine - the IT press and developer blogosphere)
Isn't it all just perspective ? All other languages are just wrappers around machine code anyway. :) Resistance is futile Any problem in computing can be solved by another layer of abstraction. And any performance problem in computing can be solved by removing one layer of abstraction. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Scott Barnes Sent: Friday, 14 February 2014 11:42 AM To: ozDotNet Subject: Re: Advice to Microsoft (not mine - the IT press and developer blogosphere) David: I think the words your seeking are JavaScript Stockholm Syndrome .. I object strongly to a language who's surrounded by frameworks that are hell bent on abstracting developers from the said language as much as possible because the said language is so far behind the evolution curve. Had JS moved to ECMA4 - ECMA6 ..sure.. i'll play along but this JS ciricle jerk that's going on because everyone's given the defeatist attitude... bleh... And yes, I will concede I see my future with me standing on the roadside way WILL CODE JS FOR CRACK... --- Regards, Scott Barnes http://www.riagenic.com On Fri, Feb 14, 2014 at 9:23 AM, David Connors da...@connors.com mailto:da...@connors.com wrote: On Fri, Feb 14, 2014 at 8:42 AM, Scott Barnes scott.bar...@gmail.com mailto:scott.bar...@gmail.com wrote: better, faster? O.o... did you just say JavaScript is better than WPF? . I said 'someone's 10kb of JS is better. JavaScript is just Internet assembly language. It's the frameworks that matter. I used to hate JS with a passion, but the momentum around it is undeniable and the things people accomplish with frameworks on top of it are staggering. David Connors mailto:da...@connors.com da...@connors.com | M +61 417 189 363 tel:%2B61%20417%20189%20363 Download my v-card: https://www.codify.com/cards/davidconnors Follow me on Twitter: https://www.twitter.com/davidconnors Connect with me on LinkedIn: http://au.linkedin.com/in/davidjohnconnors
RE: Advice to Microsoft (not mine - the IT press and developer blogosphere)
Yeah, I was limiting it to the level of the microprocessor. No interest in actually building or coding inside there nowadays. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Craig van Nieuwkerk Sent: Friday, 14 February 2014 1:11 PM To: ozDotNet Subject: Re: Advice to Microsoft (not mine - the IT press and developer blogosphere) Where's my soldering iron... On Fri, Feb 14, 2014 at 1:04 PM, Preet Sangha preetsan...@gmail.com mailto:preetsan...@gmail.com wrote: Greg. All machine languages are just wrappers for microcode Preet On 14 February 2014 14:00, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Isn’t it all just perspective ? All other languages are just wrappers around machine code anyway. :) “Resistance is futile” “Any problem in computing can be solved by another layer of abstraction. And any performance problem in computing can be solved by removing one layer of abstraction.” Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Scott Barnes Sent: Friday, 14 February 2014 11:42 AM To: ozDotNet Subject: Re: Advice to Microsoft (not mine - the IT press and developer blogosphere) David: I think the words your seeking are JavaScript Stockholm Syndrome .. I object strongly to a language who's surrounded by frameworks that are hell bent on abstracting developers from the said language as much as possible because the said language is so far behind the evolution curve. Had JS moved to ECMA4 - ECMA6 ..sure.. i'll play along but this JS ciricle jerk that's going on because everyone's given the defeatist attitude... bleh... And yes, I will concede I see my future with me standing on the roadside way WILL CODE JS FOR CRACK... --- Regards, Scott Barnes http://www.riagenic.com On Fri, Feb 14, 2014 at 9:23 AM, David Connors da...@connors.com mailto:da...@connors.com wrote: On Fri, Feb 14, 2014 at 8:42 AM, Scott Barnes scott.bar...@gmail.com mailto:scott.bar...@gmail.com wrote: better, faster? O.o... did you just say JavaScript is better than WPF? . I said 'someone's 10kb of JS is better. JavaScript is just Internet assembly language. It's the frameworks that matter. I used to hate JS with a passion, but the momentum around it is undeniable and the things people accomplish with frameworks on top of it are staggering. David Connors mailto:da...@connors.com da...@connors.com | M +61 417 189 363 tel:%2B61%20417%20189%20363 Download my v-card: https://www.codify.com/cards/davidconnors Follow me on Twitter: https://www.twitter.com/davidconnors Connect with me on LinkedIn: http://au.linkedin.com/in/davidjohnconnors -- regards, Preet, Overlooking the Ocean, Auckland image001.gif
Video bumpers
Hi Folks, Anyone got a recommendation for someone to generate good branded video bumpers? (ie: first 5-10 sec and last 5 sec of videos) 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
RE: Video bumpers
Hi Anthony, They are the short videos that wrap around professional content. Like a 5 to 10 second intro and a few seconds of trailer after a video. Here's a stock example of an intro: http://www.videoblocks.com/videos/details/particle-swirl-after-effects-temp late/ http://www.videoblocks.com/videos/details/particle-swirl-after-effects-templ ate/ 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 From: anthonyatsmall...@mail.com [mailto:anthonyatsmall...@mail.com] Sent: Wednesday, 12 February 2014 3:01 PM To: GregAtGregLowDotCom; 'ozDotNet' Subject: RE: Video bumpers Excuse my ignorance but what is a video bumper? Anthony Salerno | Consultant | SmallBiz Australia Software Developers | Mobile | Tablet | Software | Web | eCommerce | IT Support Phone : +613 8400 4191 Email : 2Anthony (at) smallbiz.com.au Postal : Po Box 135, Lower Plenty 3093 ABN : 16 079 706 737 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, 12 February 2014 2:33 PM To: ozDotNet Subject: Video bumpers Hi Folks, Anyone got a recommendation for someone to generate good branded video bumpers? (ie: first 5-10 sec and last 5 sec of videos) 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
Google Chromecast
Hi Folks, Just to follow up about the Win8.1/DLNA/Miracast, etc. discussion the other week. I spent so many hours trying to make that stuff work. The Google Chromecast devices arrived today. Slotted straight into the back of the TVs, with a short USB cable to get power from a USB port on the back of the TV too. 10 minutes later they were both installed, working and so neat and tidy. Awesome! Thanks for the recommendation. And well done Google! 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
RE: Google Chromecast
Yep, depends what media and which apps. If all you want to do is stream video content from your PC, anything I can open in Chrome just plays. (That includes all the video files from the local filesystem that I've tried to stream). For apps that understand Chromecast, it's a better experience. For example, if I open YouTube, it has a Chromecast button that appears, lets you pick which Chromecast device, then plays it pretty much full screen with nice looking headers, etc. Same deal from iOS apps. There are a few that already understand Chromecast. Any of those just stream easily. From what I've seen, this is pretty painless. I really can see this catching on. I thought AppleTV was pretty slick but I've had some issues with AirPlay. This is even more slick and seems more reliable on my short testing. It's interesting to see that there's already an ecosystem building around it. For example, you can design themes for it. On the Google site, there are a bunch of themes that Google has produced, and a bunch that designers and artists have created. Here's an example: https://chrome.google.com/webstore/category/theme/48-by-artists?utm_campaign =en https://chrome.google.com/webstore/category/theme/48-by-artists?utm_campaig n=enutm_source=en-et-na-us-oc-themesutm_medium=et utm_source=en-et-na-us-oc-themesutm_medium=et 99% of the time, I'm just wanting to watch technical mp4's that I've downloaded, on one of the TVs in the house. For that, this is perfect. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Tuesday, 11 February 2014 1:13 PM To: ozDotNet Subject: RE: Google Chromecast So, are you able to play media from your laptop to the Chromecast device? I couldn't work out if that was possible from the interwebs. Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (gregATgreglowDOTcom) Sent: Tuesday, 11 February 2014 1:59 PM To: ozDotNet Subject: Google Chromecast Hi Folks, Just to follow up about the Win8.1/DLNA/Miracast, etc. discussion the other week. I spent so many hours trying to make that stuff work. The Google Chromecast devices arrived today. Slotted straight into the back of the TVs, with a short USB cable to get power from a USB port on the back of the TV too. 10 minutes later they were both installed, working and so neat and tidy. Awesome! Thanks for the recommendation. And well done Google! 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
RE: DLNA access from Windows 8.1
Magic thanks David. That looks like the answer. I was trying to avoid having yet another device there but they look so neat. I’ve ordered a couple of them. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Connors Sent: Tuesday, 28 January 2014 6:47 PM To: ozDotNet Subject: Re: DLNA access from Windows 8.1 On Tue, Jan 28, 2014 at 5:30 PM, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: I can right click a movie or whatever and select play to for my Xbox One. Not sure if my Samsung TV shows up but I don't have it plugged in, its essentially a dumb terminal for all the other devices. On that note its the only way I can play movies from my local network on my Xbox One. There's no way to browse the local network with my XBox One. Its majorly crippled. Its easier to play stuff off the Internet than it is from my own network. I tend to use my Gigabyte media center for movies. Rather dissapointing when your newer console is less capable than your older one(s). Progress right? :( Miracast with my Dell Venue 8 is a fail but that's due to my TV not supporting it. Yay for standards... Bleeding edge technology Since finding DIaL (http://en.wikipedia.org/wiki/DIscovery_And_Launch), DLNA is dead to me. I got a mate in the US to send over a bunch of ChromeCasts and it is the way forward. $35 per first screen and you use 'whatever' phone/tablet/app to tell it to download content. Sure as hell beats the brain dead UX on my Bravia for finding media as the device you send commands from is anything and disconnected from the source and destination of the streaming. It is so frickin simple and widely supported from second screen apps on android/ios. Latest release also supports Plex for local media. YMMV. David.
DLNA access from Windows 8.1
Hi Folks, Has anyone been using DLNA from Windows 8.1 successfully? I went into Control Panel, enabled the Media Streaming options for the correct file types. It showed two Bravia TVs correctly and I enabled access for them. I checked that the WMPNetworkSvc service is running. There also seems to be a firewall exception for it. Even though Win8.1 could see the TVs, neither of them seems to find the Win8.1 machine when searching for servers. I presumed that would be a firewall issue but identical problem when I disabled the firewall during testing. Any clues? The other option would have been to use the PlayTo stuff in Windows 8.1 but even the latest software update for recent Bravia's doesn't come up as Windows Certified. I even tried the registry hack to enable non-certified devices but that didn't work either. It then shows the TVs but complains it needs a WPS PIN. Of course when I looked that up, even though Sony's ads say they support Miracast, their support site explains that their version of Miracast only works from two specific Sony client devices: sigh After spending a couple of hours trying to make this work, I have yet another new found appreciation for Apple's AirPlay, even with its warts. I was running in 5 minutes with that: 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
RE: Windows Internals 6th edition
Aren't those links just to rip-off sites? I notice that the books are still available for purchase elsewhere. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Preet Sangha Sent: Thursday, 16 January 2014 11:59 AM To: ozDotNet Subject: Re: Windows Internals 6th edition Wow I'm still digesting the Vista one :-) On 16 January 2014 14:21, Greg Keogh g...@mira.net mailto:g...@mira.net wrote: Folks, just FYI - I had two books just arrive by courier: Windows Internals Part-1 http://shop.oreilly.com/product/0790145305930.do and Windows Internals Part-2 http://shop.oreilly.com/product/0790145344403.do I had no idea until I looked just now, but both books are available as PDFs from Here http://www.google.com.au/url?sa=trct=jq=esrc=ssource=webcd=5cad=rjav ed=0CDsQFjAEurl=http%3A%2F%2Fafis.ucc.ie%2Ftbutler%2FWindows%2520Internals% 2520Part%25201%2520(6th%2520Edition).pdfei=Yy3XUsL8JoiWkgWzyYDACAusg=AFQjC NFenBrFZXnciZ7BiZAx9rnTwchwugsig2=7YKclXJIyU7Yvg8G9JiJ3wbvm=bv.59568121,d. dGI (25MB) and Here http://www.google.com.au/url?sa=trct=jq=esrc=ssource=webcd=2cad=rjav ed=0CC4QFjABurl=http%3A%2F%2Fgegeek.com%2Fdocuments%2FeBooks%2FWindows%2520 Internals%2520Part%25202_6th%2520Edition.pdfei=Yy3XUsL8JoiWkgWzyYDACAusg=A FQjCNFqPokfhKGj35ckpn6BTj-LhVJT5Qsig2=lxdn9VY-cYfQP8sVkjHuTQbvm=bv.5956812 1,d.dGI (22MB). I've been flipping through the books and all I can think of is what Homer Simpson said when he opened his operator manual looking for a way of averting a meltdown: Who could have thought a nuclear reactor would be so complicated. There's so much detailed information in these books that I reckon you could write Windows from them. The tables of contents of the books give you an idea of how technical and geeky they are. The text is dense with lots of nice diagrams but it's all very neatly organised and from my 15 minutes of flipping through it looks very readable. The Security chapter is one of the fattest, so that'll be interesting reading. I highly recommend these books for anyone who likes getting down close to the wire. Greg K -- regards, Preet, Overlooking the Ocean, Auckland
RE: Recommendations for ASP.Net MVC book
+1 In particular, I found K Scott Allen's videos from Pluralsight excellent. (Same for his CSS3 videos) 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Burstin Sent: Sunday, 5 January 2014 10:44 AM To: ozDotNet Subject: Re: Recommendations for ASP.Net MVC book If you are happy to watch videos instead, I would highly recommend the pluralsight courses. There are many on mvc and you are sure to find at least one that meets your needs. Sent from my flux capacitor. Please excuse brevity and any odd autocorrect errors. On 05/01/2014 9:58 AM, Iain Carlin cut...@gmail.com mailto:cut...@gmail.com wrote: Happy New Year all, I've resisted MVC for too long and have decided to update my knowledge from ASP.Net forms. I think the question may have been asked before but I can't find it in the archives, can anyone recommend a good book on the subject for someone who already knows ASP.Net pretty well but wants to start dabbling in MVC? Cheers, Iain
RE: NBN Petition
What devices will be needed for the 700MHz network? At present, I find Telstra’s 4G network around the country nearly works as well as their 3G network was in the early days. The 3G network is basically unusable in many locations. The worst contention I’ve found is around Collins St in Melbourne. It’s not uncommon to have 5 bars of connectivity and yet to be unable to resolve a DNS address (let alone connect to a site) from about 7:30AM to around 5:30PM. I remember discussing this “performance” with the Telstra “support” people. I was at Brisbane airport and ping times were 3000 ms (yep 3 seconds). He told me that the system was considered working if: * Less than half the packets were lost * The packets ever came back (no matter how long the delay was) Mentioning that my dial-up modem used to have a ping time of 30ms to 100ms fell on deaf ears. They seem to have enough funds to place huge adverts in the same airports though, where they endlessly make claims about having a fast network. The fastest NextG connectivity I’ve had in Australia was on King Island in the middle of Bass Strait. They have a NextG tower and I suspect that hardly anyone else was using it. What does annoy me is how they balance the quality of service settings. I can have a 4G iPhone sitting beside the 4G USB modem. The phone is still moving data but the modem isn’t, even though the modem is on a far more expensive data plan. Clearly they’ve decided that people that can’t use data on their phones will scream at them more than people paying a bunch of money to use a modem. The push is always to the lowest cost. I’m sure, however, that lots of business people would pay higher monthly rates for a service that actually worked. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Connors Sent: Tuesday, 31 December 2013 1:05 PM To: ozDotNet Subject: Re: NBN Petition It is great that you managed to get it sorted - I'd always thought it was an artificial/market segmentation thing by T to now cannibalise EoC/fibre business services. In other interesting Internet related news, the last of analogue TV gets turned off when we tick over to 1 Jan 2014. The end of 2014 and 1 Jan 2015 see the licenses commence for 2.5GHz and 700MHz respectively. It is going to be really interesting to see this play out. The performance of Telstra's LTE-A network @ 7xxMHz will be exceptional. I bought one of those new Telstra 4G/WiFi hotspots the other day to throw in my backpack: 99.58mbps down and 45mbps up (http://www.speedtest.net/my-result/3195768480). David Connors mailto:da...@connors.com da...@connors.com | M +61 417 189 363 Download my v-card: https://www.codify.com/cards/davidconnors Follow me on Twitter: https://www.twitter.com/davidconnors Connect with me on LinkedIn: http://au.linkedin.com/in/davidjohnconnors snip
RE: creating entities from rows instead of columns
Hi Kirsten, Do you just mean something like: SELECT PropertyType, MAX(CASE WHEN Attribute = 'Name' THEN Value END) AS Name, MAX(CASE WHEN Attribute = 'Age' THEN Value END) AS Age, MAX(CASE WHEN Attribute = 'Haircolour' THEN Value END) AS Haircolour FROM dbo.Properties GROUP BY PropertyType; 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Kirsten Greed Sent: Monday, 16 December 2013 10:00 AM To: 'ozDotNet' Subject: creating entities from rows instead of columns Hi All I have a table called Properties with fields PropertyName nVarchar(80) PropertyValue nVarchar(max) PropertyType int I want to be able to create an entity from it, similar to the way Entity Framework creates entities from table definitions. Are there any tools out there to do this? Thanks Kirsten
RE: NBN Petition
It’s not even an issue of whether or not the cable goes down your street. It goes down our street and we had to go to extraordinary lengths to get them to connect to our unit as it wasn’t the first one off the street. Unit 3 behind us was unable to get cable at all. The Telstra guy that hooked us up lives further up the street. He’s the one that agreed to connect us. He also told us that there were limited numbers of cable ports in the street, and we’d just taken the last one. Mind you, I’ve also spent ages talking to Telstra about why you could only have a 30meg connection under a business name but you can change to the Ultimate plan (100meg) if it’s a residential account. After an eternity discussing it with them (which mostly related to them having two internal systems and the second one not being intended for business), I finally got on to an accounting guy that told me that everything I’d been told to that point was nonsense as he’d set up lots of business accounts in the new system. He said he’d just arrange to have it migrated to the new system, and when that’s done, the 100meg service would then be available. I hope he’s right. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Friday, 13 December 2013 5:02 PM To: 'ozDotNet' Subject: RE: NBN Petition It looks like Renai Lemay, publisher of delimeter.com.au, seen as a major proponent of the Liberal version of the NBN has come out with a scathing rejection of the new NBN http://delimiter.com.au/2013/12/12/please-accept-apologies-wrong-turnbull/ One of the biggest issues is that anyone that is currently in a cable area will not get access to the NBN. Full stop. That means if Optus and Telstra went down one street and skipped your street, then because you’re in the cable “block”, you don’t get it. http://delimiter.com.au/2013/12/12/nbn-co-abandons-fttn-rollout-hfc-areas/ No competition to cable? Rupert gets his way after all. It also means I don’t get NBN – and I’m only 150 metres away from the NBN. I was told before the election that I would be able to connect if I paid $3000. Not true now. T. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Joseph Cooney Sent: Friday, 13 December 2013 9:00 AM To: ozDotNet Subject: RE: NBN Petition You're lucky to have a telecommunications infrastructure economics analyst in the family to advise you on these matters. On Dec 13, 2013 7:57 AM, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: It’s actually worse than that Ken. My brother has just gone through the strategic review and done a like for like comparison. To make the two reviews comparable, he applied the same contingency to FTTP that Malcolm’s review applied to FTTN (10% instead of 20%.) There is no justification for different contingency levels, given that there is no FTTN experience as yet. In fact, for the same reason, FTTN should have a higher contingency and not the other way round. Doing that, the cost of FTTP drops to $58 billion dollars. Secondly, he took the HFC serviced premises out for a true like for like comparison. This dropped the FTTP price by around $15 to $20 billion. $58 billion - $15 billion = $43 billion. Or, roughly the cost of the FTTN! It seems strange, does it not, that a direct comparison was not made? From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Ken Schaefer Sent: Thursday, 12 December 2013 9:19 PM To: ozDotNet Subject: RE: NBN Petition That’s in the Strategic Review (as a scenario on page 100). How will that 1gbps be delivered? By replacing everything with FTTP. Apparently the cost of that will be $4bn (in NPV terms) than doing it right now. Every upgrade scenario on that page calls for replacing substantial chunks of the current proposal with new stuff. Effectively meaning most of what Turnbull’s proposing today will simply be temporary. Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Thursday, 12 December 2013 5:36 PM To: g...@greglow.com mailto:g...@greglow.com ; 'ozDotNet' Subject: RE: NBN Petition Come on, Malcolm has promised you 1Gbps by 2030, what more could you want? (Meanwhile, my bro’ should be enjoying his 1Gbps early next year, unless they decide to crush that delivery for political reasons.) From: GregAtGregLowDotCom [mailto:g...@greglow.com] Sent: Thursday, 12 December 2013 5:14 PM To: 'Tony Wright'; 'ozDotNet' Subject: RE
RE: NBN Petition
They are only at a handful of locations for FTTP. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com Sent: Tuesday, 10 December 2013 9:35 PM To: 'ozDotNet' Subject: RE: NBN Petition Not sure if anyone is aware or already using it..but i do not have NBN but found that a company called opticomm can install fibre and an ISP like internode can give you speeds of 40MBS/20MBS connection... i'm disconnecting my Telstra low performance line for the same cost but fibre speeds. No could tell me this was possible till i found another business had fibre. I'm in Bundoora BTW From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Saturday, 7 December 2013 6:19 PM To: David Connors; ozDotNet Subject: Re: NBN Petition If anyone is interested, The Age has an article that talks about how they are moving to 1GB on the NBN: http://www.theage.com.au/it-pro/one-gigabit-available-on-nbn-this-month-2013 1206-hv4pg.html In the article it states that the cost of a CVC connection is $20,000, but that it is likely to be shared between 3000 connections. So the total cost, if the ISP gets full take up, is $6.66 per connection. ($20,000 / 3000 = $6.66) So the full wholesale cost in this scenario would be $150 + $6.66 = $156.66. This makes the $200 for 1GB possible, however it will probably be somewhere between $200 per month and $300 per month. It is also likely that the ISPs will not have to pay CVC until a higher number of connections is achieved during the setup period. So $20,000 or $6.66. You just have to decide which one is more plausible. I guess we'll see when the ISPs start offering 1GBps connections, which could be quite soon. On Tue, Nov 12, 2013 at 9:36 PM, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: Its quite simple really. The whole premise of CVC being delivered to 93% of the population is bogus and deceptive. This is the statement that was suggested. The statement was factually correct but based on a complete lie. Sent from my Windows Phone _ From: David Connors Sent: 12/11/2013 8:38 PM To: ozDotNet Subject: Re: NBN Petition On 12 November 2013 17:50, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: (Mind you, this is what is supposed to be in the NBN plan - The NBNCo Corporate Plan contains these examples on page 67: * The 1Gbps AVC price will fall from $150 to $90 (40% decrease) while the average speed increases from 30Mbps to 230Mbps (760% increase) * CVC pricing starts at $20Mbps/month when average data usage is 30GB/month and falls to $8/Mbps/month when average data usage is 540GB/month. Price falls by 2.5 times, while the average data usage grows by 18 times, which means 720% growth in revenue from CVC when accounting for price falls. ) Are you talking about this: http://www.nbnco.com.au/content/dam/nbnco/documents/nbn-co-corporate-plan-6- aug-2012.pdf ? Page 67 says nothing of the sort. I *think* what they're saying is that they are factoring in the 'no charge until 30001st premise in an area gets installed' as a form of discount, which is pretty rubbery accounting. To put page 67 in laymans terms, the first 150mbps of capacity in the service area (keeping in mind that might be 70,000+ premises) is free. I believe I read in the draft NBN document that they were intending the wholesale price to be $150 per month for a 1Gbps FTTH connection in Australia. So the least deceptive answer is that you could have a 1Gbps connection for $150 per month plus the cost of the ISP service. Nope. $150 of AVC + the ISP Service + CVC. Even if the price of CVC dropped to $8/mbps/month, then that would still be 800% higher than the forecasted cost of getting data from Europe to Australia next year. i.e. 1mbps CIR from overseas to Brisbane = $1, getting it across Brisbane, $8. FAIL. They didn't broadcast the fact because they assumed that everyone would expect the same behaviour that they are getting from just about every single internet connection in the country at the moment, and that is, you are likely to get speeds of 1Gbps from your ISP and then you'll share a pipe to the rest of the net with the other customers of the ISP. I have to admit, you're the first advocate for CVC I've ever met. Once explained to most people they are mortified. No one expects the NBN to deliver ANYTHING like what they are getting today ... otherwise they would not advocate for the $ spend. Given that FTTN is going to suffer the exact same issue, do you think Malcolm Turnbull is going to stand on a podium and declare that there is also
RE: NBN Petition
Thanks for the update Ken. Haven't read it yet but will do so. I'd love to see FTTP done if it can be rolled out in a commercial way, with commercial timeframes. The previous plan sounded nice but didn't look like it'd happen in my working lifetime so it was irrelevant to me anyway: It'd be great if the community just told them to make it happen but in a commercial way. The previous plan seemed highly political. It was being rolled out in areas that were politically interesting, not commercially interesting. Our street has had 30 gig cable for ages, 100 gig available if you can negotiate the Telstra puzzle. If they ran fibre down the street, a significant percentage of people would sign up and make good use of it. But our existing service is what doomed us to never having the new one based on the previous plan. A commercial focus would see us cabled up quickly, as we'd be both cheap to cable, and have a large take-up. If I could pay $5k and have a 1gig connection tomorrow, I'd happily pay for it tomorrow. Previously they seemed to insist on rolling it out into areas that have no existing use for it, and little interest in connecting. That's not been a commercial decision. 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 From: Ken Schaefer [mailto:k...@adopenstatic.com] Sent: Thursday, 12 December 2013 2:48 PM To: GregAtGregLowDotCom; ozDotNet Subject: RE: NBN Petition Well, Turnbull's strategic review is out. And whilst we're all likely to get the rubbish mixed-technology mix option (some FTTP, some FTTN and some HFC) due to the headline cost of building the network, the NPV savings over FTTP are miniscule once we factor in the need to upgrade to something else later. By going down the cr*p up to 25mbps we're now being promised, we save a whole $2bn if we then decide to go to 100mbps, $5bn if we decide to go to 250mbps, and $4bn if we decide to go to 1gbps. The numbers are on p100, right in Turnbull's own review. For such small savings, just build the FTTP now, and avoid crippling vast portions of community for the next 17 years. Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, 11 December 2013 7:41 PM To: 'ozDotNet' Subject: RE: NBN Petition They are only at a handful of locations for FTTP. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com Sent: Tuesday, 10 December 2013 9:35 PM To: 'ozDotNet' Subject: RE: NBN Petition Not sure if anyone is aware or already using it..but i do not have NBN but found that a company called opticomm can install fibre and an ISP like internode can give you speeds of 40MBS/20MBS connection... i'm disconnecting my Telstra low performance line for the same cost but fibre speeds. No could tell me this was possible till i found another business had fibre. I'm in Bundoora BTW From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Saturday, 7 December 2013 6:19 PM To: David Connors; ozDotNet Subject: Re: NBN Petition If anyone is interested, The Age has an article that talks about how they are moving to 1GB on the NBN: http://www.theage.com.au/it-pro/one-gigabit-available-on-nbn-this-month-2013 1206-hv4pg.html In the article it states that the cost of a CVC connection is $20,000, but that it is likely to be shared between 3000 connections. So the total cost, if the ISP gets full take up, is $6.66 per connection. ($20,000 / 3000 = $6.66) So the full wholesale cost in this scenario would be $150 + $6.66 = $156.66. This makes the $200 for 1GB possible, however it will probably be somewhere between $200 per month and $300 per month. It is also likely that the ISPs will not have to pay CVC until a higher number of connections is achieved during the setup period. So $20,000 or $6.66. You just have to decide which one is more plausible. I guess we'll see when the ISPs start offering 1GBps connections, which could be quite soon. On Tue, Nov 12, 2013 at 9:36 PM, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: Its quite simple really. The whole premise of CVC being delivered to 93% of the population is bogus and deceptive. This is the statement that was suggested. The statement was factually correct but based on a complete lie. Sent from my Windows Phone _ From
RE: NBN Petition
Hi Ken, There are lots of these sorts of infrastructure projects that I'd like to see completed but yes I do have an interest in completion dates, if I'm expected to help fund it. I do have an interest in my kids being able to use it but I can't see any reason why it couldn't be done sooner in areas that have an interest in paying for it. If you were trying to run a commercial business based on rolling out an NBN, where would you start? Would it really be the back of Ballarat and Tamworth or would you roll it out in high-density areas in Sydney/Melbourne that are already screaming for it? A political or public service might do the former when they are spending other peoples' money. A business would do the latter. High speed rail is another one. While I might show some interest in that, when they're talking 2060 or so for the first train, I have only passing interest in it. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Thursday, 12 December 2013 4:12 PM To: ozDotNet Subject: RE: NBN Petition From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Thursday, 12 December 2013 3:51 PM To: ozDotNet Subject: RE: NBN Petition not going to be there in my working life might not be the words you're looking for but the point is that it was going to take such a long time as to nearly be irrelevant to me. OK - are you only planning to be alive for the next 10 years? If you're planning to be alive for more than 10 years, the I don't see how it can be irrelevant. Because a project like this will change the way everyone else (people and business) are going to be doing things. And if you have kids, or your siblings have kids, well then you might want to start caring, because it will have a change on the way they live their lives too. Your attitude is similar to saying we don't have to worry about climate change, because it won't have a significant impact in my lifetime. Sure. But you might be f*cking up the lives of the next generation by not caring, and from a civics PoV, I'd like to think that intelligent human beings would take an interest in things where their actions (or lack of such) today, are going to potentially have a significant impact down the track. Putting this off because they take a long time is simply a recipe for never doing anything significant. My key point is that if you were rolling this out on a commercial basis, you wouldn't do it the way they were doing it. How do you know they aren't? A commercial organisation would be looking to quickly generate income from areas that want it. Surely revenue is one side of a double-sided coin? You need to look at costs as well. For example, I can understand prioritising new greenfields sites - because the alternative is laying copper now, and then replacing it with fibre in the next 5-10 years. That would dramatically increase costs. Some of the more commercially lucrative sites (e.g. inner city Sydney/Melbourne) might also be some of the most costly to implement, due to older buildings, records and facilities. I agree that some of this is politically driven, but as I said before, there is going to have to be some level of compromise. Cheers Ken
RE: NBN Petition
I love the idea of the country building infrastructure. It's the speed of public projects here that concerns me. For example, we've been talking about high-speed rail for how long? China started planning in the early 1990's and by 2015 looks like they will have completed 18,000 km of high-speed rail. We're talking about a project (Brisbane to Melbourne via Sydney and Canberra) of what? About 1700km ? And first train to run in the 2060's? Clearly we have a different situation to them but is that really the best we can do? Have it finished in time to probably made obsolete by some other technology? I've travelled on quite a few high-speed rail systems but it's hard to imagine that many of them were planned 60 or so years ago. Mind you, it would still beat the Redcliffe rail link in Brisbane. At least the current QLD govt has let a project that should see it being complete in 2016. Given it was first gazetted in QLD parliament in 1895 (no typo there), that's been quite a project. 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 From: Tony Wright [mailto:tonyw...@gmail.com] Sent: Thursday, 12 December 2013 5:01 PM To: 'ozDotNet'; GregAtGregLowDotCom Subject: RE: NBN Petition Of course, I'm interested in why they are so interested in building non-productive infrastructure, such as roads, that we spend, maybe 1 hour a day on, yet we often spend 8+ hours of our time, many of them productive (for some of us, anyway), on computers, yet they won't invest in a productive venture. One makes a profit for the country and is in need of an upgrade (NBN/Internet). The other is generally good enough and throwing more money at it isn't going to give us much of a return and certainly not foreign money (Roads). From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Thursday, 12 December 2013 4:51 PM To: g...@greglow.com mailto:g...@greglow.com ; ozDotNet Subject: RE: NBN Petition From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Thursday, 12 December 2013 4:38 PM To: ozDotNet Subject: RE: NBN Petition If you were trying to run a commercial business based on rolling out an NBN, where would you start? Would it really be the back of Ballarat and Tamworth or would you roll it out in high-density areas in Sydney/Melbourne that are already screaming for it? A political or public service might do the former when they are spending other peoples' money. A business would do the latter. I guess it would depend on a lot of things. I'm not an expert on rolling out telecoms infrastructure, but I guess I'd need to ensure that I had good information and processes first, so starting in less complex areas might make sense. Secondly, I guess it isn't cheap cabling older apartment blocks in inner-city Sydney - they were built in the 1920s through 1970s, and probably have no Ethernet cabling in the building. The cost of retrofitting these buildings even just for HFC has meant that the majority aren't connected. If I was also mandated to cover everyone in the country, then I'd be covering all the new greenfields sites, so that they aren't reworked. From what I understand, it isn't just sites in Tamworth that are being covered, but some in metropolitan areas as well. I guess, if this was a commercial operation, it would be done differently. But I don't know the whole picture (and I doubt you do either). And as I said before, we may have to accept some compromises. If each one of us had our own caveats on providing our support for this project based on implementation details, nothing would be done. You're insisting on more commercial savvy, and the next person will insist that the priority should be those people who don't have access to any comparable technology (i.e. all those on RIMs and pair-gain and whatnot that can't get ADSL2/ADSL today) Cheers Ken
RE: [OT] Facebook advertising
I've always thought the sage advice was: If the service is free, then YOU are the product. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Sunday, 1 December 2013 2:21 PM To: ozDotNet Subject: Re: [OT] Facebook advertising No, it's a security and privacy issue. I refuse to change the way I think about something corrupt, greedy, invasive and opportunist, and so should you. On 1 December 2013 10:57, Stephen Price step...@perthprojects.com mailto:step...@perthprojects.com wrote: Its called targeted advertising. If you don't want to see ads, the use an ad blocker, or don't use the internet. If you don't want them tracking you then don't use search engines. Or don't use the internet. Personally, I want things. If there is something cool out there that I want to buy and i'm happy to give them my money for it, but I don't know it exists, then I want them to tell me about it. That's targeted advertising that I want. If I see an ad for something that i don't want, then they have missed their mark. Advertising is a fine balance between hitting and missing that mark. Blanket advertising is easier and cheaper but more likely to annoy. Targeted advertising that is accurate is more expensive but if accurate enough, then untrusting people will get annoyed. I assert your relationship to money is your problem here. How you think about money and how untrusting you are that people are trying to take your money off you has you feel this way. If you thought there was an abundance of money then why would you care if someone was trying to take your money? On the other hand if you live your life as if there is a shortage of money and you have to protect what you have at all costs, then these ads will look very suspicious to you. Remember money does not exist in the real world. Its a conversation constructed by humans. Do you think your cat gives a flying damn about how much money you have? Do you think your cat gets annoyed at the advertising on your TV? If you don't like something, change it. If you can't change it then change how you think of it. Or get off the internet. ;)
RE: [OT] Email forwarding
I've had a good run with www.dnsmadeeasy.com http://www.dnsmadeeasy.com . For those sorts of dollars, they let me host about 50 domains and I've never had the slightest issue with them over many years. Regards, Greg From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Friday, 29 November 2013 10:22 AM To: ozDotNet Subject: [OT] Email forwarding Hello Friday Folks, For more than 10 years I've had some DNS records maintained by DynDns. Some are free and some are $30/year because they later removed the free service. I just received an email from their sales to tell me that if I want MX wildcard forwarding of email from my five domains it will cost $49.95 per domain per year. Pardon me, but isn't that a lot for such a piddling little facility?! Is anyone here using someone else for DNS that has a better and more reasonable deal? Searches reveal some companies that do hosting and forwarding for free (like https://www.namecheap.com/ https://www.namecheap.com/support/knowledgebase/article.aspx/546 ), but I find that hard to believe and would rather stick to someone reputable for a modest cost. Greg K
RE: [OT] Public SQL Server [answer found]
Hi Greg, Back in the dreamtime, you could only have a single copy of SQL Server installed on a computer. When SQL Server 2000 appeared, they provided the ability to install additional copies (ie: named instances) of SQL Server in addition to the default instance. At the time, you could have 16 of them, now you can have 50 of them. When you connect just using the name of your computer, you are connecting to port 1433 for the default instance. Using an unmodified installation, SQL Express installs itself as a named instance called SQLEXPRESS, so instead of connecting to mycomputer you would connect to mycomputer\SQLEXPRESS. You could also use the shared memory provider by connecting to .\SQLEXPRESS or (local)\SQLEXPRESS. You can install Express as a default instance but that won't be what you will have done. You will have installed it as a named instance called SQLEXPRESS. The default for named instances is that they use dynamic ports. That's why you will have seen 0 in the port settings in SQL Configuration Manager. When you connect to somecomputer\someinstance, your client starts by having a UDP based discussion (on port 1434) with the SQL Browser service. That service returns details of the port that the instance you mentioned is currently listening on. Your client then connects to that port. Named instances can, however, be configured to use fixed ports. What it sounds like you have now configured, is that you have a named instance configured for port 1433. While that's uncommon, there's nothing wrong with it per se. It just means that if you then tried to install a default instance (for example a SQL Server developer edition) using default settings, that install would fail. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Saturday, 23 November 2013 10:03 AM To: ozDotNet Subject: [OT] Public SQL Server [answer found] It's all to do with dynamic and static ports, something I haven't anyone discuss before. http://technet.microsoft.com/en-us/library/ms177440.aspx I deleted the Dynamic Ports 0 and added TCP Port 1433 in all the IP settings. I don't know if all need to be changed, but I haven't got time to debug it all. I hope this change doesn't have any nasty delayed side effects. Greg
RE: [OT] Public SQL Server [answer found]
All good Greg. When you have it set to dynamic, there are a few things you have to do: 1. Make sure that TCP/IP is enabled as a protocol using SQL Configuration Manager. (By default SQLEXPRESS doesn’t want external people connecting). 2. Open 1434 for UDP inbound for the SQL Browser Service in your firewall. 3. Configure your firewall to allow ports that are opened by the SQL Server executable. (That makes the dynamic port be open). Then they just connect to yourmachine\SQLEXPRESS. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Wednesday, 27 November 2013 5:57 PM To: ozDotNet Subject: Re: [OT] Public SQL Server [answer found] Thanks Doctor L, thank makes pretty good sense about the fixed/dynamic ports. It's funny no one mentioned this issue to me before. I don't like having non-standard setups, so I'd actually prefer to leave all the ports the way they were for my SQLExpress instance, but then I don't know how to connect to an instance from the outside world -- Patient K On 27 November 2013 17:25, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Hi Greg, Back in the dreamtime, you could only have a single copy of SQL Server installed on a computer. When SQL Server 2000 appeared, they provided the ability to install additional copies (ie: named instances) of SQL Server in addition to the “default” instance. At the time, you could have 16 of them, now you can have 50 of them. When you connect just using the name of your computer, you are connecting to port 1433 for the default instance. Using an unmodified installation, SQL Express installs itself as a named instance called “SQLEXPRESS”, so instead of connecting to “mycomputer” you would connect to “mycomputer\SQLEXPRESS”. You could also use the shared memory provider by connecting to “.\SQLEXPRESS” or “(local)\SQLEXPRESS”. You can install Express as a “default” instance but that won’t be what you will have done. You will have installed it as a “named instance” called SQLEXPRESS. The default for “named instances” is that they use dynamic ports. That’s why you will have seen 0 in the port settings in SQL Configuration Manager. When you connect to “somecomputer\someinstance”, your client starts by having a UDP based discussion (on port 1434) with the SQL Browser service. That service returns details of the port that the instance you mentioned is currently listening on. Your client then connects to that port. Named instances can, however, be configured to use fixed ports. What it sounds like you have now configured, is that you have a named instance configured for port 1433. While that’s uncommon, there’s nothing wrong with it per se. It just means that if you then tried to install a default instance (for example a SQL Server developer edition) using default settings, that install would fail. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Greg Keogh Sent: Saturday, 23 November 2013 10:03 AM To: ozDotNet Subject: [OT] Public SQL Server [answer found] It's all to do with dynamic and static ports, something I haven't anyone discuss before. http://technet.microsoft.com/en-us/library/ms177440.aspx I deleted the Dynamic Ports 0 and added TCP Port 1433 in all the IP settings. I don't know if all need to be changed, but I haven't got time to debug it all. I hope this change doesn't have any nasty delayed side effects. Greg
Basic MVC4 question on Form Post
Hi Folks, I'm still getting my head around MVC4 bit by bit. A quick question if I can: If I have a form declared: @using (Html.BeginForm(SomeAction, SomeController, FormMethod.Post)) { } I would normally just post it by using an input button set to submit. However, if I don't want to use a button but want to make the form post when someone clicks on some text in a div contained in the form, how do you do that? Do you have to make an onclick for the div execute some java to post the form? If so, how would you select the form using jQuery in this case? (If I code forms myself, I can give them a name but this Html helper doesn't seem to have a name). Thanks! (I'll be back to databases where I know what I'm doing soon :)) Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: SQL Server Management Studio dependencies
Hi Greg, SSMS 2012 runs inside the VS2010 shell. It's probably not surprising that removing VS2010 causes SSMS 2012 problems. I suppose it would be nice if VS2010 had an understanding of all things that used its shell but it doesn't. So running repair on SSMS 2012 would have just put back the components of the VS2010 shell. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Saturday, 2 November 2013 7:46 PM To: ozDotNet Subject: SQL Server Management Studio dependencies Here's a bit of a warning ... Last week I uninstalled VS2010 as it was running alongside VS2012 and it was of no use any more. Tonight I launch SSMS 2012 and it says required components are missing and tells me to reinstall. Web searches produce lots of hits, and suggestions about deleting registry keys are worthless. I ran the SSMS 2012 installer exe again and picked Repair. This miraculously made it work again. I also noticed that the registry keys under SSMS have dozens of references to VS2010 folders. I changed some of the more obvious ones to point to equivalent VS2012 folders, which fixed some other warning popups that I was getting. So basically there is an unholy tangle of dependencies between SSMS and VS versions more subtle than I suspected, so be careful. I look forward to building a brand new machine next Xmas to clear all of the detritus out. I'm always irritated by the way many big products don't uninstall so easily or so cleanly, leaving fragments all over the place. Greg K
RE: I forget, but which API is used to develop against SQL Server, the one that allows people to create alternative interfaces for it.
Hi Katherine, In this case, I think you're referring to SMO. http://technet.microsoft.com/en-us/library/ms162169.aspx 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 Hi all, I was curious about this because I've seen a couple of web products that basically create the Management studio in ASP.net or in some other interface. I forget which of Microsoft's APIs allows for that. There are a couple of open source projects that need to be updated pertaining to this, and one of these days, I'd definitely like to take that on. Can someone remind me which API is possibly being used? I know that it's extensible, or else I wouldn't have seen what does exist out there, no matter how out-of-date.
RE: SQL Server Management Studio dependencies
You can't have SSMS2012 without some aspects of VS2010 as SSMS2012 lives within the VS2010 shell. That's like trying to run a VS2010 add-in without VS2010. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Sunday, 3 November 2013 1:28 PM To: ozDotNet Subject: Re: SQL Server Management Studio dependencies So running repair on SSMS 2012 would have just put back the components of the VS2010 shell. Oh drats! That's the reverse of what I'm trying to do. I've got to figure out how to utterly remove VS2010 (if it's possible). When I finish today's hobby coding I'll run a global search through the registry to try and get clues about which products have their lives entwined with VS2010, then see if it's safe to attempt to untangle them. Greg K
RE: SQL Server Management Studio dependencies
Same logic applies to SSMS2008 and SSMS2008R2 and their dependency on the VS2008 shell. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Sunday, 3 November 2013 3:19 PM To: ozDotNet Subject: RE: SQL Server Management Studio dependencies You can't have SSMS2012 without some aspects of VS2010 as SSMS2012 lives within the VS2010 shell. That's like trying to run a VS2010 add-in without VS2010. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Sunday, 3 November 2013 1:28 PM To: ozDotNet Subject: Re: SQL Server Management Studio dependencies So running repair on SSMS 2012 would have just put back the components of the VS2010 shell. Oh drats! That's the reverse of what I'm trying to do. I've got to figure out how to utterly remove VS2010 (if it's possible). When I finish today's hobby coding I'll run a global search through the registry to try and get clues about which products have their lives entwined with VS2010, then see if it's safe to attempt to untangle them. Greg K
RE: Where to buy Sql Server Enterprise 2012?
Hi Corneliu, You don’t get it from the site. You have to purchase it from one of the licensing distributors. (Example would be Harris Technology but shop around). 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Tuesday, 22 October 2013 12:52 PM To: ozDotNet Subject: Where to buy Sql Server Enterprise 2012? Hi, I need to buy a licence for Sql Server Enterprise 2012. Any idea where I could get it? Microsoft site is a bit confusing. Thanks, Corneliu
RE: MSDN Azure Benefits Aston Martin
Just a final reminder that this comp ends on Monday. 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 From: Greg Low (Old POP Address) [mailto:g...@greglow.com] Sent: Friday, 23 August 2013 5:03 PM To: ozDotNet Subject: MSDN Azure Benefits Aston Martin Hi Folks, The Microsoft folk have asked us to mention this but it seems worth mentioning anyway: Most developers and DBAs have MSDN subscriptions yet they haven't enabled their Azure benefits that come included with the MSDN subscriptions. To encourage people to do it, there's a competition to win an Aston Martin which might be worth a shot. I've put details here: http://sqlblog.com/blogs/greg_low/archive/2013/08/15/are-you-using-the-azure -benefits-in-your-msdn-subscription-like-an-aston-martin.aspx Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: Restricting Data Chnages
You can add a TOP clause into data modification statements to limit how many rows are affected but I suspect that isn't your real issue. The first question that needs to be addressed is why anyone has access that allows doing that in the first place. That's the real problem. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com Sent: Wednesday, 25 September 2013 11:26 AM To: 'ozDotNet' Subject: RE: Restricting Data Chnages Is it possible to restrict the number of records that can be modified in one query? We had a database that had all its records updated by accident ie 30,000 rows..how can we avoid this in the future? What techniques are suggested? How can we see who\what changed the records? Anthony Melbourne StuffUps:learn from others, share with others! http://www.meetup.com/Melbourne-Ideas-Incubator-Stuffups-Failed-Startups/ -- NOTICE : The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. (*13POrtC*) ---
RE: Restricting Data Chnages
Another option would be to add a trigger that refuses to allow you to modify large numbers of rows. However, you really need to carefully see if that would upset the application. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com Sent: Wednesday, 25 September 2013 1:17 PM To: 'ozDotNet' Subject: RE: Restricting Data Chnages It's a db I inherited so there are many sp that may be doing 'naughty' things Anthony Melbourne StuffUps:learn from others, share with others! http://www.meetup.com/Melbourne-Ideas-Incubator-Stuffups-Failed-Startups/ -- NOTICE : The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. (*13POrtC*) --- From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, 25 September 2013 1:01 PM To: 'ozDotNet' Subject: RE: Restricting Data Chnages You can add a TOP clause into data modification statements to limit how many rows are affected but I suspect that isn't your real issue. The first question that needs to be addressed is why anyone has access that allows doing that in the first place. That's the real problem. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of anthonyatsmall...@mail.com mailto:anthonyatsmall...@mail.com Sent: Wednesday, 25 September 2013 11:26 AM To: 'ozDotNet' Subject: RE: Restricting Data Chnages Is it possible to restrict the number of records that can be modified in one query? We had a database that had all its records updated by accident ie 30,000 rows..how can we avoid this in the future? What techniques are suggested? How can we see who\what changed the records? Anthony Melbourne StuffUps:learn from others, share with others! http://www.meetup.com/Melbourne-Ideas-Incubator-Stuffups-Failed-Startups/ -- NOTICE : The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. (*13POrtC*) ---
RE: Telstra Cable 3.0
Hi Tony, Yes, no I realise that I could just make it personal but it gets more complicated with other services bundled on same account, etc. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Wednesday, 11 September 2013 5:15 PM To: 'ozDotNet' Subject: RE: Telstra Cable 3.0 Also getting over 100 Mbps down and about 2.2Mbps up. I think the main reason they don’t like business using the cable is that then they have to provide quality of service, and might even be liable in some circumstances. They would have to provide business support as well. I have a residential broadband connection in the office, and for business have a backup (initially mobile wireless hotspot, but can move quickly to alternatives if needed). The ATO doesn’t discriminate – if it’s used for business, its used for business so expense can be claimed regardless. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Wednesday, 11 September 2013 4:41 PM To: ozDotNet Subject: Re: Telstra Cable 3.0 Greg, I switched to Telstra Bigpond Cable (BigPond® Broadband 500GB Ultimate - Cable) When I tried to get it activated they told me it wasn't available. Cable that is. Which was odd because I had had their old cable service in the past, and I had Foxtel cable connected (and it works just fine thanks so wtf?) It was an ordering issue or something. Their computer said no. So I switched from Foxtel to Telstra for Foxtel (on their recommendation and I actually ended up with a discounted plan... nice Telstra, backstab yourself much?). Once I was on Telstra Foxtel (rather than Foxtel Foxtel... lol) their system could then provision my new Cable connection. I think the reason its residential only is because the plans are Liberty plans which allow shaping when you hit your quota. Business plans want you to pay when you go over so the Liberty plans are not available. Its not a technical restriction, more a billing one? Anyway my speed tests go over 100Mb. I have had some packet loss issues in the past... one time they replaced my modem and it was fine. Another time it seemed to be a fault in the street? All good now and very happy with it. The NBN can burn in hell for all I care. I got my 100Mb speeds. If fibre gives me 1000Mb then I'd switch but I think my area is last on the list when I last checked. On Wed, Sep 11, 2013 at 11:54 AM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: I got the suggestion from a few people to speak to the LiveChat people as they are based out of Australia, unlike the phone people, and that they generally seem to have a clue. I spoke to Justin who told me that he’d never seen customers using cable services for business. He thought only ADSL was for business sigh I suspect it might be Optus time, as a number of people seem happy with their DOCSIS 3 system. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of David Connors Sent: Wednesday, 11 September 2013 1:47 PM To: ozDotNet Subject: Re: Telstra Cable 3.0 On Wed, Sep 11, 2013 at 1:42 PM, David Connors da...@connors.com mailto:da...@connors.com wrote: On Wed, Sep 11, 2013 at 1:24 PM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Any thoughts on why they’d say it can only be a residential account, not a business account? Yes, it is just market segmentation so they don't cannibalise their EAS, Ethernet Line, etc products. The BigPond product probably has traffic policing on it and so on as it is resi-grade IP transit - but you probably won't care unless isohunt.com http://isohunt.com is your core business. Support on the cable service will probably be pretty shit offshore, not like calling Telstra Internet Direct. BTW; I've tried to convince them to install a DOCSIS service at our offices before with no luck. I just thought though - I wonder if you could order Foxtel business, then just get them to post you out a modem and activate the BigPond IP service over that? The issue I had was that I would have been found out during the on-site installation when they had to pull coax up from the MDF. :) David.
Telstra Cable 3.0
Hi Folks, Have any of you changed to using the cable 3.0 product from Telstra? We get about 30 meg download speed on our cable now but it claims to potentially make it a lot quicker. It used to not be available in our area. When I logged onto the bigpond site the other day, it said it was now available and gave me a phone number to call. True to form, the number that Telstra linked to was answered by someone that had no clue at all about the product. 40 minutes later she still couldn't answer: * It is available? * How fast is it? * What does it cost? Those didn't seem like rocket science but she couldn't answer them. Today I've had a call from another guy that tells me that the only way you can actually get the faster service is to change the business accounts across to being residential accounts, as the business accounts are still on their legacy billing system where the residential accounts are on their Siebel system. Apparently, only residential customers can get the faster speeds, not business customers. Again, he couldn't explain how that made any sense or why it was that way, except that the product was only available on the new billing system. I really wish these clowns had some serious competition. But has anyone made the move? I'd like to hear how you found it. Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: Telstra Cable 3.0
Hi David, Any thoughts on why they’d say it can only be a residential account, not a business account? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Connors Sent: Wednesday, 11 September 2013 1:19 PM To: ozDotNet Subject: Re: Telstra Cable 3.0 On Wed, Sep 11, 2013 at 12:48 PM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Have any of you changed to using the cable 3.0 product from Telstra? [ ... ] But has anyone made the move? I’d like to hear how you found it. I know a number of people on Telstra's DOCSIS 3.0 product and it does indeed do as it says on the tin. 100mbps, very low latency, and priced keenly. David.
RE: Telstra Cable 3.0
I got the suggestion from a few people to speak to the LiveChat people as they are based out of Australia, unlike the phone people, and that they generally seem to have a clue. I spoke to Justin who told me that he’d never seen customers using cable services for business. He thought only ADSL was for business sigh I suspect it might be Optus time, as a number of people seem happy with their DOCSIS 3 system. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Connors Sent: Wednesday, 11 September 2013 1:47 PM To: ozDotNet Subject: Re: Telstra Cable 3.0 On Wed, Sep 11, 2013 at 1:42 PM, David Connors mailto:da...@connors.com da...@connors.com wrote: On Wed, Sep 11, 2013 at 1:24 PM, GregAtGregLowDotCom mailto:g...@greglow.com g...@greglow.com wrote: Any thoughts on why they’d say it can only be a residential account, not a business account? Yes, it is just market segmentation so they don't cannibalise their EAS, Ethernet Line, etc products. The BigPond product probably has traffic policing on it and so on as it is resi-grade IP transit - but you probably won't care unless http://isohunt.com isohunt.com is your core business. Support on the cable service will probably be pretty shit offshore, not like calling Telstra Internet Direct. BTW; I've tried to convince them to install a DOCSIS service at our offices before with no luck. I just thought though - I wonder if you could order Foxtel business, then just get them to post you out a modem and activate the BigPond IP service over that? The issue I had was that I would have been found out during the on-site installation when they had to pull coax up from the MDF. :) David.
RE: [OT] Surface Pro 2
I thought it sounded pretty good until I heard from Chris Auld. He seems to have had a nightmare run with them. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Friday, 6 September 2013 9:18 AM To: ozDotNet Subject: Re: [OT] Surface Pro 2 How is the Helix? On Thu, Sep 5, 2013 at 9:01 PM, Ken Schaefer k...@adopenstatic.com mailto:k...@adopenstatic.com wrote: I replace my Surface Pro with a Lenovo Helix. However the person that has the Surface now loves it. They do a lot of PDF and Word annotations, and find the ability to just scribble notes, circle things etc. really handy. Of course, you don't need a Surface to do that, but if that's the main thing you use a device for, then I can see how it'd be useful. Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Scott Barnes Sent: Thursday, 5 September 2013 7:43 PM To: ozDotNet Subject: Re: [OT] Surface Pro 2 When Microsoft sent me the Surface Pro I was pretty excited to use it, but after a week or so I pretty much stopped using it given the whole usage of it just didn't feel comfortable (heavy, got warm often, stylus was constantly being lost etc etc). I then gave it to my a co-worker to use instead thinking maybe I'm just to jaded about it all. He then pretty much arrived at the same conclusion so he then gave it to our Manager ...and yes, he ditched as well and then gave it to one of his peers and so far that guy's about to ditch it as well. ..so it's slowly making the rounds at work and so far it hasn't found a home as yet (I keep waiting for that person to say this is awesome so i can then pounce on them, open a notepad pen and get them to tell me why etc - professional curiosity). I was hoping the next generation would try something different to stimulate a re-up or revisit but if they are just making iPad like adjustments to the specs then its kind of a weird place to occupy for them given its success today? --- Regards, Scott Barnes http://www.riagenic.com On Thu, Sep 5, 2013 at 5:39 PM, Ian Thomas il.tho...@iinet.net.au mailto:il.tho...@iinet.net.au wrote: Yes, it does seem a Surface-killer - more options (storage, RAM), enough ports. We await pricing. I was impressed by recently-announced Lenovo T440 and T240 series ultrabooks. 2 batteries, up to 17 hours - a sensible counter to tablets. _ Ian Thomas Victoria Park, Western Australia From: mailto:ozdotnet-boun...@ozdotnet.com ozdotnet-boun...@ozdotnet.com [mailto: mailto:ozdotnet-boun...@ozdotnet.com ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Thursday, September 05, 2013 3:23 PM To: ozDotNet Subject: RE: [OT] Surface Pro 2 There's also this just-announced competitor from Sony: http://www.engadget.com/2013/09/04/sony-vaio-tap-11-hands-on/ Cheers Ken From: mailto:ozdotnet-boun...@ozdotnet.com ozdotnet-boun...@ozdotnet.com [ mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ian Thomas Sent: Thursday, 5 September 2013 5:14 PM To: mailto:ozdotnet@ozdotnet.com ozdotnet@ozdotnet.com Subject: [OT] Surface Pro 2 Surface Pro 2 ready to go with an adjustable kickstand and improved battery life Basically the original Surface Pro is an ultrabook with optional keyboard. Now it's getting more RAM, and the (Intel) Haswell chips, so performance and battery life should be greatly improved. http://www.theverge.com/2013/9/4/4694838/surface-pro-2-adjustable-kickstand -haswell-better-battery-life The Verge _ Ian Thomas Victoria Park, Western Australia
RE: [OT] NBN revisited
Like most people, I'd love to have FTTH. However, I have zero confidence in the current government's ability to deliver it in a reasonable timeframe. Wishing for it won't make it happen. Given a choice between paying $3K-$5k to connect our house to a local node in 2016, and a dream of a service that's unlikely to appear before I retire in about 10 years' time, there really is no serious choice to be made. I'd pay the $3k-$5k in a heartbeat. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Wednesday, 4 September 2013 2:38 PM To: ozDotNet Subject: Re: [OT] NBN revisited Apart from the use of impacted, a nice article. For some reason, this whole argument reminds me of the republic referendum some years back. I knew a number of people who didn't like the idea of a politician appointed president and thought voting No meant the people would vote for the president. The fact is, the vast majority of people who vote on such things do so without all the facts. Certainly not enough to be responsible for making a decision. People on this list will tend to be looking at it from a technical point of view. I doubt any of this has any meaning to the population in general. If the NBN was available in my area, I'd get it. For cable, my only option now is Optus which is what I have. Telstra told me I could get ADSL with a fraction of the data and for a lot more money. If only I had a choice... David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 4 September 2013 13:53, Bill McCarthy bill.mccarthy.li...@live.com.au mailto:bill.mccarthy.li...@live.com.au wrote: Here's a good read from today : http://www.theage.com.au/digital-life/computers/blogs/gadgets-on-the-go/turn bulls-fragmented-nbn-dooms-australia-to-repeat-the-mistakes-of-the-past-2013 0904-2t4cr.html Hopefully that will help some folks see past the one tree and start looking at the forest.
RE: [OT] NBN revisited
But what's the alternative Bill? Wait for the NBN? We're not even on the we'll think about starting within 3 years map. And all they keep doing with the current targets is downgrading them. So what chance do we have of seeing it in anything like a reasonable timeframe? I'm in an area where they'd make a lot of money by rolling it out. So by their logic, we can't have it. If, however, I lived out the back of Ballarat, no problems. As I said, conceptually I love the idea. I just can't see it actually being delivered. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Bill McCarthy Sent: Wednesday, 4 September 2013 3:06 PM To: 'ozDotNet' Subject: RE: [OT] NBN revisited I wouldn't count on that running that smoothly. It will take time to get that many fridges installed everywhere: thinking it can all be done in three years sounds incredibly hopeful to me. But even once that is done, then the fibre has to be physically installed down the road/streets. If that is done on an ad-hoc, one house here, one house there, not only is it terribly unproductive, but you can expect a whole lot of council backlash against the interruption to pedestrian and vehicle traffic etc, etc. Seriously, you should try to get Telstra to run you some cable today and see what the costs are and how long it takes: Only $5K from the exchange to your house: dreaming ;) From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, 4 September 2013 2:51 PM To: ozDotNet Subject: RE: [OT] NBN revisited Like most people, I'd love to have FTTH. However, I have zero confidence in the current government's ability to deliver it in a reasonable timeframe. Wishing for it won't make it happen. Given a choice between paying $3K-$5k to connect our house to a local node in 2016, and a dream of a service that's unlikely to appear before I retire in about 10 years' time, there really is no serious choice to be made. I'd pay the $3k-$5k in a heartbeat. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Wednesday, 4 September 2013 2:38 PM To: ozDotNet Subject: Re: [OT] NBN revisited Apart from the use of impacted, a nice article. For some reason, this whole argument reminds me of the republic referendum some years back. I knew a number of people who didn't like the idea of a politician appointed president and thought voting No meant the people would vote for the president. The fact is, the vast majority of people who vote on such things do so without all the facts. Certainly not enough to be responsible for making a decision. People on this list will tend to be looking at it from a technical point of view. I doubt any of this has any meaning to the population in general. If the NBN was available in my area, I'd get it. For cable, my only option now is Optus which is what I have. Telstra told me I could get ADSL with a fraction of the data and for a lot more money. If only I had a choice... David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 4 September 2013 13:53, Bill McCarthy bill.mccarthy.li...@live.com.au mailto:bill.mccarthy.li...@live.com.au wrote: Here's a good read from today : http://www.theage.com.au/digital-life/computers/blogs/gadgets-on-the-go/turn bulls-fragmented-nbn-dooms-australia-to-repeat-the-mistakes-of-the-past-2013 0904-2t4cr.html Hopefully that will help some folks see past the one tree and start looking at the forest.
RE: [OT] NBN revisited
And that’s the real issue. If it’s all about just providing some level of service to people that have no real options today, they we need to just say that, accept that it’s a nation-building public service for the bush and be prepared to wear really major costs in providing it. But I keep seeing adverts (that I presume I’m paying for), that tell me how important it is for letting businesses be competitive, and how businesses are needing higher and higher speeds. Almost none of the businesses that they are describing are in such areas. They are in areas with some existing coverage or they wouldn’t exist. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Wednesday, 4 September 2013 3:28 PM To: ozDotNet Subject: Re: [OT] NBN revisited Isn't that really the point of the NBN? To try to make internet access more available? I have no problem with people in the middle of nowhere getting it first because they have few options. I might complain about being stuck with optus but I still get 20Mb/s down and I think 0.25 up. I know people in outer suburbs that just can't get it at all. I'm not talking rural. Sure it means I don't get my FTTH in the foreseeable future but it is the fair option. The fibre part of this whole argument is, strictly speaking, secondary. Making internet access available to all for a reasonable cost is more important. On that note, charging $5000 to get that access isn't really the same thing. For many, you may as well say they can't have it. David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 4 September 2013 15:13, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: But what’s the alternative Bill? Wait for the NBN? We’re not even on the “we’ll think about starting within 3 years” map. And all they keep doing with the current targets is downgrading them. So what chance do we have of seeing it in anything like a reasonable timeframe? I’m in an area where they’d make a lot of money by rolling it out. So by their logic, we can’t have it. If, however, I lived out the back of Ballarat, no problems. As I said, conceptually I love the idea. I just can’t see it actually being delivered. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Bill McCarthy Sent: Wednesday, 4 September 2013 3:06 PM To: 'ozDotNet' Subject: RE: [OT] NBN revisited I wouldn’t count on that running that smoothly. It will take time to get that many “fridges” installed everywhere: thinking it can all be done in three years sounds incredibly hopeful to me. But even once that is done, then the fibre has to be physically installed down the road/streets. If that is done on an ad-hoc, one house here, one house there, not only is it terribly unproductive, but you can expect a whole lot of council backlash against the interruption to pedestrian and vehicle traffic etc, etc. Seriously, you should try to get Telstra to run you some cable today and see what the costs are and how long it takes: Only $5K from the exchange to your house: dreaming ;) From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, 4 September 2013 2:51 PM To: ozDotNet Subject: RE: [OT] NBN revisited Like most people, I’d love to have FTTH. However, I have zero confidence in the current government’s ability to deliver it in a reasonable timeframe. Wishing for it won’t make it happen. Given a choice between paying $3K-$5k to connect our house to a local node in 2016, and a dream of a service that’s unlikely to appear before I retire in about 10 years’ time, there really is no serious choice to be made. I’d pay the $3k-$5k in a heartbeat. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Wednesday, 4 September 2013 2:38 PM To: ozDotNet Subject: Re: [OT] NBN revisited Apart from the use of impacted
MSDN Azure Benefits Aston Martin
Hi Folks, The Microsoft folk have asked us to mention this but it seems worth mentioning anyway: Most developers and DBAs have MSDN subscriptions yet they haven't enabled their Azure benefits that come included with the MSDN subscriptions. To encourage people to do it, there's a competition to win an Aston Martin which might be worth a shot. I've put details here: http://sqlblog.com/blogs/greg_low/archive/2013/08/15/are-you-using-the-azure -benefits-in-your-msdn-subscription-like-an-aston-martin.aspx Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: [OT] Windows Server 2012
Same as with Windows 8, Start8 ( http://www.stardock.com www.stardock.com) made my Windows Server 2012 world good again for $4.95. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Friday, 16 August 2013 10:50 AM To: ozDotNet Subject: [OT] Windows Server 2012 Folks, does anyone else think that Windows 2012 Server is really weird? I was playing with it last night for the first serious time and think it's like a crippled blend of bits of other versions of Windows. I've got it running inside Hyper-V where it boots to the desktop and you can barely do anything there except run Server Manager. I can't use the Windows key (due to Hyper-V) to get to the Start screen or show the Windows+X fake menu, so after booting I'm bogged at the desktop and can't do anything. I have to go full-screen to enable the Windows key and navigate around (which is a nuisance). From inside Server manager you can Click Manage and Tools to open many Admin tools, but not the familiar Control Panel apps. Even Server Manager is a weird app unlike other admin tools, and it's so hard to scroll around it and find things. Is anyone actually using Windows 2012 Server in anger? It doesn't seem to fit in anywhere, like a hallucination that was released by accident. Greg K
RE: 240GB SSD?
We've had a really good run with a bunch of Crucial M4s. They are up to 960GB now and all are SATA3. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Friday, 9 August 2013 9:01 AM To: ozDotNet Subject: RE: 240GB SSD? Samsung 840 (or the Pro if you can afford it and have SATA3). Crucial M4 or the newer C500 Where are you based? www.staticice.com.au http://www.staticice.com.au is pretty good for locating stores/prices/stock. Then just pick a place close to you: Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Friday, 9 August 2013 8:46 AM To: ozDotNet Subject: 240GB SSD? Hi, What's a good, fast and reliable SSD these days? My old HDD from my home workstation decided it's that time of it's lifetime when work is no longer on its books so I need to replace it. PS Maybe also a place I could buy it and pick it up today. Thanks, Corneliu.
FW: 240GB SSD?
One hint though Corneliu: if you bought one locally, it mightn’t have the latest firmware. I’d update that before I got too carried away. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Friday, 9 August 2013 3:39 PM To: ozDotNet Subject: Re: 240GB SSD? Thanks everyone. Got a Crucial 240Gb M500 from MWave. Good price and it's already getting installed :) On Fri, Aug 9, 2013 at 9:48 AM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: We’ve had a really good run with a bunch of Crucial M4s. They are up to 960GB now and all are SATA3. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Ken Schaefer Sent: Friday, 9 August 2013 9:01 AM To: ozDotNet Subject: RE: 240GB SSD? Samsung 840 (or the Pro if you can afford it and have SATA3). Crucial M4 or the newer C500 Where are you based? www.staticice.com.au http://www.staticice.com.au is pretty good for locating stores/prices/stock. Then just pick a place close to you… Cheers Ken From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Friday, 9 August 2013 8:46 AM To: ozDotNet Subject: 240GB SSD? Hi, What's a good, fast and reliable SSD these days? My old HDD from my home workstation decided it's that time of it's lifetime when work is no longer on its books so I need to replace it. PS Maybe also a place I could buy it and pick it up today. Thanks, Corneliu.
RE: UPS
No UPS is going to generate power for you. You'd need a generator for that. Do United Energy have any sort of service level agreement? Or any agreement on what the tolerance should be? In the end, it sounds like you need new cabling to your area and only the supply company can do that. Last time I looked at this, the guarantees that they provided were very limited. It was almost as though if anything came out of your power points, you should be giving thanks to them. People have been successful in giving the electricity companies a hard time about quality of supply but it's a hard road. I know of one in Queensland where they eventually gave in and power conditioned his whole house just to shut him up. (Mind you, he's also been banned from the High Court as a serial pest so you can imagine the lengths that he was prepared to go to). Is there anything else in your street that could claim a strong need for better quality supply? For example, anyone on sensitive medical equipment? A lot of computing equipment used to be rated as 220V +5% -10%. Those devices should be fine. But those that are 240V nominal might be a problem. I recall that Western Australian areas with 250V nominal used to be a real hassle for some equipment. In desperation, I'd suggest trying: 1. Finding computing equipment that's designed for 220V rather than 240V. (Some power supplies have switches on them, and you might be able to order a different power adapter for a notebook) 2. Get a big transformer (eg. 2KVA) wound for something like 215V in and 240V out, then use a UPS. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stuart Kinnear Sent: Thursday, 25 July 2013 11:50 AM To: ozDotNet Subject: UPS I am suffering major degradation of power supply over these winter months. The voltage drops to 204V during peak load periods and sits any where between 215 to 230 during the day. Contacted United Energy several times - they are playing tricks like not turning up when the problems are manifested and measuring the power at midnight saying it's OK. Talk to the technicians they say that because I live at the end of the street there are several new units tough luck charlie. What I am thinking is to get a decent UPS that would regulate the supply, but I am not sure that they would work over a number of hours. It would need to support 6 PCs. Does anyone have any recommendations ? -- - Stuart Kinnear Mobile: 040 704 5686. Office: 03 9589 6502 SK Pro-Active! Pty Ltd acn. 81 072 778 262 PO Box 6117 Cromer, Vic 3193. Australia Business software developers. SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. -
RE: UPS
Yep, Internet connection options are the 1st thing I’d look for when getting a property. I’m stunned how many devs I talk to that are living where they can’t get good Internet connections. But power??? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Thursday, 25 July 2013 12:31 PM To: ozDotNet Subject: Re: UPS Option 3. move house. Personally, I research internet speeds and connection types when researching prospective living abode. Never had to look at power because we're blessed with normal power supplies here. 1st world problems hey... On Thu, Jul 25, 2013 at 10:15 AM, Paul Keen pak...@bigpond.net.au mailto:pak...@bigpond.net.au wrote: I am a complete novice in this area but does rooftop solar have any impact on supply problems like this. Paul From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of GregAtGregLowDotCom Sent: Thursday, 25 July 2013 12:04 PM To: 'ozDotNet' Subject: RE: UPS No UPS is going to generate power for you. You’d need a generator for that. Do United Energy have any sort of service level agreement? Or any agreement on what the tolerance should be? In the end, it sounds like you need new cabling to your area and only the supply company can do that. Last time I looked at this, the guarantees that they provided were very limited. It was almost as though if anything came out of your power points, you should be giving thanks to them. People have been successful in giving the electricity companies a hard time about quality of supply but it’s a hard road. I know of one in Queensland where they eventually gave in and power conditioned his whole house just to shut him up. (Mind you, he’s also been banned from the High Court as a serial pest so you can imagine the lengths that he was prepared to go to). Is there anything else in your street that could claim a strong need for better quality supply? For example, anyone on sensitive medical equipment? A lot of computing equipment used to be rated as 220V +5% -10%. Those devices should be fine. But those that are 240V nominal might be a problem. I recall that Western Australian areas with 250V nominal used to be a real hassle for some equipment. In desperation, I’d suggest trying: 1. Finding computing equipment that’s designed for 220V rather than 240V. (Some power supplies have switches on them, and you might be able to order a different power adapter for a notebook) 2. Get a big transformer (eg. 2KVA) wound for something like 215V in and 240V out, then use a UPS. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stuart Kinnear Sent: Thursday, 25 July 2013 11:50 AM To: ozDotNet Subject: UPS I am suffering major degradation of power supply over these winter months. The voltage drops to 204V during peak load periods and sits any where between 215 to 230 during the day. Contacted United Energy several times - they are playing tricks like not turning up when the problems are manifested and measuring the power at midnight saying it's OK. Talk to the technicians they say that because I live at the end of the street there are several new units tough luck charlie. What I am thinking is to get a decent UPS that would regulate the supply, but I am not sure that they would work over a number of hours. It would need to support 6 PCs. Does anyone have any recommendations ? -- - Stuart Kinnear Mobile: 040 704 5686. Office: 03 9589 6502 SK Pro-Active! Pty Ltd acn. 81 072 778 262 PO Box 6117 Cromer, Vic 3193. Australia Business software developers. SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. -
RE: SQL Server Developer Edition
Hi Corneliu, It's good for dev/test scenarios but I gather not for UAT type scenarios. You'd be best getting advice from MS, and as usual, keep asking till you get the advice you wanted :) I've found that in general, no-one in the sales groups understand the dev edition. Last year, it took them over a week to work out how we could buy one. Now they are available from the standard license suppliers. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Wednesday, 24 July 2013 7:52 AM To: ozDotNet; SQLDownUnder Subject: SQL Server Developer Edition Hi guys, [cross post to ozDotNet and SQLDownUnder] I'm having a bit of trouble figuring out the licenceing of SQL Server Developer Edition. This is straight from the SQL_Server_2012_Licensing_Reference_Guide.pdf from Microsoft: *Licensing SQL Server for Non-production Use* When using SQL Server software for development, test or demonstration purposes, only the users are licensed and there is no need for a corresponding license for the actual server systems running SQL Server software in this case. [...] Now, can I assign such a licence to a public test/utc environment we use to test the application before going into production. The application is a website accessible over the internet but will NOT be used for any production use. It's purely for testing, staging, utc and performance testing. Thanks, Corneliu
RE: SQL Server Developer Edition
No, local DB is just the engine that you can run in an attached process. Dev edition gives you all the tools that come with the Enterprise edition of SQL Server. I see devs trying to learn to use SQL Server using Express or LocalDB all the time. That’s not sensible. Get the dev edition (it’s about $80) and you’ll have all the tools. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Arjang Assadi Sent: Wednesday, 24 July 2013 9:05 AM To: ozDotNet Subject: Re: SQL Server Developer Edition Was local DB meant to be an alternative in place of Sql Server Developer? On 24 July 2013 08:40, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Hi Corneliu, It’s good for dev/test scenarios but I gather not for UAT type scenarios. You’d be best getting advice from MS, and as usual, keep asking till you get the advice you wanted :) I’ve found that in general, no-one in the sales groups understand the dev edition. Last year, it took them over a week to work out how we could buy one. Now they are available from the standard license suppliers. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Corneliu I. Tusnea Sent: Wednesday, 24 July 2013 7:52 AM To: ozDotNet; SQLDownUnder Subject: SQL Server Developer Edition Hi guys, [cross post to ozDotNet and SQLDownUnder] I'm having a bit of trouble figuring out the licenceing of SQL Server Developer Edition. This is straight from the SQL_Server_2012_Licensing_Reference_Guide.pdf from Microsoft: *Licensing SQL Server for Non-production Use* When using SQL Server software for development, test or demonstration purposes, only the users are licensed and there is no need for a corresponding license for the actual server systems running SQL Server software in this case. [...] Now, can I assign such a licence to a public test/utc environment we use to test the application before going into production. The application is a website accessible over the internet but will NOT be used for any production use. It's purely for testing, staging, utc and performance testing. Thanks, Corneliu
FW: [OT] Azure VM provisioning timed out
Hi Greg, I'm pretty much always done them from the Gallery and it's been fine. What they normally recommend for issues is to: Email at iaasfo...@microsoft.com mailto:iaasfo...@microsoft.com along with the following info: 1.Your Windows Azure Subscrption Account Live ID 2.This forum URL 3.The Virtual Machine that you are investigating. 4.Date and Time when you started experiencing this problem. 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Friday, 19 July 2013 1:28 PM To: ozDotNet Subject: Re: [OT] Azure VM provisioning timed out Do you guys remember if you went through the web port and made your VMs using the Quick create or the From the gallery options? I used the former and ran into strife. I have seen some hints that the latter will work. I'd try the latter as an experiment but my preferred VM name is blocked by the dead VM in storage that I can't delete. Greg
RE: [OT] T-SQL GroupBy and Sum on a DateTime
Seems like a good time to mention one of our courses: http://www.sqldownunder.com/Training/Courses/2 http://www.sqldownunder.com/Training/Courses/2 :) 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Wednesday, 17 July 2013 7:14 AM To: ozDotNet Subject: Re: [OT] T-SQL GroupBy and Sum on a DateTime You can (must) use a Where clause if you refer to soh.OrderDate directly Good grief! You're right. I thought a WHERE was forbidden in a grouped query and only HAVING was allowed. A working sample is below (although monthly totals would start and end on month boundaries, this sample just proves the WHERE and grouping work) -- Greg SELECT COUNT(Id) As Count, SUM(CAST([Send] AS BIGINT)) AS SendTotal, SUM(CAST([Recv] AS BIGINT)) As RecvTotal, SUM(Elapsed) AS ElapsedTotal, DATEPART(YEAR,[Time]) AS LogYear, DATEPART(MONTH,[Time]) AS LogMonth FROM [Visit] WHERE [Time] BETWEEN '2012-07-29' AND '2013-03-02' GROUP BY DATEPART(YEAR,[Time]), DATEPART(MONTH,[Time]) ORDER BY LogYear DESC, LogMonth DESC
RE: [OT] T-SQL GroupBy and Sum on a DateTime
Hi Greg, You can use DATEPART to extract the parts of the date i.e. DATEPART(month,YourDateColumn), DATEPART(year, YourDateColumn). DATEPART has a wide variety of options but SQL Server also has direct functions for some of these i.e. MONTH(YourDateColumn), YEAR(YourDateColumn). You can group by the outcome of these functions just like any other column. I suspect you might also want to look at the outcome of adding WITH ROLLUP and/or WITH CUBE to your queries. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Tuesday, 16 July 2013 8:34 AM To: ozDotNet Subject: [OT] T-SQL GroupBy and Sum on a DateTime I've got a SQL Server table containing logging data. All of the columns are numbers except for a single DateTime column. I want to generate totals by hour, day, month or year. Because the GroupBy column is a DateTime I can't figure out the query syntax to sum on Y, YM, YMD or YMDH combinations. I'll bet there's a neat trick to do this, does anyone know what it is? Thanks Greg K
RE: [OT] T-SQL GroupBy and Sum on a DateTime
Hi Greg, You can put the DATEPART functions in the HAVING (as long as they're in the GROUP BY). The most common mistake is to try to put column aliases for them in the HAVING. USE AdventureWorks2008R2; GO SELECT SUM(sod.LineTotal) AS TotalValue, DATEPART(year,soh.OrderDate) AS OrderYear, DATEPART(month,soh.OrderDate) AS OrderMonth FROM Sales.SalesOrderHeader AS soh INNER JOIN Sales.SalesOrderDetail AS sod ON soh.SalesOrderID = sod.SalesOrderID GROUP BY DATEPART(year,soh.OrderDate), DATEPART(month,soh.OrderDate) HAVING DATEPART(year,soh.OrderDate) BETWEEN 2005 AND 2012 ORDER BY OrderYear, OrderMonth; 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Tuesday, 16 July 2013 10:00 AM To: ozDotNet Subject: Re: [OT] T-SQL GroupBy and Sum on a DateTime You can use DATEPART to extract the parts of the date I tried various combinations like that. I have DATEPART in the select, but then I get syntax errors in the HAVING because I can't put DATEPARTs into it. I can't figure out how to group and sum on parts of a DateTime column. I'll try to provide a tiny sample when I get home this evening. Greg K
RE: [OT] css and table columns (answer!)
Hi Greg, A while back, I started going through what you seem to be going through in relation to CSS. Watching the sessions on CSS at Pluralsight was really worthwhile. It was a really good investment of my time. I particularly liked the sessions by K.Scott Allen. (There's a reason he's listed as their first instructor to hit $1.8M USD in income from Pluralsight. He's good at what he does). 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Sunday, 14 July 2013 9:49 AM To: ozDotNet Subject: Fwd: [OT] css and table columns (answer!) I think I've found the answer. I found this nice summary of CSS Selectors http://www.w3schools.com/cssref/css_selectors.asp and near the end is :nth-child(n). I ran a few experiments and found this will turn the 2nd column of all tables yellow: td:nth-child(2) { background: yellow; } The problem is I have many tables on the page, so I had to apply that selector to specific tables. After many experiments I eventually found that if you give a unique id= to each table then you can do this: #table1 td:nth-child(2) However, this worked in my simple test html page but did nothing when I tried it in a real ASP.NET http://ASP.NET generated page. So after more bumbling I found that if each table has a unique class= assigned to it then you can: .footable td:nth-child(2) So this lets me externally apply formatting to each column of different tables without the need to touch the table markup. This can reduce the size of pages considerably. Greg
RE: Scaling HTML
Hi Tony, Yep, that was top of my list. I had this recollection though that if you had items with hard-coded positional info, that it wouldn’t work for scaling. Do you know if it does? I’ve also heard a lot of folk over the years saying that iframes are on the way out, and that the latest standards browsers are very inconsistent in their handling of them. I’m wondering how true that is. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Friday, 12 July 2013 3:14 PM To: ozDotNet Subject: Re: Scaling HTML Hi Greg, Have you considered using an IFRAME? It would compartmentalise the markup. Regards, Tony On Fri, Jul 12, 2013 at 2:09 PM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Hi Craig, One example would be an HTML report that normally opens as a web page. I have no control over the contents of the HTML but I’d like the have it appear within a region of my own page where I control the size. It could well contain fixed sizes, tables, etc. that I cannot control. I suppose I’d like to achieve what my iPad does. If I hit a wider site using it, by default it just scales it to fit its own size. I’d like to do that within a region of my own page. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax SQL Down Under | Web: http://www.sqldownunder.com/ www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Craig van Nieuwkerk Sent: Friday, 12 July 2013 2:05 PM To: ozDotNet Subject: Re: Scaling HTML What does auto-scale it mean? Does it have fixed widths coded into the html that you wish to change somehow based on page size? On Fri, Jul 12, 2013 at 2:02 PM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: If I have a server that sends me a bunch of HTML (ie a web page) and I want to insert it within my MVC4 page, but I want to auto-scale it to a particular size, any suggestions about how I’d best go about that? Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: Scaling HTML
Probably should give a succinct example of the type of thing I'm trying to do to see if there's a better way. Here's one example: 1. I have a report server that can send me the HTML for a report. 2. I have no control over the size of the report that's sent to me. 3. I want to display the report within a section of an MVC4 page that I have set to a specific width. 4. I'd love to be able to scale the HTML that I'm sent to make it fit within a specific region of the page, or at the very least within a specific width. (I could probably live with it being too deep). 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Friday, 12 July 2013 4:02 PM To: ozDotNet Subject: Re: Scaling HTML An iframe on it's own wouldn't do it. But I think there is a zoom property in the DOM somewhere. David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 12 July 2013 15:13, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: Hi Greg, Have you considered using an IFRAME? It would compartmentalise the markup. Regards, Tony
FW: Scaling HTML
Thanks David :) I’ll give it a go. I did spend quite a while looking for this. I bow to your superior Googling skills :) Is there a word for that? (You have no idea how much rubbish I’ve read this afternoon while trying to find it. Most of the forums are seriously depressing). 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Richards Sent: Friday, 12 July 2013 4:58 PM To: ozDotNet Subject: Re: Scaling HTML Let me google that for you ;) http://dev.hubspot.com/blog/bid/89755/jQuery-Zoomer-Zoom-up-your-iFrames I think that's close to what you want. David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 12 July 2013 16:33, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: Probably should give a succinct example of the type of thing I’m trying to do to see if there’s a better way. Here’s one example: 1. I have a report server that can send me the HTML for a report. 2. I have no control over the size of the report that’s sent to me. 3. I want to display the report within a section of an MVC4 page that I have set to a specific width. 4. I’d love to be able to scale the HTML that I’m sent to make it fit within a specific region of the page, or at the very least within a specific width. (I could probably live with it being too deep). 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of David Richards Sent: Friday, 12 July 2013 4:02 PM To: ozDotNet Subject: Re: Scaling HTML An iframe on it's own wouldn't do it. But I think there is a zoom property in the DOM somewhere. David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 12 July 2013 15:13, Tony Wright tonyw...@gmail.com mailto:tonyw...@gmail.com wrote: Hi Greg, Have you considered using an IFRAME? It would compartmentalise the markup. Regards, Tony
RE: Scaling HTML
Hi James, Sort of. I think the one that David led me to looks mighty good though: http://github.hubspot.com/jquery-zoomer/ http://github.hubspot.com/jquery-zoomer/ Will try it this weekend. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of James Chapman-Smith Sent: Friday, 12 July 2013 11:37 PM To: ozDotNet Subject: RE: Scaling HTML Hi Greg, Is this an example of the kind of scaling HTML that you're looking for? http://www.getgroundedfootwear.com/ Cheers. James. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Friday, 12 July 2013 13:33 To: ozDotNet Subject: Scaling HTML If I have a server that sends me a bunch of HTML (ie a web page) and I want to insert it within my MVC4 page, but I want to auto-scale it to a particular size, any suggestions about how I'd best go about that? Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
Scaling HTML
If I have a server that sends me a bunch of HTML (ie a web page) and I want to insert it within my MVC4 page, but I want to auto-scale it to a particular size, any suggestions about how I'd best go about that? Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: Scaling HTML
Hi Craig, One example would be an HTML report that normally opens as a web page. I have no control over the contents of the HTML but I’d like the have it appear within a region of my own page where I control the size. It could well contain fixed sizes, tables, etc. that I cannot control. I suppose I’d like to achieve what my iPad does. If I hit a wider site using it, by default it just scales it to fit its own size. I’d like to do that within a region of my own page. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Craig van Nieuwkerk Sent: Friday, 12 July 2013 2:05 PM To: ozDotNet Subject: Re: Scaling HTML What does auto-scale it mean? Does it have fixed widths coded into the html that you wish to change somehow based on page size? On Fri, Jul 12, 2013 at 2:02 PM, GregAtGregLowDotCom g...@greglow.com mailto:g...@greglow.com wrote: If I have a server that sends me a bunch of HTML (ie a web page) and I want to insert it within my MVC4 page, but I want to auto-scale it to a particular size, any suggestions about how I’d best go about that? Regards, Greg Dr Greg Low CEO and Principal Mentor SQL Down Under SQL Server MVP and Microsoft Regional Director 1300SQLSQL (1300 775 775) office | +61 419201410 tel:%2B61%20419201410 mobile│ +61 3 8676 4913 tel:%2B61%203%208676%204913 fax Web: http://www.sqldownunder.com/ www.sqldownunder.com
RE: Still trying to fix authentication on an ASP.net application: some accounts work and others don't
Hi Katherine, I'll have to let someone else that uses that membership provider answer that one. I took one look at it when it was released and decided it wasn't for me. I felt like I was in a parallel universe. Everyone in the room was talking about how fast it was to build and I was looking at the methods, etc. and thinking didn't they ever read any of the framework design guidelines? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Katherine Moss Sent: Wednesday, 10 July 2013 11:07 PM To: ozDotNet Subject: RE: Still trying to fix authentication on an ASP.net application: some accounts work and others don't That's the funny thing; when I try and retrieve the passwords for either of these two accounts, instead of having email directed to the local server (I don't have SmarterMail configured yet), I get the we can't locate your account message from Sueetie, then when I go to retrieve the user name of the account, I was able to get a temporary email sent to the local server (only for my account, and not the default administrator account), so figuring that the temp password expired since it wasn't working when Forms authentication had accidentally gotten shut off, I attempted to make another temporary password via the forgot user name link on the page. It was then when my account got locked out. Never happened before, and as far as I can tell, the default administrator account is nonexistent now. But it is only these two accounts that are causing problems now; everyone elses works fine. So my solution to this problem is instead of futzing around trying to figure out why these aren't working, I could make my friend an administrator and allow her to delete them and then recreate them. (she's an admin anyway.) But my problem is how to query the ASP.net membership tables in the database in order to ensure that the change gets replicated from database to site. Correct me if I'm wrong, but this is the aspnet_roles table I'm looking to access, right? And if so, what is the statement I would use to make this change? (I'm very weak in Transact-SQL at the moment, but it's thanks to cool folks like you guys that I learn). Looks like flipping forms authentication on and off really shuddered this thing. Jees. From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom Sent: Wednesday, July 10, 2013 12:03 AM To: ozdotnet@ozdotnet.com mailto:ozdotnet@ozdotnet.com Subject: RE: Still trying to fix authentication on an ASP.net application: some accounts work and others don't Hi Katherine, It's not saying that the account or the password are wrong. It's saying that the account is locked out. Is it set up to automatically unlock accounts after a period of time? Is there a flag in the database that holds the authentication details that says whether or not an account is locked? 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 From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Katherine Moss Sent: Wednesday, 10 July 2013 1:57 PM To: ozdotnet@ozdotnet.com mailto:ozdotnet@ozdotnet.com Subject: Still trying to fix authentication on an ASP.net application: some accounts work and others don't Hi guys, This is driving me crazy. I'm trying to fix my web site and the authentication modules. I have since replaced the web.config file and some people are able to log into the site. I cannot log in either as the main administrator with a user name of admin, or as my secondary account, yet my friend's able to log in just fine. I get the following error message when trying to retrieve my user name since the site can no longer locate my account: Server Error in '/' Application. _ The user account has been locked out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Security.MembershipPasswordException: The user account has been locked out. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [MembershipPasswordException: The user account has been locked out.] System.Web.Security.SqlMembershipProvider.ResetPassword(String username, String passwordAnswer) +1840
RE: Still trying to fix authentication on an ASP.net application: some accounts work and others don't
Hi Katherine, It's not saying that the account or the password are wrong. It's saying that the account is locked out. Is it set up to automatically unlock accounts after a period of time? Is there a flag in the database that holds the authentication details that says whether or not an account is locked? 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Katherine Moss Sent: Wednesday, 10 July 2013 1:57 PM To: ozdotnet@ozdotnet.com Subject: Still trying to fix authentication on an ASP.net application: some accounts work and others don't Hi guys, This is driving me crazy. I'm trying to fix my web site and the authentication modules. I have since replaced the web.config file and some people are able to log into the site. I cannot log in either as the main administrator with a user name of admin, or as my secondary account, yet my friend's able to log in just fine. I get the following error message when trying to retrieve my user name since the site can no longer locate my account: Server Error in '/' Application. _ The user account has been locked out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Security.MembershipPasswordException: The user account has been locked out. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [MembershipPasswordException: The user account has been locked out.] System.Web.Security.SqlMembershipProvider.ResetPassword(String username, String passwordAnswer) +1840 System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer) +145 Sueetie.Web.ForgotUsernamePage.AddBody(MailMessage _msg, SueetieUser _user) +507 Sueetie.Web.ForgotUsernamePage.SendEmail_Click(Object sender, EventArgs e) +277 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707 _ Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272 I'm trying not to have to recreate the database, after all, how would one place a fresh database under the application if all of the application's data is in there? So, my idea was to raise my friend as an administrator via the database, but I don't know how to do that and have the site replicate the change on the side of ASP.net. and why are these particular accounts being locked out and not taking email addresses? Thanks.
RE: jQuery debugging
Spent most of another life working with it. I came the conclusion that the manual was easy to read and clear as long as you’d read the entire manual first :) 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Tuesday, 9 July 2013 2:53 PM To: ozDotNet Subject: Re: jQuery debugging Reminds me of a saying, Unix is user friendly. It's just selective on who its friends are. :) On Tue, Jul 9, 2013 at 12:42 PM, Greg Keogh g...@mira.net mailto:g...@mira.net wrote: The beauty of Javascript is well hidden. Touché! -- Greg
RE: Optimising SQL column data
Actually it's the best thing in the box for 2008 but it's Enterprise Edition only. That's why I was checking whether you were working on a project with it. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Wednesday, 26 June 2013 5:53 PM To: ozDotNet Subject: Re: Optimising SQL column data Which edition of SQL Server? (Compression at the page level is awesome for this but not everyone has it) I have both SQL Server 2012 standard (for fiddling with), but I mostly use the previous one, what was it 2008? I haven't heard about the new compression you mention, so I'll run a few searches on it. However, it sounds rather low-level and dangerous -- Greg K
RE: Optimising SQL column data
Hi Greg, Which edition of SQL Server? (Compression at the page level is awesome for this but not everyone has it) It would be really good if the product had a real concept of an enumeration but it doesn't: 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Wednesday, 26 June 2013 3:36 PM To: ozDotNet Subject: Optimising SQL column data Folks, I'm loading hundreds of thousands of logging lines into a SQL Server table and I noticed that one of the columns contains only short words taken from a handful of choices. So the column reads like FOO FOO FOO FOO BAR FOO FOO FOO FOO BAR BANG FOO FOO FOO etc. The column will rarely be used. Would SQL boffins in here consider turning this column into something more space saving, like a single byte flag for example? Perhaps to save space or improve performance. Greg K
RE: VS2012 hacks
Hi Greg, A number of other project templates aren't so great in VS either. Recently, they've released the BI tools for VS2012. In SSIS, the only difference between an enabled task and a disabled one is often how dark the name of the task is. That sort of thing is a big step backwards, particularly for anyone with visual limitations. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Saturday, 15 June 2013 11:30 AM To: ozDotNet Subject: Re: VS2012 hacks Ian (et al), I have also taken a lot of steps recently to restore old colours and behaviour to recent Microsoft product releases. I don't normally do that. We all expect complaints when new versions of products are released, but in my experience the noise quickly drops away and people just accept the changes and run with them. However, the amount of stubborn resistance recently has been quite startling. Why is this happening? Microsoft is dragging us all along with it on some sort of global style change where there is less chrome, fewer borders, less saturated colour, fewer lines, etc. Now I can honestly understand this because the eye and brain work better with less clutter, but it all seems to have gone too far (remember the first preview of Visual Studio 2012 that looked like a charcoal etching?). Is there some department or research within Microsoft that is driving this trend? Do they explain their reasoning? Where did they recruit the drugged gibbons they put through the usability testing? And then there's Windows 8 ... Greg
RE: .Net based Email Newsletter
Agreed. Mailchimp seems to be the most common one that I receive mail from, and from reading it's info, it looks well managed. 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea Sent: Thursday, 13 June 2013 12:59 PM To: ozDotNet Subject: Re: .Net based Email Newsletter Why build? Why not use a proper newsletter system? MailChimp or any of the other million existing ones? They are very good. They can also give you some deliverability and open rate reports which can tell you if your newsletter have any value or they are simply money spend delivering noise. They can also handle all the spam, take care of reputation and handle the unsubscribe process. And I think it's cheaper to use such a service than spend days/weeks/months to build it :) My 2 cents. On Thu, Jun 13, 2013 at 10:10 AM, ifum...@gmail.com mailto:ifum...@gmail.com wrote: We used telerik editor to achieve this...and you could use something like mailbee to do the bulk email Anthony From: ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com mailto:ozdotnet-boun...@ozdotnet.com ] On Behalf Of Iain Carlin Sent: Thursday, 13 June 2013 10:02 AM To: ozDotNet Subject: .Net based Email Newsletter G'day all, We're looking for a solution to create a HTML newsletter with images and text that can be bulk emailed via SMTP to a list sourced from our 'CRM'. We'd prefer something .Net based as that fits with everything else we have. Has anyone got any recommendations? Cheers, Iain
RE: Lightweight database
Agreed. Even with XML, you might to deal with what happens if the schema changes ie: can your new app read an old saved set of data? 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 I think one of the first design parameters you need is how much data. If the amount of data is small, then you can get away with xml. If it starts slowing down you need to move to a different format such as a custom binary. XML - quick to code, easy, the customer can own their own data and work it out themselves if needed. Can be slow as data increases. Binary - slower to code, needs a lot of rules up front, speedy in use, needs custom export as xml functions (perhaps) In both cases you end up loading all the data into memory, so there's a real upper limit. If you get into paging it gets too complex and it's time for a real data provider. XML suffers from having to parse the file, looking for special characters, then a lookup match for each field for each record. Binary on the other hand you can write the length of each record as the record prefix so you just read in chunks of bytes, splitting each field either at fixed length (really quick) or having variable length prefixed with their length. Eg User FirstNameGreg/FirstName LastNameKeogh/LastName User Becomes 30 4 Greg 5 Keogh Where the 30 is the first dword (4 bytes), 4 is the next (4 bytes), then parse the string which is 4 Char (wide is 8 bytes) next 4 bytes is the value of 5, then parse the 5 chars (10 bytes) The problem with doing binary is if they change the schema, it's a real PITA to change the code. |-Original Message- |From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet- |boun...@ozdotnet.com] On Behalf Of Greg Keogh |Sent: Tuesday, 4 June 2013 12:25 PM |To: ozDotNet |Subject: Lightweight database | |Folks, an app has just grown with a new feature that needs to store of users, |jobs and reports and the joins between them, If I was using SQLite |it would be |3 tables with joins. However, rather than use SQLite this time I'd like |to consider |an alternative that's even more lightweight to setup and use. The app |does not |currently use any database technology and the guys managing the project |are actually scared of them. | |Can anyone recommend an in-process database (not necessarily |relational!) that |is has a friendly managed API, small footprint, not too complicated and |is easy to |get going? I know this is a lot to ask, but there may be some NoSQL |options around that I'm not aware of. The most important issues for me |are: (1) Minimal |dependencies (2) Simple managed API. | |I'm running a few web searches now for such things, and I can see |Redis, Mongo, |Couch, Raven, db4o, Cassandra, Eloquera, Lucene, and the list goes on |and on. |There are too many choices and it would take many days of hard slog to |work out |which one would be suitable. So perhaps someone has already been |through this |process?! | |I've been tempted many times over the last 10 years to write a pure |managed single-file database with indexes, and nothing much else (no |transactions, no |client-server, no schemas, etc). However, I decided to leave it to the experts, and |it looks like there are too many of them, and they all over-engineer |their works. | |Cheers, |Greg K
RE: Lightweight database
Yep, that's what I was getting at. The object structure might change between versions. Extra columns won't be an issue but other sorts of changes probably would be. 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 Yep, but with XML the new app will read the old data without a problem (unless there has been field delete's or renaming). With the binary, there's a bit more to the coding (and testing) of the layout. That said, if you write the version number in the data file's header, you can switch out to a conversion routine which would use a lot of the old parser anyway. Where-as the XML is a b it harder to switch out to different parsers. So there's probably not a lot in it, but I know it's the binary ones that seem to get me to have get the pad and pen or a spreadsheet open while I do it ;) |-Original Message- |From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet- |boun...@ozdotnet.com] On Behalf Of GregAtGregLowDotCom |Sent: Tuesday, 4 June 2013 2:25 PM |To: 'ozDotNet' |Subject: RE: Lightweight database | |Agreed. Even with XML, you might to deal with what happens if the |schema changes ie: can your new app read an old saved set of data? | |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 | |I think one of the first design parameters you need is how much data. |If the |amount of data is small, then you can get away with xml. If it starts slowing down |you need to move to a different format such as a custom binary. | |XML - quick to code, easy, the customer can own their own data and work |it out |themselves if needed. Can be slow as data increases. |Binary - slower to code, needs a lot of rules up front, speedy in use, needs custom |export as xml functions (perhaps) | |In both cases you end up loading all the data into memory, so there's a real upper |limit. If you get into paging it gets too complex and it's time for a |real data |provider. | |XML suffers from having to parse the file, looking for special |characters, then a |lookup match for each field for each record. |Binary on the other hand you can write the length of each record as the record |prefix so you just read in chunks of bytes, splitting each field either |at fixed length |(really quick) or having variable length prefixed with their length. |Eg | |User | FirstNameGreg/FirstName |LastNameKeogh/LastName |User | |Becomes | |30 4 Greg 5 Keogh | |Where the 30 is the first dword (4 bytes), 4 is the next (4 bytes), |then parse the |string which is 4 Char (wide is 8 bytes) next 4 bytes is the value of |5, then parse |the 5 chars (10 bytes) | |The problem with doing binary is if they change the schema, it's a real PITA to |change the code. | | | ||-Original Message- ||From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet- ||boun...@ozdotnet.com] On Behalf Of Greg Keogh ||Sent: Tuesday, 4 June 2013 12:25 PM ||To: ozDotNet ||Subject: Lightweight database || ||Folks, an app has just grown with a new feature that needs to store ||of |users, ||jobs and reports and the joins between them, If I was using SQLite ||it |would be ||3 tables with joins. However, rather than use SQLite this time I'd ||like to |consider ||an alternative that's even more lightweight to setup and use. The app ||does |not ||currently use any database technology and the guys managing the ||project are actually scared of them. || ||Can anyone recommend an in-process database (not necessarily ||relational!) |that ||is has a friendly managed API, small footprint, not too complicated ||and is |easy to ||get going? I know this is a lot to ask, but there may be some NoSQL ||options around that I'm not aware of. The most important issues for me ||are: (1) |Minimal ||dependencies (2) Simple managed API. || ||I'm running a few web searches now for such things, and I can see ||Redis, |Mongo, ||Couch, Raven, db4o, Cassandra, Eloquera, Lucene, and the list goes on ||and |on. ||There are too many choices and it would take many days of hard slog to ||work |out ||which one would be suitable. So perhaps someone has already been ||through |this ||process?! || ||I've been tempted many times over the last 10 years to write a pure ||managed single-file database with indexes, and nothing much else (no ||transactions, |no ||client-server, no schemas, etc). However, I decided to leave it to the |experts, and ||it looks like there are too many of them, and they all over-engineer ||their |works. || ||Cheers, ||Greg K | |
RE: 2 problems
:) Nice one Joseph! 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 From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Joseph Cooney Sent: Tuesday, 28 May 2013 11:38 AM To: ozDotNet Subject: Re: 2 problems Some people have a problem and think I know, I'll use floating point numbers, now they have 1.7 problems. On 28 May 2013 11:32, mike smith meski...@gmail.com mailto:meski...@gmail.com wrote: * Some people, when confronted with a problem, think, I know, I'll use regular expressions. Now they have two problems. https://joindiaspora.com/posts/1653418 Multithreading's my favourite. -- Meski http://courteous.ly/aAOZcv 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: Sending emails from extra domains in Office 365
Hi Greg, Overall, I’ve been really happy with Office 365. I can’t imagine going back to use anything else. We’re weaning ourselves of all such Google services. My main frustrations have been related to Telstra support for it. I wish they weren’t part of the loop in dealing with it in Australia as they don’t seem to add value to it, just an additional layer of complexity and delay in support. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.comhttp://www.sqldownunder.com/ From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Wood Sent: Saturday, 27 April 2013 9:14 PM To: ozDotNet Subject: Re: Sending emails from extra domains in Office 365 Hi Greg, Have you switched from Google hosted to Office 365 now? Thoughts? comments? worth the hassle just yet? Greg Wood g...@woodgreg.commailto:g...@woodgreg.com 0417044439 On Fri, Apr 26, 2013 at 5:57 PM, GregAtGregLowDotCom g...@greglow.commailto:g...@greglow.com wrote: Spoke too soon. That still didn't work correctly. Loryan’s suggestion of a DL still seems to be the correct one. What I had to do was: 1. Remove the extra email address from the user 2. Create a distribution list that holds just that user 3. Configure the DL to have the target email address 4. Using Powershell, assign “SendAs” permission on the DL to that user: Start Powershell Enter your primary office 365 credentials using this command PS $MyCreds = Get-Credential Start a new session to the server PS $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $MyCreds -Authentication Basic -AllowRedirection PS Import-PSSession $Session Check the real name of the target distribution list PS Get-Group * Assign SendAs permission to the user PS Add-RecipientPermission distributionlistname -AccessRights SendAs -Trustee primaryuser When prompted, confirm that you want to assign it 5. When sending, choose the “From” option, from that pick the groups option, select the new group, and make sure the “Sending As” is still pointing to the primary user Hope that helps someone else. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410tel:%2B61%20419201410 mobile│ +61 3 8676 4913tel:%2B61%203%208676%204913 fax SQL Down Under | Web: www.sqldownunder.comhttp://www.sqldownunder.com -Original Message- From: ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Mark Hurd Sent: Friday, 26 April 2013 5:24 PM To: ozDotNet Subject: Re: Sending emails from extra domains in Office 365 Ha! That's what I do with Outlook Express. I didn't think it'd still be the same! -- Regards, Mark Hurd, B.Sc.(Ma.)(Hons.) On 26 April 2013 11:50, g...@greglow.commailto:g...@greglow.com wrote: Magic Grant. That's the winner. It's a pity that it's necessary but this would of course work and is simpler. Regards, Greg -Original Message- From: Grant Castner [mailto:gcast...@castnerit.commailto:gcast...@castnerit.com] Sent: Wednesday, 24 April 2013 9:25 PM To: Greg Low; 'ozDotNet' Subject: RE: Sending emails from extra domains in Office 365 Hi Greg, One more option if you are using Outlook. It involves setting up a phantom POP account. More information on using distribution lists as well. http://community.office365.com/en-us/forums/158/p/12859/58290.aspx Cheers, Grant -Original Message- From: ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low Sent: Wednesday, 24 April 2013 5:52 PM To: 'Ian Thomas'; 'ozDotNet' Subject: RE: Sending emails from extra domains in Office 365 Wow, that's interesting thanks Ian. So it looks like the only way of doing it is to set up a distribution group for each email address rather just adding the email address to each user. I'll give it a shot tomorrow. Regards, Greg Greg Maybe this is the way to do it? http://community.office365.com/en-us/forums/158/t/22116.aspx Otherwise, I know a SMBiT Pro member (Robert Crane, in Brisbane) who would be able to definitively answer your question. Ian Thomas Victoria Park, Western Australia -Original Message- From: ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low Sent: Wednesday, April 24, 2013 3:01 PM To: 'Mark Hurd'; ozDotNet Subject: RE: Sending emails from extra domains in Office 365 Yes, I'm guessing the answer is going to be that you can't... (I was trying to replace our use of Gmail) Regards, Greg -Original Message- From