Fw: Re: [OT] NBN and phone

2017-09-17 Thread
$19 at Bunnings. Does CAT5/6 and Phone. Worth it. Regards,   Greg   Dr Greg Low   1300SQLSQL (1300 775 775) office | +61 419201410 [tel:+61%20419%20201%20410]  mobile│ +61 3 8676 4913 [tel:+61%203%208676%204913] fax SQL Down Under | Web: www.sqldownunder.com [http://www.sqldownunder.com/] 

Fw: Re: [OT] Post NBN problem

2017-09-10 Thread
From: Greg Low Date: 11/09/2017 12:03:57 PM Subject: Re: [OT] Post NBN problem To: ozdotnet@ozdotnet.com Also consider not using a VM at all. Your life gets much easier when you deploy websites and DBs as platform services. Regards,   Greg   Dr Greg Low   1300SQLSQL

Re: [OT] Post NBN problem

2017-09-09 Thread
Two thoughts: 1. Why not use a dynamic DNS service instead? 2. Why host websites at home on a dynamic service? (We used to do that so very long ago. I don't see much point to it now) Regards,   Greg   Dr Greg Low   1300SQLSQL (1300 775 775) office | +61 419201410 [tel:+61%20419%20201%20410] 

RE: Stored procedure only ORM

2017-07-12 Thread
The #1 thing you must get right though is correctly typed (ie: data typed) parameters. One of the issues with many of the frameworks is that under the covers they use methods like AddWithValue() to add values to a parameters collection. The problem is that when you finally see those sorts of

RE: AZURE SQL Data Sync

2017-07-10 Thread
f said data into the cloud. From what i've read this looks like its in Azure SQL wheel house... but given the volatility in Azure's weekly product management its important to not assume :) --- Regards, Scott Barnes http://www.riagenic.com On Mon, Jul 10, 2017 at 8:34 PM, Greg Low (罗格雷格博士) <

RE: AZURE SQL Data Sync

2017-07-10 Thread
Hi Scott Up to a few months back, I would have said “run away fast”. But now not so sure. This was a “product” that stayed in “preview” mode for so very long. Blog posts had long ago stopped and many of us for years had been asking if it was another product that was just silently dropped

RE: Global SQL Server timeout

2017-07-09 Thread
Yep, no connection timeout != command timeout. You need to have a command timeout set on each command that’s created. Sucks if the devs didn’t do that up front but I see this often. Works great until queries take more than 30 seconds. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775)

Re: Powershell testing

2017-07-08 Thread
Hi Greg There are some very good PS courses on MVA, right from the horse's (Snover's) mouth. I have moments with PS where I'm stunned how much I get done and how fast. Other days, I want to poke my eyes out with a sharp stick after trying to do something that seemed trivial. Regards, Greg

RE: [OT] New surface laptop

2017-07-04 Thread
zdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tom Rutter Sent: Wednesday, 5 July 2017 1:28 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: [OT] New surface laptop How is the touchpad on the spectre? On Wed, Jul 5, 2017 at 10:54 AM, Greg Low (罗格雷格博士)

RE: [OT] New surface laptop

2017-07-04 Thread
100% agree. Have an HP 360 Spectre i7 (quite like it BTW) but needing to dongle to get LTE is a pain in the neck. (1st world problem) Love my P50 with built-in fast LTE. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under |

RE: Azure Active Directory

2017-06-21 Thread
l.com>> Sent: Thursday, June 22, 2017 1:21:33 AM To: Greg Low (罗格雷格博士); ozDotNet Subject: RE: Azure Active Directory That seems like hard work compared to using the powershell cmdlets. If you had an ongoing integration that needed to do it, sure. Hit the REST api for a one-off? Hmm.

Re: Azure Active Directory

2017-06-21 Thread
com> From: piers.willi...@gmail.com <piers.willi...@gmail.com> Sent: Thursday, June 22, 2017 1:21:33 AM To: Greg Low (罗格雷格博士); ozDotNet Subject: RE: Azure Active Directory That seems like hard work compared to using the powershell cmdlets. If you had an ongoing integration that needed to

Re: Azure Active Directory

2017-06-21 Thread
rectly, so I might have been doubly wasting my time. Now I'm wondering how I would migrate hundreds of users from the legacy database into Azure AD. Anyone done that? GK On 21 June 2017 at 12:19, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: AAD is a wonde

RE: Azure Active Directory

2017-06-20 Thread
AAD is a wonderful tool really. Keep in mind that it has a couple of flavours, B2C (business to consumer) being the latest. I’ve got clients who moved to it and simply love it. One is a car manufacturer who used to have to manage domains for dealers, etc. They used to spend their life with

RE: [OT] Sit/stand desk results

2017-06-19 Thread
Yep, it’s the same logic that got cholesterol in so much trouble. They assumed that eating cholesterol increased your cholesterol level. Never been true though yet it was widely promoted and stopped people eating eggs, etc. for decades. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775)

RE: [OT] Sit/stand desk results

2017-06-19 Thread
A great example of the problem is that almost everyone that’s ever been on shows like “Biggest Loser” are now heavier than when they went on the show. Worse, most now have slower metabolisms and are worse off than if they’d never heard of the show. Yet that sort of caloric reduction and

RE: [OT] Sit/stand desk results

2017-06-19 Thread
Yep, agreed. And any of Gary Taub’s content. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com |http://greglow.me From:

RE: Logo for Ozdotnet

2017-04-30 Thread
Yep, love the first one out of those. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com |http://greglow.me From: ozdotnet-boun...@ozdotnet.com

RE: Unit testing question and stored procedures

2017-04-25 Thread
. Must investigate. On Wed, Apr 26, 2017 at 12:48 PM, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: I should have added that the dac framework stuff had testing but has now removed it. Some use TSQLUnit but I’ve not found it any more useful and NUnit fits well with

RE: Unit testing question and stored procedures

2017-04-25 Thread
I should have added that the dac framework stuff had testing but has now removed it. Some use TSQLUnit but I’ve not found it any more useful and NUnit fits well with other testing. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL

RE: Unit testing question and stored procedures

2017-04-25 Thread
Hi Tony, I’d still just use something like NUnit, along with all the other tests in your .NET code. Just put a wrapper calling them. Makes it easy to integrate with other tests. One thing that I often do as well, is to have a wrapper that uses database snapshots, to get the test DB back into

RE: Logo for Ozdotnet

2017-04-10 Thread
Or still use 4 colours but divide the states naturally based on the boundaries? One of the things I liked about the logo we had done was the kangaroo. That makes it subtle but obviously Australian. Could we do something similar? Opera house or other shape immediately recognisable overseas as

RE: Ozdotnet list

2017-04-04 Thread
Same. I find it interesting to hear local opinions, and to follow Greg K's journeys  I'm always hesitant when I see email lists move to anything that looks like a forum. That seems to be where discussions are organised but where they go to die. Regards,   Greg   Dr Greg Low   1300SQLSQL

RE: XML files served by Azure Websites

2017-03-01 Thread
It may be possible that the feed validator is is just being "picky". IIS should let you set the charset on that content type so the feed validates. https://forums.iis.net/t/1155439.aspx -- noonie On 1 March 2017 at 19:04, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.

Re: XML files served by Azure Websites

2017-03-01 Thread
But that still leaves the question on how to change that. It's just serving up a static xml file. How is the content type for that specified? And more importantly, where? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under |

Re: XML files served by Azure Websites

2017-02-28 Thread
Yes I did think BOM was on UTF-16. Either way, issue seems to be the header from the site. No idea where to set it. I'm suspecting that the lack of a value probably sends this as a default. Can't find ASCII mentioned anywhere in project files. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775

RE: XML files served by Azure Websites

2017-02-28 Thread
zdotnet-boun...@ozdotnet.com] On Behalf Of David Connors Sent: Wednesday, 1 March 2017 2:19 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: XML files served by Azure Websites What validator are you using? On Wed, 1 Mar 2017 at 13:11 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g..

RE: XML files served by Azure Websites

2017-02-28 Thread
et@ozdotnet.com> Subject: Re: XML files served by Azure Websites On Wed, 1 Mar 2017 at 12:44 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Our podcast feed is served as an XML file from our Azure website. Feed validator returns this: Your feed appears to be encod

XML files served by Azure Websites

2017-02-28 Thread
Hi Brains Trust, Our podcast feed is served as an XML file from our Azure website. Feed validator returns this: Your feed appears to be encoded as "UTF-8", but your server is reporting "US-ASCII" Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676

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

2017-01-31 Thread
Hi Glav, One caught my eye there. Can’t admit to like using schemas for tenants. I live in a world where “performance aside” isn’t an aside. That has way to much impact on query plans, caching, memory, etc. for my liking. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61

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

2017-01-30 Thread
use they couldn't be bothered dealing with the nonsense. On Tue, Jan 31, 2017 at 1:00 PM, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: So you think it is just job protection? Are the people protecting their jobs the same ones who are gatekeepers for the decisions?

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

2017-01-30 Thread
ble storage, moved to blob storage) simply because of the significant drop in cost of data. Regards Tony On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com<mailto:g...@greglow.com>> wrote: To my developer buddies: I'm preparing a session for Ignite where I'm

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

2017-01-30 Thread
nts are everything they can come up with even if they're not true. Eg. Pricing. It's just people who have been here the longest trying to keep things unchanged and keeping their jobs and super high salaries. On Saturday, 28 January 2017, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@gr

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

2017-01-27 Thread
ed one application to using Windows Azure (started with table storage, moved to blob storage) simply because of the significant drop in cost of data. Regards Tony On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com<mailto:g...@greglow.com>> wrote: To my developer bud

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

2017-01-27 Thread
ply because of the significant drop in cost of data. Regards Tony On 28 Jan 2017 1:19 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com<javascript:_e(%7B%7D,'cvml','g...@greglow.com');>> wrote: To my developer buddies: I'm preparing a session for Ignite where I'm discussing using A

Used Azure SQL DB? Why or why not?

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

RE: Win PE Boot USB

2017-01-14 Thread
t-Stick_in_Windows On Sat, 14 Jan 2017 at 16:50 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Hi Folks, One for the local brains trust: I create WinPE boot disks on three different types of USB sticks. One type boots afterwards (every time), the other two

Win PE Boot USB

2017-01-13 Thread
Hi Folks, One for the local brains trust: I create WinPE boot disks on three different types of USB sticks. One type boots afterwards (every time), the other two types doesn’t. I’m struggling with what is different. · I’ve tried them formatted as either FAT32 or NTFS · I’ve

RE: Entity Framework - the lay of the land

2017-01-03 Thread
“ORMs are still a real coding productivity boost,” Are they though? I see them knock at best 10% off a dev project, and that dev work is at best probably 10% of the lifetime cost of the project. So a 1% overall saving in project cost ends up determining and limiting so many aspects of the

Re: [OT] HP Spectre x360 thoughts

2016-12-14 Thread
My E7440 (Dell) has been brilliant but they did replace the screen because of a hinge issue - but functionality: wonderful Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

Re: [OT] HP Spectre x360 thoughts

2016-12-14 Thread
Yep love the look of the P50 and importantly a 4 channel nvme. 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:

Re: [OT] node.js and express

2016-11-27 Thread
Oh yes 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: David Connors > Sent: Monday,

RE: [OT] node.js and express

2016-11-24 Thread
rosoft LightSwitch was trying to fill (although I'm pretty certain it's now dead). As I said earlier, we use OutSystems here, and I believe it's an area that Aurelia.IO and other vendors are growing into as well. On 25 November 2016 at 11:00, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:

RE: [OT] node.js and express

2016-11-24 Thread
So it then comes back to tooling again. Why can’t I build an app with the ease of a winform app and have it deployed in the current environments? Surely the app framework should fix the underlying mess and let me code to a uniform clean model. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775

RE: [OT] node.js and express

2016-11-22 Thread
I’m also seeing diabolical messes in the devops on the web apps too though. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com | http://greglow.me

RE: [OT] node.js and express

2016-11-21 Thread
http://greglow.me<http://greglow.me/> From: Greg Low (罗格雷格博士) Sent: Tuesday, 22 November 2016 2:33 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: RE: [OT] node.js and express But that’s a centralized vs distributed argument. I understand that. By why exactly does a centralized develo

RE: [OT] node.js and express

2016-11-21 Thread
But that’s a centralized vs distributed argument. I understand that. By why exactly does a centralized development process have to be orders of magnitude slower than a distributed one? I just think the tooling has let us down -> big time. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775)

RE: [OT] node.js and express

2016-11-21 Thread
ternet facing apps. Dev teams usually just tell the users which browser internal apps support and just avoid the multi browser support issues. On Tue, Nov 22, 2016 at 8:33 AM, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: I’m simply amazed at what we’ve done t

RE: [OT] node.js and express

2016-11-21 Thread
sday, 22 November 2016, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: I’m simply amazed at what we’ve done to ourselves as an industry. I was on a project a while back. With 12 devs and 7 months’ work, the core business web app was created. The guys worked hard

RE: [OT] node.js and express

2016-11-21 Thread
I’m simply amazed at what we’ve done to ourselves as an industry. I was on a project a while back. With 12 devs and 7 months’ work, the core business web app was created. The guys worked hard. At the end, they were still struggling to get it to look right on different browsers. But in the end,

RE: [OT] Ad tracking and security

2016-10-04 Thread
775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> | http://greglow.me<http://greglow.me/> From: Greg Low (罗格雷格博士) Sent: Wednesday, 5 October 2016 11:47 AM To: ozDotNet <ozdotnet@ozdotnet.com> Su

RE: [OT] Ad tracking and security

2016-10-04 Thread
I thought I’d read that even common adblocker programs are now deciding which ads to let through (ie: who has paid them to be “relevant”). I think “Adblock Plus” was the topic of the article. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913

RE: Entity Framework - the lay of the land

2016-10-03 Thread
There is a certain sweet irony in creating a SQL object to query, to get around a limitation of querying the actual SQL object using the framework no ? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

RE: Entity Framework - the lay of the land

2016-09-30 Thread
Agreed but not websites with thousands of concurrent users. The problem is that people don’t realise that the same logic doesn’t apply in both areas. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

Re: Entity Framework - the lay of the land

2016-09-21 Thread
alues. Do POCO updates and read the linked objects and attach them correctly. Davy. Si hoc legere scis nimium eruditionis habes. On Tue, Sep 20, 2016 at 10:03 AM, David Connors <da...@connors.com<mailto:da...@connors.com>> wrote: On Tue, 20 Sep 2016 at 13:59 Greg Low (罗格雷格博士)

Re: Entity Framework - the lay of the land

2016-09-21 Thread
ach them correctly. Davy. Si hoc legere scis nimium eruditionis habes. On Tue, Sep 20, 2016 at 10:03 AM, David Connors <da...@connors.com<mailto:da...@connors.com>> wrote: On Tue, 20 Sep 2016 at 13:59 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>>

RE: Entity Framework - the lay of the land

2016-09-20 Thread
be quick. If your requirement is speed when updating, then you shouldn't be using EF. Davy Si hoc legere scis nimium eruditionis habes. On Tue, Sep 20, 2016 at 11:53 AM, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Have they fixed the update situation yet? I r

RE: Entity Framework - the lay of the land

2016-09-20 Thread
connors.com<mailto:da...@connors.com>> wrote: On Tue, 20 Sep 2016 at 13:59 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: I often get coy when I hear comparisons with Stack Overflow, Twitter, Facebook, Blog Engines, etc. though. Most of those platforms are

Re: Expired MSDN Subscription - Transfer of VS to a new machine

2016-09-20 Thread
VS Community Edition not enough now? I see many individuals using it. 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 On Tue, Sep 20, 2016 at 5:11 PM +1000, "Chris

RE: Entity Framework - the lay of the land

2016-09-19 Thread
When I posted on Facebook about it the other day, another Microsoft friend noted that he was going to be the product manager for EF, but commented that he managed “to dodge that bullet”. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

RE: Entity Framework - the lay of the land

2016-09-19 Thread
Hey Craig, I often get coy when I hear comparisons with Stack Overflow, Twitter, Facebook, Blog Engines, etc. though. Most of those platforms are happy to just throw away transactions when the going gets heavy. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410

RE: Entity Framework - the lay of the land

2016-09-19 Thread
not very atomic hey? [] Hehe love that dialup db connection idea... From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> <ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>> on behalf of Greg Low (罗格雷格博士) <g...@greglow.com&

RE: Entity Framework - the lay of the land

2016-09-18 Thread
up db connection idea... From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> <ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>> on behalf of Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> Sent:

RE: Entity Framework - the lay of the land

2016-09-18 Thread
I remember many years ago, connecting the devs to the DB via a dial-up 64kB modem. Worked wonders for the code that came back. Suddenly they noticed every call. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

Re: Entity Framework - the lay of the land

2016-09-18 Thread
Simple examples are anything many to many. If I have passengers on flights, I might have a Flights table, a Passengers table and perhaps some sort of FlightManifests table (who's on which flights). But I sure wouldn't want those three as objects. I'd probably want a Passenger object with a

Re: Entity Framework - the lay of the land

2016-09-18 Thread
:-) 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 On Sun, Sep 18, 2016 at 5:57 PM +1000, "noonie" > wrote: How

Re: Entity Framework - the lay of the land

2016-09-17 Thread
to get a DB to scale is to stop talking to it in the first place. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com> _ From: Greg Low (罗格雷格

RE: Entity Framework - the lay of the land

2016-09-16 Thread
Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> | http://greglow.me<http://greglow.me/> From: Greg Low (罗格雷格博士) Sent: Saturday, 17 September 2016 11:04 AM To: ozDotN

RE: Entity Framework - the lay of the land

2016-09-16 Thread
Hey Dave and all, “The great” -> hardly but thanks Dave. Look, my issues with many of these ORMs are many. Unfortunately, I spend my life on the back end of trying to deal with the messes involved. The following are the key issues that I see: Potentially horrid performance I’ve been on the

RE: SQL Server Collation

2016-06-11 Thread
The SQL collations are only there for backwards compatibility and should have stopped being the default many versions ago. We always teach admins to use the Windows collations (ie: ones without a SQL prefix) rather than the SQL collations. Now that Latin1_General_CI_AS has become the default,

RE: [OT] Looking for work

2016-06-09 Thread
Love it… 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:

Re: [OT] Looking for work

2016-06-07 Thread
Be careful what knowledge you claim to have too. I regularly do technical interviews on behalf of clients (3 so far this week already - must be the season for it). If a person claims experience or knowledge in an area, I tend to drill into it with increasing depth to judge that myself anyway.

RE: [OT] Looking for work

2016-06-06 Thread
Hey Tom, Best to give us a clue on what you think your core strengths are. Then anyone that knows of something can let you know. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

RE: [OT] WinHlp32.exe and .CHM help file format

2016-04-21 Thread
The current trend is towards online doco only, I’m guessing mostly because it’s so easy to keep up to date. The SQL Server team begrudgingly supplies offline doco but it’s not a patch (no pun intended) on the online versions. They use their HelpViewer 2 mostly. Nothing is really coming in CHM

Re: Coffee snobs

2016-04-09 Thread
Awesome thanks all - the Giotto it is Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 8 Apr 2016, at 1:10 PM, Andrew Navakas > wrote: Hi, I have a Breville at one office and it does a good enough job, but it is hard

RE: Coffee snobs

2016-04-07 Thread
maybe even a macca’s coffee too  Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Greg Low (罗格雷格博士)<mailto:g...@greglow.com> Sent: Friday, 8 April 2016 10:19 AM To: ozDotNet<mailto:ozdotnet@ozdotnet.com> Subject: Coffee snobs Hi F

RE: Coffee snobs

2016-04-07 Thread
19 PM -0700, "Greg Low (罗格雷格博士)" <g...@greglow.com<mailto:g...@greglow.com>> wrote: Hi Folks, Given the importance of caffeine for code generation, I’m guessing there will be a few other coffee snobs on the list. Anyone got a recommendation for a serious (possibly

RE: Coffee snobs

2016-04-07 Thread
: www.sqldownunder.com<http://www.sqldownunder.com/> From: Bill McCarthy [mailto:bill.mccarthy.li...@live.com.au] Sent: Friday, 8 April 2016 10:56 AM To: Greg Low (罗格雷格博士) <g...@greglow.com>; ozDotNet <ozdotnet@ozdotnet.com> Subject: RE: Coffee snobs When my delonghi broke down(leaking

Coffee snobs

2016-04-07 Thread
Hi Folks, Given the importance of caffeine for code generation, I’m guessing there will be a few other coffee snobs on the list. Anyone got a recommendation for a serious (possibly manual) coffee machine? I’ve been using a DeLonghi automatic one but now feeling that I’d prefer something like

RE: [OT] New laptop

2016-04-05 Thread
Still loving my Dell E7440. Lightweight, and I fitted it with 16GB memory from Crucial, 2TB EVO SSD, and an LTE-A internal modem from Sierra Wireless. (Currently getting near 100MB/sec down and 45MB/sec up). Great machine. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61

RE: Azure Table query "not null"

2016-03-06 Thread
keys! One of my live tables has a natural triple compound key, simple in a SQL schema, but in the table I made the PartitionKey one value and MD5 hashed the other two into an 8 byte hexchars RowKey. It feels odd to do this, but it actually works fine. GK On 6 March 2016 at 20:51, Gre

RE: Azure Table query "not null"

2016-03-06 Thread
Hi Greg, If you’re after simple, what does the Azure SQL DB T-SQL interface make hard? You don’t even need any NuGet package to work with it. They set up and run the DB. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under |

RE: Azure Table query "not null"

2016-03-06 Thread
Hi Ian, It’s a tough question. For me, the biggest issue is where the querying really will happen. If 100% of the querying will happen in the application, and every object will just be persisted to the table storage and rehydrated before querying, then a table might suit. That usually leads

RE: Azure Table query "not null"

2016-03-06 Thread
If it's NULL, why would you store it at all? Surely the lack of a value is NULL. In SQL Server when they issue XML, they have an option for a way to represent NULL. Normally they just omit the attribute. They normally only do that in case someone is trying to derive the schema from the data. In

Re: SQL Server 2014 Books Online - bits missing?

2016-03-04 Thread
ad BOL from ;-) -- noonie On 4 March 2016 at 15:10, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Yep, they had an issue. Worth noting though, that there’s a lot of discussion about the utility of keeping to produce offline documentation. And the online versio

RE: SQL Server 2014 Books Online - bits missing?

2016-03-03 Thread
Yep, they had an issue. Worth noting though, that there’s a lot of discussion about the utility of keeping to produce offline documentation. And the online versions are now far superior. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

RE: [OT] ACS - relevant?

2016-02-29 Thread
But that’s my point. Agreed, it’s not necessarily anything to do with whether the project fails. We know that. It’s the backside protection that is improved by the external certification, not necessarily the project outcome. That said, I do see a large number of projects that have in fact

RE: Azure File Storage

2016-02-28 Thread
Yep, can’t say I like the new Calculator. It does have options now for converting various types of units though. I saw a menu item that said “Settings” and I wondered what was in there. It didn’t have any settings. It was an About box. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775)

RE: Azure File Storage

2016-02-28 Thread
Hey Greg, Did you try the “Connect to Network Drive” option in Windows Explorer in Windows 10 rather than just NET USE ? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

Re: [OT] Shrinking LDF file

2016-02-09 Thread
To accommodate a transaction of a certain size, it had to grow. That's normal. It doesn't autoshrink back down as doing so is generally a really bad idea. There is an autoshrink option but I usually joke that it should be renamed "auto fragment my filesystem". You don't want files constantly

RE: Any opinions on the Dell XPS 15 laptops?

2016-02-09 Thread
We have some E7440’s that have been excellent but are now starting to have some screen separation near the hinges. (Bit surprising really). Otherwise, love them. So, was thinking about the E7470’s but now thinking XPS 15’s. My eyesight would appreciate the 15 inch screen, and the narrow bezel

RE: Any opinions on the Dell XPS 15 laptops?

2016-02-09 Thread
Nah, sadly the 8GB RAM is a showstopper. With the precision, I’m tossing up between 32GB and 64GB. I get by at present with 16GB but wish there was more. Are the drives upgradable on those? One of the things I love about my current E7440 is that drives, memory, etc. are all upgradable. So many

RE: Any opinions on the Dell XPS 15 laptops?

2016-02-09 Thread
Yep, not sure I want a keyboard like the XPS 15 one. It’s a bunch of flat top keys with little travel. I’m now wondering about the new Precision 15 7000. Keyboard looks normal but no pricing on the site. I still also might try to get away with an E7470. Regards, Greg Dr Greg Low 1300SQLSQL

Re: Any opinions on the Dell XPS 15 laptops?

2016-02-09 Thread
<therut...@gmail.com<mailto:therut...@gmail.com>> wrote: Only "get by" with 16gb? What do you do with these machines lol On Wednesday, 10 February 2016, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Nah, sadly the 8GB RAM is a showstopper.

RE: SQL foreign key question

2016-02-08 Thread
You often see tables referring to themselves (due to some sort of hierarchical data) but having a column refer to itself seems at best pointless, at worst silly. And reason #3723923 why I won’t ever use such a visual table designer. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office

RE: SQL foreign key question

2016-02-08 Thread
:06 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: SQL foreign key question On 9 February 2016 at 16:02, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: You often see tables referring to themselves (due to some sort of hierarchical data) but having a colu

RE: SQL foreign key question

2016-02-08 Thread
ozdotnet.com] On Behalf Of David Burstin Sent: Tuesday, 9 February 2016 4:06 PM To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Subject: Re: SQL foreign key question On 9 February 2016 at 16:02, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>

RE: SQL foreign key question

2016-02-08 Thread
lto:ozdotnet-boun...@ozdotnet.com> [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Burstin Sent: Tuesday, 9 February 2016 4:06 PM To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Subject: Re: SQL foreign key question On 9 February 2016 at 16:02, Greg Low (罗格雷格博士) <g.

Any opinions on the Dell XPS 15 laptops?

2016-02-08 Thread
? As per subject ? 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

Re: Azure static web sites

2016-01-28 Thread
Saved me a job thanks Andrew ! Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 28 Jan 2016, at 6:22 PM, Greg Keogh > wrote:

  1   2   >