Seattle for Summit 5×5: No. 4

For the penultimate installment of this little series, I’m going to share locations that are excellent places to meet other SQL nerds/DBAs/what-have-you for this week in Seattle. The list contains a mix of locations at the conference in addition to “outside” venues where SQL Server nerds tend to congregate after hours.

Speaker Idol
For a few years now, there has been Speaker Idol at the PASS Summit. Speaker Idol is a contest for–wait for it–speakers, competing to win the first speaking slot of the next year’s PASS summit. Comprising 12 contestants delivering 5-minute lightning talks, the contest goes down in three preliminary rounds plus a final, culminating in the winner being crowned by the panel of judges, awarded a guaranteed speaking slot in next year’s Summit, able to speak on whatever topic they choose.

Tap House

1506 Sixth Ave
On Sixth Ave, half a block north of the Sheraton, just south of the convention center, is the Tap House Grill. Likely due to its convenient location, and SURELY not due to the 160 beers on tap, this is a favorite hangout of anyone at PASS Summit anytime during operating hours. It’s downstairs, it tends to be unfortunately hot, the food tends to be decent-to-good, and someone is always there; can’t go wrong.

Community Zone

On the bridge over 6th Ave
Most importantly, PASS Summit is a community event. There’s no better place to connect with that community than the Community Zone. This is an open area on the walkway that spans between the Washington State Convention Center and The Convention Center to the north, where you can find community leaders, peers, and bean bag chairs. It’s a good place to meet and chat with fellow community members during the day, along with a decent place to just sit down and relax for a bit.

CAT lab

I assume still across from the main Vendor Hall entrance, but I haven’t been paying attention.
The Customer Advisory Team are some of the most talented support employees working for Microsoft. If you are at Summit and have any problems at all with SQL Server, these are the folks to ask. Open/Available most of the days, stop by and talk to someone in a light green shirt (OK, their shirts may be a different color this year); they’ll for-sure be able to help you. Also, towards the end of the day, you can even pick up a beer or a glass of wine at CAT Happy Hour!

SQL Karaoke/DCAC/SIOS/SentryOne

Tuesday Night
Also for a few years now, on Tuesday evening, there has been a party thrown by us and SIOS. This year, SentryOne joins the party, as it were. This is primarily a karaoke party with a live band, to boot! I don’t really sing, so don’t count on that, but this is a great place to hang out with SQL folks for entirely too far into Wednesday morning. The open bar tickets are sold out, but you can still come by! Hit the Eventbrite link there to pick up a free ticket, and come by and say hi!

Seattle for Summit 5×5: No. 3

Couple of boats in the Ballard Locks in 2011

In the last post of this series, I talked about things to see/do in Seattle that are close to downtown and/or otherwise fit into the usual conference intraweek schedule. Today, I’ll hit five things that likely will require an extra day (or two) in your trip. It may be too late for extra days this year, seeing as we’re two weeks out, but maybe you can work one of these into your next trip to SEA.

Hiram M. Chittenden (“Ballard”) Locks
3015 NW 54th Street, Ballard, WA
OK, this one may be a little goofy, I know. North of downtown Nashville, there are a set of locks built between Puget Sound and Salmon Bay, which is connected to Lake Union, and eventually Lake Washington (Lake Washington is the big body of water between Seattle and Redmond/Bellevue). These are part of a full canal connecting the sound with the lake built 100 years ago to aid/assist shipping between the bodies of water. They’re still used today, and even during the time of year when Summit is going on, there can be a fairly steady stream of traffic. For someone from boring landlocked flyover country, this is a fun thing to watch.

There is also a fish ladder, primarily serving migratory salmon heading back upstream into fresh water as part of the complex. There’s a viewing area as part of that, where you can watch the fish swim upstream. The salmon are usually done swimming by the time of year that Summit is going on, though.

The city of Woodinville is located northeast of Seattle, across Lake Washington and outside of the 405 bypass. The main point of going to Woodinville (at last for us) is for wine and the occasional distillery. There are a lot of tasting rooms and the like in town, and it’s possible to drive (Lyft, whatever) out there and walk to a bunch of places in one morning/afternoon/etc. There are a few “districts” with clumps of tasting rooms/wineries that make this easy. There are also scheduled events that go on, if scheduling works out while you’re in town.

The Museum of Flight
 9404 E Marginal Way S
Located on-field at Boeing Field/King County International Airport (KBFI) (You know that other airport you drive by between SEATAC and downtown? There.), this is the largest aerospace museum in the world. It is home to a nearly-endless stream of aircraft, related artifacts, and other air-and-space exhibits. There’s something here for anyone with even a passing interest in aviation and possibly even those who don’t–although those folks will probably be more interested in walking around the Aviation Pavilion, the outdoor static display of large aircraft that’s part of the museum, where there are a good chunk of airliners–old, new, fast, and slow.

Boeing Factory Tours
8415 Paine Field Blvd, Mukilteo, WA
The Boeing Factory at Snohomish County Airport/Paine Field (KPAE) has the fun distinction of being the largest airport in the world by volume. Boeing lets us go on tours of their production lines here, which includes 777s, 787s, and the Queen of the Skies. There’s also the Future of Aviation center here, which is another museum-type apparatus.

Also on-field at KPAE is Paul Allen’s (yes, that Paul Allen) private collection of 1930s and ’40s aircraft/aviation equipment and WWII hardware.

Grand Coulee Dam (Brace yourself for 1996)
WA-155, Coulee Dam, WA (this is literally the best I can do for an address)
This is where things get super-nerdy. See, my wife and I have a little bit of a thing about dams, so we make strange trips to, well, see dams. There happens to be a giant one–it’s almost a mile long–about four hours east of Seattle! We’ve still never actually made it out to this, because it’s probably a two-day thing due to the length of the drive. One of these years.

How can I get old SQL Server CUs?

When one maintains SQL Servers/Instances for a living, one of the things we do on a semi-regular basis (or at least should) is install major updates to said instances. But, because usually we aren’t in a position to mash the latest and greatest one out to everything we support, where to find the specific update we’re looking for isn’t immediately obvious. This is because on all of the existing–say–Cumulative Updates pages, all of the download links to a generic “latest CU” page, where that’s all you can get.

But what if I need an older one?

Behold! Via the Microsoft Update Catalog, all updates that have been released for SQL Server, [almost] ever:

From this site, you’ll be able to find what you’re looking for and pull it down. Easy peasy. Use the search box at the top to get a little more focused, keeping in mind that “Service Pack” and “Cumulative Update” are spelled out. If you’re looking for a specific update, it’s probably best to use the KB number to search for it (“KB4024305” for SQL 2016 SP1 CU4, for example).

The main page of the site is pretty awesome in a 1997 sort of way (it even looks like it’s from 1997). When you go to, basically all you get is a little welcome message, some feedback and a FAQ link, and a search box. That’s it. It’s great.

This isn’t just for SQL Server, either. Theoretically all updates for all mostly-recent MS products are available–for example, Windows XP SP3 is available for download, were you to need that. If you do, we need to have a talk. It also looks like you can’t get SQL 2000 SPs anymore, but all of SQL Server 2005’s are.

Anyway, this is a good Site/URL to keep handy, especially for times like when you’re just about to download SQL 2016 SP1 CU4, and “ah crap, CU5 just got released an hour ago and all of the download links changed.”

Seattle for Summit 5×5: No. 2

This was on the waiter’s station at Bush Garden in 2011

For installment #2 of this brief series on visiting Seattle for PASS Summit, we have a semi-touristy-flavored list of things to do/places to go. These are items that can (or should) be worked into your “normal” conference schedule, without needing to have extra time in town, a car, or such. This list doesn’t include the Pike Place Market, because that’s kind of a gimme, and you’re probably going to do that, anyway. These are other items that are either unofficial parts of the Summit experience itself, or other places that we like to visit for various reasons.

Things to Do: Semi-Touristy

Bush Garden
614 Maynard Ave S
You’ve heard of “SQL Karaoke”, right? Up to, and including the party that we (DCAC) have thrown on Tuesday evening for a few years now. But before there was that, there was Bush Garden.

Bush Garden, you see, is this little place that’s cheap Asian food place by day, karaoke bar by night. I’m not sure who found it first, but it has been a near-nightly place to go during Summit for good number of years now. There’s been Jägermeister incidents, bad singing, good singing, my wife doing dishes one time, and then there’s the green couch.

This will be the second year that “the building has been closed, so Bush Garden could go away at any moment” rumors have been present, so as long as they’re still open now–which I believe they are–you gotta go at least one night this year, because this may be it.

World Spice Merchants
1509 Western Ave
Tucked behind the Pike Place Market towards the sound, this is a favorite place of us to visit. World Spice Merchants is exactly what it sounds like–a place to buy spices. Also having teas, the walls of this place are lined with little glass jars with raw/bulk spices in them that you peruse, taking notes on what you want and how much of it on waiter pads. At the end, you hand your list over to the staff, and they pack everything up for you. Take it with you, or they will ship it home for you. They’ve got lots of stuff that may be otherwise hard to find (especially for us), so if you’re into cooking, don’t skip making a trip down here.

Wines of Washington Tasting Room
1924 Post Alley
If you’re into wine, you know how good PacNW cabs can be, and this is an excellent place to experience them. Set up almost like your friends’ living/dining/family room, with small tables and board games on shelves on the wall, this can be a fun place for either hardcore wine tasting (we ran them out of glassware one afternoon) or a cool place to just chill with friends in the evening. You can of course buy bottles here to take [home] with you, and they also have a club.

13 Coins (at 3 AM)
125 Boren Ave
So, you see… There aren’t many places open really late in Seattle. Except for 13 Coins. They’re open 24 hours, so no matter what you’re doing (or when), you can count on being able to stop by here for some good eats. Up super-early because your body’s still on Eastern time and it’s 7:00 AM where you “are”? You closed down Bush Garden and now you’re hungry? Here ya go. They have big booths, good food, and can be quite accommodating when a dozen people show up together in the middle of the night for, uh “breakfast.”

Clay’s Market (“The bodega at the convention center”)

815 Pike St
Outside the convention center (but in the building), up the street a little bit from the Crepe place and the Subway, kinda hidden underneath is Clay’s Market. This is a handy (although admittedly a little seedy) very handily-located place to buy the kinds of things you would buy at, well, a bodega. Due to its proximity to the convention center, expect prices to be higher than you may otherwise like.

There’s also another, larger place a few blocks further up Pike that has more items and more reasonable prices. If you don’t mind the walk there or need to buy ten little bottles of orange juice, that may be a better stop.

City Target

1401 2nd Ave
Bonus item!
My wife and I are from rural Indiana, and we still live a little bit out in the country, doing our shopping/such in the classic suburban situation, where there’s more parking lot than there is store. Therefore, when we first went walking around downtown Seattle, we were enamored with the “City Target”, a small-in-area-but-three-levels-high Target store right in the middle of the city. Individual bananas for 25 cents, shopping cart escalators, and a smaller selection of everything you’d expect from a Target. Usually full of locals doing their normal shopping, this can also be an excellent place to pick up some food if you’re tired of eating out at restaurants all the time and have a way to cook it, if you don’t mind the walk down towards the waterfront.

Seattle for Summit 5×5: No. 1

Seattle Coffee Works sign

via max137; Creative Commons

It’s now October (OK, over a week in), and that means for a lot of us SQL Server folks, we have the PASS Summit in Seattle to look forward to at the end of the month. Yes, fine, it tends to fall in November more often.

ANYWAY, a lot of us have gone there for a lot of years, and so we’ve seen a good chunk of downtown and know some good places to eat/such and things to do. So, although Denny’s already done his annual “Summit Firsttimers” webcast, I’m adding some more places/things for newbies and veterans alike. I’ve got five lists of five things coming up over the coming weeks to help you find some good coffee, fun things to do, and where to find all of us crazy people who tend to stay up too late most nights.

Coffee & Quick Bites

There’s a lot of good coffee and good food in Seattle, a lot of which is close to the convention center or otherwise within walking distance. This list of five places–in no particular order–are some of my favorite places to fuel up during the long week of partying learning.

Victrola Coffee Roasters
310 E Pike St
I tend to forget the actual name of this place, so will refer to it as “telegraph” or similar old technology thing when I can’t get it together. This place is up on Capitol Hill up Pike St from the Convention Center and is home to some of the best coffee in town. It’s one of Joey’s favorite places to go, although it is a bit of a hike to get there, plus it can be a total house in the mornings. It’s still worth it, as the coffee truly is great.

Seattle Coffee Works
107 Pike St.
In the opposite direction, down towards the Sound and the market and also on Pike Street is Seattle Coffee Works. As drinking coffee from the same place all week may not be what you’re looking for (also, you’re in Seattle, spread the love), this is another great option.

Cafe Campagne
1600 Post Alley
Do you like Croques Madame? Do you know what a Croque Madame is? If you answered yes to these–or you just looked up what it was and decided you can’t live without one now (good choice)–there’s this awesome little French restaurant/café in Post Alley in the Pike Place Market. Croques, real baguettes, the menu’s mostly/all in French, so yeah. If you’re into this sort of thing, it’s a nice Saturday or Sunday morning before you head out of town stop, but get there early, because this place gets pretty busy pretty fast in the mornings.

La Creperie Voila
It’s in the Convention Center. On the street. Next to the Subway. No, the other Subway.
This is handy for grabbing breakfast on the way in or a mid-afternoon snack. Pretty cheap, pretty good, and location, location, location.

Starbucks Reserve Roastery & Tasting Room
1124 Pike St
Yes, not everyone likes Starbucks, I know. But, a few years ago, Starbucks built this enormous coffee roastery, tasting room, and general temple to the coffee bean. It’s a neat place to go to due to the elaborate coffee conveyor belts that populate the place to feed the roasters. They’ve got some good single-source coffees here and other stuff that you can’t get in regular Sbux stores, and unique mugs & such.