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 mailto:g...@mira.net>> wrote: Can I ask why would you upgr

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: [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] home server

abytes is a sh1tload. On Sun, 26 Jul 2015 at 11:22 Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: 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

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 e

RE: MVC Redirect and Async Operations

e: MVC Redirect and Async Operations async HTTP handler ? On 30 July 2015 at 20:06, Greg Low (罗格雷格博士) mailto: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 a calls

RE: MVC Redirect and Async Operations

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

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.com<http://www.sqldownunder.com/> From: Greg Low (罗格雷格博士) Sent: Saturday, 1 August 2015 6

RE: MVC Redirect and Async Operations

com/> From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tom Rutter Sent: Monday, 3 August 2015 9:30 AM To: ozDotNet Subject: Re: MVC Redirect and Async Operations How did you end up doing it Greg? On Sat, Aug 1, 2015 at 9:51 PM, Greg Low (罗格雷格博士) ma

PostgreSQL vs SQL Server

Hi Folks, The SQL Server team is taking a long hard look at PostgreSQL. They’d love to speak to anyone that chose it over SQL Server in production environments. If that’s you and you have time for a 20 minute chat, please let me know and I’ll hook you up. Regards, Greg Dr Greg Low 1300SQLSQ

RE: PostgreSQL vs SQL Server

ks. But at this stage 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 (罗格雷格博士) mailto:g...@greglow.com>> wrote

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: File upload component

eed a simple file uploader? Html5 ok? Fall back to flash? Drag and drop? Multi file upload? Progress bar? On Sunday, 6 September 2015, Greg Low (罗格雷格博士) > wrote: 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: File upload component

6, 2015 10:49 PM, "Greg Low (罗格雷格博士)" 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 1300SQLSQL (1300775775)

RE: File upload component

t-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Grant Molloy Sent: Monday, 7 September 2015 7:52 AM To: ozDotNet Subject: Re: File upload component There's a JS library called dropzone. Allows drag-n-droo, as well as typical click to upload. On Sep 6, 2015 10:49 PM, "

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: H4sIAAAEALVW0W7aMBT9lanvre0wBkNtJEo3DWkFBGGvyDiXYi22M9vpYL/Wh33SfmGGJASatKOS95KH3HvPyTk+tvPn6fe1NLg3Bas5PMIsS0H3GVOZtJGm0lBmuZJfuLFKb99

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 [mailto:ozd

RE: Odd text encoding

-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Thomas Koster Sent: Thursday, 10 September 2015 10:33 AM To: ozDotNet Subject: Re: Odd text encoding On 10 September 2015 at 10:21, Greg Low (罗格雷格博士) wrote: > This one’s driving me crazy and I thought the brains trust might ha

Re: Odd text encoding

Price 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 (罗格雷格博士) mailto:g...@greglow.

Re: Odd text encoding

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

Re: Odd text encoding

y 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 unicode column. Davy Sent from my iPhone

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 v

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 [mailto:ozdotnet-boun...@ozdotn

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 mailto:gfke...@gmail.com>> wrote: Assuming computing power doubles eve

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 th

Re: PayPal Integration

heir emails. I should hit the unsubscribe button now that I'm thinking of it. On Sun, 13 Sep 2015 at 16:27 Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: Hi Folks, Been using eWay for ages and integrating with it was pretty trivial. Wanting to add PayPal now (to existing MVC

Re: PayPal Integration

ople enter card details into to be clearly their site and not mine. Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 14 Sep 2015, at 2:51 pm, Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: Yep I like Stripe and eWay was quite simple but bunches of cli

RE: PayPal Integration

ailto:ozdotnet-boun...@ozdotnet.com> [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of DotNet Dude Sent: Monday, 14 September 2015 4:59 PM To: ozDotNet mailto:ozdotnet@ozdotnet.com>> Subject: Re: PayPal Integration Anyone used braintree? On Monday, 14 September 2015, Greg Low (罗格雷格博士) mai

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 mailto:djones...@gmail.com>> wrote: Hi all I've got a colleague who is moving to Sydney next wednesday to start his visa process. Does anyone know

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 mailto:crai...@gmail.com>> wrote: Tell them you charge for meetings on normal hourly rate even if they are cancelled. Craig On Thu, Oct 22, 2015 at 7:28 PM, Gran

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 t

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 (罗格雷格博士) wrote: > > Yep correct - rarely changes - just get a reliable DDNS service and a decent > modem/router that "get

RE: [OT] Cable IP address

gave me a "slab" Netgear Gateway Max with pretty blinking lights. GK On 28 October 2015 at 18:17, Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: Yep correct - rarely changes - just get a reliable DDNS service and a decent modem/router that "gets" DDNS. We use a DO

RE: [OT] Cable IP address

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

RE: [OT] Cable IP address

bject: Re: [OT] Cable IP address What are you using for NAT? On Wed, 28 Oct 2015 at 19:00 Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: We get around 110 Mb/sec down, and about 3 up. Not complaining but yes, use the supplied Netgear box in bridge mode only. Regards, Greg Dr Greg

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 w

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 M

RE: SSL Certs

<http://www.sqldownunder.com/> From: Greg Low (罗格雷格博士) Sent: Monday, 2 November 2015 9:03 PM To: ozDotNet 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 on Azure websites, thoug

Re: SSL Certs

f.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 (罗格雷格博士) Sent: Monday, 2 November 2015 9:03 PM To: ozDotNet mailto:ozdo

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 to

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

ldn'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 (罗格雷格博士) > wrote: Yes I wondered about that one - just seemed over the top. Initial page doesn't need SSL so might look at DNS redirect from .com.au<http://com.au> t

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

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

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 3

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 Subject: RE: Sha

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: [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: www.sqldownunder.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, a

Re: [OT] Office 365 Azure AD sync

le. thanks! Stephen From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> mailto:ozdotnet-boun...@ozdotnet.com>> on behalf of Greg Low (罗格雷格博士) mailto:g...@greglow.com>> Sent: Wednesday, 2 December 2015 12:05 PM To: ozDotNet Subject: Re: [OT] Office 365

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 ju

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 mo

RE: Any Powershell gurus?

;Z:'; $_.Put() } 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

RE: Any Powershell gurus?

From: Greg Low (罗格雷格博士) Sent: Sunday, 17 January 2016 2:45 PM To: ozDotNet 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 Server 2012 R2 Server templa

Re: [OT] New PC no video

We used to write code to play tunes on drum printers - nice and loud The most hard core lady from HP product group that I ever met when working there, could walk up to one of our green screen terminals and, from memory, enter enough machine code to make it play a car game. She'd spent way too mu

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: www.sqldo

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: oz

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 mailto:gfke...@gmail.com>> wrote: https://blogs.msdn.microsoft.com/acoat/2016/01/28/publish-a-static-web-site-using-azure-web-apps/ Oooh! I'll r

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

PM To: ozDotNet Subject: Re: SQL foreign key question On 9 February 2016 at 16:02, Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: 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 si

RE: SQL foreign key question

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

RE: SQL foreign key question

urstin Sent: Tuesday, 9 February 2016 4:06 PM To: ozDotNet mailto:ozdotnet@ozdotnet.com>> Subject: Re: SQL foreign key question On 9 February 2016 at 16:02, Greg Low (罗格雷格博士) mailto:g...@greglow.com>> wrote: You often see tables referring to themselves (due to some sort of hierarchical da

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 gro

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 ma

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?

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 l

Re: Any opinions on the Dell XPS 15 laptops?

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 (罗格雷格博士) mailto:g...@greglow.com>> wrote: Nah, sadly the 8GB RAM is a showstopper. With the precision, I’m tossing up between 32GB

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

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) offi

RE: [OT] ACS - relevant?

I follow what you’re saying Tony but the two concepts are separate. You are describing what you are looking for in an employee. You might consider that “professionalism” but you are not actually describing what most other industries would describe as professionalism. In most industries, profess

RE: [OT] ACS - relevant?

that because > someone is a member of a professional body it is supposed to make > them competent. In 20 years I have only once seen a job that > specifically said ACS was desired and that was for a government job. > Which kind of means it is certainly appr

RE: [OT] ACS - relevant?

Almost agree Ken. I don’t see having “professional” attributes as being related to whether or not IT projects fail. What I do see is a difference in the finger pointing when they fail. If I was the CEO responsible when an issue occurred, I’d feel more comfortable having used staff that an exter

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 faile

RE: [ot] upgrading to windows 10

We tried to upgrade 2 x E7440’s running Windows 8.1 to Windows 10. Both said the upgrades worked and both were unusable after the upgrade. I’m sure it was a screen driver related issue. However, installing fresh went smoothly. I would have thought that would be the same drivers. Can’t imagine go

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 SQ

Re: SQL Server 2014 Books Online - bits missing?

onie On 4 March 2016 at 15:10, Greg Low (罗格雷格博士) 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 versions are now far superior. Regards, Greg Dr Gre

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 to

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

RE: Azure Table query "not null"

eys! 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, Greg Low (罗格雷格博士)

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 4192

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 t

RE: Coffee snobs

et.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Friday, 8 April 2016 11:06 AM To: ozDotNet Subject: Re: Coffee snobs Greg, I was sure you would buy the Oracle. ;) Sent from Outlook<https://aka.ms/kr63o9> on iOS On Thu, Apr 7, 2016 at 5:19 PM -0700, "

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 (罗格雷格博士) ; ozDotNet Subject: RE: Coffee snobs When my delonghi broke down(leaking water), I started looking at alternative machines. M

RE: Coffee snobs

Id=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 Folks, Given the importance of caffeine for code generation, I’m guessing there will be a few

RE: Coffee snobs

Nice ! After reading the comments, I’m starting to lean this way though: http://www.espressocompany.com.au/giotto.htm That seems amazing. (If I could learn to drive it) Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web

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 mailto:and...@ml.net.au>> wrote: Hi, I have a Breville at one office and it does a good enough job, but it is hard to be consistently

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 a

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

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

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, I

RE: Entity Framework - the lay of the land

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 ba

RE: Entity Framework - the lay of the land

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: ozDotNet

Re: Entity Framework - the lay of the land

ssues. The #1 way 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> ______

Re: Entity Framework - the lay of the land

:-) 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" mailto:neale.n...@gmail.com>> wrote: How to bridge the app/db g

Re: Entity Framework - the lay of the land

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 Flig

RE: Entity Framework - the lay of the land

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: www.sql

  1   2   >