Re: MSDN Subscription renewal

See the Q A at the bottom of the page : https://www.visualstudio.com/products/visual-studio-community-vs Regards Greg Dr Greg Low CEO and Principal Mentor SQL Down Under 1300SQLSQL (1300775775) On 22 Apr 2015, at 7:46 pm, Greg Keogh g...@mira.netmailto:g...@mira.net wrote: Can I ask why

RE: More on 'CloudStream'

Also for DB backups, there’s an Azure backup tool for SQL Server. It installs a file system driver and redirects filesystem writes (ie: writing a file like a backup) to a storage account and just leaves a stub in place. When you read from the stub, it redirects the data from the storage account

RE: MVC Redirect and Async Operations

And implemented and working like a charm. Thanks all. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.comhttp://www.sqldownunder.com/ From: Greg Low (罗格雷格博士) Sent: Saturday, 1 August 2015 6:26 PM

RE: MVC Redirect and Async Operations

Of Corneliu I. Tusnea Sent: Saturday, 1 August 2015 6:13 PM To: ozDotNet ozdotnet@ozdotnet.com Subject: Re: MVC Redirect and Async Operations Task(()= { ... do stuff }).Start() On Thu, Jul 30, 2015 at 8:06 PM, Greg Low (罗格雷格博士) g...@greglow.commailto:g...@greglow.com wrote: One for the MVC brains trust

RE: MVC Redirect and Async Operations

: www.sqldownunder.comhttp://www.sqldownunder.com/ From: Greg Low (罗格雷格博士) Sent: Saturday, 1 August 2015 6:26 PM To: ozDotNet ozdotnet@ozdotnet.commailto:ozdotnet@ozdotnet.com Subject: RE: MVC Redirect and Async Operations Thanks guys. Makes sense. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office

RE: MVC Redirect and Async Operations

Subject: Re: MVC Redirect and Async Operations async HTTP handler ? On 30 July 2015 at 20:06, Greg Low (罗格雷格博士) g...@greglow.commailto:g...@greglow.com wrote: One for the MVC brains trust if I can: I want to add some basic link redirection and logging to a test MVC site. So, for example, if I have

MVC Redirect and Async Operations

One for the MVC brains trust if I can: I want to add some basic link redirection and logging to a test MVC site. So, for example, if I have a calls like: http://www.mytestsite.com/links/10123 http://www.mytestsite.com/links/10939 I want to redirect the caller to some other URL associated with

RE: PostgreSQL vs SQL Server

we're confident it will be worthwhile. David If we can hit that bullseye, the rest of the dominoes will fall like a house of cards... checkmate! -Zapp Brannigan, Futurama On 11 August 2015 at 10:46, Greg Low (罗格雷格博士) g...@greglow.commailto:g...@greglow.com wrote: Hi Folks, The SQL Server team

RE: [OT] home server

On the subject of home servers, if someone wants to make an offer on a serious NAS - QNAP TS-879 PRO with 24TB (8x3TB Seagate Constellation SATA3 drives), little “r” ping me back. https://www.qnap.com/i/au/product/model.php?II=15 Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office |

Re: [OT] Cable IP address

sorry DOCSIS 3 - I hate autocorrect Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) > On 28 Oct 2015, at 6:17 PM, Greg Low (罗格雷格博士) <g...@greglow.com> wrote: > > Yep correct - rarely changes - just get a reliable DDNS service and a decent

Re: [OT] Cable IP address

Yep correct - rarely changes - just get a reliable DDNS service and a decent modem/router that "gets" DDNS. We use a DOCSUS 3 modem in bridge mode then have a Billion box plugged into it. Seems to work well and we can get to our NAS through it just fine. However, bit by bit we're moving it all

RE: [OT] Cable IP address

zdotnet.com<mailto:ozdotnet@ozdotnet.com>> Subject: Re: [OT] Cable IP address What are you using for NAT? On Wed, 28 Oct 2015 at 19:00 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: We get around 110 Mb/sec down, and about 3 up. Not complaining but y

RE: [OT] Cable IP address

David Connors Sent: Wednesday, 28 October 2015 8:13 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: [OT] Cable IP address What are you using for NAT? On Wed, 28 Oct 2015 at 19:00 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: We get around 110 Mb/

House batteries

Hi Folks, Has anyone ventured into house batteries as yet? Just looking to build a new house and wondering about wiring it for DC as well as AC. Seems dumb to invert low voltage DC to AC, in many cases just to bring it back to low voltage DC with plug-packs all over the place. Been wondering

Re: [OT] Clients

+1 Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 22 Oct 2015, at 4:39 PM, Craig van Nieuwkerk > wrote: Tell them you charge for meetings on normal hourly rate even if they are cancelled. Craig On Thu, Oct 22,

RE: [OT] Cable IP address

to manage and remember. I have no choice of modem, they gave me a "slab" Netgear Gateway Max with pretty blinking lights. GK On 28 October 2015 at 18:17, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Yep correct - rarely changes - just get a reliable

RE: Sharing a database file

With the “SQL Server has too many dependencies that aren’t available”, which dependencies are the issue? Have you considered the localdb option? It’s targeted pretty much right at what you’re describing. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61

RE: Sharing a database file

-express.aspx Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> From: Greg Low (罗格雷格博士) Sent: Wednesday, 11 November 2015 3:52 PM To: ozDotNet <ozdotnet@ozd

RE: Sharing a database file

No, you can start it with the localdb utility (or your code) then access it from your apps. And it, or even the Express edition have no license fees at all. The only limitations are 1GB of memory and a single CPU being used for processing and 10GB storage per database. Regards, Greg Dr Greg

Re: SSL Certs

abcdef.com.au<http://abcdef.com.au> to abcdef.com<http://abcdef.com> ? 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: [OT] SSL testing

Same here. Ran it when it was mentioned. Got an A. Sitting in Azure Websites with a Digicert certificate. Done nothing clever. That’s how it should be. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

RE: SSL Certs

<http://www.sqldownunder.com/> From: Greg Low (罗格雷格博士) Sent: Monday, 2 November 2015 9:03 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: SSL Certs Hi Guys, If using two domains like: abcdef.com and abcdef.com.au (and obviously the site also has the www. versions of those too). For

SSL Certs

Hi Guys, If using two domains like: abcdef.com and abcdef.com.au (and obviously the site also has the www. versions of those too). For SSL on Azure websites, thoughts on whether we should do two certs, or just do that on one of them and then do some sort of redirect for the other one? (It’s

RE: [OT] Office 365

There really is quite a shift going on. For years, every time we asked for enhancements to the portals in SQL Server Reporting Services, etc. the response was that “we already have a portal business and it’s called SharePoint”. Now all the SQL Server directions are away from SharePoint, back

RE: Sql Server Patch Scripts

That’s so funny Ken. I was just reading that email and thinking “I know that threads drift but I hadn’t realised that one had drifted that far”. It still seemed plausible ☺ Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under |

RE: SSL Certs

o help catch more traffic) and route them all to the main domain then it makes more sense. If you had 10 domain names you wouldn't want an SSL for every one of them. Redirect is the way to go, IMHO. On Tue, 3 Nov 2015 at 04:37 Greg Low (罗格雷格博士) <g...@greglow.com<javascript:_e(%7B%7D,

RE: Escrow : anyone been involved in the process?

Mostly it’ll be because they have some concern about your company’s long term viability. It probably isn’t that they don’t want to pay for it. They just don’t want to have a situation where you disappear and they have no way to continue to work on it. I’ve seen that in a number of contracts.

Re: File upload component

ypical click to upload. On Sep 6, 2015 10:49 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com<mailto:g...@greglow.com>> wrote: Hi folks What's the best file upload component for an MVC5 app? Regards Greg Dr Greg Low SQL Down Under +61 419201410<tel:%2B61%20419201410> 1300SQLSQL (1300775775)

RE: File upload component

015 10:49 PM, "Greg Low (罗格雷格博士)" <g...@greglow.com<mailto:g...@greglow.com>> wrote: Hi folks What's the best file upload component for an MVC5 app? Regards Greg Dr Greg Low SQL Down Under +61 419201410<tel:%2B61%20419201410> 1300SQLSQL (1300775775)

File upload component

Hi folks What's the best file upload component for an MVC5 app? Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775)

Re: Odd text encoding

at all. Surely > proper binary data types have been available in relational databases > since the dark ages? > -- > Thomas Koster > > >> On 10 September 2015 at 16:40, Greg Low (罗格雷格博士) <g...@greglow.com> wrote: >> That was my first reaction too. Haven't spent time

Odd text encoding

Hi Folks, This one’s driving me crazy and I thought the brains trust might have an idea. Here’s a value that’s stored in an ntext column in a SQL Server DB:

RE: Odd text encoding

The tail end of it looks a bit like values that I see in certificates. 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

RE: Odd text encoding

The thing to understand with databases like SQL Server is that as soon as you start comparing and/or joining values, you really hope that they are integers (or bigints). If I had a 12 digit number that was a customer number, I’d just be using a bigint. As soon as you start comparing character

Re: Odd text encoding

t; wrote: Probably because binary data was easy to put in and easy to get out, but what you put in is not what you get out. There are also performance implications with binary data, it's usually more secure to store as base64 in a varchar(max) or text. Absolutely no reason to store in an un

RE: Odd text encoding

How long would it take to insert that many rows? ☺ 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

PayPal Integration

Hi Folks, Been using eWay for ages and integrating with it was pretty trivial. Wanting to add PayPal now (to existing MVC app in VS2015). Been reading the developer doco and it seems like a convoluted mess. Presumed one of you must have been doing this lately. I need to know the outcome for

Re: Odd text encoding

Ah but the issue is how many rows you can write into a table. That's a bit more work than a for loop :-) Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 11 Sep 2015, at 5:16 pm, Greg Keogh > wrote: Assuming

RE: PayPal Integration

y, 14 September 2015, Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Yep I like Stripe and eWay was quite simple but bunches of clients want to use PayPal plus it seems to do the best multicurrency work. I presume the increasing preference for PayPal is to

Re: [OT]Work in Sydney.

How strong on .NET ? Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 17 Sep 2015, at 10:04 PM, David Rhys Jones > wrote: Hi all I've got a colleague who is moving to Sydney next wednesday to start his visa

RE: Odd text encoding

...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Thomas Koster Sent: Thursday, 10 September 2015 10:33 AM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: Odd text encoding On 10 September 2015 at 10:21, Greg Low (罗格雷格博士) <g...@greglow.com> wrote: > This one’s driving

Re: Odd text encoding

<step...@perthprojects.com<mailto:step...@perthprojects.com>> wrote: How did you get my Azure certificate? wtf?? Seriously though, the trailing == on the end (plus the overall look) makes it look exactly like an Azure publish certificate. On Thu, 10 Sep 2015 at 08:39 Greg Low

Re: PayPal Integration

old them I chose someone else and still get their emails. I should hit the unsubscribe button now that I'm thinking of it. On Sun, 13 Sep 2015 at 16:27 Greg Low (罗格雷格博士) <g...@greglow.com<mailto:g...@greglow.com>> wrote: Hi Folks, Been using eWay for ages and integrating with it

Re: [OT] Office 365 Azure AD sync

ks! Stephen 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>>

Re: [OT] Office 365 Azure AD sync

First question is if you still need local AD. With vpns and AD services on AAD, many don't now. If you do, ADFS allows for two way traversal. Are you currently using ADConnect or the older Dirsync ? Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 2 Dec 2015,

Re: [OT] Azure pricing

I see a lot of small companies using a basic web tier (up to 10 sites) and an S1 Azure SQL DB, with monthly costs around $114 AUD. You can't directly compare it with a VM as that both requires management, etc plus doesn't have built in HA options. PaaS is the future not IaaS, which is really

RE: [OT] New laptop

Have a chat to Adam Cogan. Adam’s bought a bunch of them and been posting in various lists about issues. Just see if anything is relevant. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

Re: [OT] Looking for work

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

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: SQL Server Collation

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

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:

Any Powershell gurus?

Hi Folks, Anyone know how to do either of the following via Powershell: ・ Mount an ISO as a specific drive letter ・ Change the drive letter of a mounted ISO Mount-DiskImage doesn’t seem to have any option for choosing a drive letter. Set-Partition doesn’t seem to recognise a

RE: Any Powershell gurus?

From: Greg Low (罗格雷格博士) Sent: Sunday, 17 January 2016 2:45 PM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: RE: Any Powershell gurus? Awesome Tony. While on the subject of Powershell, anyone have an idea on how to set the desktop background on one of the Azure VMs built of a Windows Se

RE: Any Powershell gurus?

The Get-Volume cmdlet returns a MSFT_Volume CIM class with a DriveLetter property, however it's readonly. cheers, Tony On 17/01/2016 10:17, Greg Low (罗格雷格博士) wrote: Hi Folks, Anyone know how to do either of the following via Powershell: · Mount an ISO as a specific drive letter · C

RE: SQL foreign key question

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

: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: [OT] Shrinking LDF file

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: SQL foreign key question

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

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?

? 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: Any opinions on the Dell XPS 15 laptops?

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?

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?

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?

<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: Azure static web sites

I was thinking the same. I’d just create a web app and deploy it, even if it had a whole bunch of static content. By doing that, you pick up all the niceness. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web:

RE: Azure static web sites

:-) Yep niceness includes all the config stuff that it makes really easy. And it's a whole world of easier to do and portable. * Shared site with host headers - check * Free option for really little sites - check * Custom domain - check * Automated help with DNS configuration - check * Makes it

RE: Azure static web sites

I could do a quick walkthrough later today if that’d help. There aren’t many options that need to be chosen. 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: Azure static web sites

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:

RE: Azure File Storage

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: Azure File Storage

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: [OT] ACS - relevant?

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: Coffee snobs

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

: 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

Re: Coffee snobs

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: [OT] New laptop

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

Coffee snobs

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: Coffee snobs

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: SQL Server 2014 Books Online - bits missing?

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: SQL Server 2014 Books Online - bits missing?

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: Azure Table query "not null"

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: Azure Table query "not null"

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"

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"

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: [OT] WinHlp32.exe and .CHM help file format

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: Used Azure SQL DB? Why or why not?

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?

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?

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?

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?

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

Used Azure SQL DB? Why or why not?

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: Used Azure SQL DB? Why or why not?

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

RE: XML files served by Azure Websites

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

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

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

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

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: [OT] Ad tracking and security

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

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

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

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 (罗格雷格博士)

  1   2   >