RE: UPS

2013-07-25 Thread David Ames
Take a read of this thread: http://forums.whirlpool.net.au/archive/1611656

It states that Australia power standards are 230 volts, +10%, -6%.

Apparently it changed a while ago from 240v to 230v.


Dave


From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Tony Wright
Sent: Thursday, 25 July 2013 12:35 PM
To: ozDotNet
Subject: Re: UPS

Just spoke with my brother about it. He says unfortunately with grid connected 
solar you are still affected by the voltage of the grid. In his case, he can 
disconnect from the grid and in that case it outputs at 48v, then an 
inverter(?) boosts it up to close to 240v (48 x 5). He has measured and it is 
usually sits around 235 volts when he does this. But when he is connected to 
the grid, he gets wild fluctuations which he says he's proven are caused 
entirely by the grid and not his solar set up. His voltages have been between 
245 and 267 at times (in Brunswick.)

He says you might be able to make a complaint to the grid authority because 
your voltages are outside of Australian Standards, which he says is +/-10% 
around 240 volts (so a minimum of 216 volts)

On Thu, Jul 25, 2013 at 12:15 PM, Paul Keen 
pak...@bigpond.net.aumailto: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.commailto:ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.commailto: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 419201410tel:%2B61%20419201410 mobile│ 
+61 3 8676 4913tel:%2B61%203%208676%204913 fax
SQL Down Under | Web: www.sqldownunder.comhttp://www.sqldownunder.com/

From: ozdotnet-boun...@ozdotnet.commailto: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: [OT] My New Pluralsight Course

2013-06-20 Thread David Ames
No worries ☺

https://pluralsight.com/training/Subscribe/Step1?isTrial=True


Free 10day trial via the above link.


Dave


From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Wallace Turner
Sent: Thursday, 20 June 2013 9:31 PM
To: ozDotNet
Subject: Re: [OT] My New Pluralsight Course

since you are in the business of spamming the list could you provide a free 
copy of your content please?

On Wed, Jun 19, 2013 at 10:11 AM, 
jasi...@yahoo.co.ukmailto:jasi...@yahoo.co.uk wrote:
Hi all,

My new Pluralsight course has just been released “Automated Testing: End to End”


http://bit.ly/pstesting


We shouldn't live in fear of our code. Long-term customer satisfaction, 
product agility, and developer happiness are crucial. A quality suite of 
automated tests helps achieve this. This practical course covers how and what 
to test at the unit, integration, and functional UI levels; and how to bring 
them all together with continuous integration build server.

Hope wherever you are in Oz you’re having a great morning #128522;

Cheers
Jason

Sent from Windows Mail




RE: Making an application that uses identity keys occassionally connected

2012-02-05 Thread David Ames
GUIDs (even by newSequencialID) are 4 times are large as INT's and if you are 
using them as the Clustering Key as well as the primary key, then all of your 
non-clustered indexes are bigger then they need to be too.

Kim Tripp probably says it best with her article: 
http://sqlskills.com/BLOGS/KIMBERLY/post/Disk-space-is-cheap.aspx

I have used sequential guid's in the past  if there is a lack of good 
candidate for the clustering key on the table, we put an int/identity on the 
table purely to serve as the clustered index (ie, the logical DB model does not 
use the int/identity at all).

The down side is that you are wasting your clustered index in order to make 
other indexes smaller.

Dave


From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Keogh
Sent: Monday, 6 February 2012 11:28 AM
To: 'ozDotNet'
Subject: RE: Making an application that uses identity keys occassionally 
connected

Folks, most people here seem to dislike Guids as primary keys. The 
articlehttp://www.codeproject.com/Articles/32597/Performance-Comparison-Identity-x-NewId-x-NewSeque
 via Bill is quite sobering, showing that NEWID is a shocking performer, but 
INDENTIY and NEWSEQUENTIALID perform similarly well. After reading that I am 
unlikely to use NEWID again.

I would still like to hear convincing arguments against NEWSEQUENTIALID. Noonie 
says his DBAs rejected them (why?). Tony hates looking at them in the debugger 
(that's not a convincing argument for me). Greg L says you might as well get an 
INT instead (more details?).

I hope you'll agree that there are times when you want to give rows an 
immutable primary key. Will you also agree that an IDENTITY INT is not 
immutable because it can change when rows move across databases or when rows 
are reorganised or reloaded. If this is so, how on earth do you stamp your rows 
with an immutable key without using something like Guids?

Greg


RE: Making an application that uses identity keys occassionally connected

2012-02-01 Thread David Ames

If your only talking a small number of clients you can play with seed/increment 
values.

Eg:
Node 1: Seed = 1, Increment = +2
Node 2: Seed = 2, Increment = +2
Node 3: Seed = -1, Increment = -2
Node 4: Seed = -2, Increment = -2


You can also assign ranges (and run the risk of running out of numbers in the 
range)
Node 1, Seed = 1
Node 2, Seed = 100,000
Node 3, Seed = 200,000
Node 4, Seed = 300,000


You could also use a GUID as the PK, set default = newSequentialid () to keep 
fragmentation down.

Dave




From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Kirsten Greed
Sent: Thursday, 2 February 2012 7:52 AM
To: 'ozDotNet'
Subject: Making an application that uses identity keys occassionally connected

Hi All
I am interested in making my application occasionally connected.
My app uses SQL Server and the tables have identity keys (auto incrementing 
numbers)
I can see this will be a problem if I have 2 databases on separate computers 
because they will both want to assign a new record to the same key.
Indeed when I experimented with Microsoft Sync Framework 2, this is what 
happened.
Any advice on a strategy forward?
Thanks
Kirsten