RE: Sending emails from extra domains in Office 365

[Greg Low (GregLow.com)]

Sorry, have no idea why that one ended up blank. This was it:

 

Hi Folks,

 

Office 365 had the option to add another domain so you can receive email
addressed to another domain.

 

Ie: if you are a...@lincoln.com in Office 365, you can add abelincoln.com as
an extra domain, then add a...@abelincoln.com as an extra email address to
receive mail on.

 

Anyone how you to then send email in Office 365 from a...@abelincoln.com?

 

Regards,

 

Greg

 

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 (GregLow.com) [mailto:g...@greglow.com] 
Sent: Wednesday, 24 April 2013 1:58 PM
To: 'ozDotNet' (ozdotnet@ozdotnet.com)
Subject: Sending emails from extra domains in Office 365

 

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

 

 

Sending emails from extra domains in Office 365

[Greg Low (GregLow.com)]

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:   www.sqldownunder.com

 

 

RE: 1300 Number

[Greg Low (GregLow.com)]

Hi Corneliu,

 

We've had a good run with:  
http://callstream.com.au/

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Corneliu I. Tusnea
Sent: Tuesday, 23 April 2013 12:06 PM
To: ozDotNet
Subject: 1300 Number

 

Hi,

 

Could I get some recommendations for hosting our 1300 number?

At the moment I'm with AllTel and their cost is quite acceptable but I'm
thinking of finding a cheaper provider.

 

PS> Also, any recommendations for a VirtualPBX system? Preferably something
cloud hosted, that can route numbers for US, AU, NZ, UK and also if possible
work with Skype :)

I'm testing Zaplee which I have to say it's quite nice.

 

Thanks,

Corneliu.

RE: MVC4 URLs

[Greg Low (GregLow.com)]

Hi Corneliu,

 

Yes, I had thought about constructing it based on the host, the protocol, and 
the action requirements. However, if the app was installed in a virtual 
directory below the root of the site, I’m presuming that wouldn’t work.

 

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, 12 April 2013 10:02 PM
To: ozDotNet
Subject: Re: MVC4 URLs

 

Greg,

 

Instead of using the AbsolutUri and changing it look at the 
HttpContext.Requst.Url.Host and add the Url.Action.

However I'd strongly recommend you look at HttpContext.Request.Headers["host"] 
and take the part before the ":" just in case your side responds to various 
host names.

Eg.. subdomain1.site.com <http://subdomain1.site.com>  and subdomain2.site.com 
<http://subdomain2.site.com> 

 

I'm sure you can push that into a nice extension method like Tony's one.

 

Regards,

Corneliu. 

 

On Fri, Apr 12, 2013 at 9:26 PM, Tony McGee mailto:tmc...@pacific.net.au> > wrote:

A problem with using string replace is that if your absolute path is "/" (site 
root /Home/Index), the URI gets mangled, 
i.e.  http:www.example.com/SomeController/SomeAction 
<http://www.example.com/SomeController/SomeAction> 

I'd be tempted to create an extension method on UrlHelper to hide some of the 
ugliness:

public static class UrlHelperExtensions
{
public static string AbsoluteAction(this UrlHelper helper, string 
actionName, string controllerName)
{
string absUri = 
helper.RequestContext.HttpContext.Request.Url.AbsoluteUri;
string urlPath = 
helper.RequestContext.HttpContext.Request.Url.PathAndQuery;
return absUri.Substring(0, absUri.Length - urlPath.Length) + 
helper.Action(actionName, controllerName);
}
}

then in your controller:

string returnURI = Url.AbsoluteAction("SomeAction","SomeController");




On 12/04/2013 18:51, Greg Low (GregLow.com) wrote:

Hi Nathan/Dave, 

 

This seems to work but seems ugly:

 

string returnURI = 
HttpContext.Request.Url.AbsoluteUri.Replace(HttpContext.Request.Url.AbsolutePath,"")
 

+ Url.Action("SomeAction", "SomeController");

 

I need to generate it based on where the site is deployed but it needs to be a 
full URL as it’s passed to a callback function on another site.

 

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 Dave Walker
Sent: Friday, 12 April 2013 5:43 PM
To: ozDotNet
Subject: Re: MVC4 URLs

 

We use a helper extension method to wrap as have configurable cdn esp. for 
images and other static resources. Was the only way we found we could do it. 
Extra complexity for us is we wrap a SquishIt bundle up as well to turn on/off 
minification and combination of files.


On 12 Apr 2013, at 08:32, Nathan Schultz mailto:milish...@gmail.com> > wrote:

Instead of using Url.Action, couldn't you just write your own ?

 

On 12 April 2013 11:17, Greg Low (GregLow.com <http://GregLow.com> ) 
mailto:g...@greglow.com> > wrote:

Hi Folks,

 

In MVC4, in the code for a controller, what’s the best way to calculate the 
fully qualified URL for a particular action?

 

Eg: If I use 

 

Url.Action(“SomeAction”,”SomeController”)

 

The intellisense for Action says “gets a fully qualified URL”. However what I 
get back is:

 

/SomeController/SomeAction

 

What I want is:

 

http://www.whateversiteIhit.com/SomeController/SomeAction 
<http://www.somesite.com/SomeController/SomeAction> 

 

As I need to pass it to an external callback.

 

What’s the best way to do 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: SQL Azure insert speed

[Greg Low (GregLow.com)]

Yes, as Craig mentioned, Red Gate bought Cerebrata recently. I've been using
Cerebrata Cloud Explorer and have been very happy with it. This new one
looks like a free cut-down version of the same tool.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Thursday, 18 April 2013 10:14 AM
To: ozDotNet
Subject: Re: SQL Azure insert speed

 

Hi Ian, I found this:

 

http://www.cerebrata.com/labs/azure-explorer

 

But I can't find a Red Gate Azure Explorer, unless this is the same thing. I
have been playing with Azure Storage Explorer version 5 preview 1 from
Neudesic, which is simple and clean, but I haven't pushed it very hard.

 

Wait, hang on, the installer is telling me that Azure Explorer publisher is
Red Gate, so it is the same thing. I'll give it a try, but will Red Gate
eventually make us pay for it? Hmmm.

 

Greg K

RE: SQL Azure insert speed

[Greg Low (GregLow.com)]

Hi Greg,

 

The issue that you're facing is latency. You are correct in assuming that
the way you're used to doing it is not really appropriate for Azure.

 

For example:

 

I have script to contain a DB and insert about 20MB of data. To run it
locally takes 50 seconds. Point the connection at SQL Azure and the same
script runs in 14 minutes.

 

However, if I export the DB to a BACPAC in Azure Storage, then import it to
a SQL Database, the whole process takes about 1 minute.

 

We've found a need to modify much of what we'd normally do on-premises when
working in this environment.

 

Regards,

 

Greg

 

Dr Greg Low

 

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


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Sunday, 14 April 2013 5:57 PM
To: ozDotNet
Subject: SQL Azure insert speed

 

Folks, I'm using EF4 to insert 3900 rows in to a table. Due to a performance
quirk/bug in EF I have to insert them in groups of 50 with a fresh context
for each group. In SQL Server and SQLite all rows insert in about 2 minutes.
With an identical table in SQL Azure the same inserts take about 20 minutes.

 

Now either SQL Azure has insert performance problems, or my insertion
technique is not valid for Azure. If anyone here is using SQL Azure in anger
then I'm keen to hear of any performance problems and/or workarounds you've
found.

 

Greg K

RE: Office365 ?

[Greg Low (GregLow.com)]

While I’d love fibre to the house, project management is the one that’s my 
biggest concern. 

 

Clichés about inability to run chook raffles, even when given chooks, 
customers, wheels and comperes come to mind.

 

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

 

From: ozdotnet-boun...@ozdotnet.com   
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Connors
Sent: Saturday, 13 April 2013 5:45 PM
To: ozDotNet
Subject: Re: Office365 ?

 



And I've not event touched on the fact that this will be a project management 
failure case study for students to write essays on for years to come. They are 
rolling out at 0.3% of the pace they are supposed to last time I punched the 
numbers (but we're ramping up, honest gov! It's only been 5 years to connect 
15K homes but the next half million are nearly here!) 

 

David

RE: Website title bar image

[Greg Low (GregLow.com)]

Thanks Michael & Yann,

 

I've added one. It's a real challenge to try to have something that looks
good in that resolution though.

 

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: Yann Duran [mailto:y...@yannduran.com] 
Sent: Friday, 12 April 2013 7:01 PM
To: Greg Low; ozDotNet
Subject: RE: Website title bar image

 

Hi Greg,

 

It's called a favicon.

 

Yann

 

From: ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com>
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (GregLow.com)
Sent: Friday, 12 April 2013 6:30 PM
To: 'ozDotNet'
Subject: Website title bar image

 

Hi Folks,

 

What property on a website is used to configure this icon:

 



 



 

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: MVC4 URLs

[Greg Low (GregLow.com)]

Hi Nathan/Dave, 

 

This seems to work but seems ugly:

 

string returnURI = 
HttpContext.Request.Url.AbsoluteUri.Replace(HttpContext.Request.Url.AbsolutePath,"")
 

+ Url.Action("SomeAction", "SomeController");

 

I need to generate it based on where the site is deployed but it needs to be a 
full URL as it’s passed to a callback function on another site.

 

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 Dave Walker
Sent: Friday, 12 April 2013 5:43 PM
To: ozDotNet
Subject: Re: MVC4 URLs

 

We use a helper extension method to wrap as have configurable cdn esp. for 
images and other static resources. Was the only way we found we could do it. 
Extra complexity for us is we wrap a SquishIt bundle up as well to turn on/off 
minification and combination of files.


On 12 Apr 2013, at 08:32, Nathan Schultz mailto:milish...@gmail.com> > wrote:

Instead of using Url.Action, couldn't you just write your own ?

 

On 12 April 2013 11:17, Greg Low (GregLow.com <http://GregLow.com> ) 
mailto:g...@greglow.com> > wrote:

Hi Folks,

 

In MVC4, in the code for a controller, what’s the best way to calculate the 
fully qualified URL for a particular action?

 

Eg: If I use 

 

Url.Action(“SomeAction”,”SomeController”)

 

The intellisense for Action says “gets a fully qualified URL”. However what I 
get back is:

 

/SomeController/SomeAction

 

What I want is:

 

http://www.whateversiteIhit.com/SomeController/SomeAction 
<http://www.somesite.com/SomeController/SomeAction> 

 

As I need to pass it to an external callback.

 

What’s the best way to do 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

 

 

 

Website title bar image

[Greg Low (GregLow.com)]

Hi Folks,

 

What property on a website is used to configure this icon:

 



 



 

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:   www.sqldownunder.com

 

 

<><>

RE: Office365 ?

[Greg Low (GregLow.com)]

2027?

 

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 mike smith
Sent: Friday, 12 April 2013 4:22 PM
To: ozDotNet
Subject: Re: Office365 ?

 

On Fri, Apr 12, 2013 at 2:01 PM, Stephen Price mailto:step...@perthprojects.com> > wrote:

This seems like an appropriate point to troll this thread and mention the NBN. 
Bwhahahahaha.. 

 

Hey it IS Friday. :)

 

 

Vote for the NBN.  Until it's finished, and then vote to your taste.

 

 

On Fri, Apr 12, 2013 at 10:41 AM, David Connors mailto:da...@connors.com> > wrote:

EXACTLY. On a related note, I am always amused at these cloud providers using 
geographical maps rather than network topological ones to determine where to 
put their customers. Both Salesforce and Microsoft put their Aussie customer 
sin Singers, presumably because they see us as part of APAC or that magical 
land called Oceania, and therefore nearby.

 

Depending on your transit provider, it is very likely that your IP transit to 
Singapore goes via Japan and that path is actually slow than going to the West 
coast of the USA. 

 

Sometimes I think Google and Amazon are the only two large companies who know 
how the Internet actually works ... and it is going to get a LOT worse with 
software defined networking. 




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

 

On Fri, Apr 12, 2013 at 12:36 PM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

And ironically, that’s value that Telstra really could potentially bring to the 
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: David Connors [mailto:da...@connors.com <mailto:da...@connors.com> ] 
Sent: Friday, 12 April 2013 12:34 PM
To: Greg Low
Cc: ozDotNet; Corneliu I. Tusnea
Subject: Re: Office365 ?

 

The solution for small business will be to wait for MS to do their own voice in 
the same DCs. They need to digitus extractus and get infrastructure in Oz to 
make that work (unless you want a local call for a pizza to have the same lag 
as a call to the US or Singapore via Japan).

 

Multi-tennant voice platforms are always pretty ratshit though. It'll be 
interesting to see how it pans out. 




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

 

On Fri, Apr 12, 2013 at 12:31 PM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Agreed, but not every Office365 customer is an enterprise customer. One of the 
benefits of things like Office 365 is that it allows big company options for 
small companies that couldn’t otherwise arrange it themselves, or don’t have 
the personnel to implement it.

 

In most cases, I see these people falling back to using Skype instead, and 
you’re back on the Internet anyway.

 

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: David Connors [mailto:da...@connors.com <mailto:da...@connors.com> ] 
Sent: Friday, 12 April 2013 12:14 PM
To: Greg Low; ozDotNet
Cc: Corneliu I. Tusnea
Subject: Re: Office365 ?

 

To do voice properly, at an enterprise level, you need to QoS the shit out of 
the links and preferrably use private IP/dedicated connections to the VOIP 
provider. If you do that, VOIP is pretty much as good as PSTN.

 

If you want to run it over the intarwebs, well, good luck with that.




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

 

On Fri, Apr 12, 2013 at 11:42 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

I don’t see any real reason why the US providers of Lync to PSTN integration 
couldn’t offer services to Australia. I’d be happy to have VOIP calls back 
to/from Australia when making/returning calls. You’d think you’d be able to 
just connect a local SIP endpoint to the IP of those overseas providers. I’ve 
done that in the past

RE: [OT] Surface RT or Surface Pro?

[Greg Low (GregLow.com)]

I think they are responding to the BYOD movement as well. The days of IT
staff defining an SOE and forcing everyone to use it are gone, or at least
disappearing fast. It's really common to have top-down decisions on this
stuff now ie: CEOs coming in with their tablets and saying "make it work
here".

 

I've just spent quite a bit of time moving around dozens of software houses,
and I can tell you that almost everyone has an HTML5/CSS3/JS story. They see
it as a design choice that isn't going to disappear again tomorrow, even
though building apps there is still so much harder than what it should be.
It's seen as a hard but safe bet. Most are using additional frameworks like
KendoUI.

 

This sort of change isn't new though. What does concern me is the loss of
productivity we've had over the years. 

 

We didn't move to web apps in the first place because users were screaming
out for slow delivery times, a lousy user interface and session state that's
likely to throw away their work without warning. As an example, OWA is a
pretty good web app but it's not a patch on Outlook. The initial move to web
apps was all about IT departments not wanting to deal with deployment
issues, because they were just too hard sometimes.

 

I see this as just the next part of this trend. I look at productivity
though and it could make you cry. I've just spent a couple of weeks coding
in an MVC4 project, and while I like it and can see the appeal of it, I
can't help but thinking I could have created the same business functionality
in a winforms app in less than a day. At least it runs all over the place
(sort of).

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Corneliu I. Tusnea
Sent: Friday, 12 April 2013 3:04 PM
To: ozDotNet
Subject: Re: [OT] Surface RT or Surface Pro?

 

Yes, but by the time .Net developers started to use WebServices everyone
else moved on to REST as they figured out WS were bloody hard to use,
incompatible between platforms, heavyweight, hard to upgrade and generally a
pain in the *** to develop against :)

Now everyone is talking lightweight REST + JSON and we just managed finally
to get that in the WebApi ...

 

On Fri, Apr 12, 2013 at 2:53 PM, Tom Rutter mailto:therut...@gmail.com> > wrote:

Wasn't the original intent for .net to be for creating web services?

 

On Thu, Apr 11, 2013 at 3:47 AM, Katherine Moss mailto:katherine.m...@gordon.edu> > wrote:

Then why are the  majority rather than the  minority of windows 8 modern
apps (I hate that term when talking about computers and servers, belongs on
a mobile phone), nearly all written in pure HTML5 and JS?  Where's the C# or
VB in them?  And touting HTML5 and JS more than the .net framework sounds
more like a kill-off rather than an enhancement.  

 

From: ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com 
] On Behalf Of Arjang Assadi
Sent: Wednesday, April 10, 2013 6:12 AM


To: ozDotNet
Subject: Re: [OT] Surface RT or Surface Pro?

 

Not taken over but augmented with, .net still reigns supreme, js and html
allow one to rich the poorest of places in terms of OS and framework.
Knowing knockout, backbone etc. is a must for any .net programmer.

 

On 10 April 2013 19:15, Bec Carter mailto:bec.usern...@gmail.com> > wrote:

.net taken over by html and js? Haha looks like the pendulum is swinging
back again

 

On Wed, Apr 10, 2013 at 4:57 AM, Katherine Moss mailto:katherine.m...@gordon.edu> > wrote:

I disagree, still.  WPF was expanded for instance, from versions 4.0 to 4.5
of the .net framework significantly from what I can tell from MSDN.  And
besides, since Windows 8 modern apps are so limited in their feature set
compared to what we know currently today, I sort of consider Microsoft a
little crazy for thinking that everyone's going to accept less than what
they have now.  And that's what scares me about the "Gemini" update for
Office coming in the future since in order to metro-ize Office completely,
according to sources of Mary Joe Fowley on All About Microsoft over at
ZDNet, she says that what people are telling her is that the update will be
a subset of the current feature set.  And that's what gets me; what about
enthusiasts who need more than just a Fisher Price version?  What if we want
all of the cool features?  What is Microsoft telling us to do, never move on
because they are interested in depleting stuff?  

And then in terms of .net being taken over by HTML and JavaScript?  How much
more 1990's can you get?  Come on, jees.  I'll never accept a version of
Windows or it's successors without .net installed and living in some form.  

 

From: ozdotnet-boun...@ozdotnet.com 

MVC4 URLs

[Greg Low (GregLow.com)]

Hi Folks,

 

In MVC4, in the code for a controller, what's the best way to calculate the
fully qualified URL for a particular action?

 

Eg: If I use 

 

Url.Action("SomeAction","SomeController")

 

The intellisense for Action says "gets a fully qualified URL". However what
I get back is:

 

/SomeController/SomeAction

 

What I want is:

 

http://www.whateversiteIhit.com/SomeController/SomeAction
 

 

As I need to pass it to an external callback.

 

What's the best way to do 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:   www.sqldownunder.com

 

 

RE: Office365 ?

[Greg Low (GregLow.com)]

And ironically, that’s value that Telstra really could potentially bring to the 
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: David Connors [mailto:da...@connors.com] 
Sent: Friday, 12 April 2013 12:34 PM
To: Greg Low
Cc: ozDotNet; Corneliu I. Tusnea
Subject: Re: Office365 ?

 

The solution for small business will be to wait for MS to do their own voice in 
the same DCs. They need to digitus extractus and get infrastructure in Oz to 
make that work (unless you want a local call for a pizza to have the same lag 
as a call to the US or Singapore via Japan).

 

Multi-tennant voice platforms are always pretty ratshit though. It'll be 
interesting to see how it pans out. 




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

 

On Fri, Apr 12, 2013 at 12:31 PM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Agreed, but not every Office365 customer is an enterprise customer. One of the 
benefits of things like Office 365 is that it allows big company options for 
small companies that couldn’t otherwise arrange it themselves, or don’t have 
the personnel to implement it.

 

In most cases, I see these people falling back to using Skype instead, and 
you’re back on the Internet anyway.

 

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: David Connors [mailto:da...@connors.com <mailto:da...@connors.com> ] 
Sent: Friday, 12 April 2013 12:14 PM
To: Greg Low; ozDotNet
Cc: Corneliu I. Tusnea
Subject: Re: Office365 ?

 

To do voice properly, at an enterprise level, you need to QoS the shit out of 
the links and preferrably use private IP/dedicated connections to the VOIP 
provider. If you do that, VOIP is pretty much as good as PSTN.

 

If you want to run it over the intarwebs, well, good luck with that.




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

 

On Fri, Apr 12, 2013 at 11:42 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

I don’t see any real reason why the US providers of Lync to PSTN integration 
couldn’t offer services to Australia. I’d be happy to have VOIP calls back 
to/from Australia when making/returning calls. You’d think you’d be able to 
just connect a local SIP endpoint to the IP of those overseas providers. I’ve 
done that in the past with Lync on-premises. But every one of the US ones that 
I’ve talked to, just says “oh Australia, we can’t do that yet”. It’s hard to 
see why.

 

You could presumably sign up in the US, if you have a credit card with a US 
billing address.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au 
<mailto:corne...@acorns.com.au> ] 
Sent: Friday, 12 April 2013 11:36 AM
To: Greg Low; ozDotNet
Subject: Re: Office365 ?

 

Thanks, that's great info.

 

Any idea of a "low-cost" service to turn Lync into PABX? Could I connect it to 
my iiNet iiTalk?

Could I buy Office365 + Lync E4 from US or is Telstra really the only option?

 

Thanks,

Corneliu.

 

 

On Fri, Apr 12, 2013 at 11:02 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Product = great. Telstra support = very poor. If we could deal directly with 
Microsoft, it would be far superior. Telstra seem to just add a layer of 
additional complexity, plus a big delay in support issues. You have to deal 
with them first for support. Generally they later pass it on to Microsoft for 
resolution but I’ve recently had it take a week for them to do that. I would 
have saved a week if we could have dealt directly with Microsoft support. Also, 
Telstra support is only available Mon-Fri business hours. That on its own is 
enough to exceed many business SLAs.

 

Lync that comes with the E3 offering is ok but biggest missing thing with Lync 
is built-in PSTN integration. There are some local companies that can help to 
provide that but there currently isn’t an E4 offering for Australia, apart from 
you providing your own on-premises Lync server. There are several options for 
those that are US-based. You can sign up to low-cost 

RE: Office365 ?

[Greg Low (GregLow.com)]

Agreed, but not every Office365 customer is an enterprise customer. One of the 
benefits of things like Office 365 is that it allows big company options for 
small companies that couldn’t otherwise arrange it themselves, or don’t have 
the personnel to implement it.

 

In most cases, I see these people falling back to using Skype instead, and 
you’re back on the Internet anyway.

 

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: David Connors [mailto:da...@connors.com] 
Sent: Friday, 12 April 2013 12:14 PM
To: Greg Low; ozDotNet
Cc: Corneliu I. Tusnea
Subject: Re: Office365 ?

 

To do voice properly, at an enterprise level, you need to QoS the shit out of 
the links and preferrably use private IP/dedicated connections to the VOIP 
provider. If you do that, VOIP is pretty much as good as PSTN.

 

If you want to run it over the intarwebs, well, good luck with that.




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

 

On Fri, Apr 12, 2013 at 11:42 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

I don’t see any real reason why the US providers of Lync to PSTN integration 
couldn’t offer services to Australia. I’d be happy to have VOIP calls back 
to/from Australia when making/returning calls. You’d think you’d be able to 
just connect a local SIP endpoint to the IP of those overseas providers. I’ve 
done that in the past with Lync on-premises. But every one of the US ones that 
I’ve talked to, just says “oh Australia, we can’t do that yet”. It’s hard to 
see why.

 

You could presumably sign up in the US, if you have a credit card with a US 
billing address.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au 
<mailto:corne...@acorns.com.au> ] 
Sent: Friday, 12 April 2013 11:36 AM
To: Greg Low; ozDotNet
Subject: Re: Office365 ?

 

Thanks, that's great info.

 

Any idea of a "low-cost" service to turn Lync into PABX? Could I connect it to 
my iiNet iiTalk?

Could I buy Office365 + Lync E4 from US or is Telstra really the only option?

 

Thanks,

Corneliu.

 

 

On Fri, Apr 12, 2013 at 11:02 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Product = great. Telstra support = very poor. If we could deal directly with 
Microsoft, it would be far superior. Telstra seem to just add a layer of 
additional complexity, plus a big delay in support issues. You have to deal 
with them first for support. Generally they later pass it on to Microsoft for 
resolution but I’ve recently had it take a week for them to do that. I would 
have saved a week if we could have dealt directly with Microsoft support. Also, 
Telstra support is only available Mon-Fri business hours. That on its own is 
enough to exceed many business SLAs.

 

Lync that comes with the E3 offering is ok but biggest missing thing with Lync 
is built-in PSTN integration. There are some local companies that can help to 
provide that but there currently isn’t an E4 offering for Australia, apart from 
you providing your own on-premises Lync server. There are several options for 
those that are US-based. You can sign up to low-cost services that turn Lync 
into your PABX. Then it really shines.

 

I was really impressed with how easily I could set up Federations in Lync.

 

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

 

 

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: Friday, 12 April 2013 10:18 AM
To: ozDotNet
Subject: Office365 ?

 

Hi,

 

Anyone tried Office365 + Lync?

Is it worth it? Is it only available via Telstra or can I buy it in other ways? 
How is customer support and what is the quality of Lync vs Skype?

 

Thanks,

Corneliu.

 

 

 

RE: Office365 ?

[Greg Low (GregLow.com)]

I don’t see any real reason why the US providers of Lync to PSTN integration 
couldn’t offer services to Australia. I’d be happy to have VOIP calls back 
to/from Australia when making/returning calls. You’d think you’d be able to 
just connect a local SIP endpoint to the IP of those overseas providers. I’ve 
done that in the past with Lync on-premises. But every one of the US ones that 
I’ve talked to, just says “oh Australia, we can’t do that yet”. It’s hard to 
see why.

 

You could presumably sign up in the US, if you have a credit card with a US 
billing address.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au] 
Sent: Friday, 12 April 2013 11:36 AM
To: Greg Low; ozDotNet
Subject: Re: Office365 ?

 

Thanks, that's great info.

 

Any idea of a "low-cost" service to turn Lync into PABX? Could I connect it to 
my iiNet iiTalk?

Could I buy Office365 + Lync E4 from US or is Telstra really the only option?

 

Thanks,

Corneliu.

 

 

On Fri, Apr 12, 2013 at 11:02 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Product = great. Telstra support = very poor. If we could deal directly with 
Microsoft, it would be far superior. Telstra seem to just add a layer of 
additional complexity, plus a big delay in support issues. You have to deal 
with them first for support. Generally they later pass it on to Microsoft for 
resolution but I’ve recently had it take a week for them to do that. I would 
have saved a week if we could have dealt directly with Microsoft support. Also, 
Telstra support is only available Mon-Fri business hours. That on its own is 
enough to exceed many business SLAs.

 

Lync that comes with the E3 offering is ok but biggest missing thing with Lync 
is built-in PSTN integration. There are some local companies that can help to 
provide that but there currently isn’t an E4 offering for Australia, apart from 
you providing your own on-premises Lync server. There are several options for 
those that are US-based. You can sign up to low-cost services that turn Lync 
into your PABX. Then it really shines.

 

I was really impressed with how easily I could set up Federations in Lync.

 

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

 

 

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: Friday, 12 April 2013 10:18 AM
To: ozDotNet
Subject: Office365 ?

 

Hi,

 

Anyone tried Office365 + Lync?

Is it worth it? Is it only available via Telstra or can I buy it in other ways? 
How is customer support and what is the quality of Lync vs Skype?

 

Thanks,

Corneliu.

 

 

RE: Office365 ?

[Greg Low (GregLow.com)]

Product = great. Telstra support = very poor. If we could deal directly with
Microsoft, it would be far superior. Telstra seem to just add a layer of
additional complexity, plus a big delay in support issues. You have to deal
with them first for support. Generally they later pass it on to Microsoft
for resolution but I've recently had it take a week for them to do that. I
would have saved a week if we could have dealt directly with Microsoft
support. Also, Telstra support is only available Mon-Fri business hours.
That on its own is enough to exceed many business SLAs.

 

Lync that comes with the E3 offering is ok but biggest missing thing with
Lync is built-in PSTN integration. There are some local companies that can
help to provide that but there currently isn't an E4 offering for Australia,
apart from you providing your own on-premises Lync server. There are several
options for those that are US-based. You can sign up to low-cost services
that turn Lync into your PABX. Then it really shines.

 

I was really impressed with how easily I could set up Federations in Lync.

 

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:   www.sqldownunder.com

 

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Corneliu I. Tusnea
Sent: Friday, 12 April 2013 10:18 AM
To: ozDotNet
Subject: Office365 ?

 

Hi,

 

Anyone tried Office365 + Lync?

Is it worth it? Is it only available via Telstra or can I buy it in other
ways? How is customer support and what is the quality of Lync vs Skype?

 

Thanks,

Corneliu.

 

RE: PowerPivot?

[Greg Low (GregLow.com)]

Ah, sorry, yes was forgetting that the updates only seem to affect the Excel 
2010 bits.

 

I am running Excel 2013, and I’d have to say that I do find the PowerPivot 
designer in it buggy. I’ve often broken it. By comparison, the designer in SSDT 
seems really solid. Given that it looks like the same code, it just must be a 
challenge in being a complex Excel add-in.

 

Does this setting help with the recalc 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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au] 
Sent: Tuesday, 9 April 2013 10:12 AM
To: Greg Low
Cc: ozDotNet
Subject: Re: PowerPivot?

 

Greg,

 

I don't have SQL installed and I can't seem to find any update for PowerPivot 
for Excel 2013 (not 2012!).

I'm also using PP with a remote OData feed not with SQL ... which makes it much 
slower 

(sidenode: the continuous refreshes while changing column formulas are really 
annoying :))

 

Regards.

Corneliu.

 

 

 

On Tue, Apr 9, 2013 at 9:14 AM, Greg Low mailto:g...@sqldownunder.com> > wrote:

PowerPivot updates come in the SP’s and CU’s for SQL Server.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au 
<mailto:corne...@acorns.com.au> ] 

Sent: Tuesday, 9 April 2013 9:09 AM
To: Greg Low; ozDotNet
Subject: Re: PowerPivot?

 

Is there an SP1 already for Office 2013? I'll check and install.

 

 

On Tue, Apr 9, 2013 at 8:59 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Hi Corneliu,

 

Have you applied the SP1 and/or CU updates to PowerPivot?

 

I found the designer in Excel painful at times. It certainly doesn’t have the 
stability of basically the same designer in SSDT.

 

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, 9 April 2013 8:24 AM
To: ozDotNet
Cc: ozDotNet
Subject: Re: PowerPivot?

 

No VSTO. Just clean Excel + PP. no development tools installed at all. 

The crashes are all while editing formulas in the grids not when running 
pivots. 

 

Also my connection for data is over OData from a remote server which has a bit 
of lag at times. 

 

Regards,

Corneliu. 


On 08/04/2013, at 8:25 PM, Arjang Assadi mailto:arjang.ass...@gmail.com> > wrote:

Are you using it through VSTO? on it' own I have only used it 1 per workbook 
and not with millions of records. 5000 records should very well be easy to 
handle.

 

 

 

On 8 April 2013 18:34, Corneliu I. Tusnea mailto:corne...@acorns.com.au> > wrote:

Hi,

 

Is PowerPivot considered a "Production" product? I'm running it on a 
W8+Office2013 and it's crashing like a beta product. I only have 9 worksheets 
and up to about 5000 rows in each and it's unusable. Once I start entering 
formulas it's practically crashing every few minutes.

I now got it to a point where I can't even open it properly. 

 



 

This is quite disappointing right now :(

 

Am I missing something?

 

Regards,

Corneliu

 

 

 

<>

RE: PowerPivot?

[Greg Low (GregLow.com)]

PowerPivot updates come in the SP’s and CU’s for SQL Server.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au] 
Sent: Tuesday, 9 April 2013 9:09 AM
To: Greg Low; ozDotNet
Subject: Re: PowerPivot?

 

Is there an SP1 already for Office 2013? I'll check and install.

 

 

On Tue, Apr 9, 2013 at 8:59 AM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Hi Corneliu,

 

Have you applied the SP1 and/or CU updates to PowerPivot?

 

I found the designer in Excel painful at times. It certainly doesn’t have the 
stability of basically the same designer in SSDT.

 

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, 9 April 2013 8:24 AM
To: ozDotNet
Cc: ozDotNet
Subject: Re: PowerPivot?

 

No VSTO. Just clean Excel + PP. no development tools installed at all. 

The crashes are all while editing formulas in the grids not when running 
pivots. 

 

Also my connection for data is over OData from a remote server which has a bit 
of lag at times. 

 

Regards,

Corneliu. 


On 08/04/2013, at 8:25 PM, Arjang Assadi mailto:arjang.ass...@gmail.com> > wrote:

Are you using it through VSTO? on it' own I have only used it 1 per workbook 
and not with millions of records. 5000 records should very well be easy to 
handle.

 

 

 

On 8 April 2013 18:34, Corneliu I. Tusnea mailto:corne...@acorns.com.au> > wrote:

Hi,

 

Is PowerPivot considered a "Production" product? I'm running it on a 
W8+Office2013 and it's crashing like a beta product. I only have 9 worksheets 
and up to about 5000 rows in each and it's unusable. Once I start entering 
formulas it's practically crashing every few minutes.

I now got it to a point where I can't even open it properly. 

 



 

This is quite disappointing right now :(

 

Am I missing something?

 

Regards,

Corneliu

 

 

RE: PowerPivot?

[Greg Low (GregLow.com)]

Hi Corneliu,

 

Have you applied the SP1 and/or CU updates to PowerPivot?

 

I found the designer in Excel painful at times. It certainly doesn’t have the 
stability of basically the same designer in SSDT.

 

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

 

From: ozdotnet-boun...@ozdotnet.com   
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Corneliu I. Tusnea
Sent: Tuesday, 9 April 2013 8:24 AM
To: ozDotNet
Cc: ozDotNet
Subject: Re: PowerPivot?

 

No VSTO. Just clean Excel + PP. no development tools installed at all. 

The crashes are all while editing formulas in the grids not when running 
pivots. 

 

Also my connection for data is over OData from a remote server which has a bit 
of lag at times. 

 

Regards,

Corneliu. 


On 08/04/2013, at 8:25 PM, Arjang Assadi mailto:arjang.ass...@gmail.com> > wrote:

Are you using it through VSTO? on it' own I have only used it 1 per workbook 
and not with millions of records. 5000 records should very well be easy to 
handle.

 

 

 

On 8 April 2013 18:34, Corneliu I. Tusnea mailto:corne...@acorns.com.au> > wrote:

Hi,

 

Is PowerPivot considered a "Production" product? I'm running it on a 
W8+Office2013 and it's crashing like a beta product. I only have 9 worksheets 
and up to about 5000 rows in each and it's unusable. Once I start entering 
formulas it's practically crashing every few minutes.

I now got it to a point where I can't even open it properly. 

 



 

This is quite disappointing right now :(

 

Am I missing something?

 

Regards,

Corneliu

 

RE: occasionally connected application design problem

[Greg Low (GregLow.com)]

Hi Corneliu,

 

I don't mind roll-your-own solutions. They work ok. Biggest issue I come
across with those LastUpdated type columns is checking out how they get
updated. I often see people run into issues with those if they don't
understand how they were updated.

 

For example, doing work on a DB2 site recently, they had a scheme like this
but missed the odd row. Turns out that they were using a trigger to set the
LastUpdated column value. But the value appeared when the trigger finished
running yet it was set to the time value of when the trigger started. So, it
looked like (occasionally) a row jumped backwards in time. Similar issues
can happen when they are updated in proc code, and even worse when they are
updated based on client code.

 

99% of those problems are avoided by saying "give me everything since last
time but only up to a few seconds ago" instead of getting everything up to
the most recent.

 

Sync Framework does work reasonably well. Azure Data Sync is still in
preview but we've had pretty good success with it for simple scenarios.

 

Replication is probably overkill and isn't supported on all editions, so
that might be a limiting factor.

 

And just to add to the "can't believe that pasta sauce is a vege" discussion
in the USA, we have nothing to be proud of. The GST exemption on food that
the Greens needed before passing the legislation has led to significant
chunks of our Tax Act that define what "food" is. 

 

For example, we now have several pages in the Australian Tax Act that cover
the definitions of the word "pudding". I shudder to think what that cost us
all to have that written .

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Corneliu I. Tusnea
Sent: Wednesday, 27 March 2013 8:07 PM
To: ozDotNet
Subject: Re: occasionally connected application design problem

 

Greg,

 

I'm sure the SQL guys will tell you about some "magical tool" that can do
all of this for you hands free and without any headaches (fingers crossed)
but my take would be the good old REST API model.

 

1. For every Table have two columns LastUpdated, LastUploaded and
LastDownloaded. Every change you do locally you update the LastUpdated to
UTC now (never use local times!)

2. Keep a table with the "sync status" of each table where all you need to
store is the TableName, LastUploaded and LastDownloaded.

3. Have a background thread that tries to monitor for network events (don't
continuously try to ping your server as your'll burn the battery of those
devices).
http://www.codeproject.com/Articles/64975/Detect-Internet-Network-Availabili
ty

4. When you have connectivity all you need to do is select top 100 from each
table where LastUpdatd for the Status for the table < LastUpdated of the
row.

(I don't know if I make sense but basically you want to select all the rows
that were changed since point of your LastUpdated in your Status table).

You then try to push those back to your server. For every row that "made it"
to the server you update the LastUploaded to UtcNow or even better I would
update it to the time just before you started the sync.

5. You do the reverse for downloading data. You ask the server for all
changes since your LastDownload. Once all the changes were received, you
update your own LastDownload.

With a bit of reflection and some clear naming conventions you could code
all of this generically enough that you can simply run it on your database
disregarding the number of tables & columns.

 

I'm now going to let the SQL guys deliver their magical tool :)

 

Regards,

Corneliu.

 

 

 

On Wed, Mar 27, 2013 at 8:41 PM, Greg Harris mailto:harris.gre...@gmail.com> > wrote:

Dear People,

 

I need some help to get some good ideas for a design issue I am facing:

 

The application will be geographically dispersed and only occasionally
connected to the internet with a slow / unreliable connection.

The users at remote branch offices are doing daily data entry to their own
local databases (probably SQL express databases).

On a periodic basis the remote branch offices need to synchronise data with
head office (probably a full SQL database).

Most (99%) of data will travel from the remote branch offices the head
office some reference data may travel back to the remote branch office.

 

There are a couple of design ideas that I have had:

 

SQL Server Replication:
(http://msdn.microsoft.com/en-us/library/ms151198.aspx) I do not know how
well this will work on wires that are of such poor quality.  Also how easy
(hard) it will be to support remotely.

 

Program based updates: Have a program running in the background at each site
attempting connection with head office transferring data.  All rows would
have a transferred status flag, that would be set on

RE: nTier ASP.NET MVC Application Architecture

[Greg Low (GregLow.com)]

Hi Craig,

 

Agreed but what intrigues me (or frustrates me) is the real differences in even 
very basic functionality.

 

Even sadder are things like it being 2013 and there’s still no common video 
format that you can use, 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: Craig van Nieuwkerk [mailto:crai...@gmail.com] 
Sent: Thursday, 21 March 2013 12:25 PM
To: g...@greglow.com; ozDotNet
Subject: Re: nTier ASP.NET MVC Application Architecture

 

Getting things to look good on all browsers takes a bit of experience. I think 
the keys are

 

- Don't support old browsers (IE6) unless you really have to

- Remember that it doesn't have to look exactly the same on every browser. If 
IE8 doesn't support gradients for example, they don't get them.

- Use common frameworks like Twitter Bootstrap and jQuery that do a lot of work 
abstracting the change out for you.

 

 

On Thu, Mar 21, 2013 at 12:10 PM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Yep, found the same. They were very useful.

 

Now if browsers would only all play the game properly, it’d be pretty easy. I 
still find real challenges trying to get things to look even close to the same 
on the different browsers, even with trying different toolkits.

 

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 Jason Roberts
Sent: Thursday, 21 March 2013 10:31 AM
To: ozDotNet
Subject: RE: nTier ASP.NET <http://ASP.NET>  MVC Application Architecture

 

Hi Greg, as well as the fat books, you may find the Pluralsight MVC videos 
helpful too...

Cheers,
Jason

  _  

From: Greg Keogh
Sent: 21/03/2013 6:36 AM
To: ozDotNet
Subject: Re: nTier ASP.NET <http://ASP.NET>  MVC Application Architecture

This discussion comes at a coincidentally interesting time for me, as over 
recent years I have become increasingly irritated by classic ASP.NET 
<http://ASP.NET> . The controls are just so heavyweight and the lifecycle of 
events and postbacks is so tangled that you need a doctorate in topology to 
follow it. All of the problems I have ever suffered usually boil down to 
fighting or misunderstanding the huge infrastructure that wraps up such a 
simple concept as a http request. Lord knows how many times I've made a subtle 
mistake in Load, CreateChildControls, PreRender, Render, event handlers, etc, 
causing composite controls or repeater controls to produce gibberish. And then 
there is the misery of trying to integrate JavaScript into the machinery.

 

I was just about to visit bookware and buy two fat ASP.NET <http://ASP.NET>  
MVC 4 books, obviously because I'm considering that as an alternative. I've 
read about the differences between the frameworks and I've run some tutorials 
and can see immediately that MVC takes you closer to the wire and gives you 
more control over rendering, with the penalty that you have to do more work.

 

So I'm wondering if there is anyone here who has migrated to MVC 3/4 
successfully and happily? Is it just substituting one huge complex framework 
for another huge complex one which simply changes the problems from one set to 
another? I worry about the number of files in a large MVC project. Are there 
tools or techniques to integrate scripting more easily? What about emitting 
html that is cross-browser safe or standards compliant? Will MVC make these 
things easier than in class ASP.NET <http://ASP.NET> ?

 

Should I give up on ASP.NET <http://ASP.NET>  completely and use something like 
the GTK or the confusing family of similar tools to use html5? Can I leave the 
ASP.NET <http://ASP.NET>  world totally behind and go this way for rich and 
interactive web sites? Has anyone gone this way? Is it just a new form of 
suffering?

 

Greg K

 

RE: nTier ASP.NET MVC Application Architecture

[Greg Low (GregLow.com)]

Yep, found the same. They were very useful.

 

Now if browsers would only all play the game properly, it'd be pretty easy.
I still find real challenges trying to get things to look even close to the
same on the different browsers, even with trying different toolkits.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Jason Roberts
Sent: Thursday, 21 March 2013 10:31 AM
To: ozDotNet
Subject: RE: nTier ASP.NET MVC Application Architecture

 

Hi Greg, as well as the fat books, you may find the Pluralsight MVC videos
helpful too...

Cheers,
Jason

  _  

From: Greg Keogh
Sent: 21/03/2013 6:36 AM
To: ozDotNet
Subject: Re: nTier ASP.NET MVC Application Architecture

This discussion comes at a coincidentally interesting time for me, as over
recent years I have become increasingly irritated by classic ASP.NET
 . The controls are just so heavyweight and the lifecycle of
events and postbacks is so tangled that you need a doctorate in topology to
follow it. All of the problems I have ever suffered usually boil down to
fighting or misunderstanding the huge infrastructure that wraps up such a
simple concept as a http request. Lord knows how many times I've made a
subtle mistake in Load, CreateChildControls, PreRender, Render, event
handlers, etc, causing composite controls or repeater controls to produce
gibberish. And then there is the misery of trying to integrate JavaScript
into the machinery.

 

I was just about to visit bookware and buy two fat ASP.NET 
MVC 4 books, obviously because I'm considering that as an alternative. I've
read about the differences between the frameworks and I've run some
tutorials and can see immediately that MVC takes you closer to the wire and
gives you more control over rendering, with the penalty that you have to do
more work.

 

So I'm wondering if there is anyone here who has migrated to MVC 3/4
successfully and happily? Is it just substituting one huge complex framework
for another huge complex one which simply changes the problems from one set
to another? I worry about the number of files in a large MVC project. Are
there tools or techniques to integrate scripting more easily? What about
emitting html that is cross-browser safe or standards compliant? Will MVC
make these things easier than in class ASP.NET  ?

 

Should I give up on ASP.NET   completely and use something
like the GTK or the confusing family of similar tools to use html5? Can I
leave the ASP.NET   world totally behind and go this way for
rich and interactive web sites? Has anyone gone this way? Is it just a new
form of suffering?

 

Greg K

RE: Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim.

[Greg Low (GregLow.com)]

Agreed. A deadlock graph will show you the resources held and requested for
each process involved.

 

It'd also be interesting to consider the whole NOLOCK, and dynamic TVF names
that are being used here, but that's a discussion for another day :

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tony Wright
Sent: Tuesday, 19 March 2013 3:28 PM
To: ozDotNet
Subject: Re: Transaction (Process ID 65) was deadlocked on lock |
communication buffer resources with another process and has been chosen as
the deadlock victim.

 

I use SQL Profiler to investigate deadlocks.

 

See this article:

Analyse Deadlocks with SQL Server Profiler.

http://msdn.microsoft.com/en-us/library/ms188246.aspx

On Tue, Mar 19, 2013 at 3:14 PM, Corneliu I. Tusnea mailto:corne...@acorns.com.au> > wrote:

Hi, 

 

I have a SQL Procedure that call a SQL Function that (way too often) dies
with the above message.

 

The SP looks like this

ALTER PROCEDURE [dbo].[Report]

@FileId BIGINT

, @Id BIGINT

, @FunctionToExecute NVARCHAR(200)

AS

BEGIN

DECLARE @UtcTime DATETIME

SET @UtcTime = GETUTCDATE()

 

DECLARE @ToUpdate TABLE(ReferenceId BIGINT, ReferenceLastUpdateTime
DATETIME, RelatedReferenceId BIGINT, RelatedReferenceTypeId INT)

DECLARE @sql NVARCHAR(MAX)

 

SET @sql = N'SELECT * FROM ' + @FunctionToExecute + CONVERT(VARCHAR(20),
@FileId) + N', ' + CONVERT(VARCHAR(20), @Id) + N')'

INSERT INTO @ToUpdate

EXEC sp_executesql @statement = @sql

-- the crash is always in the EXEC line.

 

The @FunctionToExecute looks like this:

CREATE FUNCTION [dbo].[Validate_]

(

@FileId BIGINT

, @Id BIGINT

)

RETURNS @Results TABLE(ReferenceId BIGINT, ReferenceLastUpdateTime DATETIME,
RelatedReferenceId BIGINT, RelatedReferenceTypeId INT)

AS

BEGIN

INSERT INTO @Results(ReferenceId, ReferenceLastUpdateTime,
RelatedReferenceId, RelatedReferenceTypeId)

SELECT DISTINCT T.Id, T.LastUpdateTime, T.ContactId, 1 FROM dbo.Data T
WITH(NOLOCK)

WHERE T.FileId = @FileId

AND T.ContactId IS NULL

RETURN

END

GO

 

 

(I've removed various bits to keep it simple.

Basically the function has a quite straight forward SELECT with a NOLOCK and
the SP has an insert in a table variable.

 

At the moment I have a failure rate of about 6 out of 10 and the failure.

 

I'm running this on SQL2012 Standard (with which I'm having quite some hard
time as it runs some queries much slower than my old SQL2008R2 on much lower
hardware specs).

 

Any ideas or clues in how to diagnose and fix this?

 

Thanks,

Corneliu

 

 

RE: Visual Studio once great for blind users, but not anymore: how to work around this and still be able to learn the Windows 8 Runtime interface?

[Greg Low (GregLow.com)]

o people using screen readers, and
depending on how important Microsoft considers it's own standards, pointing
you guys at your own documentation for accessibility on the .net framework,
would be like slapping you in the face, now wouldn't it?

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of David Kean
Sent: Monday, March 18, 2013 1:27 PM
To: ozDotNet; g...@greglow.com
Subject: RE: Visual Studio once great for blind users, but not anymore: how
to work around this and still be able to learn the Windows 8 Runtime
interface?

Thanks for the feedback. The problem with something like Connect is that it
acts like we're always open for taking bugs - but truth is, you need to know
the right time to file.  If we're at the end of a release (last 4-5 months
up-to RTM), then it's extremely unlikely we'll fix something unless it's a
regression from a previous release, or a major issue in a new feature.

In saying that though, now is a *really good* time to file bugs, please do.
Especially around situations that used to work in VS 2010, but don't in VS
2012.

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Katherine Moss
Sent: Saturday, March 16, 2013 7:06 AM
To: g...@greglow.com; ozDotNet
Subject: RE: Visual Studio once great for blind users, but not anymore: how
to work around this and still be able to learn the Windows 8 Runtime
interface?

Thank you; I appreciate it very much.  Though the last time I have placed my
feedback dealing with accessibility on SQL Server (remember that?), at least
on Microsoft connect, the only thing I got is "we'll look into it", which to
me, seems to be Microsoft's way of telling me to buzz off because what I had
to say is unimportant to them.  At least this issue  wasn't an issue since
2003 or 2005 like the SQL issue is.  I hope we get some good results, but
remember that some of this can only be fixed by the manufacturers of the
screen readers; they are the ones who don't listen to their customers if
their beliefs don't match those of the customer; like take for example, the
new modern-style interface.  I would love to be able to install and buy tons
and tons of apps, but I cannot, because companies like GW micro make a
conscious decision not to support the new interface, saying, "The new
modern-style interface is for phones, not for desktops", and then make some
comment of how they are useless to those without touch screens.  But I do
not understand why these people find it too much work to keep up with the
times.

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Saturday, March 16, 2013 7:16 AM
To: 'ozDotNet'
Subject: RE: Visual Studio once great for blind users, but not anymore: how
to work around this and still be able to learn the Windows 8 Runtime
interface?

Hi Katharine,

I've passed your comments onto an internal Microsoft mailing list (without
identifying you) and I'll let you know what feedback comes back. That's
certainly interesting feedback.

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

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Katherine Moss
Sent: Saturday, 16 March 2013 5:48 PM
To: ozdotnet@ozdotnet.com
Subject: Visual Studio once great for blind users, but not anymore: how to
work around this and still be able to learn the Windows 8 Runtime interface?

Hi,
I would hate to have to run two copies of Visual Studio (one 2010 and the
other 2012) on here, for this computer works hard enough, but that's what
it's looking like will have to happen in order for me to progress in my C#
learning, for after doing some testing, I realized that most of the parts of
the interface of Visual Studio that were once accessible to all of my screen
readers, are now accessible to none; the properties window, the toolbox, the
project properties multitabbe dialog box, and I'm sure there was one other
area, of visual studio 2012 are like having nothing there; nothing is read
allowed.  Try a demo of JAWS from Freedom Scientific or Window-Eyes from
GWMicro (you can navigate with the mouse for the most part even with screen
readers enabled), and do a side-by-side comparison of the toolbox
especially, since this is the real gotcha here.  To test them, use your
arrows and your tab key to examine the toolbox.  You will notice one thing.
2010 reads, 2012 doesn't!  And never mind learning the new Windows interface
from a programming prospective, but I don't think there's a way to enable
those templates in VS 2010?  If there is, please, tell me how.
The second re

RE: Visual Studio once great for blind users, but not anymore: how to work around this and still be able to learn the Windows 8 Runtime interface?

[Greg Low (GregLow.com)]

Hi Katharine,

I've passed your comments onto an internal Microsoft mailing list (without
identifying you) and I'll let you know what feedback comes back. That's
certainly interesting feedback.

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

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Katherine Moss
Sent: Saturday, 16 March 2013 5:48 PM
To: ozdotnet@ozdotnet.com
Subject: Visual Studio once great for blind users, but not anymore: how to
work around this and still be able to learn the Windows 8 Runtime interface?

Hi,
I would hate to have to run two copies of Visual Studio (one 2010 and the
other 2012) on here, for this computer works hard enough, but that's what
it's looking like will have to happen in order for me to progress in my C#
learning, for after doing some testing, I realized that most of the parts of
the interface of Visual Studio that were once accessible to all of my screen
readers, are now accessible to none; the properties window, the toolbox, the
project properties multitabbe dialog box, and I'm sure there was one other
area, of visual studio 2012 are like having nothing there; nothing is read
allowed.  Try a demo of JAWS from Freedom Scientific or Window-Eyes from
GWMicro (you can navigate with the mouse for the most part even with screen
readers enabled), and do a side-by-side comparison of the toolbox
especially, since this is the real gotcha here.  To test them, use your
arrows and your tab key to examine the toolbox.  You will notice one thing.
2010 reads, 2012 doesn't!  And never mind learning the new Windows interface
from a programming prospective, but I don't think there's a way to enable
those templates in VS 2010?  If there is, please, tell me how.  
The second reason I'm sending this message out is because one ambitious
technologist like me requesting support from GWMicro, Serotek, and Freedom
Scientific to give support for the latest version of Visual Studio is not
going to do much.  I need a ton of us requesting it; maybe even the sighted
community; to remind these people that the blind community will not bend to
their will (that is, stop updating the support to support the latest
features and interfaces properly, so in terms of Visual Studio, restricting
blind people to the 2010 version if they want to get anything productive
done, and the sad thing is that most of us just accept that and move on), so
that they can give up keeping with updated versions.  It's like screen
reader manufacturers are stuck in the time when from windows version to
windows version, things didn't change much; it's like they are deliberately
refusing to keep up.  Like they're stuck in a rut.  And I'll tell you, I'm
not having this anymore.  Are you?  Who's with me on this?  Thanks to
everyone on here, and I look forward to this discussion continuing.  

RE: Running code snippets

[Greg Low (GregLow.com)]

+1

 

All’s fine with PayPal till it isn’t. Then it feels like you’re in a Monty 
Python skit…

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Nathan Chere
Sent: Tuesday, 12 March 2013 12:38 PM
To: ozDotNet
Subject: RE: Running code snippets

 

Use PayPal only under duress. When they inevitably bite you they bite HARD, and 
their customer service / dispute resolution is non-existent when it’s a dispute 
about them.

 

From: ozdotnet-boun...@ozdotnet.com   
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith
Sent: Tuesday, 12 March 2013 11:44 AM
To: ozDotNet
Subject: Re: Running code snippets

 

I'm with you on this one, if you don't like PayPal, there's Amazon, Google, and 
an Aussie mob doing the same kind of proxy payment.

 

On Tue, Mar 12, 2013 at 11:42 AM, Katherine Moss mailto:katherine.m...@gordon.edu> > wrote:

Use Paypal when and if you can at all times when possible; keeps people from 
knowing your info; especially in international transactions.  

 

From: ozdotnet-boun...@ozdotnet.com   
[mailto:ozdotnet-boun...@ozdotnet.com  ] 
On Behalf Of Greg Keogh
Sent: Monday, March 11, 2013 8:39 PM


To: ozDotNet
Subject: Re: Running code snippets

 

After browsing around and experimenting I have decided that LINQPad is a vital 
tool to have for this sort of thing, and more. It has improved greatly since I 
last looked at it, so I've even decided to get a Premium licence key. It's just 
a shame I can do my snippet editing and testing from within VS2012.

 

I now have to figure out who will rip me off the least for the $58 purchase: 
Westpac VISA or PayPal. The former has a 3.5% international transaction free, 
I'm not sure how PayPal works but I'll try to compare.

 

Greg





 

-- 
Meski


   http://courteous.ly/aAOZcv


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

 

Click here   to report 
this email as spam.

 

This message has been scanned for malware by Websense.  
 www.websense.com

RE: sql server concurrency and 'conflicting' updates

[Greg Low (GregLow.com)]

Yep, I tend to call it a name like "Concurrency" or something, with a data
type of "rowversion". I'd try to avoid naming the column after a data type.
While you can, I wouldn't :-)

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

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Wallace Turner
Sent: Tuesday, 5 February 2013 3:14 PM
To: ozDotNet
Subject: Re: sql server concurrency and 'conflicting' updates

Thanks Greg,

Does that mean rowversion becomes a member of all your entities?

public class EntityA
{

public int Field1 { get; set; }
public byte[] RowVersion { get; set; }
}
?



On 5/02/2013 10:58 AM, Greg Low (GregLow.com) wrote:
> Hi Wallace,
>
> The best approaches for this are usually based around the rowversion 
> data type.
>
> Each table can have a column of type "rowversion". This used to be 
> called "timestamp".
>
> All it contains is a binary value that changes whenever the data in 
> the row changes. It does that automatically.
>
> So, the sort of concurrency scheme that you're talking about (even for 
> disconnected use) can be performed by:
>
> 1. Read the data, including the rowversion column.
> 2. Update the data having the rowversion column in the WHERE predicate.
> 3. Check whether or not the row was updated. If not, someone else had 
> already modified it and you need to take appropriate action.
>
> This sort of scheme is far better than anything based around locks, 
> unless you are talking about really short timespans.
>
> 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
>
> -Original Message-
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Wallace Turner
> Sent: Tuesday, 5 February 2013 12:54 PM
> To: ozDotNet
> Subject: sql server concurrency and 'conflicting' updates
>
> i have googled a bit for this but fear i am missing an important keyword.
>
> What methods are used to handle concurrent updates in sql server? That 
> is, two users editing the same 'thing'.
>
> The way ravenDB does it [1] looks good to me. What support is there 
> for approaches of this type (using etags) in sql server?
>
> Could you also discuss what you allow the end users to see/do? eg are 
> they given options to 'ignore clash and override'
>
> [1]: http://ravendb.net/docs/http-api/http-api-comcurrency
>

RE: sql server concurrency and 'conflicting' updates

[Greg Low (GregLow.com)]

Hi Wallace,

The best approaches for this are usually based around the rowversion data
type.

Each table can have a column of type "rowversion". This used to be called
"timestamp".

All it contains is a binary value that changes whenever the data in the row
changes. It does that automatically.

So, the sort of concurrency scheme that you're talking about (even for
disconnected use) can be performed by:

1. Read the data, including the rowversion column.
2. Update the data having the rowversion column in the WHERE predicate.
3. Check whether or not the row was updated. If not, someone else had
already modified it and you need to take appropriate action.

This sort of scheme is far better than anything based around locks, unless
you are talking about really short timespans.

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

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Wallace Turner
Sent: Tuesday, 5 February 2013 12:54 PM
To: ozDotNet
Subject: sql server concurrency and 'conflicting' updates

i have googled a bit for this but fear i am missing an important keyword.

What methods are used to handle concurrent updates in sql server? That is,
two users editing the same 'thing'.

The way ravenDB does it [1] looks good to me. What support is there for
approaches of this type (using etags) in sql server?

Could you also discuss what you allow the end users to see/do? eg are they
given options to 'ignore clash and override'

[1]: http://ravendb.net/docs/http-api/http-api-comcurrency

RE: Transcription software

[Greg Low (GregLow.com)]

Hi Corneliu,

 

Yes, I’ve always come back to using real people. I was just wondering what the 
state of the technology was now.

 

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: Corneliu I. Tusnea [mailto:corne...@acorns.com.au] 
Sent: Monday, 4 February 2013 9:26 AM
To: g...@greglow.com; ozDotNet
Subject: Re: Transcription software

 

Ask Hanselman .. he is always transcripting his recordings. I think he is using 
an actual person (elance, taskarmy) for few cents an hour.

 

On Sat, Feb 2, 2013 at 1:26 PM, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Hi Folks,

 

Anyone know if there’s anything better than Dragon for transcription software? 

 

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

 

 

 

Transcription software

[Greg Low (GregLow.com)]

Hi Folks,

 

Anyone know if there's anything better than Dragon for transcription
software? 

 

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:   www.sqldownunder.com

 

 

RE: SQLite and SQL Server schemas

[Greg Low (GregLow.com)]

Hey Greg,

 

SQL Server IDENTITY columns can be 32 bit or 64 bit. Both work ie: int or
bigint.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Tuesday, 22 January 2013 10:20 PM
To: ozDotNet
Subject: SQLite and SQL Server schemas

 

Folks, I was considering being able to swap SQLite and SQL
Server/Compact/Azure as the backend of my app. I use POCOs as the entities
and I can generate multiple EDXMs for the databases and load them
dynamically a runtime. It's a bit tricky to keep everything "neutral" and
abstract the database away, but it was looking feasible as a good cooding
exercise.

 

Then I suddenly reaslised that the POCOs aren't "neutral" because the SQLite
IDENTITY columns are 64-bit and the SQL ones are 32-bit. I ran a diff on the
POCOs and was suddenly reminded of this difference. Dammit!

 

So, do I make all the IDENTITY columns in the SQL databases 64-bit to match
(if that's possible), or perhaps there is some other lateral thinking trick
I'm missing.

 

Having a completely replaceable database is a lovely thing to have, but
tricker in practise than I initially thought with EF5 and POCOs. Has anyone
attempted this sort of thing before?

 

Greg

RE: Xaml basics: where to start?

[Greg Low (GregLow.com)]

It's also worth noting that many frameworks attempt to reduce the amount of
code that you need to write by favouring convention over configuration. So
you need to follow the conventions of the framework to avoid fighting with
it. For example, with MVC, naming a controller XXXController isn't just an
isolated design choice. It affects how the code runs. You could still work
with it if you'd used other naming but it's a lot more work.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Arjang Assadi
Sent: Tuesday, 22 January 2013 8:48 AM
To: ozDotNet
Subject: Re: Xaml basics: where to start?

 



Katherine

MVVM, and other MV* patterns are what can be used for laying out models,
some frameworks  would go as far as having niceties to match the properties
or even picking a control for layout that would match the type of property
(e.g. if your in your model you have DateTime then a date time picker is
used, or you can specify the type of custom control to be used).  

Using or making a framework can be beneficial in having a uniform way of
dealing with UI that is directly generated from model as oppose to manually
making them.

How ever the time to learn/make a frame work is substantial and is only
justified if one is expecting some type of uniformity that can be handled
automatically by a framework rather than in a manual and error prone way by
a human.

One of the main ideas behind XAML (WPF), was the ability to break up the
visual and code parts to be handled by separate teams. Even sighted
programmers are hopeless with layout with XAML and it is preferred to pass
it to the designer team.

I still recommend the book Illustrated WPF for start, and at some point
eventually moving to a framework or using MVVM.

 

Regards

 

Arjang

 

 

 

On 22 January 2013 01:30, Katherine Moss mailto:katherine.m...@gordon.edu> > wrote:

I think I may have seen that somewhere, but what is the ppoint of using MVVM
frameworks?  What are they, anyway?  

 

From: ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com 
] On Behalf Of Greg Keogh
Sent: Monday, January 21, 2013 3:40 AM


To: ozDotNet
Subject: Re: Xaml basics: where to start?

 

My favourite book on WPF is an old one called Windows Presentation
Foundation Unleashed by Adam Nathan -- Greg 

 

RE: vs 2010 and 2012

[Greg Low (GregLow.com)]

Agreed. Wish it was there already. From previous announcements, I recall the RS 
team saying they’d have their one ready this quarter. Hope the others are on 
track to do the same. They’ve decoupled these releases from the shipping of 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 Preet Sangha
Sent: Wednesday, 16 January 2013 9:40 AM
To: ozDotNet
Subject: Re: vs 2010 and 2012

 

It's annoying how the BI team isn't keeping up with the SQL team. We have the 
BI stuff stuff at VS2010, SQL Server at VS2012 (and VS2010), and to top it all 
to support existing software the BI stuff VS2008.

 

I'd love to upgrade the Bi stuff to a better (slightly less opaque DTS/SSRS and 
more forgi\ving ) environment

 

On 16 January 2013 11:20, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Another is that the SQL BI projects are still all VS2010 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 <mailto:ozdotnet-boun...@ozdotnet.com> ] 
On Behalf Of a...@nomscon.com <mailto:a...@nomscon.com> 
Sent: Wednesday, 16 January 2013 3:15 AM
To: ozDotNet


Subject: RE: vs 2010 and 2012

 

One example is that VS 2012 doesn't support MSI setup (.vdproj) projects.

 

See the following blogs for additional differences:

 

 <http://msdn.microsoft.com/en-us/library/vstudio/hh266747.aspx> 
http://msdn.microsoft.com/en-us/library/vstudio/hh266747.aspx

 
<http://blogs.msdn.com/b/zainnab/archive/2012/06/05/visual-studio-2012-compatibility-aka-project-round-tripping.aspx>
 
http://blogs.msdn.com/b/zainnab/archive/2012/06/05/visual-studio-2012-compatibility-aka-project-round-tripping.aspx

 

 Original Message 
Subject: RE: vs 2010 and 2012
From: Katherine Moss < <mailto:katherine.m...@gordon.edu> 
katherine.m...@gordon.edu>
Date: Tue, January 15, 2013 10:45 am
To: ozDotNet < <mailto:ozdotnet@ozdotnet.com> ozdotnet@ozdotnet.com>

I’m rather curious as to why somebody would want to do that though if the 2012 
version supersedes the previous one in so many ways?

 

From: ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com>  
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Loo
Sent: Tuesday, January 15, 2013 6:58 AM
To: ozDotNet
Subject: Re: vs 2010 and 2012

 

triple yes!

On 15/01/13 12:28, ifum...@gmail.com <mailto:ifum...@gmail.com>  wrote:

Can you install vs 2012 in parallel with vs 2010?  

 

 





-- 
David Loo
MCPD, MCP, MCTS
http://www.davidloo.com





 

-- 
regards,
Preet, Overlooking the Ocean, Auckland 

RE: vs 2010 and 2012

[Greg Low (GregLow.com)]

Another is that the SQL BI projects are still all VS2010 based.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of a...@nomscon.com
Sent: Wednesday, 16 January 2013 3:15 AM
To: ozDotNet
Subject: RE: vs 2010 and 2012

 

One example is that VS 2012 doesn't support MSI setup (.vdproj) projects.

 

See the following blogs for additional differences:

 

  
http://msdn.microsoft.com/en-us/library/vstudio/hh266747.aspx

 

 
http://blogs.msdn.com/b/zainnab/archive/2012/06/05/visual-studio-2012-compatibility-aka-project-round-tripping.aspx

 

 Original Message 
Subject: RE: vs 2010 and 2012
From: Katherine Moss <  
katherine.m...@gordon.edu>
Date: Tue, January 15, 2013 10:45 am
To: ozDotNet <  ozdotnet@ozdotnet.com>

I’m rather curious as to why somebody would want to do that though if the 2012 
version supersedes the previous one in so many ways?

 

From:   ozdotnet-boun...@ozdotnet.com [ 
 mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of David Loo
Sent: Tuesday, January 15, 2013 6:58 AM
To: ozDotNet
Subject: Re: vs 2010 and 2012

 

triple yes!

On 15/01/13 12:28,   ifum...@gmail.com wrote:

Can you install vs 2012 in parallel with vs 2010?  

 

 






-- 
David Loo
MCPD, MCP, MCTS
  http://www.davidloo.com

RE: vs 2010 and 2012

[Greg Low (GregLow.com)]

+1

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Michael Minutillo
Sent: Tuesday, 15 January 2013 3:34 PM
To: ozDotNet
Subject: Re: vs 2010 and 2012

 

I've been running both in parallel for about 6 months and haven't run into
any issues with either.




Michael M. Minutillo
Indiscriminate Information Sponge
http://codermike.com

 

On Tue, Jan 15, 2013 at 12:29 PM, Craig van Nieuwkerk mailto:crai...@gmail.com> > wrote:

Yes.

 

On Tue, Jan 15, 2013 at 3:28 PM, mailto:ifum...@gmail.com> > wrote:

Can you install vs 2012 in parallel with vs 2010?  

 

 

 

 

RE: More on cross-platform development

[Greg Low (GregLow.com)]

Well said David.

 

One thing I'd like to add to the conversation though is that I see people
all the time that consider their mobile interfaces as a "low functionality
add-on" to the "real" application. While I've dealt with mobile apps that
way in the past, I'm increasingly changing my view.

 

We're moving into a world where the majority of Internet users will have the
primary Internet experience via a mobile device. It's not some add-on access
to their "real" usage like it has been for us in the past. I think we ignore
that at our peril. We need to be thinking about how to make that experience
be as rich as possible.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of David Connors
Sent: Saturday, 5 January 2013 9:35 AM
To: ozDotNet
Subject: Re: More on cross-platform development

 

On Sat, Jan 5, 2013 at 5:02 AM, Katherine Moss 
wrote:

I suppose it's a question of who is right in terms of the future.  I have
read so many articles that insult .net to the core, and it kills me.  I'll
never forget the guy who called the .NET Framework and it's set of
development tools a McDonalds assembly line! 

I like this topic and I remember the post:
http://blog.expensify.com/2011/03/25/ceo-friday-why-we-dont-hire-net-program
mers/ Best part is where he calls .NET a language. Epic fail. I am surprised
how much it still irritates me given how long ago it originally came out. 

 

The guy's post is emblematic of software development junk/pop culture. These
guys are always quick to the draw when it comes to saying MS is this or that
but rarely have I seen a reasoned bit of introspection in how they conduct
their own work. His hatred for .NET is based on what? RDP, that MS platforms
use a \ instead of a / for path delineation (ironically, this is abstracted
in .NET - not that he'd know). 

 

How about as a comparison: it is 2013 and PHP (which expensify is written
in) still isn't thread safe - or at least no one can agree on whether it is
which is even worse. Maybe he should try a few posts about I/O completion,
thread pooling, getting the best utilisation out of CPU and IO in his server
farm, etc instead of the merits of the slash over the backslash. 

 

I have worked on a lot of projects on a lot of platforms over the years.
I've also done a lot of application assurance/security reviews on a lot of
other people's work in my time and I can say without a shadow of a doubt,
work that I review from people writing in PHP is, on the whole, horrific.
Go have a look at the guts of phpBB some day - he's dead right about Lord of
the Flies.

 

Work I have reviewed from people working in .NET and Java is, on the whole,
a much higher calibre. It is very rarely that I have seen the same abject
lack of planning and forethought in .NET/Java projects that I have seen in
PHP projects from customers.

 

Sure there is more overhead in getting a .NET project up and running
compared to putting  in a text file - but so
what? Maybe he doesn't know you can whack <%@ Page Language="C#"  %> at the
top of an aspx to make .NET 'just as productive as PHP'. Saves all that
nasty thinking about overall systems architecture and long term
maintainability.

Anyway, what I mean, is with all of this stuff leading to mobile
development, does that mean that Microsoft is actually right and that the
desktop computer, the on-premise server, the .NET Framework, and all the
rest, are dying rather hard?  I mean, seasoned developers like you guys, and
learners like me, how much of our time is being wasted in this century? 

Don't panic - nothing is dying hard. The future is heterogeneous. 

 

We had a Windows hegemony for a long time because MS was the only company in
the world that:

*   had a clue about the benefits of building ecosystems
*   wrote the only stable and well supported mass scale OS (OS9 was
junk, Linux is just too hard for end users and no one is going to rebuild
kernals to make bluetooth work OS/2 tried to solve problems that didn't
exist)
*   had the money to do all of the above
*   had the money to focus massive resources on really mundane stuff
like having awesome drivers and rallying OEMs together to support stuff like
plug and play etc

The stuff that made Windows so successful was really pretty basic. It was/is
a dependable workhorse with great driver support and you could get it
running on almost anything. That was always the hard part for competitors
that came over the years. OS/2 might have been great on a number of
technical merits, but it was the same old story, crappy hardware support,
system resource requirements too high, backwards compatibility story was
junk (the Windows subsystem on OS/2 was beyond slow - and if you want to run
Windows apps why not just run Windows?) 

 

I

RE: SQL Reports driving me nuts

[Greg Low (GregLow.com)]

Hi Stuart,

 

Are you setting the visibility of the tablix itself with an expression or just 
hiding the rows?

 

You might also get better responses for SQL issues on the SQL list:  
<http://www.sqldownunder.com/Resources/EMailSupportListserver.aspx> 
http://www.sqldownunder.com/Resources/EMailSupportListserver.aspx

 

Another good option is #sqlhelp on twitter.

 

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: Friday, 14 December 2012 10:45 AM
To: ozDotNet
Subject: Re: SQL Reports driving me nuts

 

I think the adage "if at first you don't succeed, never try again" can be 
applied to this problem. No co-operation here so I've dropped it. The solution 
is to write separate reports for each scenario, not ideal nor elegant but it 
will have to do.

 

I tried in both client side reports - Visual Studio 10 and server side SSRS 
2008 & the same problem occurs. A trivial exercise in other event driven report 
managers is a nightmare in this beast.

 

- Stuart

 

On 13 December 2012 22:59, Stuart Kinnear  wrote:

SSRS 2008.

 

I think I am getting closer but still struggling. I set both tablix to the same 
dataset and filtered it. This way I was able to embed the two tablix within a 
parent tablix. 

 

But setting the row visibility did not do anything different - Arrgh !

 

Anyway, I've come across another article suggesting a static row group. This 
I'll try tomorrow when I've cooled down a bit.

 

- Stuart

 

 

On 13 December 2012 21:12, Greg Low (GregLow.com) mailto:g...@greglow.com> > wrote:

Hey Stuart,

 

Which version are you using?

 

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 Stuart Kinnear
Sent: Thursday, 13 December 2012 9:03 PM
To: ozDotNet
Subject: SQL Reports driving me nuts

 

I am trawling the net for solutions but haven't  come up with one yet, so 
hopefully someone out there can assist.

 

I have a report that is composed of two tablix controls  one above another.

 

Tablix A has an unique set data 

Tablix B has an unique set data .

 

If tablix A or B has no data the control should hide itself and collapse its 
presence ie zero height.

 

The problem is that if Tablix A has no data it uses up its allocated height, 
however, if we swap the scenario and have no data in Tablix B no height is 
taken, because of the report property 'ConsumeContainerWhiteSpace'.

 

Next I thought I could embed the tablix controls within a host tablix, then set 
the rowVisibility property based on the tablix A or B Hidden property or its 
underlying dataset's row count. Much cussing and infuriation - the child tablix 
controls cannot have independent data sources.

 

Where to next ? toss the whole lot in the bin and go back to ComponentOne ?  
Surely this can't be that difficult ! 

 




 

-- 
-
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.
-





 

-- 
-
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.
-





 

-- 
-
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 Reports driving me nuts

[Greg Low (GregLow.com)]

Hey Stuart,

 

Which version are you using?

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stuart Kinnear
Sent: Thursday, 13 December 2012 9:03 PM
To: ozDotNet
Subject: SQL Reports driving me nuts

 

I am trawling the net for solutions but haven't  come up with one yet, so
hopefully someone out there can assist.

 

I have a report that is composed of two tablix controls  one above another.

 

Tablix A has an unique set data 

Tablix B has an unique set data .

 

If tablix A or B has no data the control should hide itself and collapse its
presence ie zero height.

 

The problem is that if Tablix A has no data it uses up its allocated height,
however, if we swap the scenario and have no data in Tablix B no height is
taken, because of the report property 'ConsumeContainerWhiteSpace'.

 

Next I thought I could embed the tablix controls within a host tablix, then
set the rowVisibility property based on the tablix A or B Hidden property or
its underlying dataset's row count. Much cussing and infuriation - the child
tablix controls cannot have independent data sources.

 

Where to next ? toss the whole lot in the bin and go back to ComponentOne ?
Surely this can't be that difficult ! 

 




 

-- 

-
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: Azure Websites WebAPI Authentication

[Greg Low (GregLow.com)]

Hi Craig,

 

Yes, that was one I’d been reading. The issue is that I don’t think that 
Windows Azure Websites support SSL 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: Craig van Nieuwkerk [mailto:crai...@gmail.com] 
Sent: Tuesday, 16 October 2012 9:59 AM
To: g...@greglow.com; ozDotNet
Subject: Re: Azure Websites WebAPI Authentication

 

I think it depends on your requirement. What I am going to do is use Basic 
Authentication combined with Https. 

 

Something like

 

http://remy.supertext.ch/2012/04/basic-http-authorization-for-web-api-in-mvc-4-beta/

 

Craig

 

 

On Tue, Oct 16, 2012 at 9:55 AM, Greg Low (GregLow.com)  
wrote:

Hi Folks,

 

What’s the best way to provide authentication for REST services exposed by MVC4 
WebAPI within Windows Azure Websites?

 

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

 

 

 

Azure Websites WebAPI Authentication

[Greg Low (GregLow.com)]

Hi Folks,

 

What's the best way to provide authentication for REST services exposed by
MVC4 WebAPI within Windows Azure Websites?

 

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:   www.sqldownunder.com

 

 

Hyper-V on Windows 8

[Greg Low (GregLow.com)]

Hi Folks,

 

I'm loving having Hyper-V available in the client with Windows 8.

 

However, one of the reasons that I used to use VirtualBox instead is that it
could deal with different screen resolutions when you used "Connect".

 

Anyone know any way to actually use the full screen with Hyper-V apart from
connecting with RDP instead?

 

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:   www.sqldownunder.com

 

 

RE: Powershell script ?

[Greg Low (GregLow.com)]

Thanks Ian, that one from Andrew is awesome but I'll keep that in mind in
case I want to do something the one he linked to can'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 Ian Thomas
Sent: Saturday, 29 September 2012 2:05 PM
To: 'ozDotNet'
Subject: RE: Powershell script ?

 

Hi Greg

There is a library written by Novell - TagLib - which has a C# wrapper,
(TagLibSharp) which may be usable with PowerShell. 

 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Andrew Coates (DPE AUSTRALIA)
Sent: Saturday, September 29, 2012 11:01 AM
To: g...@greglow.com; ozDotNet
Subject: RE: Powershell script ?

 

Hi Greg,

There's an excellent bit of freeware called, from memory, MP3Tag that can do
exactly this (and lots more besides).

http://www.mp3tag.de/en/

Cheers,
Andrew 

  _  

From: Greg Low (GregLow.com)
Sent: 29/09/2012 12:35 PM
To: 'ozDotNet'
Subject: FW: Powershell script ?

Hi Folks,

 

I want to set the "Title" property of all the mp4 files in a folder to their
file name.

 

ie:   something.mp4 would get the title "something".

 

Anyone know how to do that? Is there some way to do that with Powershell?

 

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: Powershell script ?

[Greg Low (GregLow.com)]

Magic thanks Andrew. Wasn't immediately obvious how to do it with it but
that's way, way cool. The convert options are great.

 

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: Saturday, 29 September 2012 1:01 PM
To: g...@greglow.com; ozDotNet
Subject: RE: Powershell script ?

 

Hi Greg,

There's an excellent bit of freeware called, from memory, MP3Tag that can do
exactly this (and lots more besides).

http://www.mp3tag.de/en/

Cheers,
Andrew 

  _____  

From: Greg Low (GregLow.com)
Sent: 29/09/2012 12:35 PM
To: 'ozDotNet'
Subject: FW: Powershell script ?

Hi Folks,

 

I want to set the "Title" property of all the mp4 files in a folder to their
file name.

 

ie:   something.mp4 would get the title "something".

 

Anyone know how to do that? Is there some way to do that with Powershell?

 

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

 

 

FW: Powershell script ?

[Greg Low (GregLow.com)]

Hi Folks,

 

I want to set the "Title" property of all the mp4 files in a folder to their
file name.

 

ie:   something.mp4 would get the title "something".

 

Anyone know how to do that? Is there some way to do that with Powershell?

 

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:   www.sqldownunder.com

 

 

RE: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

The other trick I gathered from the comments is that if you buy the real one, 
you need to disable the “check for updates” part. Lots of people complaining 
that they bought a life-time license but it auto-updated and then wouldn’t work 
until they paid a bunch more.

 

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: Friday, 21 September 2012 9:28 AM
To: ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Team viewer is awesome. I use it to remote control my wife's server. Paid 
version allows installing as a service. Also free to use for non commercial. I 
don't use the multiple presentation mode but its there. Can even use client 
from smartphone. I did it on my phone from Bali once. 
Not cheap but its worth it.

On Sep 20, 2012 8:51 PM, "Jorke Odolphi"  wrote:

Teamviewer can do LAN only, but you gotta pay for it. It's nicely cross 
platform too.


Sent from a Phone


 Original message 
Subject: RE: VNC over wireless vs cabled 
From: "Greg Low (GregLow.com)"  
To: 'Ian Thomas' ,'ozDotNet'  
CC: 



Hi Ian,

 

Yes, I came to Tight VNC by looking at VLC Media Player. It really feels like 
it shouldn’t be rocket science to try to do this. It seems insane to send your 
screen images out to the cloud and then back in to ten other machines in the 
same room, that are on the same network. There has to be a simpler way.

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Thursday, 20 September 2012 10:04 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

VLC Media Player can multicast. I have been working with some video capture, 
and came across one or two CodeProject articles that describe setting up your 
screen as a capture device, so it could be used in conjunction with VLC 
multicasting, or via .NET code with nVLC (a wrapper for libvlc – see also a 
CodeProject, by Roman Ginzburg). 

It seems a circuitous route, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Thursday, September 20, 2012 7:40 PM
To: 'Ken Schaefer'; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

Hi Ken,

 

Good question for #1. Can’t find any reference to it in the setup or in the 
manual.

 

For #2, answer is no at present. Mind you, for some reason it’s stopped even 
when they’re on the same wired network. Earlier today that worked L

 

There really must be a good way to project a screen image to a set of machines 
on the same wired network without having to go out an Internet connection and 
back in. Anyone got any other ideas? 

 

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, 20 September 2012 3:41 PM
To: g...@greglow.com; ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Does the wireless access point in your device support multicasting packets 
received on the wireless interface?

Does it work if the projector is connected to a wired port, and the clients are 
on the WiFi?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 20 September 2012 3:12 PM
To: 'ozDotNet'
Subject: VNC over wireless vs cabled

 

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982 with 
wired connections to a router, all is good. But if I try to do that using a 
wireless connection to the same router, I’m having no luck at all.

 

Any ideas on this? I can’t see anything blocked in the router config, 
specifically for wireless connections.

 

I’d love to be able to just take a wireless router with me, and be able to 
project my desktop to the other machines in the room, without the need for 
either a projector or a switch and cables.

 

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: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Jorke,

 

Yes, what put me off is that every time they discuss LAN only, they’re only 
discussing the remote control options. It’s silent on that in the meeting 
options.

 

I’ll have to try 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: Jorke Odolphi [mailto:jo...@jorke.net] 
Sent: Thursday, 20 September 2012 11:18 PM
To: g...@greglow.com; ozdotnet@ozdotnet.com; il.tho...@iinet.net.au
Subject: RE: VNC over wireless vs cabled

 

Haven't tested myself on LAN, but..Multiple viewers is what it does, 

 

http://www.teamviewer.com/en/help/40-Can-TeamViewer-be-used-within-a-local-network-LAN-only.aspx




Sent from a Phone




 Original message 
Subject: RE: VNC over wireless vs cabled 
From: "Greg Low (GregLow.com)"  
To: Jorke Odolphi ,"ozdotnet@ozdotnet.com" 
,"il.tho...@iinet.net.au"  
CC: 



Hi Jorke,

 

Don’t mind paying for it. I was looking at the TeamViewer site again earlier. 
Can that really do multiple viewers concurrently, and on a local LAN only?

 

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: Jorke Odolphi [mailto:jo...@jorke.net] 
Sent: Thursday, 20 September 2012 10:52 PM
To: g...@greglow.com; ozdotnet@ozdotnet.com; il.tho...@iinet.net.au
Subject: RE: VNC over wireless vs cabled

 

Teamviewer can do LAN only, but you gotta pay for it. It's nicely cross 
platform too.


Sent from a Phone


 Original message ----
Subject: RE: VNC over wireless vs cabled 
From: "Greg Low (GregLow.com)"  
To: 'Ian Thomas' ,'ozDotNet'  
CC: 

Hi Ian,

 

Yes, I came to Tight VNC by looking at VLC Media Player. It really feels like 
it shouldn’t be rocket science to try to do this. It seems insane to send your 
screen images out to the cloud and then back in to ten other machines in the 
same room, that are on the same network. There has to be a simpler way.

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Thursday, 20 September 2012 10:04 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

VLC Media Player can multicast. I have been working with some video capture, 
and came across one or two CodeProject articles that describe setting up your 
screen as a capture device, so it could be used in conjunction with VLC 
multicasting, or via .NET code with nVLC (a wrapper for libvlc – see also a 
CodeProject, by Roman Ginzburg). 

It seems a circuitous route, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Thursday, September 20, 2012 7:40 PM
To: 'Ken Schaefer'; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

Hi Ken,

 

Good question for #1. Can’t find any reference to it in the setup or in the 
manual.

 

For #2, answer is no at present. Mind you, for some reason it’s stopped even 
when they’re on the same wired network. Earlier today that worked L

 

There really must be a good way to project a screen image to a set of machines 
on the same wired network without having to go out an Internet connection and 
back in. Anyone got any other ideas? 

 

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, 20 September 2012 3:41 PM
To: g...@greglow.com; ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Does the wireless access point in your device support multicasting packets 
received on the wireless interface?

Does it work if the projector is connected to a wired port, and the clients are 
on the WiFi?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 20 September 2012 3:12 PM
To: 'ozDotNet'
Subject: VNC over wireless vs cabled

 

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982 with 
wired connections to a router, all is good. But if I try to do that using a 
wireless connection to the same router, I’m having no luck at all.

 

Any ideas on this? I can’t see anything blocked in the router config, 
specifically for wireless connections.

 

I’d love to be able to just take a wireless router with me, and be able to 
project my desktop

RE: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Jorke,

 

Don't mind paying for it. I was looking at the TeamViewer site again
earlier. Can that really do multiple viewers concurrently, and on a local
LAN only?

 

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: Jorke Odolphi [mailto:jo...@jorke.net] 
Sent: Thursday, 20 September 2012 10:52 PM
To: g...@greglow.com; ozdotnet@ozdotnet.com; il.tho...@iinet.net.au
Subject: RE: VNC over wireless vs cabled

 

Teamviewer can do LAN only, but you gotta pay for it. It's nicely cross
platform too.


Sent from a Phone


 Original message 
Subject: RE: VNC over wireless vs cabled 
From: "Greg Low (GregLow.com)"  
To: 'Ian Thomas' ,'ozDotNet' 

CC: 



Hi Ian,

 

Yes, I came to Tight VNC by looking at VLC Media Player. It really feels
like it shouldn't be rocket science to try to do this. It seems insane to
send your screen images out to the cloud and then back in to ten other
machines in the same room, that are on the same network. There has to be a
simpler way.

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Thursday, 20 September 2012 10:04 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

VLC Media Player can multicast. I have been working with some video capture,
and came across one or two CodeProject articles that describe setting up
your screen as a capture device, so it could be used in conjunction with VLC
multicasting, or via .NET code with nVLC (a wrapper for libvlc - see also a
CodeProject, by Roman Ginzburg). 

It seems a circuitous route, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, September 20, 2012 7:40 PM
To: 'Ken Schaefer'; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

Hi Ken,

 

Good question for #1. Can't find any reference to it in the setup or in the
manual.

 

For #2, answer is no at present. Mind you, for some reason it's stopped even
when they're on the same wired network. Earlier today that worked L

 

There really must be a good way to project a screen image to a set of
machines on the same wired network without having to go out an Internet
connection and back in. Anyone got any other ideas? 

 

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, 20 September 2012 3:41 PM
To: g...@greglow.com; ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Does the wireless access point in your device support multicasting packets
received on the wireless interface?

Does it work if the projector is connected to a wired port, and the clients
are on the WiFi?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 20 September 2012 3:12 PM
To: 'ozDotNet'
Subject: VNC over wireless vs cabled

 

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982
with wired connections to a router, all is good. But if I try to do that
using a wireless connection to the same router, I'm having no luck at all.

 

Any ideas on this? I can't see anything blocked in the router config,
specifically for wireless connections.

 

I'd love to be able to just take a wireless router with me, and be able to
project my desktop to the other machines in the room, without the need for
either a projector or a switch and cables.

 

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: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Ian,

 

Yes, I came to Tight VNC by looking at VLC Media Player. It really feels
like it shouldn't be rocket science to try to do this. It seems insane to
send your screen images out to the cloud and then back in to ten other
machines in the same room, that are on the same network. There has to be a
simpler way.

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Thursday, 20 September 2012 10:04 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

VLC Media Player can multicast. I have been working with some video capture,
and came across one or two CodeProject articles that describe setting up
your screen as a capture device, so it could be used in conjunction with VLC
multicasting, or via .NET code with nVLC (a wrapper for libvlc - see also a
CodeProject, by Roman Ginzburg). 

It seems a circuitous route, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, September 20, 2012 7:40 PM
To: 'Ken Schaefer'; 'ozDotNet'
Subject: RE: VNC over wireless vs cabled

 

Hi Ken,

 

Good question for #1. Can't find any reference to it in the setup or in the
manual.

 

For #2, answer is no at present. Mind you, for some reason it's stopped even
when they're on the same wired network. Earlier today that worked L

 

There really must be a good way to project a screen image to a set of
machines on the same wired network without having to go out an Internet
connection and back in. Anyone got any other ideas? 

 

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, 20 September 2012 3:41 PM
To: g...@greglow.com; ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Does the wireless access point in your device support multicasting packets
received on the wireless interface?

Does it work if the projector is connected to a wired port, and the clients
are on the WiFi?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 20 September 2012 3:12 PM
To: 'ozDotNet'
Subject: VNC over wireless vs cabled

 

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982
with wired connections to a router, all is good. But if I try to do that
using a wireless connection to the same router, I'm having no luck at all.

 

Any ideas on this? I can't see anything blocked in the router config,
specifically for wireless connections.

 

I'd love to be able to just take a wireless router with me, and be able to
project my desktop to the other machines in the room, without the need for
either a projector or a switch and cables.

 

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: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Stephen,

 

Tight VNC Projector just takes screen changes at predefined timeframes (eg: 
10ms) and sends them out as a stream of UDP packets on port 5892, using 
multicast. The Receiver program should then just pick them up and display 
what’s on the screen. The trick nowadays seems to get to get the packets from 
the sender to the receivers.

 

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: Stephen Price [mailto:step...@perthprojects.com] 
Sent: Thursday, 20 September 2012 3:38 PM
To: g...@greglow.com; ozDotNet
Subject: Re: VNC over wireless vs cabled

 

Hey Greg,

 

I'm assuming you've tried pinging the projector from both wired and wireless 
connections and compared results?

Sounds like a useful setup. Does the projector support adhoc connections? Maybe 
you can dispense with the router all together?

 

cheers,

Stephen

On Thu, Sep 20, 2012 at 1:12 PM, Greg Low (GregLow.com)  
wrote:

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982 with 
wired connections to a router, all is good. But if I try to do that using a 
wireless connection to the same router, I’m having no luck at all.

 

Any ideas on this? I can’t see anything blocked in the router config, 
specifically for wireless connections.

 

I’d love to be able to just take a wireless router with me, and be able to 
project my desktop to the other machines in the room, without the need for 
either a projector or a switch and cables.

 

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: VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Ken,

 

Good question for #1. Can't find any reference to it in the setup or in the
manual.

 

For #2, answer is no at present. Mind you, for some reason it's stopped even
when they're on the same wired network. Earlier today that worked L

 

There really must be a good way to project a screen image to a set of
machines on the same wired network without having to go out an Internet
connection and back in. Anyone got any other ideas? 

 

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, 20 September 2012 3:41 PM
To: g...@greglow.com; ozDotNet
Subject: RE: VNC over wireless vs cabled

 

Does the wireless access point in your device support multicasting packets
received on the wireless interface?

Does it work if the projector is connected to a wired port, and the clients
are on the WiFi?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 20 September 2012 3:12 PM
To: 'ozDotNet'
Subject: VNC over wireless vs cabled

 

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982
with wired connections to a router, all is good. But if I try to do that
using a wireless connection to the same router, I'm having no luck at all.

 

Any ideas on this? I can't see anything blocked in the router config,
specifically for wireless connections.

 

I'd love to be able to just take a wireless router with me, and be able to
project my desktop to the other machines in the room, without the need for
either a projector or a switch and cables.

 

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

 

 

VNC over wireless vs cabled

[Greg Low (GregLow.com)]

Hi Folks,

 

If I use Tight VNC Projector to project my screen using VNC over UDP 5982
with wired connections to a router, all is good. But if I try to do that
using a wireless connection to the same router, I'm having no luck at all.

 

Any ideas on this? I can't see anything blocked in the router config,
specifically for wireless connections.

 

I'd love to be able to just take a wireless router with me, and be able to
project my desktop to the other machines in the room, without the need for
either a projector or a switch and cables.

 

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:   www.sqldownunder.com

 

 

RE: SQL Server feature or a bug?

[Greg Low (GregLow.com)]

Hi Jano,

 

That's just not how it works. SQL Server has deferred name resolution. For
tables that exist, it tries to check for cannot check those that it doesn't
know about. For example, try the following:

 

USE tempdb;

GO

 

CREATE PROC dbo.AccessNoSuchTable

AS

  SELECT NoSuchColumn FROM NoSuchTable;

GO

 

EXEC dbo.AccessNoSuchTable;

 

Another concept is that creating (or cataloguing) a procedure doesn't
compile it. That happens at execution time.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Jano Petras
Sent: Sunday, 19 August 2012 12:48 AM
To: ozdotnet@ozdotnet.com
Subject: SQL Server feature or a bug?

 

Hi folks,

I have encountered a weird behaviour of SQL Server 2008 R2 yesterday, so
wanted to share this experience with the list. 

If a #temp table is used in a SQL select statement within a stored
procedure, SQL server does not validate the fields at all. 

An example:

create procedure test_dummyfield
as
begin

select
non_existing_field1
from
FX_ORDER ord
inner join #temp t
on t.non_existing_field2 = ord.non_existing_field3
inner join FX_ORDER_LINE ordline
on ord.non_existing_field4 = ordline.non_existing_field5
where
ord.non_existing_field6 = 120
end


This stored procedure will compile nicely, but will obviously crash on
execution. If temp table is removed, the SP cannot be created as it raises
errors about non-existing fields. 

As much as I try to think of an obvious reason (apart from bug in SQL
server), I cannot see why it would not validate other tables (I do
understand that #temp cannot be always validated). 


So, just be wary that this happens. I have relied upon validation when
drop/create of a procedure happened to make sure there are no issues with
fields / tables used, and this proved to be a bit of an issue obviously. 


Cheers,
jano

RE: Anyone clever with RSS feeds?

[Greg Low (GregLow.com)]

Brilliant. Thanks Michael. That was the issue with the different formats.

 

Now if I can just solve the mysteries of iTunes, all will be well with the 
world J

 

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: Michael Minutillo [mailto:michael.minuti...@gmail.com] 
Sent: Wednesday, 15 August 2012 9:14 PM
To: g...@greglow.com; ozDotNet
Subject: Re: Anyone clever with RSS feeds?

 

Hi Greg,

 

In IE episode 36 is the only one that shows the value of the pubDate element. 
I'm guessing that's because the pubDate element should conform to RFC-822 and 
have a 3-char month whereas yours are full month name. It just so happens that 
episode 36 was published in May, the month which only HAS 3 chars so it 
coincidentally gets parsed correctly. I guess IE prioritizes the episodes with 
known publish dates.

 

Not sure about the itunes issue. That's not my arena ;)

 


Michael M. Minutillo
Indiscriminate Information Sponge
http://codermike.com



On Wed, Aug 15, 2012 at 6:18 PM, Greg Low (GregLow.com)  
wrote:

Hi Folks,

 

When I view the following feed in IE: 
http://www.sqldownunder.com/SQLDownUnderMP3Feed.xml the feed view puts show 36 
first. I’ve stared at it for ages and can’t for the life of me work out what’s 
different about that entry.

 

While you’re at it, if anyone is good with iTunes, I’d also like a clue about 
why the icons appear in iTunes but don’t show up for each show…

 

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

 

 

 

Anyone clever with RSS feeds?

[Greg Low (GregLow.com)]

Hi Folks,

 

When I view the following feed in IE:
http://www.sqldownunder.com/SQLDownUnderMP3Feed.xml the feed view puts show
36 first. I've stared at it for ages and can't for the life of me work out
what's different about that entry.

 

While you're at it, if anyone is good with iTunes, I'd also like a clue
about why the icons appear in iTunes but don't show up for each show:

 

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:   www.sqldownunder.com

 

 

RE: One one way sync from sql to sql thru webservice?

[Greg Low (GregLow.com)]

It's not free but it's also not that expensive and there are free trials.

 

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: ifum...@gmail.com [mailto:ifum...@gmail.com] 
Sent: Monday, 6 August 2012 10:56 AM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

Never used azure...is this free, or can i get trial?

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Saturday, 4 August 2012 12:11 PM
To: 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

I'd be tempted to use a small SQL Azure database and configure a data sync
group. That way, both of your servers can reach out to a common place and
don't need to be able to hit each other directly.

 

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 ifum...@gmail.com
Sent: Friday, 3 August 2012 8:47 PM
To: 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

Sorry been out of office all week, wish to about 1000 thousand records a day
one way.

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 2 August 2012 4:16 PM
To: 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

How much data is involved? Is it a one-off or a regular thing?

 

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 Tom Rutter
Sent: Thursday, 2 August 2012 3:44 PM
To: ozDotNet
Subject: Re: One one way sync from sql to sql thru webservice?

 

one way would be to do a filedump on one end then load it in on the other

On Wed, Aug 1, 2012 at 5:15 PM, Anthony Mayan  wrote:

Hoping someone can help, we have an internal database at ur office which we
need to export to a website database.What is the best way to do this?

There is no direct link from office db to website db.

We only need to do a one way synch(Office to website db)

We currently have a application  at office that that connects to the server
through a webservice, but how would we handler thousands of records.


Anthony

 

RE: One one way sync from sql to sql thru webservice?

[Greg Low (GregLow.com)]

I'd be tempted to use a small SQL Azure database and configure a data sync
group. That way, both of your servers can reach out to a common place and
don't need to be able to hit each other directly.

 

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 ifum...@gmail.com
Sent: Friday, 3 August 2012 8:47 PM
To: 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

Sorry been out of office all week, wish to about 1000 thousand records a day
one way.

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 2 August 2012 4:16 PM
To: 'ozDotNet'
Subject: RE: One one way sync from sql to sql thru webservice?

 

How much data is involved? Is it a one-off or a regular thing?

 

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 Tom Rutter
Sent: Thursday, 2 August 2012 3:44 PM
To: ozDotNet
Subject: Re: One one way sync from sql to sql thru webservice?

 

one way would be to do a filedump on one end then load it in on the other

On Wed, Aug 1, 2012 at 5:15 PM, Anthony Mayan  wrote:

Hoping someone can help, we have an internal database at ur office which we
need to export to a website database.What is the best way to do this?

There is no direct link from office db to website db.

We only need to do a one way synch(Office to website db)

We currently have a application  at office that that connects to the server
through a webservice, but how would we handler thousands of records.


Anthony

 

RE: One one way sync from sql to sql thru webservice?

[Greg Low (GregLow.com)]

How much data is involved? Is it a one-off or a regular thing?

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tom Rutter
Sent: Thursday, 2 August 2012 3:44 PM
To: ozDotNet
Subject: Re: One one way sync from sql to sql thru webservice?

 

one way would be to do a filedump on one end then load it in on the other

On Wed, Aug 1, 2012 at 5:15 PM, Anthony Mayan  wrote:

Hoping someone can help, we have an internal database at ur office which we
need to export to a website database.What is the best way to do this?

There is no direct link from office db to website db.

We only need to do a one way synch(Office to website db)

We currently have a application  at office that that connects to the server
through a webservice, but how would we handler thousands of records.


Anthony

 

RE: [OT] Detect ADSL modem in use

[Greg Low (GregLow.com)]

That does look quick. I’m in a populated area well served by cable so it looks 
like the NBN is going to be some time away for me.

 

It’s interesting to see how other countries are going though. A colleague was 
recently in a hotel in Chile and had 250Mb/s down and 220 up, to a US-based 
hub, from within the hotel room. (And of course it was included in the low room 
fee…)

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Ian Thomas
Sent: Tuesday, 31 July 2012 12:11 PM
To: 'ozDotNet'
Subject: RE: [OT] Detect ADSL modem in use

 

They can’t spell fibre correctly in Kansas. 

 

  _  

Ian Thomas
Victoria Park, Western Australia

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of ben.robb...@jlta.com.au
Sent: Tuesday, July 31, 2012 9:06 AM
To: ozdotnet@ozdotnet.com
Subject: RE: [OT] Detect ADSL modem in use

 

Or you could move to Kansas...

https://fiber.google.com/about/ 

 

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Ian Thomas
Sent: Sunday, 29 July 2012 12:43 PM
To: 'ozDotNet'
Subject: RE: [OT] Detect ADSL modem in use

 

Nooo…  months is my firm belief. There’s plenty of work happening by Syntheo, 
here. 

Forcing 121 PIOs on them instead of 14 is one of the things that small-minded 
people should be blamed for. 

Just what deals will be available from RSPs will be interesting. They will all 
be offering bundled consumer products of course – IP TV, etc etc. 

  _  

Ian Thomas
Victoria Park, Western Australia

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of David Connors
Sent: Sunday, July 29, 2012 11:46 AM
To: ozDotNet
Subject: Re: [OT] Detect ADSL modem in use

 

 

On Sat, Jul 28, 2012 at 7:51 PM, Ian Thomas  wrote:

 

[ ... ]

Anyway (months ago now), I took the combined suggestions of Les Hughes and 
David Connors – see below - which gave rise to a very simple .NET DLL that 
called on the Windows system file, iphlpapi.dll That component is available in 
all 32/64 bit Windows since Windows 2000 I think. And pInvoke info was helpful.

 

Always good to see a happy ending to an ozdotnet adventure.

 

It will lovely to get the NBN here in the next 12 months and hopefully to do 
away with cantankerous copper connections. I have a neighbour in the same 
rollout FSA 6VIC-02 with a max ADSL speed of about 2x dial-up.

I think you meant to say 12 years, not 12 months. :) 

 

-- 

David Connors

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

 


This email is intended for the named recipient only.  The information it 
contains
may be confidential or commercially sensitive.  If you are not the intended
recipient you must not reproduce or distribute any part of this email, disclose 
its
contents to any other party, or take any action in reliance on it.  If you have
received this email in error, please contact the sender immediately and delete 
the
message from your computer.

 

RE: ASP.NET modal dialog effect

[Greg Low (GregLow.com)]

I think that was my point. From my (limited) experience with this, I found
that jquery fixed most of my cross-browser issues on these sorts of things,
much better than I could have. I can't imagine having to write the
javascript all by hand nowadays, and having any chance of cross-browser
success.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Heinrich Breedt
Sent: Thursday, 19 July 2012 9:33 AM
To: ozDotNet
Subject: Re: ASP.NET modal dialog effect

 

really curious to hear what browser compatibilty issues you are referring to
with regards to javascript and/or jquery.

 

I write js and jquery a lot. The server is exclusively to get/save/update
data. webpage handles all html layout interactions etc with js, jquery. Even
back in the day when I wrote webforms I used jquery a lot. 

Intelisense these days is really great. 

 

I honestly find it hard to even think of producing websites without client
side scripting. The maintenance issues of doing everything serverside must
be a nightmare.

Case in point: producing a modal dialog effect - trivial with jquery ui ,
seems like a nightmare with the all server side approach

On Thu, Jul 19, 2012 at 9:12 AM, Greg Keogh  wrote:

>Are you writing the javascript directly or using jquery?

 

Sorry for the late reply, yes I occasionally code JavaScript by hand when I
need it. I have never found a suitable tool that helps me write reliable
cross-browser friendly JavaScript. Although I haven't looked very hard due
to my natural aversion to the horrors of client scripting.

 

If there are people in here who actually like writing JavaScript by one
means or another, then I'm curious to hear what tools or techniques they
use. Are there people who can knock-up or generate reliable JavaScript with
the ease that I write C# code in the IDE?

 

I get depressed because I actually admire the JavaScript language a lot, but
I can never get to use it in anger because of frustrating issues about how
it's hosted, browser compatibility issues, tool support, intellisense, etc.
I'm happy to study something like jQuery if people think it's a valuable
investment of my time.

 

Greg

 





 

-- 
Heinrich Breedt

"Do not wait to strike till the iron is hot; but make it hot by striking." -
William B. Sprague

RE: ASP.NET modal dialog effect

[Greg Low (GregLow.com)]

Hi Greg,

 

Are you writing the javascript directly or using jquery?

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Tuesday, 17 July 2012 2:56 PM
To: 'ozDotNet'
Subject: RE: ASP.NET modal dialog effect

 

"My previous experience with Javascript and   ASP.NET
combined has been a nightmare of quirks and failure trying to manage the
lifetime and interaction of the two."

I've never had a problem of this sort.

 

Then I must be an idiot. A few months ago it took me 3 hours to write a few
lines of Javascript that enabled some controls when you changed other
controls, and when I thought it was working beautifully in different
browsers I discovered that a page load sometimes upset the sequence of
events and it failed. So I stuff different bits of code into the different
emit events in the ASP.NET page lifetime and it just gets worse and
incomprehensible. Someone in here said that "javascript is like the assembly
language of the web" ... well yeah, it's hell to write it yourself. The
whole history of the web, html and scripting is a gigantic mess of
uncoordinated hacks and half-baked ideas, compounded by different standards
and browser behaviour. Once day we'll all look back and laugh at the days of
html5 when gigantic compiler generated non human readable scripts were
driving rectangles and lines across browser screens. I'm laughing already.

 

Greg

 

RE: ASP.NET modal dialog effect

[Greg Low (GregLow.com)]

Hi Greg,

 

Along with what the other guys have said, I'd add a vote for "try to avoid
the need for anything modal if possible". Is there any way to avoid the need
for it to be modal?

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Tuesday, 17 July 2012 9:55 AM
To: 'ozDotNet'
Subject: ASP.NET modal dialog effect

 

Folks, we have a traditional ASP.NET page with a need for a popup "product
picker". We need that mock modal dialog effect you get (for example) in
Gmail where you do things like Export Contacts, create New Group, etc. Gmail
even has a nice effect where the background disables and the popup has a
drop shadow and a close X button to simulate a real model window in a web
page.

 

What is the quickest and least painful way of getting this modal dialog
effect in an ASP.NET page?

 

My previous experience with Javascript and ASP.NET combined has been a
nightmare of quirks and failure trying to manage the lifetime and
interaction of the two. So I'm hoping there are some kits or tools to help
me. Any advice would be greatly appreciated so I can knock-up a demo asap.

 

Thanks

Greg

RE: Deploying SQL reports to multiple sites

[Greg Low (GregLow.com)]

Have to agree. Calling the webservice is quite easy and if that's too messy,
using the rs command line utility as Donald mentioned below is a good
option. There are lots of sample .rss files around. The contents of them is
basically like VB but you're best to just start with any sample. 

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Donald
Sent: Thursday, 21 June 2012 1:10 PM
To: ozDotNet
Subject: Re: Deploying SQL reports to multiple sites

 

We have used a set of batch files to deploy SSRS to various different
environments

 

Use the command line deployment utility

 

rs -i PublishSampleReports.rss -s   http:///reportserver 

 

Create a 'core' batch file that contains all the files (reports, images,
data sources, etc) to deploy, but with parameters.  Then create a batch file
for each environment with parameters passed into the 'core' batch file.
Hope that this makes sense.

 

Don.

 

On 21 June 2012 11:23, Stuart Kinnear  wrote:

When deploying SQL reports 2008  from Visual Studio it is a pain when it
comes to deploying to a few different sites. I tried setting up different
configurations using the Configuration Manager  & that failed miserably. I
have a couple of test virtual machines and a couple of customers to deploy
to with patches and new reports, it seems ridiculous to have to manually set
up the target server every time.

 

Anyway I came across this application called RSBuild, but it seems to be a
bit buggy & not updated for a while. When I try to use UNC paths for the
location of the rdl files it fails and if I map the UNC path to a drive I
get a error stating that "the given path's format is not supported". Perhaps
if I move the config and/or the rsbuild app to the unc location it may work.

 

Is there a better way ?  Surely there must be !


 

-- 

-
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 connection taking ages when using IP Address vs Computer Name

[Greg Low (GregLow.com)]

Sorry, have been offline but I'm with Stephen & others that it sounds like a
routing issue. Try a tracert to the server.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stephen Price
Sent: Thursday, 7 June 2012 5:54 PM
To: ozDotNet
Subject: Re: sql connection taking ages when using IP Address vs Computer
Name

 

My guess is something weird with routing. How many networks are you on? Just
one, or more than one? (ie wifi and lan)

Perhaps one goes via wifi the other goes different route. I'm also assuming
that using the name resolves to the same IP. What happens if you
ping/tracert to the IP and/or name. Different results or same?

On Thu, Jun 7, 2012 at 3:43 PM, Wallace Turner 
wrote:

Hi All (especially Greg Low tho),

I've been debugging an issue whereby conn.Open( ) was/is taking 5 seconds to
connect to a machine on the LAN (same VM host actually)



I've 'fixed' this by changing the connection string.  Was:
database=FooDb;server=10.210.10.130;trusted_connection=true; //takes 5
seconds to conn.Open( )

and changed to:

database=FooDb;server=sql-svr;trusted_connection=true; //takes 30ms seconds
to conn.Open( )


This behavior is consistent on subsequent runs (it is just a simple console
app). You don't even need to query anything which proves its nothing to do
with a specific query.

Why does this cause an issue? Well if the application is idle for 5 minutes
then the next person to 'do something' has to wait 5 secs for the sql conn
to open.
Someone care to explain? 

 

<>

RE: [OT] It's not Friday, but I've had a tough last 3 weeks ...

[Greg Low (GregLow.com)]

Most are also paid on how quickly they process calls. I see lots of people
tell them that they need to talk to X where X is some random name
and that they'll put them through to them but then just put them on hold
permanently seems to work well at stopping them coming back too often.

 

Of course, this was always a pretty funny solution too:

http://www.engadget.com/2005/09/12/the-telecrapper-2000/

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Arjang Assadi
Sent: Thursday, 7 June 2012 10:25 AM
To: ozDotNet
Subject: Re: [OT] It's not Friday, but I've had a tough last 3 weeks ...

 

  

I'm sure they understand all English swear words mate :) 

Just try ... 

 

 

Nop, That is not recomended, for follwoing reasons:

 

The scammers have your details, they might decide to move you to their VIP
list or god knows what ever other evil scham list they might have.

After all they are criminals and last thing honest people need is to have
any more interaction with shady types than the absolute minimum.

 

Just pretend they are selling a service you are not intrested in and move
on, scams work statistically, and no matter how many people decide to do
something about it they just move shop and methods.

 

Do a read on scham histories their methods and techniques, they are just an
industry ( of artistic/creative/illegal/immoral type) that have existsted
and will continue to exist due to the very human nature.

 

Maybe somebody can offer them a legit job, after all people will tend
towards honest work if they are given the chance, here is an inspriring
story :
http://www.michaelcarwile.com/inspiring-man-gives-coat-to-his-mugger/

 

Curse the cause that makes people go down into the illegit path not the
people, people can always change if only given the chance.

 

Regards

 

Arjang





On Thu, Jun 7, 2012 at 9:41 AM, mike smith  wrote:

On Thu, Jun 7, 2012 at 9:36 AM, Iain Carlin  wrote:
> Love it...is it Monday, Tuesday, Wednesday...etc. LOL.
>
> Agree with the idea of playing them along. I did similar to this guy, "I
> have 5 computers, which one is faulty". Spun the guy on for about 5
minutes
> before he comes back with "Ah, you are some sort of smart***. Bet you are
> jack of all trades and master of none". At that point I lost it with him
and
> my kids heard some new words :-) Felt kind of relaxing to scream some
choice
> language down the phone at some Indian clown.
>

They bothered my mum.  So I got her an iMac.  Convo starts "You've got
a Windows computer" "NO"  From there it's downhill for them.  I
suppose eventually they'll get a script for Apples.

Anyone know some good Indian swear words to use on the phone?

--
Meski

 http://courteous.ly/aAOZcv

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

 

 

RE: Free eBooks (Microsoft Press)

[Greg Low (GregLow.com)]

Yeah, I'm happy to see him get $10 for that J

 

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 Ian Thomas
Sent: Thursday, 31 May 2012 7:14 PM
To: 'ozDotNet'
Subject: RE: Free eBooks (Microsoft Press)

 

Damn - I paid the full price! At ~$AUS11 and with progressive new releases,
plus O'Reilly's "lifetime access" etc, that's not too bad I guess"

 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Jiri Kosar
Sent: Thursday, May 31, 2012 5:03 PM
To: 'g...@greglow.com'; 'ozDotNet'
Subject: RE: Free eBooks (Microsoft Press)

 

If you apply this code : MYEP9

It will drop 50% off 

 

Jiri

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 31 May 2012 6:50 PM
To: 'ozDotNet'
Subject: RE: Free eBooks (Microsoft Press)

 

Sweet. Thanks for the link Grant.

 

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:%5bmailto:ozdotnet-boun...@ozdotnet.com%5d>  On Behalf Of Grant
Castner
Sent: Thursday, 31 May 2012 2:19 PM
To: ozDotNet
Subject: Re: Free eBooks (Microsoft Press)

 

Charles Petzold has a consumer preview for $10 of his new sixth edition of
Programming Windows which includes developing for Windows 8. The price
increases June 1.

 

See http://charlespetzold.com/ 



  <http://www.castnerit.com.au/images/castnerITLogo_96x96.png> 

Castner IT Pty Ltd 
Dr Grant Castner 
Director

e: gcast...@castnerit.com.au

w: http://www.castnerit.com.au <http://www.castnerit.com.au/> 
p: 0458 770 749 

a: P.O. Box 952 Mooloolaba QLD 4557
twitter: @castnerit <http://twitter.com/CastnerIT> 
facebook:
<http://www.facebook.com/pages/Brisbane-Australia/Castner-IT/291936316886?v=
info> facebook.com/castnerit

 

 

 

On 31 May 2012 11:34, Stephen Price  wrote:

Interesting choice of cover tools. The Moving to Visual Studio 2010
has a pair of pliers on the cover. Somehow appropriate. My mental
image, for some reason, imagined the pliers being used on my teeth.
*erk*

lol


On Thu, May 31, 2012 at 9:19 AM, Ian Thomas  wrote:
> These 10 free eBooks (PDF, XPS) from Microsoft Press have been available
for
> some time, I think - but someone sent me a link just today.
>
> One of interest may be Programming Windows Phone 7, by Charles Petzold.
This
> has epub, MOBI (Kindle) versions as well - plus code for C#, VB.NET
> (separate downloads).
>
> The general link is here - the 10 topics (not exact titles) are:
>
> SQL Server 2012, SQL Server 2008 R2, Windows Server 2008 R2, office 365,
> Office 2010, Security and privacy for Office 2010, Moving to VS2010,
> Understanding Virtualization Solutions, Deploying Windows 7, Programming
> Windows Phone 7
>
> 
>
> Ian Thomas
> Victoria Park, Western Australia
>
>

 

RE: Free eBooks (Microsoft Press)

[Greg Low (GregLow.com)]

Sweet. Thanks for the link Grant.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Grant Castner
Sent: Thursday, 31 May 2012 2:19 PM
To: ozDotNet
Subject: Re: Free eBooks (Microsoft Press)

 

Charles Petzold has a consumer preview for $10 of his new sixth edition of
Programming Windows which includes developing for Windows 8. The price
increases June 1.

 

See http://charlespetzold.com/ 



   

Castner IT Pty Ltd 
Dr Grant Castner 
Director

e: gcast...@castnerit.com.au

w: http://www.castnerit.com.au  
p: 0458 770 749 

a: P.O. Box 952 Mooloolaba QLD 4557
twitter: @castnerit  
facebook:
 facebook.com/castnerit

 

 





On 31 May 2012 11:34, Stephen Price  wrote:

Interesting choice of cover tools. The Moving to Visual Studio 2010
has a pair of pliers on the cover. Somehow appropriate. My mental
image, for some reason, imagined the pliers being used on my teeth.
*erk*

lol


On Thu, May 31, 2012 at 9:19 AM, Ian Thomas  wrote:
> These 10 free eBooks (PDF, XPS) from Microsoft Press have been available
for
> some time, I think - but someone sent me a link just today.
>
> One of interest may be Programming Windows Phone 7, by Charles Petzold.
This
> has epub, MOBI (Kindle) versions as well - plus code for C#, VB.NET
> (separate downloads).
>
> The general link is here - the 10 topics (not exact titles) are:
>
> SQL Server 2012, SQL Server 2008 R2, Windows Server 2008 R2, office 365,
> Office 2010, Security and privacy for Office 2010, Moving to VS2010,
> Understanding Virtualization Solutions, Deploying Windows 7, Programming
> Windows Phone 7
>
> 
>
> Ian Thomas
> Victoria Park, Western Australia
>
>

 

RE: Application Interface Options for Integration

[Greg Low (GregLow.com)]

Hi Michael,

 

Have you considered SQL Server Service Broker? It would provide you with a
transacted queue between the SQL Server databases.

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Michael O'Dea-Jones
Sent: Monday, 14 May 2012 1:21 PM
To: ozDotNet (ozdotnet@ozdotnet.com)
Subject: Application Interface Options for Integration

 

Hi all,

 

Scenario: 

 

1.   Two systems need to be able to communicate via middleware

2.   Source System is ASP.Net 4.0 web application

a.   Has SQL Server Database

b.  Exports via Export tables in SQL database

3.   Destination System is not a .Net application

a.   Has SQL Server Database

b.  Imports via control tables in SQL database

4.   Middleware is .Net 4.0 system with WCF services

a.   Customised .Net plug-ins will be written to ETL from source to
destination systems

 

Current ETL is via SSIS packages and there are issues with sequencing,
performance and lack of business rules, logging and alerting. Source System
Vendor is happy to implement WCF services to push data to middleware though
they need time to upskill. 

 

Could I have an opinion on this idea:

 

Developer supply Source System Vendor with .Net library which they integrate
into the source system. Library has a couple of method calls that submit
messages from source system to middleware via WCF. A provider pattern could
be implemented in the class library so other clients could supply their own
"export" providers.

 

Pros: 

 

Easy for source system vendor to implement as they don't have to research
and develop WCF solution

Costs client less because fewer changes are required to the source system

Client gets update quicker

Client has the flexibility to update Export Provider any time they like

Other Clients could implement non-WCF Export 

 

Cons:

 

Architecturally it might be better to implement WCF from the start

Might reduce operational calls and issue complexity for the Vendor if there
is only one way to export data

 

 

Regards,

 

Michael O'Dea-Jones

 

RE: Selecting data stored using FileStream in SQl Server

[Greg Low (GregLow.com)]

Hi Stuart,

 

Take a look at the ADO.NET samples here for reading varbinary(max) columns:

http://msdn.microsoft.com/en-us/library/bb399384.aspx (in particular,
GetSqlBinary and GetBytes).

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stuart Kinnear
Sent: Sunday, 13 May 2012 11:19 AM
To: ozDotNet
Subject: Re: Selecting data stored using FileStream in SQl Server

 

You can get stuff in very easily using the plethora of examples, however
using T-SQL to get the record out is not possible, perhaps because of the
need to isolate the field value and deal with it separately. If you were to
create a clr function using the info available for c# code then you would
have means to do it via SQL server.

 

I played with the idea of using bcp, but it corrupted the binary. Perhaps as
bcp expects a tabulated output it adds termination values to the file .


eg.

declare @sql varchar(8000)

select @sql = 'bcp "SELECT TOP 1 blob FROM mydatabase.dbo.Myblob" queryout
c:\Temp\Mydump.txt -n -T -S MyServer\MyInstance'

exec master.. xp_cmdshell @sql 

 

this might work for you if the records were plain text.

 

 

Regards, Stuart

 

 

 

On 12 May 2012 23:33, Peter Maddin  wrote:

I have found examples of how to use T-SQL to insert a file as a Filestream
blob in SQL Server 2008.

 

I have not been successful at finding out how to use just T-SQL to select
the same blob data to a local file.

All the examples I have seen are code based (C# etc.). Is it possible just
to use T-SQL to persist a FileStream blob to a local file?

 

Regards Peter Maddin

 

 





 

-- 

-
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.

-

Blog module for DNN 6

[Greg Low (GregLow.com)]

Anyone got a recommendation for a high quality blog module for DNN?

 

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:   www.sqldownunder.com

 

RE: Powerpoint pain

[Greg Low (GregLow.com)]

Thanks Ian. That's a good idea. If it doesn't do it, I'll ping them because
they say they're keen on ideas.

 

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 Ian Thomas
Sent: Tuesday, 17 April 2012 4:03 PM
To: 'ozDotNet'
Subject: RE: Powerpoint pain

 

Greg 

For enhancing OL, I usually write something myself - but I have never tried
for PPT. 

There is a vibrant industry based on add-ins for Outlook (all versions, even
the oldest), and the same exists for PowerPoint. 

Out of interest (because I have little need for extensive re-hashing of PPT
presentations, so have no recommendations based on experience), I searched
and found (example, not a recommendation) PPTXtreme - see the attached 90Kb
PDF created from its web page. I'm sure you could find something for << $50
that might save time and angst! 

 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Tuesday, April 17, 2012 1:01 PM
To: 'Andrew Coates (DPE AUSTRALIA)'; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi Andrew,

 

Thanks. That seems to do basic stuff with fonts but not sizes, etc.

 

It just seems  a real pity that there isn't just way of having "styles"
where you define a name for each combination of font, size, colour like you
can in Word.

 

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: Friday, 13 April 2012 3:18 PM
To: g...@greglow.com; ozDotNet
Subject: RE: Powerpoint pain

 

Ctrl+A then Ctrl+Space usually works for me (as it does in Word)

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
<mailto:%5bmailto:ozdotnet-boun...@ozdotnet.com%5d>  On Behalf Of Greg Low
(GregLow.com)
Sent: Thursday, 12 April 2012 4:34 PM
To: 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi Peter,

 

Thanks but that (unfortunately), has options to "Use destination format",
"Use source format", etc. but regardless, it doesn't change custom font
settings.

 

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:%5bmailto:ozdotnet-boun...@ozdotnet.com%5d>  On Behalf Of Peter
Gfader
Sent: Wednesday, 11 April 2012 11:27 PM
To: ozDotNet
Subject: Re: Powerpoint pain

 

@Greg

 

Another option worth trying is:

1. Select All,

2. Copy 
3. File New Powerpoint with your favourite template

4. Paste

 

 

 

   .peter.gfader. (current mood = happy-go-lucky)

   http://blog.gfader.com

 

 

2012/4/11 Greg Low (GregLow.com) 

Thanks Ian and all. I've just gone and copied (via Notepad) all the text and
then reformatted. Seems like a really odd thing to have no simple way to do.
(And yes, I was dealing with some really odd content formatting).

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Wednesday, 11 April 2012 7:28 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Greg

Styles don't work the same way as you're used to in Word. 

I think you have 2 options: one is to use the format painter, the other is
Tools > Slide Design. But I'm using very olde PPT 2003. 

When the panel appears at right, you can click on one of the available
standard (Design Template) formats (arranged in groups, "Used in this
presentation", "Recently used", "Available for use"). This will change the
currently selected slide, for its "styles" only. The background for the
slides probably has to be changed independently. 

Also, available on the same panel, is a selection "Color Schemes" That may
or may not be useful. 

I suspect that PPT 2010 is a little more flexible, but 2003 works fine for
me. I can appreciate that PPT is a palette / canvas for some people's
incredibly bad taste, thou

RE: Powerpoint pain

[Greg Low (GregLow.com)]

Hi Andrew,

 

Thanks. That seems to do basic stuff with fonts but not sizes, etc.

 

It just seems  a real pity that there isn’t just way of having “styles” where 
you define a name for each combination of font, size, colour like you can in 
Word.

 

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: Friday, 13 April 2012 3:18 PM
To: g...@greglow.com; ozDotNet
Subject: RE: Powerpoint pain

 

Ctrl+A then Ctrl+Space usually works for me (as it does in Word)

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Thursday, 12 April 2012 4:34 PM
To: 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi Peter,

 

Thanks but that (unfortunately), has options to “Use destination format”, “Use 
source format”, etc. but regardless, it doesn’t change custom font settings.

 

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 Peter Gfader
Sent: Wednesday, 11 April 2012 11:27 PM
To: ozDotNet
Subject: Re: Powerpoint pain

 

@Greg

 

Another option worth trying is:

1. Select All,

2. Copy 
3. File New Powerpoint with your favourite template

4. Paste

 

 

 

   .peter.gfader. (current mood = happy-go-lucky)

   http://blog.gfader.com

 

 

2012/4/11 Greg Low (GregLow.com) 

Thanks Ian and all. I’ve just gone and copied (via Notepad) all the text and 
then reformatted. Seems like a really odd thing to have no simple way to do. 
(And yes, I was dealing with some really odd content formatting).

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Wednesday, 11 April 2012 7:28 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Greg

Styles don’t work the same way as you’re used to in Word. 

I think you have 2 options: one is to use the format painter, the other is 
Tools > Slide Design. But I’m using very olde PPT 2003. 

When the panel appears at right, you can click on one of the available standard 
(Design Template) formats (arranged in groups, “Used in this presentation”, 
“Recently used”, “Available for use”). This will change the currently selected 
slide, for its “styles” only. The background for the slides probably has to be 
changed independently. 

Also, available on the same panel, is a selection “Color Schemes” That may or 
may not be useful. 

I suspect that PPT 2010 is a little more flexible, but 2003 works fine for me. 
I can appreciate that PPT is a palette / canvas for some people’s incredibly 
bad taste, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Wednesday, April 11, 2012 4:41 PM
To: 'David Connors'; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi David,

 

The issue is that I can’t find anything on the toolbar that seems to do this. 
What I’m looking for is the equivalent of “styles” in MS Word ie: equivalent of 
grab a piece of text and say “Heading 1” or “Normal”, etc. 

 

I just keep thinking that if there is a Slide Master and I’m happy with it, but 
someone’s gone through and used custom fonts all over the place, that there 
would be an easy way to remove those and set the standard styling from the 
slide master back in place.

 

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: David Connors [mailto:da...@codify.com] 
Sent: Wednesday, 11 April 2012 6:21 PM
To: Greg Low; ozDotNet
Subject: Re: Powerpoint pain

 

Ctrl a + change the stuff on the tool bar? 

You can ctrl click with the format painter too iirc 

On Apr 11, 2012 5:59 PM, "Greg Low (GregLow.com)"  wrote:

Hi Folks,

 

One thing I’ve always wanted to know about PowerPoint is how you can take a 
slide with rubbish fonts, colours, etc. and say “make this look like the fonts, 
etc. in the slide master” ie: how do you “lose” the custom formatting?

 

Thanks in advance.

 

Regards,

 

Greg

 

Dr Gre

RE: Powerpoint pain

[Greg Low (GregLow.com)]

Hi Peter,

 

Thanks but that (unfortunately), has options to “Use destination format”, “Use 
source format”, etc. but regardless, it doesn’t change custom font settings.

 

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 Peter Gfader
Sent: Wednesday, 11 April 2012 11:27 PM
To: ozDotNet
Subject: Re: Powerpoint pain

 

@Greg

 

Another option worth trying is:

1. Select All,

2. Copy 
3. File New Powerpoint with your favourite template

4. Paste

 

 

 

   .peter.gfader. (current mood = happy-go-lucky)

   http://blog.gfader.com

 

 

2012/4/11 Greg Low (GregLow.com) 

Thanks Ian and all. I’ve just gone and copied (via Notepad) all the text and 
then reformatted. Seems like a really odd thing to have no simple way to do. 
(And yes, I was dealing with some really odd content formatting).

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Wednesday, 11 April 2012 7:28 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Greg

Styles don’t work the same way as you’re used to in Word. 

I think you have 2 options: one is to use the format painter, the other is 
Tools > Slide Design. But I’m using very olde PPT 2003. 

When the panel appears at right, you can click on one of the available standard 
(Design Template) formats (arranged in groups, “Used in this presentation”, 
“Recently used”, “Available for use”). This will change the currently selected 
slide, for its “styles” only. The background for the slides probably has to be 
changed independently. 

Also, available on the same panel, is a selection “Color Schemes” That may or 
may not be useful. 

I suspect that PPT 2010 is a little more flexible, but 2003 works fine for me. 
I can appreciate that PPT is a palette / canvas for some people’s incredibly 
bad taste, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Low (GregLow.com)
Sent: Wednesday, April 11, 2012 4:41 PM
To: 'David Connors'; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi David,

 

The issue is that I can’t find anything on the toolbar that seems to do this. 
What I’m looking for is the equivalent of “styles” in MS Word ie: equivalent of 
grab a piece of text and say “Heading 1” or “Normal”, etc. 

 

I just keep thinking that if there is a Slide Master and I’m happy with it, but 
someone’s gone through and used custom fonts all over the place, that there 
would be an easy way to remove those and set the standard styling from the 
slide master back in place.

 

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: David Connors [mailto:da...@codify.com] 
Sent: Wednesday, 11 April 2012 6:21 PM
To: Greg Low; ozDotNet
Subject: Re: Powerpoint pain

 

Ctrl a + change the stuff on the tool bar? 

You can ctrl click with the format painter too iirc 

On Apr 11, 2012 5:59 PM, "Greg Low (GregLow.com)"  wrote:

Hi Folks,

 

One thing I’ve always wanted to know about PowerPoint is how you can take a 
slide with rubbish fonts, colours, etc. and say “make this look like the fonts, 
etc. in the slide master” ie: how do you “lose” the custom formatting?

 

Thanks in advance.

 

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

 

 





 

-- 

 

 

  .peter.gfader. (current mood = happy!) 

  Check this before you go live

  http://blog.gfader.com/2011/07/website-check-list-part-1-aspnet-4.html

 

 

RE: Powerpoint pain

[Greg Low (GregLow.com)]

Thanks Ian and all. I've just gone and copied (via Notepad) all the text and
then reformatted. Seems like a really odd thing to have no simple way to do.
(And yes, I was dealing with some really odd content formatting).

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Wednesday, 11 April 2012 7:28 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Greg

Styles don't work the same way as you're used to in Word. 

I think you have 2 options: one is to use the format painter, the other is
Tools > Slide Design. But I'm using very olde PPT 2003. 

When the panel appears at right, you can click on one of the available
standard (Design Template) formats (arranged in groups, "Used in this
presentation", "Recently used", "Available for use"). This will change the
currently selected slide, for its "styles" only. The background for the
slides probably has to be changed independently. 

Also, available on the same panel, is a selection "Color Schemes" That may
or may not be useful. 

I suspect that PPT 2010 is a little more flexible, but 2003 works fine for
me. I can appreciate that PPT is a palette / canvas for some people's
incredibly bad taste, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

  _____  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Wednesday, April 11, 2012 4:41 PM
To: 'David Connors'; 'ozDotNet'
Subject: RE: Powerpoint pain

 

Hi David,

 

The issue is that I can't find anything on the toolbar that seems to do
this. What I'm looking for is the equivalent of "styles" in MS Word ie:
equivalent of grab a piece of text and say "Heading 1" or "Normal", etc. 

 

I just keep thinking that if there is a Slide Master and I'm happy with it,
but someone's gone through and used custom fonts all over the place, that
there would be an easy way to remove those and set the standard styling from
the slide master back in place.

 

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: David Connors [mailto:da...@codify.com] 
Sent: Wednesday, 11 April 2012 6:21 PM
To: Greg Low; ozDotNet
Subject: Re: Powerpoint pain

 

Ctrl a + change the stuff on the tool bar? 

You can ctrl click with the format painter too iirc 

On Apr 11, 2012 5:59 PM, "Greg Low (GregLow.com)"  wrote:

Hi Folks,

 

One thing I've always wanted to know about PowerPoint is how you can take a
slide with rubbish fonts, colours, etc. and say "make this look like the
fonts, etc. in the slide master" ie: how do you "lose" the custom
formatting?

 

Thanks in advance.

 

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: Powerpoint pain

[Greg Low (GregLow.com)]

Hi David,

 

The issue is that I can’t find anything on the toolbar that seems to do this. 
What I’m looking for is the equivalent of “styles” in MS Word ie: equivalent of 
grab a piece of text and say “Heading 1” or “Normal”, etc. 

 

I just keep thinking that if there is a Slide Master and I’m happy with it, but 
someone’s gone through and used custom fonts all over the place, that there 
would be an easy way to remove those and set the standard styling from the 
slide master back in place.

 

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: David Connors [mailto:da...@codify.com] 
Sent: Wednesday, 11 April 2012 6:21 PM
To: Greg Low; ozDotNet
Subject: Re: Powerpoint pain

 

Ctrl a + change the stuff on the tool bar? 

You can ctrl click with the format painter too iirc 

On Apr 11, 2012 5:59 PM, "Greg Low (GregLow.com)"  wrote:

Hi Folks,

 

One thing I’ve always wanted to know about PowerPoint is how you can take a 
slide with rubbish fonts, colours, etc. and say “make this look like the fonts, 
etc. in the slide master” ie: how do you “lose” the custom formatting?

 

Thanks in advance.

 

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

 

 

Powerpoint pain

[Greg Low (GregLow.com)]

Hi Folks,

 

One thing I've always wanted to know about PowerPoint is how you can take a
slide with rubbish fonts, colours, etc. and say "make this look like the
fonts, etc. in the slide master" ie: how do you "lose" the custom
formatting?

 

Thanks in advance.

 

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:   www.sqldownunder.com

 

 

RE: File/folder sync options for Windows

[Greg Low (GregLow.com)]

Hi Bill,

 

Are you using v7 or v8? There seem to be a lot of people that loved it up to v7 
but are not happy at all with v8.

 

Do you run it as a service or manually? (It seems like v8 has an issue with 
running as a service on Win7)

 

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: Bill Chesnut [mailto:b...@biztalkbill.com] 
Sent: Sunday, 8 April 2012 10:49 AM
To: g...@greglow.com; ozDotNet
Subject: Re: File/folder sync options for Windows

 

Greg,

 

I use some software call 2nd copy (www.secondcopy.com), let you do one-way or 
two-way sync. I have been using it to sync my MSDN to an external drive for a 
couple of years now.



Bill Chesnut
BizTalk Server MVP
Melbourne, Australia

  _  

From: Greg Low (GregLow.com) [mailto:g...@greglow.com]
To: 'ozDotNet' [mailto:ozdotnet@ozdotnet.com]
Sent: Fri, 06 Apr 2012 20:41:58 +1000
Subject: File/folder sync options for Windows

Hi Folks,

 

Anyone got recommendations for file sync? Just a couple of PCs that want to 
share one or more folders between them and also to a NAS that they both can 
access. Happy for the main folder to live on the NAS and for the other two PCs 
to sync with it.

 

I spent time today looking at Offline files in Windows 7 and while it looked 
promising at first, after wasting hours trying to debug its issues, I’ve 
decided it’s not for me.

 

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: File/folder sync options for Windows

[Greg Low (GregLow.com)]

Magic, thanks Bill, I’ll check it out.

 

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: Bill Chesnut [mailto:b...@biztalkbill.com] 
Sent: Sunday, 8 April 2012 10:49 AM
To: g...@greglow.com; ozDotNet
Subject: Re: File/folder sync options for Windows

 

Greg,

 

I use some software call 2nd copy (www.secondcopy.com), let you do one-way or 
two-way sync. I have been using it to sync my MSDN to an external drive for a 
couple of years now.



Bill Chesnut
BizTalk Server MVP
Melbourne, Australia

  _  

From: Greg Low (GregLow.com) [mailto:g...@greglow.com]
To: 'ozDotNet' [mailto:ozdotnet@ozdotnet.com]
Sent: Fri, 06 Apr 2012 20:41:58 +1000
Subject: File/folder sync options for Windows

Hi Folks,

 

Anyone got recommendations for file sync? Just a couple of PCs that want to 
share one or more folders between them and also to a NAS that they both can 
access. Happy for the main folder to live on the NAS and for the other two PCs 
to sync with it.

 

I spent time today looking at Offline files in Windows 7 and while it looked 
promising at first, after wasting hours trying to debug its issues, I’ve 
decided it’s not for me.

 

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: Weird spooler error on Windows 7

[Greg Low (GregLow.com)]

Thanks guys. I tried removing the feature and re-adding it but that doesn't
actually remove the print spooler, etc. It just removes things like Internet
Printing.

 

The weirder thing was that when I set the spooler to manual startup, it
showed "Manual" and "Started" after a restart.

 

Anyway, it must have been something with the Kyocera driver and it's
management queue. I removed all the Kyocera software, rebooted, re-added the
printer and endless printing is gone.

 

Thanks to all that offered ideas. (The trees are greatful)

 

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: Ian Thomas [mailto:il.tho...@iinet.net.au] 
Sent: Sunday, 8 April 2012 2:01 AM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Weird spooler error on Windows 7

 

Greg

 

The common problem with Windows 7 and printer drivers is usually the
opposite - ie, spooler service stopped. In my experience it's due to a wrong
printer driver (eg, 32-bit installed instead of 64-bit).

 

But this may be helpful - 

 

So if uninstalling the print and document services in programs and
features\Turn windows features on-off applet

and rebooting and then adding the feature back in does not work.

There may be a dependancy in the Spooler registry setting that is pointing
at a printer driver or service that is not available.

look at the HKLM\System\CurrentControlSet\Services\Spooler registry key.
Looking for "Dependant on service" reg_Value

My Win7 uses RPCSS and http by default. Look for your drivers service name
there if so, Remove it and leave only the default.

Review

1. removing and then adding the print and document services feature in
affect reinstalls the spooler components and reg values.

2. verifying the spooler service is not dependant on a non existant or
broken applications service entry

and return the spooler registry values to default.

 

- left verbatim as answered. 

 

(I had seen reference to this sort of thing before, but had to search and
read a few answers to refresh my recollection). 

 

As I read it, the registry entry he's talking about causes a restart of the
spooler, via the service that the printer-specific service uses. 

 

This would point to comparing your problem machine with another that is
hooked to the same network printer, comparing the registry settings. 

 

Worth a try? 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Saturday, April 07, 2012 11:07 PM
To: 'ozDotNet'
Subject: Weird spooler error on Windows 7

 

Hi Folks,

 

I'm having a weird spooler issue on one of our Windows 7 machines. If I
leave the spooler service running, it constantly sends the same file again
and again to one of the network printers (a big Kyocera box).

 

I even removed the printer (logical printer) from the devices list and no
other printer has that IP address. Still every time I restart the spooler,
it starts sending the file again.

 

I even stopped the spooler service, then went into the
C:\Windows\System32\spool\PRINTERS folder and nuked everything in there.

 

Any thoughts? I'm keen to stop the killing the trees.

 

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

 

 

Weird spooler error on Windows 7

[Greg Low (GregLow.com)]

Hi Folks,

 

I'm having a weird spooler issue on one of our Windows 7 machines. If I
leave the spooler service running, it constantly sends the same file again
and again to one of the network printers (a big Kyocera box).

 

I even removed the printer (logical printer) from the devices list and no
other printer has that IP address. Still every time I restart the spooler,
it starts sending the file again.

 

I even stopped the spooler service, then went into the
C:\Windows\System32\spool\PRINTERS folder and nuked everything in there.

 

Any thoughts? I'm keen to stop the killing the trees.

 

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:   www.sqldownunder.com

 

 

File/folder sync options for Windows

[Greg Low (GregLow.com)]

Hi Folks,

 

Anyone got recommendations for file sync? Just a couple of PCs that want to
share one or more folders between them and also to a NAS that they both can
access. Happy for the main folder to live on the NAS and for the other two
PCs to sync with it.

 

I spent time today looking at Offline files in Windows 7 and while it looked
promising at first, after wasting hours trying to debug its issues, I've
decided it's not for me.

 

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:   www.sqldownunder.com

 

RE: Win 8 Tablet

[Greg Low (GregLow.com)]

Used MagicISO for many years and very happy with it. (And it's free)

 

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

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Peter Maddin
Sent: Sunday, 1 April 2012 1:48 AM
To: 'ozDotNet'
Subject: RE: Win 8 Tablet

 

Thanks

 

Looks like a good product for US$30.

 

Did you purchase it or just use it unregistered?

 

Regards Peter Maddin
Applications Development Officer
PathWest Laboratory Medicine WA
Phone : +618 6396 4285 (Monday, Wednesday,Friday)

Phone : +618 9346 4372 (Tuesday, Thursday)
Mobile: 0423 540 825 
E-Mail : petermad...@iinet.net.au; peter.mad...@health.wa.gov.au
The contents of this e-mail transmission outside of the WAGHS network are
intended solely for the named recipient's), may be confidential, and may be
privileged or otherwise protected from disclosure in the public interest.
The use, reproduction, disclosure or distribution of the contents of this
e-mail transmission by any person other than the named recipient(s) is
prohibited. If you are not a named recipient please notify the sender
immediately.

 

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Ian Thomas
Sent: Saturday, 31 March 2012 9:47 PM
To: 'ozDotNet'
Subject: RE: Win 8 Tablet

 

Try PowerISO - I have used it numerous times for mounting ISO files and
installing. 

 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Peter Maddin
Sent: Saturday, March 31, 2012 9:43 PM
To: 'ozDotNet'
Subject: RE: Win 8 Tablet

 

Thanks Stephen

 

I think I'll go with virtual clone drive. I have got it installed already on
main notebook.  I have never used it that much.

 

The link below says that Daemon comes with spyware

 

"Daemon Tools - Well known tool, but the latest version installs spyware on
your computer, and the old version doesn't work in Vista or 7."

 

 

Regards Peter Maddin
Applications Development Officer
PathWest Laboratory Medicine WA
Phone : +618 6396 4285 (Monday, Wednesday,Friday)

Phone : +618 9346 4372 (Tuesday, Thursday)
Mobile: 0423 540 825 
E-Mail : petermad...@iinet.net.au; peter.mad...@health.wa.gov.au
The contents of this e-mail transmission outside of the WAGHS network are
intended solely for the named recipient's), may be confidential, and may be
privileged or otherwise protected from disclosure in the public interest.
The use, reproduction, disclosure or distribution of the contents of this
e-mail transmission by any person other than the named recipient(s) is
prohibited. If you are not a named recipient please notify the sender
immediately.

 

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stephen Price
Sent: Saturday, 31 March 2012 7:24 PM
To: ozDotNet
Subject: Re: Win 8 Tablet

 

I used daemon tools lite for mounting the ISO under Win7, and did an upgrade
to Win8. 

 

Really REALLY cool thing about Win 8 is that it finally, out of the box,
supports mounting ISOs. Doesn't help you upgrading from Win 7, but the
future is bright. I can't believe its taken them this long to get something
in the OS. YAY

 

On Sat, Mar 31, 2012 at 7:17 PM, Peter Maddin 
wrote:

Hi Stephen

 

Got the slate up and running (use the pen for initial config, trying to use
just the screen was a bad experience).

 

Got Bluetooth keyboard and mouse connected. Connected to home WiFi. Pretty
easy really.

Win7 not that good with tablets. Looking forward to Win8.

 

When you mounted the Win8 ISO on your slate did you use Virtual Clone Drive
http://www.howtogeek.com/howto/windows-vista/mount-an-iso-image-in-windows-v
ista/

or some other method?

 

Could make a bootable USB, but I think I need a high capacity one (16GB+)

 

I have an external usb DVD drive but it needs two ports. So I can use that
if I get desperate.

 

Regards Peter Maddin
Applications Development Officer
PathWest Laboratory Medicine WA
Phone : +618 6396 4285   (Monday,
Wednesday,Friday)

Phone : +618 9346 4372   (Tuesday, Thursday)
Mobile: 0423 540 825 
E-Mail : petermad...@iinet.net.au; peter.mad...@health.wa.gov.au
The contents of this e-mail transmission outside of the WAGHS network are
intended solely for the named recipient's), may be confidential, and may be
privileged or otherwise protected from disclosure in the public interest.
The use, reproduction, disclosure or distribution of the contents of this
e-mail transmission by any person other than the named recipient(s) is
prohibited. If you are not a named recipient please notify the sender
immediately.

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stephen Price
Sent: Friday, 30 March 2012 9:00 AM


To: ozDotNet
Subject: Re: Win 8 Tabl

RE: Making an application that uses identity keysoccassionally connected

[Greg Low (GregLow.com)]

Another option that I should have mentioned is to move the data around as it
changes using Service Broker. We've used that sort of scheme at many sites
and it can have many advantages, not the least of which is the nice level of
decoupling that queues add to the solution. It can lead to very robust
solutions but it has a steeper learning curve before it can be used
effectively.

 

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: Kirsten Greed [mailto:kirst...@jobtalk.com.au] 
Sent: Monday, 6 February 2012 4:24 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Making an application that uses identity keysoccassionally
connected

 

Thanks Greg

I get the point about saving the round trip!

 

I am starting to hope I can use my existing database structure replicated at
each site, with some kind of mapping system hosted in the cloud

The mapping table would be something like

 

GUID  

SiteID - one for each installation

TableID  - one for each table

PKIntID   - the identity field for the record at the site

 

Is this what you were talking about when you said 
"The other main thing is that there often seems to be a presumption that you
have to have your logical data model the same as your physical data model.
You don't.
For example, rather than having all your tables that have a customer ID
having the GUID, you can always have ints or bigints all over the place, and
just have one table that maps between them." ?

Does SQL Server have some sort of in built process we could piggy back?

Thanks
Kirsten

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Monday, 6 February 2012 2:16 PM
To: 'ozDotNet'
Subject: RE: Making an application that uses identity keysoccassionally
connected

 

Hi Greg,

 

The point I was making is that the main reason for using GUIDs is so that
the code that creates an object can assign an ID to it without having to
reference a single allocator for IDs. I could have five servers and four
apps and they can all happily create values and related objects that will
then be able to be thrown into a single database some time later. 

 

This gets even worse where you have queues involved. The code generating the
object might not even have access to the database. With a GUID, the code can
generate an ID, then ship it across the queue to some other system to
process it.

 

Any ID generated by database misses the point. To use them, I usually run
off to the database to get an ID before I continue. If I'm going to do that,
what's the advantage of getting a NEWSEQUENTIALID rather than just an INT or
BIGINT? It's just uglier for no benefit.

 

The main aim of using GUIDs is to avoid being tied to some server that's the
source of all IDs, and having to incur round-trip costs to it.

 

Regards,

 

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: 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 article
<http://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 



__ Information from ESET NOD32 Antivirus, version of virus signature
database 6777 (20120108) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

RE: Making an application that uses identity keysoccassionally connected

[Greg Low (GregLow.com)]

Hi Kirsten,

 

If you can partition your data so that an ID is only unique within a site,
the built-in Peer to Peer options for transactional replication in SQL
Server work pretty well. For example, can you use SiteID and then the PKID
to identify rows in a given table?

 

If so, take a look at Peer to Peer replication. The biggest limitation with
it is that 2008 added conflict detection but there isn't an automated
conflict correction system. If the data is well partitioned, it works really
well though.

 

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: Kirsten Greed [mailto:kirst...@jobtalk.com.au] 
Sent: Monday, 6 February 2012 4:24 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: Making an application that uses identity keysoccassionally
connected

 

Thanks Greg

I get the point about saving the round trip!

 

I am starting to hope I can use my existing database structure replicated at
each site, with some kind of mapping system hosted in the cloud

The mapping table would be something like

 

GUID  

SiteID - one for each installation

TableID  - one for each table

PKIntID   - the identity field for the record at the site

 

Is this what you were talking about when you said 
"The other main thing is that there often seems to be a presumption that you
have to have your logical data model the same as your physical data model.
You don't.
For example, rather than having all your tables that have a customer ID
having the GUID, you can always have ints or bigints all over the place, and
just have one table that maps between them." ?

Does SQL Server have some sort of in built process we could piggy back?

Thanks
Kirsten

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Monday, 6 February 2012 2:16 PM
To: 'ozDotNet'
Subject: RE: Making an application that uses identity keysoccassionally
connected

 

Hi Greg,

 

The point I was making is that the main reason for using GUIDs is so that
the code that creates an object can assign an ID to it without having to
reference a single allocator for IDs. I could have five servers and four
apps and they can all happily create values and related objects that will
then be able to be thrown into a single database some time later. 

 

This gets even worse where you have queues involved. The code generating the
object might not even have access to the database. With a GUID, the code can
generate an ID, then ship it across the queue to some other system to
process it.

 

Any ID generated by database misses the point. To use them, I usually run
off to the database to get an ID before I continue. If I'm going to do that,
what's the advantage of getting a NEWSEQUENTIALID rather than just an INT or
BIGINT? It's just uglier for no benefit.

 

The main aim of using GUIDs is to avoid being tied to some server that's the
source of all IDs, and having to incur round-trip costs to it.

 

Regards,

 

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: 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 article
<http://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 



__ Information from ESET NOD32 Antivirus, version of virus signature
database 6777 (20120108) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

RE: Making an application that uses identity keys occassionally connected

[Greg Low (GregLow.com)]

Hi Greg,

 

The point I was making is that the main reason for using GUIDs is so that
the code that creates an object can assign an ID to it without having to
reference a single allocator for IDs. I could have five servers and four
apps and they can all happily create values and related objects that will
then be able to be thrown into a single database some time later. 

 

This gets even worse where you have queues involved. The code generating the
object might not even have access to the database. With a GUID, the code can
generate an ID, then ship it across the queue to some other system to
process it.

 

Any ID generated by database misses the point. To use them, I usually run
off to the database to get an ID before I continue. If I'm going to do that,
what's the advantage of getting a NEWSEQUENTIALID rather than just an INT or
BIGINT? It's just uglier for no benefit.

 

The main aim of using GUIDs is to avoid being tied to some server that's the
source of all IDs, and having to incur round-trip costs to it.

 

Regards,

 

Dr Greg Low

 

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


SQL Down Under | Web:   www.sqldownunder.com

 

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 article
  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 occassionallyconnected

[Greg Low (GregLow.com)]

The problem with NEWSEQUENTIALID is that it fixes the wrong problem.

 

One of the main reasons for using GUIDs in the first place is so they can be
generated in other layers of code (and potentially other servers) and then
just thrown into the database. If you are going to the database to get a
GUID of any type, you might as well get an INT instead.

 

Regards,

 

Dr Greg Low

 

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


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Kirsten Greed
Sent: Saturday, 4 February 2012 3:39 PM
To: 'ozDotNet'
Subject: RE: Making an application that uses identity keys
occassionallyconnected

 

Noonie

 

Were you using NEWSEQUENTIALID() in the app that had problems in production?

David Amos also mentioned NEWSEQUENTIALID() to keep fragmentation down - but
I missed it's importance.

 

Bill - thanks for the info and link.

 

I am thinking that the problem with 2 part keys is that it's a bigger
re-write than changing primary keys.  I am sure to forget to add the 2nd key
in places!

 

Kirsten

 

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Bill Chesnut
Sent: Saturday, 4 February 2012 3:20 PM
To: ozDotNet
Subject: RE: Making an application that uses identity keys
occassionallyconnected

 

Kirsten,

 

One issue with GUID keys is that they are not one-up so with clustered
indexes base on a GUID, inserting new records into a table typically can
cause a page split, which is expensive, there is a different algorithm to
generate a GUID that is always increasing so it acts more like an integer
key.

 

In SQL 2005 and above it is NEWSEQUENTIALID() and there is code to generate
it in .net I think.

 

Good article that compares all of these key types:
http://www.codeproject.com/Articles/32597/Performance-Comparison-Identity-x-
NewId-x-NewSeque



Bill Chesnut
BizTalk Server MVP
Melbourne, Australia

  _  

From: Kirsten Greed [mailto:kirst...@jobtalk.com.au]
To: 'ozDotNet' [mailto:ozdotnet@ozdotnet.com]
Sent: Sat, 04 Feb 2012 12:40:51 +1100
Subject: RE: Making an application that uses identity keys
occassionallyconnected

Hi Noonie

Thanks for that info, 

I have hundreds of thousands of records in some of my tables and have been
very happy with identity integers as primary keys so far.

Kirsten

 

 

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of noonie
Sent: Saturday, 4 February 2012 12:05 PM
To: ozDotNet
Subject: Re: Making an application that uses identity keys
occassionallyconnected

 

Hi Kirsten,

 

>From my experience, using GUIDs as surrogate primary keys works fine in
development where sample data is only thousands of rows. It bites viciously
in production where we have millions of rows and deep dependencies. Int keys
are still surrogate keys but seem to offer better performance.

 

How you do this will depend on what your occasionally connected applications
are connecting to. If it is a reporting database that consolidates data from
different sites then your solution would be simpler than where it shared the
information across all the remote sites.

 

All the suggestions mentioned, in this thread, are viable. I have used
two-part keys (e.g site-id, item-id) in the past to good effect. More
recently we have added non-key GUIDs for the central database to verify
equality and, as we don't redistribute all the data to the remote databases,
it's only used as a tie-breaker.

 

The solution you choose will depend on the nature of the application and how
much sync code you are willing to write. If you use a framework you are as
much constrained by its limitations as you are freed from having to write
code :-(

 

-- 

Regards,

noonie

 

 

On 2 February 2012 07:51, Kirsten Greed  wrote:

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

 

 

 

 

 

 



__ Information from ESET NOD32 Antivirus, version of virus signature
database 6777 (20120108) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

RE: Web Development

[Greg Low (GregLow.com)]

Also, while doing that, make sure you spend quite a bit of time looking at
other people's code. The mindset needed is quite different.

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Nathan Schultz
Sent: Wednesday, 10 August 2011 12:42 PM
To: ozDotNet
Subject: Re: Web Development

 

I would advocate doing your own project or an open source project in your
spare time - just so you have something to put on your CV. 

While there are some aspects of development from winforms development that
can be transferred over (such as general .Net knowledge), it will still take
some time to become proficient in ASP.Net (and web development in general).

Years ago I started off doing purely WinForms, and my first couple of
ASP.Net projects were... well... not fantastic.



On Wed, Aug 10, 2011 at 10:26 AM, Simon Kuldin
 wrote:

I meant *un*employable

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Simon Kuldin
Sent: Wednesday, 10 August 2011 12:18 PM
To: ozdotnet@ozdotnet.com
Subject: Web Development

 

Hey there everyone,

 

It seems to me that almost all of the Dot Net jobs advertised out there,
require a decent level of ASP.NET experience.  Does that mean I'm pretty
much employable since I have little to no ASP.NET experience, despite my
level of Dot Net experience in WinForms and Compact Framework development?

 

I am studying ASP.NET when I can, but don't have any real work experience
with it yet.

 

I feel like I'm fighting an uphill battle to try and get into a full-time
Dot Net development role (I'm only doing Dot Net development as a portion of
my job at the moment).

 

RE: [OT] Renting a data projector

[Greg Low (GregLow.com)]

Hi Greg,

 

J As an aside, for someone starting with T-SQL, the first book that Itzik
had in that series is probably more appropriate:

 

Inside T-SQL: Fundamentals ->
http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-De
veloper/dp/0735626014/ref=sr_1_10?ie=UTF8

&qid=1310714811&sr=8-10

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Friday, 15 July 2011 4:43 PM
To: 'ozDotNet'
Subject: RE: [OT] Renting a data projector

 

Yeah Chris, you would win a handful of Lindt chocky balls which I'm giving
away as prizes for good answers. 3km was a reasonable guess, as most people
think it's a few hundred metres or so.

 

And Ben, my grain of sand I picked up from Mentone beach is 0.7000mm
in diameter, and it's a perfect Silicon Dioxide sphere of course.

 

Another question I ask is how many grains of sand are in the jar (PHOTO LINK
 ). The book pictured behind the
jar is book 1 of the pair T-SQL Querying and T-SQL Programming. I
accidentally bought book 2 first and found it discussed things like
triggers, performance and rarer topics like spatial data, auditing (by Greg
Low), service broker, etc. A lot of that wasn't of much interest to me as a
pure developer, so I rushed out and bought book 1. I must now report that
the book 1 is very heavy and dense reading with a lot of maths and algorithm
discussions that I guess would be university course level. If you just want
to be a good T-SQL and proc coder then there are probably many books that
are easier to digest. If you're a bit geeky and like full coverage and deep
technical background information then I think the pair of Inside SQL Server
2008 books will tickle your fancy.

 

Cheers,

Greg

 

RE: SQL CLR table as function parameter

[Greg Low (GregLow.com)]

That can work quite well but be careful if you're using the .nodes() method
in T-SQL to provide the table to join to. It doesn't have cardinality
estimates (actually it "guesses" 10,000 rows) and can end up with some
seriously badly performing query plans. Often we have to use it to extract
the data into a temporary table and then join to it. (Wish it wasn't so).

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Jamie Surman
Sent: Wednesday, 29 June 2011 4:13 PM
To: ozDotNet
Subject: Re: SQL CLR table as function parameter

 

Personally I tend to do this kind of stuff by passing the parameter as xml.
In your SQL you can then join to the xml as though it were a table.

 

  _  

From: Greg Keogh 
To: ozDotNet 
Sent: Wed, 29 June, 2011 5:17:40
Subject: RE: SQL CLR table as function parameter




Oh oh! http://msdn.microsoft.com/en-us/library/ms131103.aspx has some bad
news:

 

Table-valued parameters are user-defined table types that are passed into a
procedure or function and provide an efficient way to pass multiple rows of
data to the server. Table-valued parameters provide similar functionality to
parameter arrays, but offer greater flexibility and closer integration with
Transact-SQL. They also provide the potential for better performance.
Table-valued parameters also help reduce the number of round trips to the
server. Instead of sending multiple requests to the server, such as with a
list of scalar parameters, data can be sent to the server as a table-valued
parameter. A user-defined table type cannot be passed as a table-valued
parameter to, or be returned from, a managed stored procedure or function
executing in the SQL Server process.

 

So I have to find some other convenient way of getting variable numbers of
parameters into a managed function.

 

Is there a T-SQL equivalent of String.Join(...) that easily joins many
strings together with a separator, I could possibly accept that a proxy
variable length parameter.

 

Greg

RE: Calling out to all you geeks to help me buy\build a machine (preferably laptop) that can support following System Requirements.

[Greg Low (GregLow.com)]

Hi Stuart,

 

Have you checked with them about bios upgrades? We got a bunch of Dell
machines a while back that had the same limitation but after a bios upgrade,
all good.

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Stuart Kinnear
Sent: Friday, 10 June 2011 8:33 AM
To: ozDotNet
Subject: Re: Calling out to all you geeks to help me buy\build a machine
(preferably laptop) that can support following System Requirements.

 

If you buy a laptop double check that it supports 64 bit virtualisation. I
am miffed that a HP DV7 I bought does not and so I can only do 32 bit
virtualisation even though the processor is 64 bit !. 

If you don't need portability, stick to a desktop assembly, go to MSY and
roll out your own (they will build as well). Much better bang for the buck.

Regards, Stuart



On 9 June 2011 21:03, Ken Schaefer  wrote:

I think this really depends on what you want to run. With an 8GB laptop and
a couple of SSDs, you can run 4-5 VMs without too many issues - even I/O
intensive ones like SCOM or Exchange. But this would mainly be for testing
things on an ad hoc basis

 

If you're looking to have a permanent lab running, and actually build up
data in databases, then you'll probably need a desktop machine. Most
mid-high end ones will go to 16GB RAM, and the workstation class ones will
give you 24+ GB

 

That all said, the more VMs you run, the more I/O throughput you need. So,
get SSDs. Trying to run 10 VMs off 2 regular disks (for example) will just
be painful.

 

Cheers

Ken

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tejas Goradia
Sent: Thursday, 9 June 2011 6:21 PM
To: ozDotNet
Subject: Re: Calling out to all you geeks to help me buy\build a machine
(preferably laptop) that can support following System Requirements.

 

Hi Ben, 

Thanks for the info. Would you suggest building a desktop instead? I'm happy
to invest in a laptop but these days no amount of RAM is good enough. 

Tejas.



On Thu, Jun 9, 2011 at 7:29 PM,  wrote:

I'm not sure if any laptops exist that have the option of having Win Server
2008 R2 installed. If they do they are likely pretty expensive.

 

Here's a reasonable Acer laptop for $1,050 (after cash back from Acer) that
will meet your specs once you add another 4GB of RAM (comes with 1x 4GB but
can be upgraded to 2x 4GB) and install your OS of choice. I've bought a
couple of things from MWave before and had no problems with them (I have no
affiliation with them).

 

http://www.mwave.com.au/sku-31010931-Acer_AS5750G_2634G64Mn_Notebook_Intel_G
en2_Core_i7_2630QM_Processor_%282_0GHz_up_t

 

There are faster processors but this is pretty good (the entry-level Sandy
Bridge mobile CPU with 4 cores and hyper threading):
http://en.wikipedia.org/wiki/Sandy_Bridge

 

Ben

 


  _  


From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tejas Goradia
Sent: Thursday, 9 June 2011 5:14 PM
To: ozdotnet@ozdotnet.com
Subject: Calling out to all you geeks to help me buy\build a machine
(preferably laptop) that can support following System Requirements.


System Requirements

  _  


*   Supported Operating Systems:Windows Server 2008 R2 


Additionally you will need: 

*   Windows Server 2008 R2 with the Hyper-V role enabled. 
*   Drive Formatting: NTFS 
*   Processor: Intel VT or AMD-V capable 
*   RAM: 8 GB or more recommended 
*   Hard disk space required for install: 50 GB


This machine is going to be dedicated for running Virtual Machines made
available from Microsoft like the   2010 Information
Worker Demonstration and Evaluation Virtual Machine (RTM)
 

I naturally don't want to spend a fortune so please suggest good value for
money. 

Thanks,
Tejas

 




-- 

-
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: Sudden violent death of SSDs

[Greg Low (GregLow.com)]

Which types of drives Ken?

Regards,

Greg

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Ken Schaefer
Sent: Friday, 3 June 2011 3:25 PM
To: ozDotNet
Subject: RE: Sudden violent death of SSDs

I've had two that have ended up like this. One day working. Then you get I/O
blockages that require you to restart (and then the SSD might work for
another couple of days before freezing up again). And then it just stops
being detected.

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Craig van Nieuwkerk
Sent: Friday, 3 June 2011 1:08 PM
To: ozDotNet
Subject: Re: Sudden violent death of SSDs

I don't know much about SSD's but I think once they die they are a brick, so
make sure you back up!

>
> What is particularly different about SSDs that you referred to "the 
> kind of sudden violent death that only SSD's can really manage"?
>

RE: SSD minimum size question

[Greg Low (GregLow.com)]

Yep, I'd say at least that. It's certainly way more zippy to use and to 
install. The latest OS's seem to be more SSD aware.

Regards,

Greg

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Tony Wright
Sent: Wednesday, 18 May 2011 1:10 PM
To: ozDotNet
Subject: RE: SSD minimum size question

I'd say I get a 1/3 speed improvement. That's to say without measuring, it 
feels about 1/3 faster to build.

T.

-Original Message-
From: mike smith
Sent: Wednesday, 18 May 2011 12:47 PM
To: g...@greglow.com; ozDotNet
Subject: Re: SSD minimum size question

Doing a build?  (not that I'm suggesting a build would take that long.
 maybe a CI build)

How long does it take, vs a spinning drive build?

On Tue, May 17, 2011 at 7:06 PM, Greg Low (GregLow.com)  
wrote:
> In all seriousness, it does run on battery for about 1.5 hrs at present. I 
> was expecting it to last about 14 milliseconds.
>
> Regards,
>
> Greg
>
> -Original Message-
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith
> Sent: Tuesday, 17 May 2011 4:31 PM
> To: ozDotNet
> Subject: Re: SSD minimum size question
>
> A desktop with a UPS, given the time they will run :)
>
> On Tue, May 17, 2011 at 12:32 PM, Ken Schaefer  wrote:
>> I think that's a desktop with a battery personally :-)
>>
>> You could carry around three Sony Zs for the same weight.
>>
>> Cheers
>> Ken
>>
>> -Original Message-
>> From: ozdotnet-boun...@ozdotnet.com
>> [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low
>> (GregLow.com)
>> Sent: Friday, 13 May 2011 8:40 PM
>> To: 'Stephen Price'; 'ozDotNet'
>> Subject: RE: SSD minimum size question
>>
>> Lenovo W701 - two normal drive bays plus replaced the DVD so it's got 3 SATA 
>> drives.
>>
>> Regards,
>>
>> Greg
>>
>> -Original Message-
>> From: Stephen Price [mailto:step...@littlevoices.com]
>> Sent: Friday, 13 May 2011 5:54 PM
>> To: g...@greglow.com; ozDotNet
>> Subject: Re: SSD minimum size question
>>
>> Wait, what? You have a laptop that has three hard drives in it? What laptop 
>> is that?
>>
>> On Fri, May 13, 2011 at 2:38 PM, Greg Low (GregLow.com) 
>> 
>> wrote:
>>> Hi Tony,
>>>
>>>
>>>
>>> I've put 3 of the new Crucial M4 512G's into my notebook and have 
>>> been
>>> *really* happy with them.
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> Greg
>>>
>>>
>>>
>>> From: ozdotnet-boun...@ozdotnet.com
>>> [mailto:ozdotnet-boun...@ozdotnet.com]
>>> On Behalf Of Tony Wright
>>> Sent: Friday, 13 May 2011 12:43 PM
>>>
>>> To: 'ozDotNet'
>>> Subject: RE: SSD minimum size question
>>>
>>>
>>>
>>> Found the tom's hardware review:
>>>
>>> http://www.tomshardware.com/reviews/intel-ssd-320-crucial-m4-realssd
>>> -
>>> c
>>> 400,2908-6.html
>>>
>>>
>>>
>>> From: ozdotnet-boun...@ozdotnet.com
>>> [mailto:ozdotnet-boun...@ozdotnet.com]
>>> On Behalf Of Tony Wright
>>> Sent: Friday, 13 May 2011 12:28 PM
>>> To: 'ozDotNet'
>>> Subject: RE: SSD minimum size question
>>>
>>>
>>>
>>> Personally I decided on the 256G. And I've got the same for 3 
>>> laptops now. I don't want to have to waste my time dealing with the 
>>> possibility of running out of space.
>>>
>>>
>>>
>>> BTW, there are a number of 3rd gen SSDs out now, not just the 
>>> Crucial M4, although they use newer technology which is apparently 
>>> not as good (cheaper but not better performing). Some of the 2nd gen 
>>> drives are pretty awesome if you can get them for a good price, such 
>>> as the Crucial C300 (the only 2nd gen I would buy)
>>>
>>> I read the following forum on tom's hardware.
>>>
>>> http://www.tomshardware.com/forum/266789-32-foot-race-vertex3-intel-
>>> c
>>> r
>>> ucial
>>>
>>> And a comparison site written in French (no I can't read it but 
>>> google translate is my friend. If you know of a better comparison, 
>>> please post it as I'm interested)
>>>
>>> http://www.hardware.fr/articles/830-7/comparatif-ssd-2011-crucial-m4
>>> -
>>> o
>>> cz-vertex-3-intel-510-320.html
>>>
>>>
>>>
>>> T.
>>
>>
>
>
>
> --
> Meski
>
> "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
>
>



--
Meski

"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: SSD minimum size question

[Greg Low (GregLow.com)]

In all seriousness, it does run on battery for about 1.5 hrs at present. I was 
expecting it to last about 14 milliseconds.

Regards,

Greg

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of mike smith
Sent: Tuesday, 17 May 2011 4:31 PM
To: ozDotNet
Subject: Re: SSD minimum size question

A desktop with a UPS, given the time they will run :)

On Tue, May 17, 2011 at 12:32 PM, Ken Schaefer  wrote:
> I think that's a desktop with a battery personally :-)
>
> You could carry around three Sony Zs for the same weight.
>
> Cheers
> Ken
>
> -Original Message-
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low 
> (GregLow.com)
> Sent: Friday, 13 May 2011 8:40 PM
> To: 'Stephen Price'; 'ozDotNet'
> Subject: RE: SSD minimum size question
>
> Lenovo W701 - two normal drive bays plus replaced the DVD so it's got 3 SATA 
> drives.
>
> Regards,
>
> Greg
>
> -Original Message-
> From: Stephen Price [mailto:step...@littlevoices.com]
> Sent: Friday, 13 May 2011 5:54 PM
> To: g...@greglow.com; ozDotNet
> Subject: Re: SSD minimum size question
>
> Wait, what? You have a laptop that has three hard drives in it? What laptop 
> is that?
>
> On Fri, May 13, 2011 at 2:38 PM, Greg Low (GregLow.com) 
> 
> wrote:
>> Hi Tony,
>>
>>
>>
>> I've put 3 of the new Crucial M4 512G's into my notebook and have 
>> been
>> *really* happy with them.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> From: ozdotnet-boun...@ozdotnet.com
>> [mailto:ozdotnet-boun...@ozdotnet.com]
>> On Behalf Of Tony Wright
>> Sent: Friday, 13 May 2011 12:43 PM
>>
>> To: 'ozDotNet'
>> Subject: RE: SSD minimum size question
>>
>>
>>
>> Found the tom's hardware review:
>>
>> http://www.tomshardware.com/reviews/intel-ssd-320-crucial-m4-realssd-
>> c
>> 400,2908-6.html
>>
>>
>>
>> From: ozdotnet-boun...@ozdotnet.com
>> [mailto:ozdotnet-boun...@ozdotnet.com]
>> On Behalf Of Tony Wright
>> Sent: Friday, 13 May 2011 12:28 PM
>> To: 'ozDotNet'
>> Subject: RE: SSD minimum size question
>>
>>
>>
>> Personally I decided on the 256G. And I've got the same for 3 laptops 
>> now. I don't want to have to waste my time dealing with the 
>> possibility of running out of space.
>>
>>
>>
>> BTW, there are a number of 3rd gen SSDs out now, not just the Crucial 
>> M4, although they use newer technology which is apparently not as 
>> good (cheaper but not better performing). Some of the 2nd gen drives 
>> are pretty awesome if you can get them for a good price, such as the 
>> Crucial C300 (the only 2nd gen I would buy)
>>
>> I read the following forum on tom's hardware.
>>
>> http://www.tomshardware.com/forum/266789-32-foot-race-vertex3-intel-c
>> r
>> ucial
>>
>> And a comparison site written in French (no I can't read it but 
>> google translate is my friend. If you know of a better comparison, 
>> please post it as I'm interested)
>>
>> http://www.hardware.fr/articles/830-7/comparatif-ssd-2011-crucial-m4-
>> o
>> cz-vertex-3-intel-510-320.html
>>
>>
>>
>> T.
>
>



--
Meski

"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: SSD minimum size question

[Greg Low (GregLow.com)]

:-)

I love it actually. It's a bit heavier than my last notebook but it's great
to be able to do whatever I need to while travelling. It even has a built-in
Wacom digitizer beside the track pad and the color sensor stuff for
adjusting LCD color, a powered USB 3 port while the laptop is off (for
charging devices), video card for driving multiple external monitors, etc.

I stopped short of the dual-screen option. But the idea of slide-out 10"
screen beside the 17" screen was tempting... :-)

The biggest challenge is that it doesn't fit in the xray trays at most
airports.

Regards,

Greg

-Original Message-
From: Ken Schaefer [mailto:k...@adopenstatic.com] 
Sent: Tuesday, 17 May 2011 12:33 PM
To: g...@greglow.com; ozDotNet
Subject: RE: SSD minimum size question

I think that's a desktop with a battery personally :-)

You could carry around three Sony Zs for the same weight.

Cheers
Ken

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low (GregLow.com)
Sent: Friday, 13 May 2011 8:40 PM
To: 'Stephen Price'; 'ozDotNet'
Subject: RE: SSD minimum size question

Lenovo W701 - two normal drive bays plus replaced the DVD so it's got 3 SATA
drives.

Regards,

Greg

-Original Message-
From: Stephen Price [mailto:step...@littlevoices.com]
Sent: Friday, 13 May 2011 5:54 PM
To: g...@greglow.com; ozDotNet
Subject: Re: SSD minimum size question

Wait, what? You have a laptop that has three hard drives in it? What laptop
is that?

On Fri, May 13, 2011 at 2:38 PM, Greg Low (GregLow.com) 
wrote:
> Hi Tony,
>
>
>
> I've put 3 of the new Crucial M4 512G's into my notebook and have been
> *really* happy with them.
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> From: ozdotnet-boun...@ozdotnet.com
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Tony Wright
> Sent: Friday, 13 May 2011 12:43 PM
>
> To: 'ozDotNet'
> Subject: RE: SSD minimum size question
>
>
>
> Found the tom's hardware review:
>
> http://www.tomshardware.com/reviews/intel-ssd-320-crucial-m4-realssd-c
> 400,2908-6.html
>
>
>
> From: ozdotnet-boun...@ozdotnet.com
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Tony Wright
> Sent: Friday, 13 May 2011 12:28 PM
> To: 'ozDotNet'
> Subject: RE: SSD minimum size question
>
>
>
> Personally I decided on the 256G. And I've got the same for 3 laptops 
> now. I don't want to have to waste my time dealing with the 
> possibility of running out of space.
>
>
>
> BTW, there are a number of 3rd gen SSDs out now, not just the Crucial 
> M4, although they use newer technology which is apparently not as good 
> (cheaper but not better performing). Some of the 2nd gen drives are 
> pretty awesome if you can get them for a good price, such as the 
> Crucial C300 (the only 2nd gen I would buy)
>
> I read the following forum on tom's hardware.
>
> http://www.tomshardware.com/forum/266789-32-foot-race-vertex3-intel-cr
> ucial
>
> And a comparison site written in French (no I can't read it but google 
> translate is my friend. If you know of a better comparison, please 
> post it as I'm interested)
>
> http://www.hardware.fr/articles/830-7/comparatif-ssd-2011-crucial-m4-o
> cz-vertex-3-intel-510-320.html
>
>
>
> T.

RE: SSD minimum size question

[Greg Low (GregLow.com)]

Lenovo W701 - two normal drive bays plus replaced the DVD so it's got 3 SATA
drives.

Regards,

Greg

-Original Message-
From: Stephen Price [mailto:step...@littlevoices.com] 
Sent: Friday, 13 May 2011 5:54 PM
To: g...@greglow.com; ozDotNet
Subject: Re: SSD minimum size question

Wait, what? You have a laptop that has three hard drives in it? What laptop
is that?

On Fri, May 13, 2011 at 2:38 PM, Greg Low (GregLow.com) 
wrote:
> Hi Tony,
>
>
>
> I’ve put 3 of the new Crucial M4 512G’s into my notebook and have been
> *really* happy with them.
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Tony Wright
> Sent: Friday, 13 May 2011 12:43 PM
>
> To: 'ozDotNet'
> Subject: RE: SSD minimum size question
>
>
>
> Found the tom’s hardware review:
>
> http://www.tomshardware.com/reviews/intel-ssd-320-crucial-m4-realssd-c
> 400,2908-6.html
>
>
>
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Tony Wright
> Sent: Friday, 13 May 2011 12:28 PM
> To: 'ozDotNet'
> Subject: RE: SSD minimum size question
>
>
>
> Personally I decided on the 256G. And I’ve got the same for 3 laptops 
> now. I don’t want to have to waste my time dealing with the 
> possibility of running out of space.
>
>
>
> BTW, there are a number of 3rd gen SSDs out now, not just the Crucial 
> M4, although they use newer technology which is apparently not as good 
> (cheaper but not better performing). Some of the 2nd gen drives are 
> pretty awesome if you can get them for a good price, such as the 
> Crucial C300 (the only 2nd gen I would buy)
>
> I read the following forum on tom’s hardware.
>
> http://www.tomshardware.com/forum/266789-32-foot-race-vertex3-intel-cr
> ucial
>
> And a comparison site written in French (no I can’t read it but google 
> translate is my friend. If you know of a better comparison, please 
> post it as I’m interested)
>
> http://www.hardware.fr/articles/830-7/comparatif-ssd-2011-crucial-m4-o
> cz-vertex-3-intel-510-320.html
>
>
>
> T.
>
>
>
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Matt Siebert
> Sent: Wednesday, 11 May 2011 10:22 PM
> To: ozDotNet
> Subject: Re: SSD minimum size question
>
>
>
> I got a 120 GB SSD about 2 months ago (107 GB usable) and have been 
> running with around 43 GB free space for most of that time.
>
>
>
> I'm careful to keep my documents and photos on another drive but I do 
> have a frequently used XP VM on there occupying about 8 GB.
>
>
>
> If I did a cleanup I could probably get away with a 60 GB drive if I 
> had to, but for a development machine I'd really want 120 GB.
>
> On Wed, May 11, 2011 at 4:23 PM, Ian Thomas 
wrote:
>
> Incidentally, Windows 7 SP1 now installs OK on his system.
>
> It’s a pity that the installer didn’t give an appropriate message, 
> instead of just terminating with some unrelated or incomprehensible 
> message. How hard is it to say “you’re out of disk space, dude”?
>
> I wouldn’t have thought a 60Gb SSD was too small, though.
>
> 
>
> Ian Thomas
> Victoria Park, Western Australia
>
> 
>
> From: ozdotnet-boun...@ozdotnet.com 
> [mailto:ozdotnet-boun...@ozdotnet.com]
> On Behalf Of Ian Thomas
> Sent: Wednesday, May 11, 2011 2:18 PM
> To: 'ozDotNet'
> Subject: RE: SSD minimum size question
>
>
>
> We were looking for something like that, Joseph – I’ll pass it on. 
> Wading through the Power Settings didn’t make that clear.
>
> (just found the same advice from Hanselman, too)
>
> 
>
> Ian Thomas
> Victoria Park, Western Australia
>
>

RE: SSD minimum size question

[Greg Low (GregLow.com)]

Hi Tony,

 

I've put 3 of the new Crucial M4 512G's into my notebook and have been
*really* happy with them.

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tony Wright
Sent: Friday, 13 May 2011 12:43 PM
To: 'ozDotNet'
Subject: RE: SSD minimum size question

 

Found the tom's hardware review:

http://www.tomshardware.com/reviews/intel-ssd-320-crucial-m4-realssd-c400,29
08-6.html

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Tony Wright
Sent: Friday, 13 May 2011 12:28 PM
To: 'ozDotNet'
Subject: RE: SSD minimum size question

 

Personally I decided on the 256G. And I've got the same for 3 laptops now. I
don't want to have to waste my time dealing with the possibility of running
out of space. 

 

BTW, there are a number of 3rd gen SSDs out now, not just the Crucial M4,
although they use newer technology which is apparently not as good (cheaper
but not better performing). Some of the 2nd gen drives are pretty awesome if
you can get them for a good price, such as the Crucial C300 (the only 2nd
gen I would buy)

I read the following forum on tom's hardware.

http://www.tomshardware.com/forum/266789-32-foot-race-vertex3-intel-crucial

And a comparison site written in French (no I can't read it but google
translate is my friend. If you know of a better comparison, please post it
as I'm interested)

http://www.hardware.fr/articles/830-7/comparatif-ssd-2011-crucial-m4-ocz-ver
tex-3-intel-510-320.html

 

T.

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Matt Siebert
Sent: Wednesday, 11 May 2011 10:22 PM
To: ozDotNet
Subject: Re: SSD minimum size question

 

I got a 120 GB SSD about 2 months ago (107 GB usable) and have been running
with around 43 GB free space for most of that time.

 

I'm careful to keep my documents and photos on another drive but I do have a
frequently used XP VM on there occupying about 8 GB.

 

If I did a cleanup I could probably get away with a 60 GB drive if I had to,
but for a development machine I'd really want 120 GB.

On Wed, May 11, 2011 at 4:23 PM, Ian Thomas  wrote:

Incidentally, Windows 7 SP1 now installs OK on his system.

It's a pity that the installer didn't give an appropriate message, instead
of just terminating with some unrelated or incomprehensible message. How
hard is it to say "you're out of disk space, dude"? 

I wouldn't have thought a 60Gb SSD was too small, though. 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Ian Thomas
Sent: Wednesday, May 11, 2011 2:18 PM
To: 'ozDotNet'
Subject: RE: SSD minimum size question

 

We were looking for something like that, Joseph - I'll pass it on. Wading
through the Power Settings didn't make that clear. 

(just found the same advice from Hanselman, too)

  _  

Ian Thomas
Victoria Park, Western Australia

 

RE: [OT] Lightweight laptop for dev and demos

[Greg Low (GregLow.com)]

And you just need one of these inside it :-)
http://www.crucial.com/store/listmodule/SSD/~524288~/list.html

Regards,

Greg

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Andrew Coates (DPE AUSTRALIA)
Sent: Friday, 6 May 2011 3:43 PM
To: ozDotNet
Subject: RE: [OT] Lightweight laptop for dev and demos

I've just ordered a Lenovo x220
(http://www.lenovoblogs.com/designmatters/2011/03/thinkpad-x220-you-sexy-bea
st/) - they claim 23hr battery with the additional slice battery (15 hr
without)

Corei7 + 8GB + 320GB + 3yr onsite + IPS (720p) + WWAN + UltraBay + Slice
Battery

Just waiting for it to arrive now ...

-Original Message-
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Bec Carter
Sent: Thursday, 5 May 2011 9:53 AM
To: ozDotNet
Subject: Re: [OT] Lightweight laptop for dev and demos

Hmm yes battery life would be important to me. The mini dell claims over 7
hours battery life though I doubt that is the case when doing anything but
running the screensaver :-)

Vostro sounds good but for the size. Thanks for the info I'll keep looking

On Thu, May 5, 2011 at 12:29 AM, Wallace Turner 
wrote:
> Bec, disclaimer, the Vostro has guts (for its weight/price) but its 
> battery life is *poor*.
>
> I have used it at work connected to a 23" HD monitor with no issues 
> but on a plane trip you'll be lucky to get 2hrs of dev work in.
>
> mostly i use it plugged in so is not an issue for me personally.
>
> On 4/05/2011 7:42 PM, Ken Schaefer wrote:
>>
>> Most of the "mini" machines have a pretty cramped keyboard. I would 
>> not use it for dev work (or any serious typing). The screen 
>> resolution tends to be low as well.
>>
>> Powering an external, high res monitor can be painful, depending on 
>> what sort of graphics chip it has.
>>
>> For skype/web browsing etc, no problems using one of these things. 
>> For more serious work, I'd get something a bit larger with a bit more 
>> oomph. The Vostro V13 mentioned earlier is a pretty good tradeoff.
>> All depends on your budget
>>
>> Cheers
>> Ken
>>
>> -Original Message-
>> From: ozdotnet-boun...@ozdotnet.com
>> [mailto:ozdotnet-boun...@ozdotnet.com]
>> On Behalf Of Bec Carter
>> Sent: Wednesday, 4 May 2011 7:23 PM
>> To: ozDotNet
>> Subject: Re: [OT] Lightweight laptop for dev and demos
>>
>> Anybody here got a notebook mini? Dell mini 10 or HP 10? What do you 
>> think of them?
>> I need something with a web cam for Skype, wireless card obviously 
>> and
>> *maybe* a tiny bit of dev here and there - these minis seem to meet 
>> system requirements for vs express versions.
>>
>>
>> On Wed, Apr 6, 2011 at 1:18 PM, Grant Maw  wrote:
>>>
>>> Very true.
>>>
>>> I took mine on a site visit one day and one of their mobile guys 
>>> laughed at me, and informed the rest of the group that my M1730's 
>>> power supply was bigger than his computer!
>>>
>>> Our power bill has dropped $20 since I stopped using it.
>>>
>>> On 6 April 2011 11:26, Stephen Price  wrote:

 3.5Kg is light!!

>>
>
>

RE: [OT] SQL Server Windows Authentication - New Clue

[Greg Low (GregLow.com)]

You need to create a login for the YourDomain\SQLAdmins group and assign it
permissions in the databases via the "User Mappings" tab.

 

HTH,

 

Greg

 

From: Greg Keogh [mailto:g...@mira.net] 
Sent: Thursday, 24 March 2011 2:30 PM
To: g...@greglow.com; 'ozDotNet'
Subject: RE: [OT] SQL Server Windows Authentication - New Clue

 

Folks, wouldn't you know, but minutes after posting my hopeless situation I
have found an important clue. I should have asked my cat.

 

The Security Logins for the instance has a Login 'BUILTIN\Users'. If I add
'BUILTIN\Users' to Security Users for a particular database and give it the
db_owner role, this fixes the problem for that database.

 

However, this is ugly and I'm looking for an elegant global fix. I created a
domain group called 'SQL Admins' and tried to add it as a Security Login,
but the group doesn't appear in the selection list. I was hoping to use this
custom group as a way of assigning specific users the permission to own and
manage databases, but it doesn't work as I expected. There probably is a
proper way of doing this, but I haven't found it yet.

 

Greg

RE: [OT] SQL Server Windows Authentication

[Greg Low (GregLow.com)]

Hi Greg/Grant,

 

The issue isn't whether or not the service account has access to the files,
it's whether or not it's been granted permission to access the server and
the databases.

 

Open SSMS and make sure it's configured as a Login and also that the Login
has access to the database.

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Grant Castner
Sent: Wednesday, 23 March 2011 11:33 AM
To: ozDotNet
Subject: Re: [OT] SQL Server Windows Authentication

 

Hi Greg,

Its been a while since I had this problem but when you moved the databases
to the new server, did it create a whole bunch of additional Schemas under
Security for each database? I've seen it create new schemas for each user
(especially Windows users). Deleting those additional schemas fixed the
problem.

 

Kind regards,

Grant

 

 

On 22 March 2011 16:34, Greg Keogh  wrote:

Folks, this morning I was forced to perform a big switch-over to a pair of
new Win2008 R2 domain controller and file/web/sql server machines.

 

I have found that SQL Server Management Studio on the workstation machines
does not have permission to access the databases when I use Windows
Authentication. If I use 'sa' then there is no problem. If I try to open a
database node in Object Explorer I get:

 

The database X is not accessible. (ObjectExplorer)

 

Procmon on the server shows me that NETWORK SERVICE does not have read
permission on the LDF and MDF files, but If I give it full control, it has
no effect. If I add Authenticated Users it fixes the procmon warnings but
has no effect upon the problem.

 

I'm unable to find a point of blame for this problem. I don't know if it's
the NTFS permissions, some security or roles in SQL Server, or some domain
user/group problem. Any ideas anyone? I'm stuffed.

 

Greg




-- 

Castner IT Pty Ltd

Dr Grant Castner
Director
gcast...@castnerit.com
www.castnerit.com.au
0458770749
Level 22 Northbank Plaza, 
69 Ann Street, Brisbane QLD 4000
Twitter: http://twitter.com/castnerit
Facebook: facebook/castnerit.com
 

 

RE: SQL Server report scheduling

[Greg Low (GregLow.com)]

Officially it's required for data-driven subscriptions but not for standard
subscriptions. However, there are ways around it:
http://sqlblog.com/blogs/greg_low/archive/2008/08/13/data-driven-subscriptio
ns-in-sql-server-2005-standard-edition.aspx

 

Regards,

 

Greg

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Kennedy
Sent: Wednesday, 16 March 2011 8:31 AM
To: ozDotNet
Subject: Re: SQL Server report scheduling

 

Hi Greg,

I could be wrong but I don't think you needed the Enterprise version to get
subscriptions. Standard edition is enough and is significantly cheaper.

 

Greg

On Wed, Mar 16, 2011 at 8:04 AM, Greg Keogh  wrote:

Folks, our customer needs a facility to generate reports via calendar
schedules and then distribute them to lists of email recipients.  For
example, on the first of each month, monthly summary reports with filtering
arguments for different customers and departments would be generated and
each would be emailed to one or more related people. They currently do this
by hand and it's a growing burden on the staff.

 

One of us discovered that SQL Server with Reporting Services
  (SSRS) seems to do
everything we need, so we upgraded to SQL Server Express with Advanced Tools
(and reporting) and ran some experiments to make RDL server-side reports and
use the web interface to publish and generate them. This all works, and we
got excited, but then discovered that subscription reports
  are not a
part of SQL Express editions, so we don't get the facility to schedule and
distribute reports unless our customer upgrades to the SQL Server Enterprise
edition which is about $27000 per processor.

 

So we have to tell the customer to buy SQL Server Enterprise and we learn
how to use SSRS, or we find some other way of creating the
subscription/schedule facility. Our current preference is for the latter if
there is a way of programmatically generating the RDL reports stored on the
server. If we can generate the reports, then we're quite happy to wrap it in
a scheduler (NCron, Quartz .NET, etc) and it's easy to send email
attachments. That way, SQL Server holds all the report definitions and data,
and our code schedules and distributes the reports.

 

Does anyone know if there is an API or service into SSRS to allow us to
generate the RDL reports?

 

Any other general comments on this matter would be welcome.

 

Cheers,

Greg