June 2, 2017 at 8:10 am
Bellevue in August should be nice, though as mentioned it can rain. I'd make sure you had a sweater and rain jacket, just in case. October usually chilly, but you never know. I've had sunny days in Oct in Seattle as well.
I've also had Amazon deliver things to various hotels in SEA when I've forgotten things. Address it to the hotel c/o your name and you should be fine. The front desk will hold it for you.
June 2, 2017 at 8:46 am
Sean Lange - Friday, June 2, 2017 7:32 AMBrandie Tarvin - Friday, June 2, 2017 4:28 AMDesNorton - Friday, June 2, 2017 1:38 AMI am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.
Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.
Bellevue is just on the East side of Lake Washington. It has the same weather as Seattle. Definitely not rainforest, although there is the only temperate rainforest in North America a couple hours away on the peninsula. People always say that it rains a lot in Seattle. This is sort of true and untrue at the same time. There are lots of rainy days but it almost never rains hard. It is more of a light mist/sprinkle most of the time. In October is can be chilly but not super cold. The problem with winter in the NW is that it is so humid the cold goes to the bone and you can't get warm. October shouldn't be bad at all but given the climate differences you would definitely want a hoodie and/or a jacket. Most likely in the 50s-60s Fahrenheit during the day and dropping 10-15 degrees at night.
Steve Jones - SSC Editor - Friday, June 2, 2017 8:10 AMBellevue in August should be nice, though as mentioned it can rain. I'd make sure you had a sweater and rain jacket, just in case. October usually chilly, but you never know. I've had sunny days in Oct in Seattle as well.I've also had Amazon deliver things to various hotels in SEA when I've forgotten things. Address it to the hotel c/o your name and you should be fine. The front desk will hold it for you.
HOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.
June 2, 2017 at 9:02 am
DesNorton - Friday, June 2, 2017 8:46 AMSean Lange - Friday, June 2, 2017 7:32 AMBrandie Tarvin - Friday, June 2, 2017 4:28 AMDesNorton - Friday, June 2, 2017 1:38 AMI am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.
Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.
Bellevue is just on the East side of Lake Washington. It has the same weather as Seattle. Definitely not rainforest, although there is the only temperate rainforest in North America a couple hours away on the peninsula. People always say that it rains a lot in Seattle. This is sort of true and untrue at the same time. There are lots of rainy days but it almost never rains hard. It is more of a light mist/sprinkle most of the time. In October is can be chilly but not super cold. The problem with winter in the NW is that it is so humid the cold goes to the bone and you can't get warm. October shouldn't be bad at all but given the climate differences you would definitely want a hoodie and/or a jacket. Most likely in the 50s-60s Fahrenheit during the day and dropping 10-15 degrees at night.
Steve Jones - SSC Editor - Friday, June 2, 2017 8:10 AMBellevue in August should be nice, though as mentioned it can rain. I'd make sure you had a sweater and rain jacket, just in case. October usually chilly, but you never know. I've had sunny days in Oct in Seattle as well.I've also had Amazon deliver things to various hotels in SEA when I've forgotten things. Address it to the hotel c/o your name and you should be fine. The front desk will hold it for you.
HOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.
How interesting.
I always thought you were a Brit, Des - something to do with the way you write and your choice of words.
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
June 2, 2017 at 9:12 am
DesNorton - Friday, June 2, 2017 8:46 AMSean Lange - Friday, June 2, 2017 7:32 AMBrandie Tarvin - Friday, June 2, 2017 4:28 AMDesNorton - Friday, June 2, 2017 1:38 AMI am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.
Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.
Bellevue is just on the East side of Lake Washington. It has the same weather as Seattle. Definitely not rainforest, although there is the only temperate rainforest in North America a couple hours away on the peninsula. People always say that it rains a lot in Seattle. This is sort of true and untrue at the same time. There are lots of rainy days but it almost never rains hard. It is more of a light mist/sprinkle most of the time. In October is can be chilly but not super cold. The problem with winter in the NW is that it is so humid the cold goes to the bone and you can't get warm. October shouldn't be bad at all but given the climate differences you would definitely want a hoodie and/or a jacket. Most likely in the 50s-60s Fahrenheit during the day and dropping 10-15 degrees at night.
Steve Jones - SSC Editor - Friday, June 2, 2017 8:10 AMBellevue in August should be nice, though as mentioned it can rain. I'd make sure you had a sweater and rain jacket, just in case. October usually chilly, but you never know. I've had sunny days in Oct in Seattle as well.I've also had Amazon deliver things to various hotels in SEA when I've forgotten things. Address it to the hotel c/o your name and you should be fine. The front desk will hold it for you.
HOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.
That is a cold day? I thought that was warm... that is the start of "shorts weather"!
Right now, where I am, the temperatures are around 9C when I get up... mind you yesterday we got up to 34C. Our weather is crazy! A cold day up here, middle of winter, we get -40C and colder. Sometimes even -50C... although not all that often. The average Dec-Jan temps are around -18C. October averages around 5C.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2017 at 11:09 am
bmg002 - Friday, June 2, 2017 9:12 AMDesNorton - Friday, June 2, 2017 8:46 AMSean Lange - Friday, June 2, 2017 7:32 AMBrandie Tarvin - Friday, June 2, 2017 4:28 AMDesNorton - Friday, June 2, 2017 1:38 AMI am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.
Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.
Bellevue is just on the East side of Lake Washington. It has the same weather as Seattle. Definitely not rainforest, although there is the only temperate rainforest in North America a couple hours away on the peninsula. People always say that it rains a lot in Seattle. This is sort of true and untrue at the same time. There are lots of rainy days but it almost never rains hard. It is more of a light mist/sprinkle most of the time. In October is can be chilly but not super cold. The problem with winter in the NW is that it is so humid the cold goes to the bone and you can't get warm. October shouldn't be bad at all but given the climate differences you would definitely want a hoodie and/or a jacket. Most likely in the 50s-60s Fahrenheit during the day and dropping 10-15 degrees at night.
HOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.
That is a cold day? I thought that was warm... that is the start of "shorts weather"!
Right now, where I am, the temperatures are around 9C when I get up... mind you yesterday we got up to 34C. Our weather is crazy! A cold day up here, middle of winter, we get -40C and colder. Sometimes even -50C... although not all that often. The average Dec-Jan temps are around -18C. October averages around 5C.
And where are you at, the Artic Circle?
June 2, 2017 at 11:32 am
DesNorton - Friday, June 2, 2017 8:46 AMHOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.
It's not that bad. All buildings will be heated, and are built to keep warm, not like locally. Plus it's a humid cold, so it doesn't bite that badly.
I dress much the same for Seattle in Oct/Nov as I do for JHB in June/July
Pack a windbreaker, and something waterproof. The rain and wind's far worse than the cold itself
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2017 at 12:11 pm
GilaMonster - Friday, June 2, 2017 11:32 AMDesNorton - Friday, June 2, 2017 8:46 AMHOLY COW. In my world, a cold winters day is 12-14C (53-57F). And then I am looking for a blanket, a warm fire and a whole heap of alcohol.It's not that bad. All buildings will be heated, and are built to keep warm, not like locally. Plus it's a humid cold, so it doesn't bite that badly.
I dress much the same for Seattle in Oct/Nov as I do for JHB in June/JulyPack a windbreaker, and something waterproof. The rain and wind's far worse than the cold itself
Thanks Gail.
So if I stay indoors, and all should be well. The bar probably requires some propping up anyway.
June 2, 2017 at 12:18 pm
Lynn Pettis - Friday, June 2, 2017 11:09 AMAnd where are you at, the Artic Circle?
heh... not quite... little further south than that (pretty close to the exact middle of Canada). We had a bear (not a polar bear) up in a tree in our city a few days go. That was a fun time (thankfully nowhere near me).
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2017 at 1:00 pm
bmg002 - Friday, June 2, 2017 12:18 PMheh... not quite... little further south than that (pretty close to the exact middle of Canada). We had a bear (not a polar bear) up in a tree in our city a few days go. That was a fun time (thankfully nowhere near me).
I lived in Alaska (about an hour NE of Anchorage in the mountains) for a year and it rarely got that cold. Although Thanksgiving day it was -40F with wind chills that pushed it close to -70F. Crazy in the winter there. Everyday in the paper you could read about somebody who died because of exposure when just running from their car to a building. These were usually business people and such doing things like wearing a suit in the winter.
_______________________________________________________________
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/
June 2, 2017 at 1:27 pm
Sean Lange - Friday, June 2, 2017 1:00 PMI lived in Alaska (about an hour NE of Anchorage in the mountains) for a year and it rarely got that cold. Although Thanksgiving day it was -40F with wind chills that pushed it close to -70F. Crazy in the winter there. Everyday in the paper you could read about somebody who died because of exposure when just running from their car to a building. These were usually business people and such doing things like wearing a suit in the winter.
We get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2017 at 1:44 pm
bmg002 - Friday, June 2, 2017 1:27 PMWe get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.
That was more than half my life ago. Long story but I happened into a situation that allowed me to live there free for a year. I was young and figured it might be the only chance I would get for such an adventure so I took it. I was actually working as a screen printer during that time so I was working inside in shorts and a tshirt. It was always a challenge to convince myself to put on a coat to take out the trash. I was also quite young at that point so the cold didn't affect me quite as much as it would today.
_______________________________________________________________
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/
June 2, 2017 at 2:58 pm
Sean Lange - Friday, June 2, 2017 1:44 PMbmg002 - Friday, June 2, 2017 1:27 PMWe get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.That was more than half my life ago. Long story but I happened into a situation that allowed me to live there free for a year. I was young and figured it might be the only chance I would get for such an adventure so I took it. I was actually working as a screen printer during that time so I was working inside in shorts and a tshirt. It was always a challenge to convince myself to put on a coat to take out the trash. I was also quite young at that point so the cold didn't affect me quite as much as it would today.
living for free sounds really nice! I know that feeling though... I always look out the window before taking my trash out as it can be sunny one mintue then raining the next... or actually both at the same time (it is doing that now :/).
So if it is raining/snowing, I tend to stay indoors as much as possible. I've also been here my whole life so I'd expect that I'd be more used to the cold by now, but I still complain about it a lot more than I should. If I am not willing to move, I shouldn't really complain. But I have a pretty good job, so it is hard to justify moving (unless somebody was to offer me more money).
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2017 at 7:06 pm
bmg002 - Friday, June 2, 2017 2:58 PMSean Lange - Friday, June 2, 2017 1:44 PMbmg002 - Friday, June 2, 2017 1:27 PMWe get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.That was more than half my life ago. Long story but I happened into a situation that allowed me to live there free for a year. I was young and figured it might be the only chance I would get for such an adventure so I took it. I was actually working as a screen printer during that time so I was working inside in shorts and a tshirt. It was always a challenge to convince myself to put on a coat to take out the trash. I was also quite young at that point so the cold didn't affect me quite as much as it would today.
living for free sounds really nice! I know that feeling though... I always look out the window before taking my trash out as it can be sunny one mintue then raining the next... or actually both at the same time (it is doing that now :/).
So if it is raining/snowing, I tend to stay indoors as much as possible. I've also been here my whole life so I'd expect that I'd be more used to the cold by now, but I still complain about it a lot more than I should. If I am not willing to move, I shouldn't really complain. But I have a pretty good job, so it is hard to justify moving (unless somebody was to offer me more money).
You see sun one minute and rain the next? You see it raining while the sun is shining? Are you sure you aren't in Michigan?
June 5, 2017 at 1:47 am
Sean Lange - Friday, June 2, 2017 1:44 PMbmg002 - Friday, June 2, 2017 1:27 PMWe get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.That was more than half my life ago. Long story but I happened into a situation that allowed me to live there free for a year. I was young and figured it might be the only chance I would get for such an adventure so I took it. I was actually working as a screen printer during that time so I was working inside in shorts and a tshirt. It was always a challenge to convince myself to put on a coat to take out the trash. I was also quite young at that point so the cold didn't affect me quite as much as it would today.
Chef, SQL Server guru, screen printer - when did you find the time to fit in that year pole-dancing in Thailand you mentioned? 😉
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
June 5, 2017 at 2:08 am
Ed Wagner - Friday, June 2, 2017 7:06 PMbmg002 - Friday, June 2, 2017 2:58 PMSean Lange - Friday, June 2, 2017 1:44 PMbmg002 - Friday, June 2, 2017 1:27 PMWe get a few days per year that are in that range. I am quite lucky to have a remote start and heated seats in my car :). But when it gets to -50C, my car is very unhappy about starting even after having the block heater plugged in all night.
I can't imagine wearing a suit in that weather... Thankfully where I work, I can dress "business casual". And I hide in my own little corner with headphones on working and sipping on a nice glass of tea on those cold days... or if I can't make it into work, I do have VPN access so I can work from home if need be.That was more than half my life ago. Long story but I happened into a situation that allowed me to live there free for a year. I was young and figured it might be the only chance I would get for such an adventure so I took it. I was actually working as a screen printer during that time so I was working inside in shorts and a tshirt. It was always a challenge to convince myself to put on a coat to take out the trash. I was also quite young at that point so the cold didn't affect me quite as much as it would today.
living for free sounds really nice! I know that feeling though... I always look out the window before taking my trash out as it can be sunny one mintue then raining the next... or actually both at the same time (it is doing that now :/).
So if it is raining/snowing, I tend to stay indoors as much as possible. I've also been here my whole life so I'd expect that I'd be more used to the cold by now, but I still complain about it a lot more than I should. If I am not willing to move, I shouldn't really complain. But I have a pretty good job, so it is hard to justify moving (unless somebody was to offer me more money).You see sun one minute and rain the next? You see it raining while the sun is shining? Are you sure you aren't in Michigan?
I've just come back from five great days' camping in the Highlands of Scotland. When we were putting the tent up, the rain was blowing so hard in to my back I could feel the individual drops but I needed sunglasses it was so bright in front of me. I got sunburned on Wednesday then saw lying snow (and Ospreys close up) on Thursday. There was no internet and only patchy mobile signal, bliss.
We didn't get any of the local lamb, it disagrees with Mrs B, but brought home a cracking venison fillet and some beef short ribs nearly four inches thick.
Eirikur, those pizzas look good. I didn't get chance to get the smoker out last weekend, the weather forecast beat me. It'll be out soon for those short ribs with any luck though.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 15 posts - 58,816 through 58,830 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply