September 6, 2017 at 7:31 am
TomThomson - Tuesday, September 5, 2017 1:30 PMJeff Moden - Sunday, September 3, 2017 5:37 PMTomThomson - Saturday, September 2, 2017 7:17 PMSean Lange - Thursday, August 31, 2017 8:11 AMI would have to argue with your brother in law...there is no such thing as a good IPA. 😉 Not really sure when it happened but hoppy beers like IPAs have become really popular. I personally can't stand hoppy beers, but I am definitely a beer snob.Well, once again an American demonstration that left-pondians don't like decent ales, they prefer awful poor-imitation-lager-style muck. Come and visit Britain sometime and drink some of our real ale instead of the pasteurised stuff you are used to - you'll find it an eye-opener - a decent Scottish Heavy or English Bitter is vastly better than any IPA, but most iPAs I've tasted are infinitely better than any American beer. Or visit Germany for decent lager or the Czech Republic for decent Budweiser instead of your poor American imitation (and once you've had the real Budweiser you'll undertand why Europeans think it amazing that after stealing both the production technique and the trade-name you still can't get it right).
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.Interesting. Any way you can ship me a pint of "Real Budweiser" for a taste-test comparison?
I'm a long way from the nearest place I can get either American or Czech Budweiser, and ordering it by mail or phone is rather chaotic and fraught with problems as there is real confusion between the two. In most of Europe, the American company calls its beer "Bud" because it has no right to use Budweiser and no right to use Budvar, but in the UK, both the Americans and the Czechs call their beers "Budweiser Budvar", which means you have to read the small print on the bottle to work out which it is.
But you can easily get a least one of the Czech Budweiser brewery's beers in the USA. They're sold under the name "Czechvar" because the name "Budweiser" (German for "from Budweis") was hijacked. There are maybe 10 varieties of Budweiser from the Cech brewery, but at least one of those comes in casks not in bottles and I haven't seen any Czech cask Budweiser in the USA. I'm not sure how many of the different bottled versions are sold in the USA. At least one of them is available in Canada too (in green glass bottles instead of brown glass as in the USA) under the same "Czechvar" name. Avoid the variety marked "B: Free" - that's the alcohol-free version! The original Budweiser Budwar may be marked "B: Original" (or not - iit was in the UK last time I looked).
Kopřivnice - Wikipedia
Good info. I'll look into it, Tom.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 6, 2017 at 7:31 am
Brandie Tarvin - Wednesday, September 6, 2017 6:34 AMNeil Burton - Wednesday, September 6, 2017 6:25 AMjonathan.crawford - Wednesday, September 6, 2017 6:15 AMNeil Burton - Wednesday, September 6, 2017 2:12 AMThom 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.
You'll have to (obviously) consider SQL Injection, but I did a proof of concept to do just exactly what you're suggesting, works fine. I was completely unhappy with trying this without creating an audit table that captured every change, userids and stamps of when it happened, because you're necessarily exposing the record to modification just by returning it to the report. PM me if you want an example
It's not something I want to do, personally I think it's a horrible idea for many reasons, not least SQL injection. I know it can be done, I'd just rather it wasn't. Having some kind of official line against it would be ammunition in the discussion with the customer about how they're not going to break our databases in future. There's all kinds of politics involved in this sh!tpile and the upshot is I'll probably have to make changes to my data warehouse to allow their idiots to do stuff no sensible person would want to do. Why, because that's going to cheapest!
Congratulations Brandie 🙂
Thanks...
BTW, aren't reports supposed to "report"? As in the idea is that applications change data, reports just tell you the state of the data. That's the way I've always seen the issue. It doesn't make sense to have a report that does application work.
I know that, you know that and the customer knows that. They knocked out SSRS solution to last until their system came online after six months but that six months has never ended. The problem is we're the fourth year into a six month interim service and we're being switched off in six months (for a given definition of six months). Stuff that was put in place temporarily until the new world was switched on is still in use. Nobody at the customer wants to spend any money on interim stuff because it's only got months to last, or not. It's a massive pain in many areas, not least because products are coming out of support around our ears and we're frantically trying to get stuff upgraded. 2020 has been mooted as a possible end date now and that's just not funny.
Anyway enough of that, go and enjoy the little one.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 6, 2017 at 7:33 am
jasona.work - Wednesday, September 6, 2017 7:29 AMGrant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
And after reading the Wikipedia page on it, added to my own "find it" list.
And thank you Eirikur.
Now I need to go and find my copy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2017 at 7:36 am
Grant Fritchey - Wednesday, September 6, 2017 7:33 AMjasona.work - Wednesday, September 6, 2017 7:29 AMGrant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
And after reading the Wikipedia page on it, added to my own "find it" list.
And thank you Eirikur.
Now I need to go and find my copy.
/Me plans a trip down to John K King Books to see if they have it.
September 6, 2017 at 7:37 am
Sean Lange - Wednesday, September 6, 2017 7:13 AMEd Wagner - Wednesday, September 6, 2017 5:09 AMSean 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.
Haha. We did. I came into the office for about 6 hours on Saturday and then another 4-5 hours on Sunday from home. I was able to get out and see a band Saturday night (Living End from Australia). Then I got to spend all day Monday with the family. The release of course has a lot of craziness now but nothing where the sky is falling or anything that horrific. All in all it has been pretty smooth. One of or VPs stated that it has been almost 4 years since we started this project. Our last branches in the distribution division will cut over this next Monday which will mean that our mainframe application will no longer be in use. There may be an AS400 or two on the resale market in the near future. Now if we had just chosen a better ERP to migrate too all would be good.
That's good to hear. I'm glad it didn't consume your entire weekend and you got to have some fun. I don't know how many takers you'll get on the old AS400 systems, but I'm sure there's someone out there that'll bite. As for the ERP you migrated to...well, you already know what I think so let's just say you have my condolences and leave it at that.
Good job on the release. The next hurdle you'll have to deal with is when your remaining divisions moves over to using it.
September 6, 2017 at 7:42 am
Ed Wagner - Wednesday, September 6, 2017 7:37 AMSean Lange - Wednesday, September 6, 2017 7:13 AMEd Wagner - Wednesday, September 6, 2017 5:09 AMSean 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.
Haha. We did. I came into the office for about 6 hours on Saturday and then another 4-5 hours on Sunday from home. I was able to get out and see a band Saturday night (Living End from Australia). Then I got to spend all day Monday with the family. The release of course has a lot of craziness now but nothing where the sky is falling or anything that horrific. All in all it has been pretty smooth. One of or VPs stated that it has been almost 4 years since we started this project. Our last branches in the distribution division will cut over this next Monday which will mean that our mainframe application will no longer be in use. There may be an AS400 or two on the resale market in the near future. Now if we had just chosen a better ERP to migrate too all would be good.
That's good to hear. I'm glad it didn't consume your entire weekend and you got to have some fun. I don't know how many takers you'll get on the old AS400 systems, but I'm sure there's someone out there that'll bite. As for the ERP you migrated to...well, you already know what I think so let's just say you have my condolences and leave it at that.
Good job on the release. The next hurdle you'll have to deal with is when your remaining divisions moves over to using it.
The biggest challenge for me was releasing the ecommerce site into the wild this last weekend. Everything had to change to point to the new ERP instead of the ancient (and not much worse) mainframe database.
_______________________________________________________________
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 6, 2017 at 7:44 am
Grant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
Not a great fan but I recall reading it on a plain many years ago, that damn photographic memory just lit up when I read your description of the cover, otherwise I don't think I would have remembered it.. 😉
😎
September 6, 2017 at 7:47 am
jasona.work - Wednesday, September 6, 2017 7:36 AMGrant Fritchey - Wednesday, September 6, 2017 7:33 AMjasona.work - Wednesday, September 6, 2017 7:29 AMGrant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
And after reading the Wikipedia page on it, added to my own "find it" list.
And thank you Eirikur.
Now I need to go and find my copy.
/Me plans a trip down to John K King Books to see if they have it.
Look no further, you'll find it here
😎
September 6, 2017 at 8:26 am
Eirikur Eiriksson - Wednesday, September 6, 2017 7:47 AMjasona.work - Wednesday, September 6, 2017 7:36 AMGrant Fritchey - Wednesday, September 6, 2017 7:33 AMjasona.work - Wednesday, September 6, 2017 7:29 AMGrant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
And after reading the Wikipedia page on it, added to my own "find it" list.
And thank you Eirikur.
Now I need to go and find my copy.
/Me plans a trip down to John K King Books to see if they have it.
Look no further, you'll find it here
😎
And give up the chance to browse the stacks here: http://www.kingbooksdetroit.com/
Are you *MAD*???
September 6, 2017 at 8:36 am
jasona.work - Wednesday, September 6, 2017 8:26 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:47 AMjasona.work - Wednesday, September 6, 2017 7:36 AMGrant Fritchey - Wednesday, September 6, 2017 7:33 AMjasona.work - Wednesday, September 6, 2017 7:29 AMGrant Fritchey - Wednesday, September 6, 2017 7:21 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:17 AMGrant Fritchey - Wednesday, September 6, 2017 7:08 AMHey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.There was a book from the 70s called Highways or Exits or something like that. It had a pickup truck on the cover. It was about a road that if you could find the entrance to allowed you to travel through time & space depending on which exit you took. One of the characters had a load of rifles he planned on delivering to the Spartans at Thermopylae as soon as he could find the right exit. Any help on the title to this please?
Are you talking about Roadmarks by Roger Zelazny, the cover has a pickup truck and a flying dragon IIRC
😎WINNER!
And after reading the Wikipedia page on it, added to my own "find it" list.
And thank you Eirikur.
Now I need to go and find my copy.
/Me plans a trip down to John K King Books to see if they have it.
Look no further, you'll find it here
😎And give up the chance to browse the stacks here: http://www.kingbooksdetroit.com/
Are you *MAD*???
No, not mad:crazy: just practical
😎
September 6, 2017 at 8:47 am
Eirikur Eiriksson - Wednesday, September 6, 2017 8:36 AMjasona.work - Wednesday, September 6, 2017 8:26 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:47 AMjasona.work - Wednesday, September 6, 2017 7:36 AM/Me plans a trip down to John K King Books to see if they have it.Look no further, you'll find it here
😎And give up the chance to browse the stacks here: http://www.kingbooksdetroit.com/
Are you *MAD*???No, not mad:crazy: just practical
😎
The man who turns down a chance to browse the stacks of a four-story used bookstore has no soul...
:crying:
Of course, considering I only live about 30-40 minutes away from John King, that does color my perception somewhat.
September 6, 2017 at 9:00 am
jasona.work - Wednesday, September 6, 2017 8:47 AMEirikur Eiriksson - Wednesday, September 6, 2017 8:36 AMjasona.work - Wednesday, September 6, 2017 8:26 AMEirikur Eiriksson - Wednesday, September 6, 2017 7:47 AMjasona.work - Wednesday, September 6, 2017 7:36 AM/Me plans a trip down to John K King Books to see if they have it.Look no further, you'll find it here
😎And give up the chance to browse the stacks here: http://www.kingbooksdetroit.com/
Are you *MAD*???No, not mad:crazy: just practical
😎The man who turns down a chance to browse the stacks of a four-story used bookstore has no soul...
:crying:Of course, considering I only live about 30-40 minutes away from John King, that does color my perception somewhat.
Last time I was in John King's it took as long as getting the books delivered to my home in London, too much too interesting too little time etc.
😎
September 6, 2017 at 9:12 am
Ugh. Our network today has decided it's a good day to be wonky.
Segments seem to be going up and down willy-nilly, and of course other than calling back and pestering our guy in the network center, there's nothing I can do about it...
September 6, 2017 at 9:16 am
Brandie Tarvin - Wednesday, September 6, 2017 6:04 AM...Unfortunately, the release date happened 6 weeks earlier than expected...
Wow, congrats, and hope everything's alright given how early he is. I had a son born 4 weeks early and there were a ton of extra tests and stuff that had to be done.
September 6, 2017 at 9:18 am
Thom A - Wednesday, September 6, 2017 2:50 AMMaybe not right, it's not even 10:00 yet! I try not to drink before midday ^_^
people here are from all around the world... it's always 5:00 somewhere 😉
Viewing 15 posts - 59,836 through 59,850 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply