September 5, 2017 at 2:12 pm
TomThomson - Tuesday, September 5, 2017 1:56 PMKopřivnice - Wikipedia Sean Lange - Sunday, September 3, 2017 12:47 PMTomThomson - Saturday, September 2, 2017 7:17 PM...
I've drink American beers in a few states - NJ, NH, NY, MA, CA, WA, IL, VT and ME and not a single one had beer that could match European (other than non-Danish Scandinavian) standards.Not sure where you came to the conclusion that I like lagers. I actually do not care for lagers at all...at least not the American ones. Thankfully we can get many imports so we aren't stuck with only a choice between which pilsner to drink. I apologize that American beer is not up to your standards but gosh, you are bordering on JC style bashing here.
Ok, you have a point. I most definitely must do my best not to emulate JC's commenting style (except when commenting on his comments, perhaps).
It's long time since I formed my view on American beer and decided that when I was in the UsA I would stick to wine or whisky or gin or vodka or brandy or cocktails (but sadly I never found a Barman in CA or WA who knew what a Manhattan was) when in the USA. Perhaps the beer has improved since then (in fact it seems probable, as a lot of my American friends/colleagues shared my view on American beer, and that encourage brewers to make improvements) and I didn't noticed because I'd given up drinking it.
If it has been a long time then yes the beer on this side of the pond has improved a thousand fold. There was a time all you could get was the crap pilsner that had to be served about 30F because once it warmed up to more than about 34F it started to gain flavor...and the flavor was nothing short of horrific. You definitely give some American brewers another shot. There are small batch breweries in nearly every city and many of them don't have any distribution outside of the building. That being said I am going to be trying to search out more of the European lagers to try.
I am not all that surprised that finding a barman who knows how to make a Manhattan is challenging. The American palette has still not progressed greatly when it comes to traditional mixed drinks.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 5, 2017 at 2:15 pm
Grant Fritchey - Tuesday, September 5, 2017 7:03 AMI am a hop fanatic. IPAs are glorious and wonderful.
Would that be American IPAs or non-American IPAs?
Tom
September 6, 2017 at 1:02 am
TomThomson - Tuesday, September 5, 2017 2:15 PMGrant Fritchey - Tuesday, September 5, 2017 7:03 AMI am a hop fanatic. IPAs are glorious and wonderful.Would that be American IPAs or non-American IPAs?
Quick techie question to see if something warrants further investigation: does anybody know if writing back to the database from an SSRS report is supported? Er, asking for a friend.
Back to beer.
I only realised recently that Greene King IPA isn't actually an IPA only marketed with those initials. It was only when I tried more true IPA's that I realised how different it was.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 6, 2017 at 1:42 am
Thom A - Tuesday, September 5, 2017 7:44 AMNeil Burton - Tuesday, September 5, 2017 7:38 AMI've found some good lagers recently from both sides of the Atlantic. It can definitely have a lot more flavour than I thought. I can sometimes be persuaded by a cold pint of Bud on a hot day, not that we get many of those in my neck of the woods.
I've recently taken a liking to imported Lagers. Japanese seem to be my favoured choice at the moment (for example Asahi and Sapporo). Still like good English Ales still though; won't say no to a good Badger Beer for example. 🙂
I don't like Asahi but I do drink Sapporo and Kirin (when I can get it), other lagers Staropramen, Peroni and Warsteiner. Used to drink a lot of real ales but now not many (Directors, Timothy Taylor Landlord and Boddingtons). I do like IPA, not all but some, it's the same with all beers, some are good and some are awful.
Far away is close at hand in the images of elsewhere.
Anon.
September 6, 2017 at 1:42 am
"American-style IPA" doesn't have to be awful. Here's probably the best IPA in the world: http://www.thornbridgebrewery.co.uk/product.php?s=jaipur
Reading is a desert when it comes to decent food but it has half a dozen of the best pubs in the country, and at least one of them supplies Thornbridge ales from time to time - so I can tell you it's nice from the tap, too.
I know I've posted this up here before but the USA makes some magnificent ales. I've had the pleasure of drinking most of the ales imported from Rogue Ales at some time or another and they've all been special.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 6, 2017 at 1:47 am
TomThomson - Tuesday, September 5, 2017 2:15 PMGrant Fritchey - Tuesday, September 5, 2017 7:03 AMI am a hop fanatic. IPAs are glorious and wonderful.Would that be American IPAs or non-American IPAs?
These days the IPA TLA is more like xPA, there is APA for American Pale Ale, IPA can be Indian, Irish, Icelandic, Italian etc.
😎
September 6, 2017 at 1:57 am
Neil Burton - Wednesday, September 6, 2017 1:02 AMQuick techie question to see if something warrants further investigation: does anybody know if writing back to the database from an SSRS report is supported? Er, asking for a friend.
Depends what you mean by write back. I've used a report with hyperlinks on it, which reloaded the report with an additional parameter. That parameter, when passed, updated the specific record in its value with a the next step in the status chain. I.e. Pending -> Processing -> Completed. It wasn't really the tool for the job, but it solved the problem (much like a hammer could get a screw in a hole 🙂 )
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 6, 2017 at 2:12 am
Thom A - Wednesday, September 6, 2017 1:57 AMNeil Burton - Wednesday, September 6, 2017 1:02 AMQuick techie question to see if something warrants further investigation: does anybody know if writing back to the database from an SSRS report is supported? Er, asking for a friend.Depends what you mean by write back. I've used a report with hyperlinks on it, which reloaded the report with an additional parameter. That parameter, when passed, updated the specific record in its value with a the next step in the status chain. I.e. Pending -> Processing -> Completed. It wasn't really the tool for the job, but it solved the problem (much like a hammer could get a screw in a hole 🙂 )
We have a data warehouse we provide to a third party. They have a series of reports on their own database on our server (not ideal but politics) and they use some views on our database to build these reports. Some of these reports take a user parameter and write to other tables in their database so they can record the reason a task was or wasn't completed. Yesterday our data warehouse ran long because a user had an open transaction locking one of the fact tables. My theory is that it was one of these write-back reports of theirs that caused it. If I remember correctly, if you are updating a table from a view, locks are taken on the underlying tables until the update is committed. If the transaction is not committed the locks will stay in place. We're now looking at ways of preventing this happening again and one of the options is telling them not to do it. If could say that writing to databases from SSRS is not supported by Microsoft then we'd be in a stronger position.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 6, 2017 at 2:31 am
Neil Burton - Wednesday, September 6, 2017 2:12 AMWe have a data warehouse we provide to a third party. They have a series of reports on their own database on our server (not ideal but politics) and they use some views on our database to build these reports. Some of these reports take a user parameter and write to other tables in their database so they can record the reason a task was or wasn't completed. Yesterday our data warehouse ran long because a user had an open transaction locking one of the fact tables. My theory is that it was one of these write-back reports of theirs that caused it. If I remember correctly, if you are updating a table from a view, locks are taken on the underlying tables until the update is committed. If the transaction is not committed the locks will stay in place. We're now looking at ways of preventing this happening again and one of the options is telling them not to do it. If could say that writing to databases from SSRS is not supported by Microsoft then we'd be in a stronger position.
At the end of the day SSRS simply runs T-SQL and then displays any resultsets graphically in the way you tell it to. If that T-SQL contains an UPDATE, INSERT, etc, statement, then the SQL Server will be happy to run it, regardless of the source application (including if that application is SSRS).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 6, 2017 at 2:39 am
Thom A - Wednesday, September 6, 2017 2:31 AMNeil Burton - Wednesday, September 6, 2017 2:12 AMWe have a data warehouse we provide to a third party. They have a series of reports on their own database on our server (not ideal but politics) and they use some views on our database to build these reports. Some of these reports take a user parameter and write to other tables in their database so they can record the reason a task was or wasn't completed. Yesterday our data warehouse ran long because a user had an open transaction locking one of the fact tables. My theory is that it was one of these write-back reports of theirs that caused it. If I remember correctly, if you are updating a table from a view, locks are taken on the underlying tables until the update is committed. If the transaction is not committed the locks will stay in place. We're now looking at ways of preventing this happening again and one of the options is telling them not to do it. If could say that writing to databases from SSRS is not supported by Microsoft then we'd be in a stronger position.At the end of the day SSRS simply runs T-SQL and then displays any resultsets graphically in the way you tell it to. If that T-SQL contains an UPDATE, INSERT, etc, statement, then the SQL Server will be happy to run it, regardless of the source application (including if that application is SSRS).
That makes sense, I had a feeling that was the case but I could hope. IPA for your trouble?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 6, 2017 at 2:50 am
Neil Burton - Wednesday, September 6, 2017 2:39 AMThat makes sense, I had a feeling that was the case but I could hope. IPA for your trouble?
Maybe not right, it's not even 10:00 yet! I try not to drink before midday ^_^
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 6, 2017 at 5:09 am
Sean Lange - Tuesday, September 5, 2017 2:12 PMIf it has been a long time then yes the beer on this side of the pond has improved a thousand fold. There was a time all you could get was the crap pilsner that had to be served about 30F because once it warmed up to more than about 34F it started to gain flavor...and the flavor was nothing short of horrific. You definitely give some American brewers another shot. There are small batch breweries in nearly every city and many of them don't have any distribution outside of the building. That being said I am going to be trying to search out more of the European lagers to try.I am not all that surprised that finding a barman who knows how to make a Manhattan is challenging. The American palette has still not progressed greatly when it comes to traditional mixed drinks.
I'm sorry to interject an unrelated question into the beer conversation, but Sean, how did things go this past weekend. I believe you had a deployment scheduled.
September 6, 2017 at 5:56 am
So the wife nearly had a heart attack this weekend, Saturday night...
We were in Toronto for a convention, FanExpo, and the star of the show "Arrow," Stephen Amell, was there (which is why the wife wanted to go.) She'd gotten a couple autographs and one of the pay-for photo ops with him and all was well.
Until we went out to dinner at a pub across from our hotel.
And as she's watching the waitress who was about to lead us to our table, this strange guy walks up to her with his hand out (no, not me,) saying "Hi, I'm Stephen Amell!" She was wearing a t-shirt with a picture of him from the show on it, and he must've seen it (him and his friends were at a table right by the door.) She was in such a state of shock.
On the way out, she asked him if she could take a pic with him and he graciously agreed.
Loads of fun watching her fan-girl out the rest of the evening.
Oh, and if you ever find yourself in Toronto, downtown by Union Station / CN Tower area, give the Loose Moose pub a try.
September 6, 2017 at 6:04 am
So... I'm not going to be around as much as usual over the next couple of months. I've been working on a major project over the past 8 months that (as one coworker put it) was going straight from development to production. Unfortunately, the release date happened 6 weeks earlier than expected and now I'm kind of focusing on fixing the bugs 24/7 for the next 8+ weeks. I hope y'all don't fall apart without me. @=)
BTW, the project I'm talking about? It had to do with an inadvertent use of DBCC TIMEWARP() on a pregnancy. Baby says "hi" or would if he could do more than gurgle at the moment.
What the heck did I just get myself into? SIGH. Please be careful with the use of that function. Apparently it has side effects no one warned me about. :crazy:
September 6, 2017 at 6:10 am
Brandie Tarvin - Wednesday, September 6, 2017 6:04 AMSo... I'm not going to be around as much as usual over the next couple of months. I've been working on a major project over the past 8 months that (as one coworker put it) was going straight from development to production. Unfortunately, the release date happened 6 weeks earlier than expected and now I'm kind of focusing on fixing the bugs 24/7 for the next 8+ weeks. I hope y'all don't fall apart without me. @=)BTW, the project I'm talking about? It had to do with an inadvertent use of DBCC TIMEWARP() on a pregnancy. Baby says "hi" or would if he could do more than gurgle at the moment.
What the heck did I just get myself into? SIGH. Please be careful with the use of that function. Apparently it has side effects no one warned me about. :crazy:
Congratulations! Yes, side effects of uncontrolled happiness! Happiness Spigot
you're already used to not sleeping, working with databases. Happy Birthday, Brandie Prime!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 15 posts - 59,806 through 59,820 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply