A while back, I wrote about installing SQL Server 2016 on my laptop. Since then, Microsoft has released SQL Server 2019. Additionally, I bought a new laptop last November; my tired old HP 4430s had served me well for several years, but it was showing its age, so I decided it was time to upgrade. Since we have updated versions of SQL Server, and I have a (still relatively) new laptop on which to install it, not to mention that I have some time with this COVID-19 isolation, I figured this would be a good time to install SQL Server 2019 on my new laptop.
Before we begin, let me start with my laptop specs. I make no claims that these are the recommended specs for SQL Server, but this is what I have.
HP Pavilion x360 Convertible 14m-dh1xxx
Intel Core i5-10210U @ 160 GHz
8 GB RAM
Windows 10 Home Edition (it’s what came installed)
129GB available disk space
I started by going to the SQL Server downloads page and downloaded the freeware version of SQL Server 2019 Developer. There are a number of versions on this page, including (among other things) a trial version of SQL Server 2019 on-premises and SQL Server 2019 on Azure (and, of course, the Express version of SQL Server). For my rather modest needs, which includes practicing SQL Server skills, writing about it from time to time, and having some fun with it, Developer version should suit my needs.
The link downloaded SQL2019-SSEI-Dev.exe to my machine. I ran the file and was greeted by a screen asking for the installation type.
I decided to use the Custom option. The lazy body in me thought about running the Basic installation type, but since I’m documenting this installation, I figured it would defeat part of the purpose.
The next screen asked where to download the media. By default, it goes to C:\SQL2019. Since most everything I download goes to my Downloads folder, I decided to switch it there. I set it to download to a SQL2019 folder within my Downloads folder. It also indicated that I would need 8.9GB free space, with a download size of 1.4GB. My new laptop doesn’t have the disk size that my old one did, but I still have plenty available, so it shouldn’t be a problem. (One thing I should note: my new laptop uses a SSD, as opposed to the traditional storage disk on my old machine.)
I clicked Install, and the install package started to download.
Once the Installer finished downloading, the SQL Server Installation Center appeared.
I ran the System Configuration Checker, and it came up cleanly. I decided to proceed with installation. I clicked the Installation tab and selected New SQL Server stand-alone installation or add features to an existing installation.
On the Product Key page, I selected Developer under free edition. The next few screens were straightforward — the only warning I saw was for my firewall — until it got to the Feature Selection screen. I went ahead and selected all features, which would take up 14GB of disk space. If you’re installing SQL Server on your own machine, you’ll need to decide what features you want to install at this point.
I went with the default instance for the instance configuration.
I selected standalone PolyBase-enabled instance. I’m using this on a standalone configuration, after all.
Since I don’t have Java installed on my machine, I used the Open JRE included with the installation. If you have Java on your machine, you’ll need to determine what instance of Java you want to use.
Under Server Configuration, I used the default service accounts. There’s a note that reads: “Microsoft recommends that you use a separate account for each SQL Server service.” I am not sure about the implications of using the default service accounts; this would be a question for someone who knows more about SQL Server than I do.
Under the Database Engine Configuration, I went with Windows authentication mode. If I was installing this under any configuration other than my own machine and login, I would not go with this option; I would use Mixed Mode and specify a SQL user account. I added myself (clicking Add Current User) as the administrator for this account. Again, this is not something I, personally, would recommend for a large-scale installation, but since I’m the only one who’ll be using this instance, and I have no intention of using this for anything other than demo, practice, and documentation purposes, I went ahead and used Windows Authentication.
I pretty much went with the defaults for the rest of the installation. I did need to consent to install R and Python. I got to the Ready to Install screen, clicked Install, and let it do its thing.
Installation was straightforward and painless. In years and installations past, I’d be writing about the errors that came up and the number of times I’d have to click or press Enter to continue with the installation, but there were no such prompts. I let it go and went off to do other things. I’m not sure how long it took — I’ll guess around twenty minutes, although it seemed longer — but when I looked again, SQL Server was installed on my laptop.
That was as far as I got for this installation. I still need to tinker with post-installation configurations, including SSMS, SSIS, and any tools that I need to actually do something with SQL Server. That’ll likely come later when I have a chance to tinker some more.
The weekend began with the speaker’s dinner. While I had a great time hanging out with all my wonderful SQL friends, we also had a compelling conversation — enough that I wrote about it that night. It reaffirmed just how important professional development is within technical circles, and the importance of my endeavor of presenting professional development topics. Even Matt Cushing sent a tweet mentioning just how important professional development is. It made me feel pretty good knowing just how much I’m contributing to the technical community.
Of course, after dinner, Paresh and I just had to go for ice cream. On this occasion, we hit a Coldstone Creamery around the corner from the speaker’s dinner. For those of you who don’t follow me regularly, it has become tradition for Paresh and me (and anyone who joins us) to go out for ice cream at any SQL Saturday that we both attend. Paresh even started using a Twitter hashtag for it: #SQLIceCream!
There was a lot of talk about the weather leading up to the event. The National Weather Service had predicted heavy lake-effect snow (as much as two feet) leading up to the event. Rochester sits right on the bank of Lake Ontario, and as anyone who lives in upstate New York knows, is prone to lake-effect snow. The weather forecast even prompted the University of Maryland to reschedule a women’s lacrosse game against Syracuse. As it turned out, the talk about bad weather turned out to be exactly that: talk. When I drove out to Rochester on Friday, the amount of snowfall was negligible, and the Thruway was clear sailing all the way from Albany to Rochester. There was a light dusting of snow on the ground when I woke up the next morning, but that was about it. Despite all the hype about the weather, it turned out not to be a factor.
I arrived at RIT a little later than I would’ve liked. Ordinarily, I like to settle into the speaker’s room, maybe get myself some coffee, talk to some people, and relax a bit. But by the time I arrived, sessions were about to start. I barely had enough time to drop my stuff off in the speaker’s room before getting to the first round of sessions.
Of course, the first session I attended was Matt’s. I’ve pretty much attended his session each time I’ve had the chance. For a while, I had attended it every time he presented it, but that streak was broken when he started traveling to other places (such as Austin, TX) that were difficult for me to get to. Last year, Matt (along with another friend, Deborah Melkin) were named IDERA Aces. I won’t get too much into the IDERA Ace program (use the link for more info), but one of the benefits is funding that allows you to travel to speak at events like SQL Saturday. (Congrats, by the way, Matt and Deb!) Matt is encouraging me to sign up for the IDERA Ace program for this year. When applications start coming out later this year, I will definitely look into it!
Speaking of Deborah Melkin, her session was up next in the room next door. I’ve seen her session before, and she does a great job with it. I have to confess, however, that I wasn’t paying all that close attention (sorry, Deb!). The reason: my lightning talk session was up next, and I was going through my slides, making sure everything was ready to go. Last November, I had purchased a new laptop (an HP Pavilion x360), and this was my first time using it for a SQL Saturday presentation. I checked my slides, I tested my presentation clicker, and made sure everything was ready to go.
The next round included my lightning talk. I was scheduled to do my talk, along with two friends: Taiob Ali and Kimberly St. Jacques. The last time I saw Kimberly was at PASS Summit, which wasn’t a good time for her. She had been scheduled to present a lightning talk at Summit, but was unable to do so because she had lost her voice. I’d felt really bad for her! I was glad to see that she had regained her voice and was able to present again!
Going on at the same time was a presentation by Tracy Boggiano, who talked about mental illness in tech. It sounded like a really interesting talk, and I desperately wanted to attend, but it conflicted with my lightning talk session. I told Tracy that I intend to attend her session the next opportunity that I had.
Lunch was the next order of the day. It was either Andy or Matt Slocum — I don’t remember whom — who had a good relationship with a BBQ restaurateur. This same person has catered Rochester SQL Saturday every time I’ve attended, and the food was excellent every time. I highly recommend the pulled pork!
I decided to take the next round of sessions off. As much as I love attending SQL Saturday, one thing that never fails is that it tires me out. After lunch, I felt like I was going to fall asleep, so I retreated back to the speaker’s room to relax. I pretty much just surfed the web and conversed with other speakers in the room.
The last time slot of the day came about, and it was time for me to do my own full-length presentation. I actually had a pretty good-sized audience: I’ll guess around fifteen to twenty people. Even though it was the last session of the day, and everyone (including me) was tired, I made it a point to keep my audience engaged. They seemed to be into my talk, and I like to think that I presented well.
I did attend the after-event party. I enjoy hanging out with these people (they’re called #SQLFamily for a reason), and any chance I get to spend time with them is welcome. I had a long drive home ahead of me; I left the party around 7:45, and pulled into my driveway around 11:30.
All in all, it was yet another awesome SQL Saturday! (Of course, I think they’re all awesome!)
My next scheduled event is SQL Saturday Chicago on March 21, only a few weeks away! This will only be my second time in Chicago (changing planes at O’Hare doesn’t count), and it’ll be my first SQL Saturday where it is not feasible for me to drive. It should make for an interesting trip. See you there!
A week ago last Saturday, just before noontime, I returned home to Albany after departing Seattle the night before, and traveling across the country on a redeye flight. To say I was tired was an understatement; indeed, after my wife picked me up at the airport and brought me home, I went straight upstairs to the bedroom and just slept all day. Even a day after I arrived home, I was still not completely recovered from my trip. I spent a couple of hours going through almost 300 emails and getting caught up in general. It took me a while to get caught up, if I ever got there at all.
I had every intention of live-blogging my PASS Summit trip, but it didn’t happen. I had wanted to ‘blog about my experience each day of the trip. As it turned out, I never even touched my laptop. I ended up not needing it at all (and that includes for my presentation, which I’ll talk about below). On top of that, I was so busy during the week that I never had the chance to sit down and ‘blog like I wanted to. Instead, I’ll write about my trip exploits in one article. Warning: I expect that this will end up being a long article, so bear with me!
Day 1: Tuesday, Nov. 5
My alarm woke me up at 3:30 am Eastern time (time zones are important to note in this writeup) so that I could catch a 5:30 flight to Baltimore. Upon arriving in Baltimore, I found myself an in-airport diner where I had myself breakfast, then proceeded to the gate to wait for my flight to Seattle. I had a four hour layover in Baltimore, so I had plenty of time to kill!
While waiting at the gate, I bumped into my first #SQLFamily for the trip. Andy Leonard ended up being on the same flight! We had a nice conversation, and when the time came to board, Andy said he would save me a seat. Sure enough, I found him at the back of the plane, and he had indeed saved me a spot. I took the aisle seat; I figured that six hours was a long time to spend inside an airplane, and I might want to get up and walk around a bit.
The middle seat ended up being taken by another PASS Summit attendee: Mike, from Akron, OH (last name withheld for privacy reasons). The three of us had a wonderful conversation as we flew to Seattle.
Our flight arrived a little after 2 pm Pacific time. It would have arrived even earlier, except the Southwest pilot executed a go-around on our landing attempt. I think he mentioned something about being too close to the flight ahead of us (wake turbulence is not a fun thing, especially on a landing). It was my first experience with an aborted landing, so it was interesting to feel the jets power up and see the flaps retract on our initial landing attempt. The second attempt was more successful.
I had planned all along to not rent a car and make use of public transportation for this trip, so I made my way to the light rail and rode to the Columbia City stop, where I checked into my AirBnB. After taking a few minutes to introduce myself to my host and drop off my bags, I reboarded the light rail and made my way to Westlake Station in downtown Seattle, only a few blocks from the convention center.
Of course, getting off a transit line in any city can be disorienting, even more so in a city with which you’re not completely familiar. I exited Westlake Station at the opposite end (as I would find out later) from where I should have exited. It took me several minutes (and Google Maps on my phone) before I finally figured out which way I was going. After walking a few blocks longer than I should have, I finally found the convention center.
I made my way upstairs, and ran into another friend: Andy Levy. Having just arrived at the convention center for the first time, Andy took me over to the registration area, where I picked up my badge and started getting myself situated. I also picked up a couple of items that came with my association as a PASS Summit speaker: a hoodie jacket and a polo shirt.
As I walked around the facility, I was stopped by a few different people. I wrote before about how your clothing can be a conversation piece. I made it a point to wear my fraternity hat, as I promised I would. Two people identified themselves to me as members of my fraternity. Another told me that he was from Syracuse (the city, not the university). More examples of clothing as networking in action!
Andy said to me that one of the things about PASS Summit was that “it takes you fifteen minutes to walk fifty feet.” If you’re involved with SQL Saturday (like I am), PASS Summit is, essentially, a great big reunion. Even within my first hour at the conference, I’d already bumped into several people whom I knew. Andy’s words were true; within a short time, I already came across a number of friends I knew from my SQL Saturday involvement!
My first event was the first-timer’s event. That was an interesting experience; it was a large room, and the seats were arranged in groups of six. We were all encouraged to interact with each other and introduce ourselves. We were treated to a few talks from some PASS volunteers, including, among others, my friend, Matt Cushing, who gave a shortened version of his Networking 101 talk. (I just can’t get away from your talk, can I, Matt! 🙂 ) There was even a trivia quiz that matched up our groups of six as teams. The winning team received tickets to one of the game nights. Alas, we didn’t win. Oh well.
The second event of the evening was the welcome reception. After PASS president Grant Fritchey kicked off the reception, it was essentially one great big party! There were multiple drink stations and tables of food, and large crowds of people everywhere. The event was overwhelming — and I say this in a good way! I thoroughly enjoyed myself! I reconnected with a number of friends of mine from the SQL Saturday speaking circuit, and met a number of new ones as well!
One of the new people I met was Anthony, my designated SQL buddy. The idea of the SQL buddy program is for first-time PASS Summit attendees to have a “buddy” with whom they can connect so they’re not overwhelmed by the large crowds of strangers attending. I think it’s a great program, but I have to admit that it probably wasn’t completely applicable for me, because, even despite that this was my first PASS Summit, I wasn’t a stranger, either, since I knew dozens of people attending the event. As it turned out, the few minutes I spent with Anthony was my only contact with him during the week. I had wanted to talk to him even more during the week, but I lost him at the welcome reception, and didn’t reconnect with him again. (I am going to make it a point to drop him a line later!)
I left the event to attend another one, a volunteer party for PASS Summit volunteers. This event was invitation-only; only Summit volunteers were allowed to attend. I’m not sure whether it was my association as a PASS speaker or my willingness to help with the event, but in any case, I did receive an invitation to attend the party. It was held in a bar called SPIN, a ping-pong-themed bar. The venue was pretty cool; I wish we had one of these back home! (Their website says there’s a couple of locations in New York City, which are probably the closest ones to me.) I conversed with a number of people, and had a great time!
I would’ve enjoyed it even more, but by this time, the fact that I had been awake twenty hours was catching up with me. I decided to call it a night and head back to my AirBnB. If the rest of the week was going to be anything like this first day, I was going to be in for a long and tiring, but exciting, week!
Day 2: Wednesday, Nov. 6
My alarm went off around 5:30 — granted, that’s 5:30 Pacific time, and my body was still living on the East Coast, so it wasn’t that much of a problem. I showered, dressed, and caught the light rail to the convention center.
The first order of business was breakfast. I had signed up for a vendor breakfast, and went straight to the conference room. I filled up on my share of breakfast sandwiches, juice, and coffee. I’ll be the first to admit that I signed up primarily for the breakfast, not for the vendor talk. That said, vendor sessions are an integral part of just about any conference; as sponsors, their input and support are invaluable.
I decided to skip the keynote and took the time to explore the convention center. With everything that was going on, I figured it would be my best chance to get some downtime. I located my room where I would be speaking on Friday and got myself a sense of what was where.
At 10:15, I attended the session titled “Becoming a Technical Leader,” presented by Denise McInerney and Kellyn Pot’Vin-Gorman. I had previously crossed paths with Kellyn at Boston BI SQL Saturday (and likely some others — I’d seen her name before), but as far as I knew, I’d never met Denise (at least not that I remembered). They emphasized communication throughout their session, a topic close to my heart. Overall, it was an excellent presentation.
I had a variety of reasons for choosing sessions to attend. One of the big ones was to advance my own career. I will likely not be doing what I’m currently doing forever, so I wanted to attend sessions that I could use to improve my own professional standing.
With that in mind, I also attended a session called “Build Your Brand with Technical Writing,” presented by my friend, Kathi Kellenberger. She focused on tips and advice for getting published. I’ve had a couple of articles published before (my article on the history of major-league baseball in Troy comes to mind), but writing a book is a bucket list item of mine. I picked up some good pointers from her presentation. I did speak with Kathi, and she suggested that she might have some opportunities for me to write! I might just take her up on it!
For the last session, I decided to take in round 1 of Speaker Idol. For those not familiar with Speaker Idol, it’s an opportunity for people to give a quick presentation — within a span of five minutes. The presentation is judged by a panel, and the winner moves on to the final round. The grand prize is a guaranteed speaker’s slot in next year’s PASS Summit!
Last year’s winner was Rob Volk, who did a presentation of being “the very model of a SQL Server DBA.” (Imagine him singing to the tune of “I Am The Very Model Of A Modern Major-General,” and you’ll get the idea.) Click the link and check out his winning presentation. Trust me on this!
There were a number of vendor-sponsored events that evening, but I hadn’t registered for them. I ended up having drinks in a hotel bar with another friend from my SQL Saturday travels, Slava Murygin. We spent a few hours chatting and having drinks before deciding to call it a night.
Two great days down!
Day 3: Thursday, Nov. 7
Another day, another vendor breakfast. The spread was a little more substantial this time: scrambled eggs, bacon, sausage, pastries, and so on. If you’re interested in having a fulfilling breakfast at PASS Summit, I definitely recommend signing up for vendor-sponsored breakfasts! And it also helps if the vendor is doing a talk that interests you!
I started my day of sessions by attending “Making the Leap to Management” by Chris Yates and Adam Jorgensen. Honestly, I’m on the fence as to how interested I am in pursuing a career that involves management. Nevertheless, it is a possibility as I advance further in my career, and a sense of what I could potentially get into is never a bad thing. I did find it interesting that good communication was a common thread throughout the session. I’ve always been a big believer that the vast majority of the world’s problems can be solved by improving communication, and this session seemed to validate that belief.
I attended “Successfully Communicating with Your Customers” after lunch. Denise McInerney gave this talk, and I saw a lot of similarities between her presentation and what I do with some of mine — enough to the point that I told her, after she was finished: “you could do my presentation.” I sent her a LinkedIn connect request and asked if we could stay in touch so we could compare notes.
Right after the presentation, the vendors did their prize drawings. If you’ve ever attended a SQL Saturday, it’s the same concept as the vendor prize drawings at the end of the day (the only difference was that they held it in the middle of the conference): you submit your ticket, and maybe your name is drawn for a prize. You need to be present to win. No, I didn’t win anything on this day. C’est la vie.
I attended another sponsor reception that evening at The Tap House Grill. It was billed as “a chance to meet and network with people outside of the conference.” Among others, I met Janice Gerbrandt, who, along with my friend, Paresh Motiwala (who did not attend Summit this year), lead the PASS Professional Development virtual group. I had previously been acquainted with Janice when I did my virtual presentation on networking back in May; now, I finally met her in person for the first time. During the week, I met a number of people whom I’ve only gotten to know through emails and online correspondence, including most of the staff at PASS.
I also bumped into my friend, George Walters. He was not attending Summit, but he was in town for work-related reasons, and decided to crash the party. It was nevertheless good to see yet another familiar face in a somewhat-strange town!
Unfortunately, I couldn’t stay out too late. Since I was presenting the next day — not to mention leaving town — I had to go back to my AirBnB and pack my things, as well as get some rest so I could do my presentation the next morning!
Day 4: Friday, Nov. 8
At last, it was my day to speak! My presentation was scheduled for the first time slot of the day, at 8 am.
I checked out of my AirBnB before 6 am and made my way, with my luggage, to the convention center. For the last day of the conference, PASS had a baggage check set up, and I made use of it. I checked my bags and went off to find myself breakfast.
Unlike the previous two days, there was no vendor breakfast that morning, so I had breakfast at a hotel restaurant right across the street. Up to that point, nearly every meal I’d had was provided by some PASS or vendor event, so this breakfast was the first meal since I’d arrived in Seattle that I paid out of my own pocket. After finishing breakfast, I went up to my conference room to prepare for my presentation.
As I mentioned earlier, I did not touch my laptop at all during this trip, including for my presentation. Each presentation room included a laptop that was already connected to a projector. All I needed was my presentation on a USB stick. I also used my own presentation clicker. (That said, I kept my laptop nearby anyway, in case a problem came up with the equipment that was supplied. Always have a backup plan.)
The presentation went well! It really wasn’t all that different from my experience with doing SQL Saturday presentations. The audience was larger, it was more geographically diverse, and because it was being recorded, I had the use of microphones. I passed it around when attendees had questions; that way, their questions could be captured as part of the session recording. People I spoke to later told me that they enjoyed my session, and I did a good presentation!
And after it was over, I could honestly refer to myself as a PASS Summit speaker! Achievement unlocked!
One disappointment about my presentation was that it conflicted with round 3 of Speaker Idol. It was especially disappointing, because two of my friends were participating in this round: Slava Murygin and Deborah Melkin. While I never got the chance to see Slava present, I would later get to see Deborah!
I hooked up with Andy Levy so we could go to the exhibitor booths. RDX gave out what was widely thought to be the best (and definitely the most popular) vendor swag: Minecraft swords! We had tried to get them the day before, but they had run out. We were told that they would have twenty more at the beginning of the day, and if we wanted one, we would have to be one of the first twenty. Indeed, Andy and I were number one and two in line when the vendor fair opened for the day!
I had volunteered to man a Birds of a Feather lunch table. These special-interest tables allowed people to congregate and discuss a common area of interest during lunch. As someone with writing, UX/UI, and design experience, I ended up moderating the Storytelling & Visualization lunch table.
Since the entire CASSUG (Albany user group) leadership team — myself, Greg Moore, and Ed Pollack — was at PASS Summit, I decided that we needed to take a photo of the three of us. Our local user group was well-represented in Seattle that week!
We took our photo at the PASS Community Zone. I spent a lot of time there during the week. It was a good place to congregate, meet people and network, and relax (there were beanbag chairs around the area). It was also a good place for me to recharge — literally. There were outlets set up around the zone, where I could plug my phone in to let it recharge. I spoke to a number of people and made some new networking contacts there throughout the week.
I did make it to the final round of Speaker Idol. As it turned out, I did not miss Deborah’s presentation, as she was one of the finalists. And wouldn’t you know, she ended up winning the entire thing! She was the Speaker Idol winner for 2019! She now has a guaranteed speaker slot for next year’s PASS Summit in Houston! Congrats, Deb!
By this time, PASS Summit was beginning to wind down. There was still another slot of sessions going on, but I didn’t attend. PASS Summit is an exciting, but tiring, experience. I learned that I needed to be picky about what sessions I attended, because trying to attend them all is impossible. I took some time to get myself organized, making sure that my stuff was together, packed, and ready to bring home. The Minecraft sword I’d obtained earlier in the day wouldn’t fit in my carry-on luggage (and it wouldn’t have surprised me if TSA flagged it while going through security). There was a FedEx office on the ground floor of the convention center, and I took advantage of it, shipping my new toy, along with a few other swag items, home. They’d be sitting on my doorstep later in the week.
At this point, a number of people were making arrangements for final dinners and plans before venturing home. Apparently, there was a tradition for a number of #SQLFamily to get dinner at the Crab Pot at the end of PASS Summit. Greg had invited me to accompany him to a small private party with Rensselaer alumni in west Seattle, which is what I elected to do. Unfortunately, because of issues with ordering dinner, I had to settle for taking a couple of hours to reconnect with some old friends before getting a Lyft to the airport and catching my cross-country redeye flight home.
There’s a number of things I left out of my commentary; most of it is superfluous. Besides, I didn’t want to feel like I was rambling, not to mention that I’ve been sitting on this article for over a week.
PASS Summit was everything I’d been told and I expected: exciting, overwhelming, tiring, and fun! I had an absolute blast during my week in Seattle! I would attend every year if I could. Unfortunately, there are mitigating circumstances that prevent me from attending more often (the biggest being the registration fee; unlike SQL Saturday, PASS Summit is not free to attend. Since I’m doing this on my own dime — my company does not pay me to go — my resource to attend are limited. I was able to attend because I was selected to speak, so my fee was waived). That said, should an opportunity for me to attend ever comes up, I will not hesitate to go again!
I will definitely submit my presentations to speak at PASS Summit again. Hopefully, I’ll be selected again! And hopefully, you’ll be able to experience the same excitement and learning experience that I did at PASS Summit!
I’m getting back into the swing of things after being offline for a week and a half! My first PASS Summit was an absolute blast! I have a ‘blog article in the works about my PASS Summit experience, so stay tuned!
I’m spending time getting caught up on emails and schedules. I walked into my office this morning and discovered that I’ve been assigned a new SQL Server-related project, so I might have some updates coming with that relatively soon.