Ctrl+shift actually, switches between keyboard layouts. Alt+shift switches between language settings, which usually have another keyboard layout set to them.
steenbergh
@steenbergh
Best posts made by steenbergh
Latest posts made by steenbergh
-
RE: Really inspiring confidence there, guys...
-
RE: Excel errors? Gotcha covered boss!
@El_Heffe said:
@steenbergh said:
Excel doesn't enforce correct user
How would Excel do that?
input
It doesn't, and that's the point. When you need to enter in unstructured data (uch as a spreadsheet) into a structured setting (such as an RDBMS), stuff can go wrong. I don't mean to prevent that, but working with the flaws inherent in this process is NOT done in the way described above... If the interface prcess would just throw an error when encountering these malformed input, that would be fine. This, well, not so much. -
Excel errors? Gotcha covered boss!
We hire folks to build a data warehouse for us. You all probably know the drill: Copy tables from systems such as our HR application, finance, production etc, convert into a fact/dimension model, load into cubes, show it in a report.
Not all our inputs stem from relational databases. In any (semi-)professional environment, one sooner or later comes across an Excel file that needs to be added to the data model. And of course, Excel doesn't enforce correct user input. So when dealing with erroneous Excel entries, a developer is placed before a choice. Some may have the code throw an error, some may even *speak* with a client to say that 'the date entered on line 312 is malformed and could you please fix it'.
Not Jim. Jim made sure the customer had a smooth ride. After copying the entire Excel file into a staging table, he used this view to copy the data to the data warehouse:
CREATE VIEW [dbo].[V_SA_BL_D_CancelledSessions] AS select N'01' as Organisation_Bkey ,convert(int, convert(nvarchar, convert(date, case when number = 43 then '15-4-2009' when number = 44 then '15-4-2009' else [date reported] end, 105) -- format dd-mm-yyyyy , 112)) as DateReported_SKey ,convert(date, case when number = 43 then '15-4-2009' when number = 44 then '15-4-2009' else [date reported] end, 105) -- format dd-mm-yyyyy as DateReported ,convert(int, convert(nvarchar, convert(date, case when number = 43 then '16-4-2009' when number = 44 then '17-4-2009' when number = 365 then '3-3-2011' when number = 699 then '19-7-2012' else [Date Session] end, 105) -- format dd-mm-yyyyy , 112)) as Date_Session_SKey
... etc ...</pre><br>
Yes. This developer thought the best way to deal with dates entered incorrectly was to do a row-based replace of the dates concerned. This of course worked like a charm, until the next error was typed into the sheet.
-
SSIS Annotation
I just wrote an annotation in a data flow in SSIS. When entering a date in the format 'DD-MM-YYYY' (dutch default notation) I automatically used the minus-key located on the numpad. No hyphen appeared. Used the other one and bingo. Opened Notepad to verify that the numpad-minus was working. It was...
SSIS discriminates between numpad and regular hyphen when entering annotations. Debate.
-
RE: Your AVG Protection.
Streamlining your boot process is a relatively new 'feature' in AVG. I've used it for several years now and only noticed it in the latest release.
-
RE: Your AVG Protection.
@jmap said:
I lost faith in AVG the first time I got a popup on startup saying something like:
Thanks to AVG, your computer started up 105% faster than usual!
with absolutely no indication of why. If anything I expect startup to be slower with anti-virus running, so what exactly is it doing to improve startup speeds and how is that any of AVG's goddamn business in the first place?
Yeah, I raised an eyebrow at that notification too. Especially since the percentage reported to me was a lot bigger, something like 250%. It was a new laptop on which I installed AVG and removed all the factory-issue bloatware. But yes AVG, good job on imrpoving boot speed.
Also I really like the way how AVG needs an update every three months and how it automattically checks the premium edition for you. Pretty neat feature!
-
RE: Please click on the link below to exceeding your quota.
@derari said:
@Zecc said:
Microsoft Network Number (http://en.wikipedia.org/wiki/MSN). Didn't you know that the Netherlands are a Microsoft subsidiary?@toon said:
MSN number
Mobile... Something... Number?
This is true. In Holland, one can get sued for using Linux. Though there are exceptions for the use of Android on hand-held devices.
-
RE: I like Raymond Chen's blog but I think he's making this stuff up
@PedanticCurmudgeon said:
@steenbergh said:
It's an example of persuasive definition. The Partnership for a Drug-Free America crowd would have you believe that any drug use inevitably leads to the brain-as-egg-bashed-by-frying-pan scenario, so it is all abuse as far as they're concerned.@TGV said:
Either he made it up, or there is substance abuse involved.
Why is the consumption of such substances always referred to as 'abuse'?
Wow, that's delusional! What are they smoking, the Drug Free America crowd?
-
RE: I like Raymond Chen's blog but I think he's making this stuff up
@TGV said:
Either he made it up, or there is substance abuse involved.
Why is the consumption of such substances always referred to as 'abuse'?