Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Series

Tags

, ,


Last year, I started writing an article that was supposed to be a series for Installing, Configuring and Managing Windows Server Failover Cluster using Windows PowerShell. The first of the series came out on July 2013 (which ended up being the last article I wrote for the year 2013 on MSSQLTips.com.) Since then, I’ve been involved with more projects on SharePoint and business intelligence (BI) integration that I barely had a chance to work with the SQL Server database engine on a regular basis. But since part 1 of the series is already out there, I figured it’s worth the time and effort to finish it up. So, here it is – the complete series on Installing, Configuring and Managing Windows Server Failover Cluster using Windows PowerShell.

  • Part 1 – from installing the feature to creating the Windows Server Failover Cluster
  • Part 2 – retrieving and changing cluster object properties and adding clustered disks
  • Part 3 – managing permissions, changing parameter values, moving clustered resources and dependencies
  • Part 4 – common cluster troubleshooting tasks

Enjoy!

Two SQL Server Webcasts from MSSQLTips.com

Tags

,


I’ve done two SQL Server webcasts for my friends at MSSQLTips.com. One is regarding security best practices for deploying SQL Server databases in the cloud. As more and more customers are thinking of deploying databases in the cloud, security is one of their main concerns. In the webcast, I talked about principles and concepts on securing databases in the cloud. You can check out the recording from the MSSQLTips.com website.

securityWebcast

 

The second one is about networking best practices for SQL Server high availability and disaster recovery. The premise of the webcast is that SQL Server DBAs are now dependent on the things that they have no control over. Knowing what SQL Server depends on for high availability and disaster recovery enabled SBAs to be better prepared to communicate with the other teams to meet their overall objectives. You can check out the recording from the MSSQLTips.com website.

HADRNetworkingWebcast

Even Spiderman Can Use a Bit of Business Intelligence

Tags

, , , , ,


When I first heard of the Microsoft PowerBI Demo contest, I figured it would be a great opportunity to explore the business intelligence capabilities of Excel 2013. With the preview of Power Maps and Power Query, I thought it would be fun to play around with these features. Besides, I’ve seen some fancy demos at the last PASS Summit.

Being a story teller and presenter, I can’t help but think of a way to showcase these features without having a story around it. So, while having dinner with my family one day, I told my 11-year-old son (who is into creating stop motion videos) if he might be interested in working on a project with me. I told him about the contest and what it’s about. More importantly, I told him about a story that I already have in mind which I was absolutely sure he’ll love: enter Spiderman. The story revolved around the fact that Spiderman needs to pay his tuition soon but he doesn’t have enough money on his savings. He just got fired from The Daily Bugle so there isn’t really much he could do. However, he can go back to delivering pizza around New York City since he’s done it before. But this time, he needs to be strategic and efficient. He needs to identify which boroughs in New York City has the highest mean household income so that he can focus his efforts on that particular area. He also needs to find out which boroughs have the highest number of complaints and crime incidents for the past few weeks. That way he can avoid bumping into situations where he may need to stop what he was doing just to go on a rescue mission. This is where he starts using his wits and gets working on his computer to search for publicly available New York City data. With the insights he came up with  based on the data he gathered, he sets out to pursue his plans until he hits his first roadblock.

I had fun working on this project with my son (he enjoyed it a lot since he was the one who created the Spiderman scenes). I hope you like the video, too. And if I may ask, can you vote for the video by clicking on this link? The final video is embedded below.

And you can try it out for yourself. Download the Power Maps and Power Query preview on the Microsoft Download Center and enable them on your Excel 2013 workbooks. I bet you’ll have fun the way I did.

Database Configuration for Maximum SharePoint Performance (Video, Slide and PowerShell Script)

Tags

, , ,


This post is way overdue. Since I’ve been getting a lot of requests about this specific presentation regarding SharePoint databases, I decided to do two things. First, I recorded this presentation for all my attendees to use as a reference. Now, you might be thinking, “If you’ve already recorded your presentation, wouldn’t that affect attendance in your events?” Yes and No. Yes, because those who have seen the video will no longer attend my presentation. For me, this is a great opportunity to help those individuals to plan ahead and maximize their time while attending events. As IT professionals, we’re busy, stuck in our day-to-day work and don’t even have time to look into some of these best practices that need to be applied in our environment. Often times, we are forced into the let’s-do-things-quick-and-fix-it-later corner because of the constant demand for our time. If the drop in attendance in my presentation/events would mean helping those individuals maximize their time, then, I’m all for that. This also includes those who really wanted to attend my presentations but do not have the means to do so (those in different time zones, different countries, no budget, etc.) And the flip side? No, it wouldn’t affect attendance in my events. Everyone who has seen me deliver a presentation can tell you a thing or two about why they’ve decided to attend my presentations even though they’ve already seen me (or the same presentation) at a previous event. I really work hard to prepare my presentations – the proper use of pictures, colors, fonts, and stories all are done with intent – even if it’s the same presentation delivered at a different event. This is my way of saying, “thank you for taking time off your hectic and tight schedule to attend my presentation.” In addition to that, I wanted them to have a resource that they can use as a reference when they go back to work. I want them to become valuable and continue to grow as an IT professional. After all, that’s my primary mission statement.

So, here it is, a video recording of my most requested topic at SharePoint conferences and events – Database Configuration for Maximum SharePoint 2010/2013 Performance

And, you’ve probably seen the corresponding slide deck.


But this is just the first of the two things I mentioned. Here’s the second one. I’ve written a PowerShell script to check the SQL Server instance that you use for your SharePoint databases. This is the PowerShell script that I use when delivering my presentation on Windows PowerShell for the SharePoint Administrators. It’s also the same PowerShell script that I use when I work with customers who request for my services to review and evaluate their SharePoint databases. The script checks for best practices configuration recommended for SharePoint databases – stuff like MAXDOP =1, disabled autoupdate and autocreate statistics, etc. As SQL Server DBAs, we hate some of these configuration. However, these are all documented and supported. Which means they have to be applied to your SQL Server instances and databases used by SharePoint. In addition, I have also included checks that we SQL Server DBAs consider best practices – separation of MDF and LDF files, regular DBCC CHECKDB execution, backup compression enabled, etc. You can download the PowerShell script from here.

Keep in mind that this is not the best way to write PowerShell scripts. I didn’t apply those best practices here so that would probably be my next personal project.

Feel free to use this script as you wish. It has only been tested on default instances of SQL Server 2008 and higher (named instances have not been considered yet) running on Windows Server 2008 and higher. High availability checks like failover clustering, database mirroring and Availability Groups have not been included yet on this version. Comment on the script for bugs and fixes that you want included, keeping in mind that this is specifically for SharePoint databases. Don’t expect any indexing improvements nor identifying the TOP I/O consumers because there is no way for us to modify those queries without breaking your SharePoint support contract (and I am in no way a lawyer to even argue about the contents of the EULA.)

Enjoy.

Preparing for the PASS Summit 2013 – Part 5

Tags

,


PASS_Summit2013

This is part 5 of the series of tips that I’ve prepared for those attending the PASS Summit 2013 in Charlotte, NC. In part 1, I talked about preparation for travel, accommodation and communication.  Part 2 talked about what to bring to the summit. Part 3 walked you thru the preparation before you hit the road. Part 4 talked about networking and scheduling your summit sessions. This blog post outlines what you need to prepare for when you arrive in Charlotte. And don’t think this will be the last one in this series. Feel free to add to the list by posting in the comments section if you can think of anything else.

Arriving at the Summit

With a few more days to go before the summit proper, you’re probably excited to get out of the door and head over to Charlotte. Hold on to the excitement just yet. There’s still a few more things to prepare for before the main conference starts.

Checking in to Your Hotel

Since I come from outside of the US, I have to fill up a US customs declaration form that asks for my address while in the US. Knowing the address of the hotel is one thing but knowing how to get there is another. If you are booked at one of the hotels within the vicinity of the convention center, then, the only thing you need to worry about is how to get to your hotel from the airport and back. There are taxis and buses from the airport that will take you to downtown Charlotte (I talked about Charlotte’s public transport system in a previous blog post.) If you prefer to rent a car, there is a shuttle outside of the Arrivals area that will take you to the rental car complex.  Know how to efficiently get from the airport to your hotel whether via public transport or rental car. If your hotel is a few miles/kilometers away from the convention center, know how to get to and from these venues. I find that this sometimes causes a bit of stress on the first day of being in a new city. Don’t let this ruin a great summit experience. That is why preparation is key.

TIP: If you pay close attention, there will be a lot of conference attendees at the airport. Don’t be afraid to ask questions and introduce yourself. This is a great way to meet new people even before the summit starts. You can even ask if you could join them on their way to the hotel.

Check in to your hotel as soon as you can.  Find out what amenities are available to you. Ask if they have a free shuttle back to the airport on the day of your departure. Do you have free breakfast and Internet access included in your reservation? This is very helpful especially if somebody else made the reservation for you.

Event Registration

Summit registration starts at 5PM on Sunday, 13-October and it goes on from Monday to Friday, from 7AM to 5:30PM. Once you’ve finally settled in to your hotel, head over to the PASS Summit registration booth at the convention center. The registration booth is organized by the first letter of attendees’ last name. You will need to provide proof of identification when you register. Part of the registration will be the event badge with your name, company name and Twitter handle if you’ve provided it in your registration. You will also get a printed schedule and a layout of the convention center. I find the printed schedule helpful for me to circle out the sessions that I plan to attend as I’ve mentioned in a previous blog post. Once I finalize the schedule, I key them in on the Guidebook mobile app in my phone. Also, familiarize yourself with the layout of the convention center. Since you’re already there, you might as well walk around with the map to know where you need to go for your chosen sessions.

The registration package also contains some marketing collaterals, raffle entries for some of the vendor events and even your attendee party pass. Vendors are very generous during events like this so make sure you look into your registration package to see what’s in store for you.

Internet Connectivity in your Hotel and at the Convention Center

Can you imagine yourself living 30 years ago when there was no wireless Internet available? Well, you’re not alone. We’ve all become very dependent on the Internet for just about everything. So, when you get to your hotel, check if wireless Internet is available to you. If it is, then, good for you. If not, check the Internet connectivity at the convention center. PASS provides wireless Internet connectivity to all summit attendees. Check the signal and speed after registering for the event. Don’t expect it to be as fast as what you have back home. That’s why you need to check when and where you can get a good signal and speed. If you need to connect to your corporate VPN while at the summit, you need to know where to go and what to expect. There will also be restaurants and stores around the convention center that have wireless Internet available.

I bet by now you’re all too excited to be at the summit. The worst part is having to read all of the Twitter updates from folks who are already there at the venue. Don’t worry. You can catch up all you want once you’re in Charlotte. And once you do get to catch up, you’ll understand what that #SQLFamily hashtag on Twitter is all about.

Preparing for the PASS Summit 2013 – Part 4

Tags

,


PASS_Summit2013

This is part 4 of the series of tips that I’ve prepared for those attending the PASS Summit 2013 in Charlotte, NC. In part 1, I talked about preparation for travel, accommodation and communication.  Part 2 talks about what to bring to the summit. Part 3 walks you thru the preparation before you hit the road. This blog post talks about networking and scheduling your summit sessions. Since it’s already less than a week before the summit, I decided to publish this for those who will be coming to the summit a bit early. Feel free to add to the list by posting in the comments section if you can think of anything else.

Networking before the Event

Networking and meeting people should be a part of your goal as an attendee. As SQL Server professionals, we feel alone sometimes when resolving issues or even implementing a solution. Knowing that there is someone out there who feels the same pain and agony (and sometimes victories) as we do is comforting.

But meeting other SQL Server professionals should not just happen at the event. Social media has opened doors of opportunities to meet people virtually before meeting them in person. Below are some of the tips that you can use to get started.

Connect with the Attendees

Do you remember being asked for your Twitter and LinkedIn profile when you registered for the summit? PASS has dedicated a page to let other attendees know who is coming. Be a white-hat stalker (hey, I do this before jumping in on sales calls.) Check out the Who’s Attending page to find out their Twitter and LinkedIn profile. Find out where they’re from and what their interests are. What are they talking about on Twitter? What is their job role? How long have they been working with SQL Server? These are just some of the things that you need to know to get the conversation started. Also check if your profile is there. If not, make sure you update your profile so people can find out about you.

Introduce yourself early on by joining the conversation on Twitter. Use the #SQLFirstTimers, #Summit13 and #SQLPASS hashtags on Twitter.  By the time you meet them at the summit, it’ll be like an alumni homecoming.

Connect with the Speakers

By now, you’ve probably seen the summit schedule and you have an idea what sessions you’ll be attending. Find out who the speaker will be for that session and learn more about him or her. The more you know about the speaker, the better questions you can ask during or after the session. Better yet, introduce yourself to the speaker even before the summit. Don’t you know that speakers announce their presentation weeks in advance on social media? And they do monitor their followers. They’re thrilled to know that someone is already planning to attend their presentation that they worked hard and prepared for. Interact with them before the summit. Share their tweets or LinkedIn/Facebook updates to your contacts. And, who knows, you might be able to stir up an idea that the speaker can include in their presentation.

Connect with other First Timers

In 2011, PASS introduced the Big Brothers/Sisters program to enhance the experience of first time attendees. I wished that they have done this back in 2007 so I could take advantage of the experiences of a PASS Summit alumni. If this is your first time attending the summit, you will be included in the First Timers program and assigned to a PASS Summit alumni. Don’t be afraid to ask him or her about the other folks in your First Timers group. I know that they are sworn to secrecy with the non-disclosure agreement that they signed but since you will be meeting the other folks in your group anyway at the First Timers Orientation Meeting on 15-Oct-2013, you might as well get to know them in advance. You can all meet up prior to attending the orientation meeting so you can go as a group.

Connect with other Party Goers

I can’t help it, I keep mentioning the parties.

Seriously, when you sign up for the parties, you’ll probably see an EventBrite page for registration. It will list folks you know who are attending as well, depending on the social media settings of the site. Get in touch with them and maybe even arrange how to go to the party venue. If the venue is a few blocks away from the convention center, it wouldn’t hurt having a chat with somebody who speaks T-SQL. You’ll be surprised how those party conversations sometimes end up being a game changer for either your career or your organization. Zappos CEO Tony Hseh takes advantage of party conversations to engage customers and partners with their awesome company culture.

Take Notes

Don’t you wish you’ve got 64GB of memory to store all of the valuable information that you come across with? Apparently, we don’t have memory chips embedded in our brain. That’s why note taking is still a very important skill. I’ve mentioned about bringing business cards at the summit to hand out to the people that you meet. But before you even meet them in person, jot down what you’ve known about them thru their social media profile. It helps drive meaningful conversations. You could write down their hobbies, where they are from, or even their musical inclinations. Trust me when I say that these become the foundation of meaningful relationships that you’ll build at the summit. I hang out with the SQL Server experts who are not only very good at clustering but also enjoy writing music and slapping their bass guitars and keyboards. The stories that you’ll share will become the bond that brings you closer (OK, I better stop right here before I get too emotional.)

Scheduling Session Attendance

Whether you’re a database administrator, a developer or a BI professional, the PASS Summit has something in store for you to learn about SQL Server. Attendees will certainly pick the sessions that they will attend to and schedule accordingly. While most will just pick from the available sessions, keeping these tips in mind will help you maximize your attendance at the summit.

Define Your Goals

It’s probably a cliché since we all have them: New Year’s resolutions, career objectives, personal development, etc. But we can never underestimate the power of having goals. Without them, we’d be like beating against the wind or traveling without a destination. What are your primary reasons for attending the PASS Summit? List them out, maybe just a handful of them to make sure you achieve those goals. Be as specific as you possibly can. If your goal is to learn as much as you can to become a better BI professional who maximizes Excel and Excel Services in SharePoint for information delivery, then plan to attend sessions that help you achieve that goal. Notice how specific I was in defining that goal. It helps me zoom in to what I really need to do to achieve it. Your organization might have a different expectation as to why they want you to attend the summit. Define those as well and make sure that you meet them before going back to work. SQL Server MVP and Microsoft Certified Master Brent Ozar (Twitter | blog) takes this a step further and using this as a ticket to your next summit attendance.

Create a Schedule

The PASS Summit schedule is already available. Based on your defined goals, list out the different sessions that you intend to attend. Prioritize the schedule based on timing and criticality. Timing because there may be sessions that plan to see but are running at the same time. Criticality because you have a pressing production issue that needs to be resolved and attending one particular session can secure you a 5-minute conversation with the speaker to help you address the issue. Better yet, you might want to pay the SQL Server Clinic a visit and have one of the CSS engineers fix it for you. If you have a smartphone, check out the Guidebook mobile application that the PASS Summit team has provided. I’ve already downloaded it on my iPhone and started creating my schedule. It’s a great tool to help schedule your selected sessions and alert you when the next session is about to start.

Plan to Buy the Session Recordings

Let’s admit it. Until human cloning is yet to be invented, you are a limited resource. And you certainly can’t be at all the sessions you want even if you’ve carefully selected or prioritized your list. Make sure you buy the session recordings for future reference. I still view some of the recorded sessions from the 2007 and 2008 summits when I have time (I am still gauging how much I’ve improved in my presentation skills throughout the years) or when a specific session will help me further resolve an issue. While you may not be working with HDInsight in your current job, who’s to say that you won’t next year. Preparation is key and having the session recordings is part of your preparation to become a better SQL Server professional.

Preparing for the PASS Summit 2013 – Part 3

Tags

,


PASS_Summit2013

This is part 3 of the series of tips that I’ve prepared for those attending the PASS Summit 2013 in Charlotte, NC. In part 1, I talked about preparation for travel, accommodation and communication.  Part 2 talks about what to bring to the summit. This blog post talks about what you need to prepare for prior to travelling to the summit. Feel free to add to the list by posting in the comments section if you can think of anything else.

Preparing Before Travelling

For those who travel a lot as part of their job, this comes as second nature. For those who don’t, this is for you (and me, too.)

Travelling to a city you’ve never been to can be both fun and challenging. It’s fun because it opens the door to a lot of learning opportunities, challenging because you need to deal with something new and unfamiliar. If you come from North America, the only challenge you might face when travelling to Charlotte for the PASS Summit is the time zone difference. You speak the same language, drive on the same side of the road, have burger and fries for dinner, etc. I could go on and on to assure you that it’s no different from going on a road trip. Your body clock may throw you off a bit if you’re coming from the west coast because you now have to sleep and wake up a bit earlier than usual. Imagine how it felt like for somebody who comes from the other side of the globe. It took me about 22 hours to get from Singapore to Denver back in 2007. So, whether your time zone is off by 3 hours or 13, these tips will help you prepare before you hit the road.

Get enough sleep, be fit and have a balanced diet

I do my best to get an average of 7.5 hours of sleep a day. That’s because my brain doesn’t function well when I don’t get enough sleep. And, I’ve proven that a lot of times when solving critical issues. In order to really maximize your PASS Summit attendance, your body has to be prepared as well. Get enough sleep the week before you travel. This is the best preparation you could ever make especially if you’re coming from a different time zone. You want to be physically prepared for the changes that you’ll face during the summit.   Plus, remember all those parties I told you about? You’ll have the Welcome Reception, the Annual PASS Virtual Chapter Quiz Bowl, the Exhibitor Reception and the Community Appreciation Party to start with. I haven’t even told you about the SQLKaraoke nights throughout the week and all the other unofficial parties going on that I’m not supposed to talk about. I bet that your earliest time to hit the sack may be at around 10PM every night. If you don’t get enough sleep now, don’t expect to get it during the week of the summit. And, you have to really be intentional about this especially when you’re coming from a different time zone. I knew how it felt like to be half awake the week after my very first summit experience. And that was just because of the time zone difference because I was already in bed as early as 10PM.

Physical exercise is something that a lot of IT professionals don’t get much of. We sit in our desk the whole day to fix issues and fight fires. If we’re lucky, we get to implement cool projects. But that shouldn’t prevent us from keeping ourselves fit. I always say that we are the only person responsible for taking care of ourselves. Get yourself fit and exercise. You don’t need to go to the gym. All you need is determination and willingness to fit (pun intended) this routine in your schedule. Even a 20-minute walk twice a day would be enough. This will help you become a better IT professional overall, not just in preparation for the summit. Oh, and if you want to join your fellow SQL Server professionals do the third ever SQLRun at the summit, sign up here. It’s a fun way to be fit at the summit.

Since I already mentioned about those official and unofficial parties at the summit, expect a lot of junk food pouring along your way. I’m not a big fan of eating out because my wife’s a great cook but you can’t avoid that when you travel. This is especially true at the summit. You will be digging in to a lot of great food and refreshments – alcoholic and not – most of which is definitely junk food for those health-conscious individuals. You might want to load up with a lot of healthy food prior to hitting the road. Now, I’m not saying there won’t be any healthy ones during the parties but they usually don’t go well with alcoholic beverages. All I’m saying is to get yourself ready with a lot of unhealthy food during the summit and make sure you prepare for it. That also means a lot of coffee in the morning to keep you awake during the sessions.

Prepare your personal schedule

You’ll be at the summit for a week at most. You want to learn as much as you can and meet as many people as possible. But that doesn’t mean you’re completely off the radar. As you prepare your summit schedule, be sure to include time to call back home and say “Hi” to your family. Put it in your calendar so you get an alert when it’s about time to make that phone call. You also need to include time to call your colleagues back at the office for updates. They may have a pressing issue that can be resolved by implementing an idea that you’ve just learned from one of the sessions. You might even be able to raise this issue with the Microsoft engineers at the SQL Server CSS Clinic – a free engagement with the Microsoft SQL Server CSS engineers, the very folks who get on the call when you open up a ticket with Microsoft. Or, you may even share the excitement with your team that they would think about attending next year’s summit. This is crucial if you’re coming from a different time zone. You wouldn’t want to be calling your spouse or your colleagues at 9AM when they’re in the west coast. Get it in your calendar so you don’t forget.

Learn how to read maps

In the digital age of Google Maps, Bing Maps, Yahoo Maps, MapQuest (does anyone still use this nowadays?) or other mapping technologies available today, it’s easy to laugh at somebody holding a printed map to find locations and directions. But this has been one of the most important skill that I’ve learned during my years in the army reserve training (I even blogged about its importance.) When your smartphone battery has run out of juice and there’s no electrical outlet in sight, knowing where you are and how to get to where you want to go spell the difference between a sumptuous meal and a chilling walk back at the hotel. Know where your hotel is relative to the convention center. If you’re driving, know where the parking spaces are. If you’ve scheduled attendance to the parties, know where the restaurants are. This will help you schedule which parties to go first. If the venues are completely opposite to one another, measure the distance and the time it takes to go from one party venue to the other.  I’m not really concerned about the weather during the week of the summit so walking to the party venues is not a challenge. However, I’m more concerned about carrying my bag to go to these parties if they are about four to six blocks away from each other.  Also, know the architectural layout of the convention center. If you have scheduled a session that is on the other side of the convention center, be sure you get there in time to get a seat. We had feedback several years ago about the location of the conference halls relative to the banquet halls. Reading the conference center layout is the first thing that I do after I get my registration onsite.

Prepare your party schedule

This is the nth time I’ve mentioned this. It doesn’t mean that I only go to the PASS Summit to attend parties. But I certainly want you to have as much fun as you can possibly have during the summit. And, going to these official and unofficial parties is one way to make sure you do. I’ve listed down some of those that are publicly available. Those that aren’t publicly available, I leave that for you to find out. I’m sure you are aware of the party etiquettes but here are the top three in my list – RSVP, network and D.I.M. (drink in moderation.)   I use the acronym RnD to remind myself of these three things, although the last one doesn’t really apply to me. Still, while these parties are open to public, some of them require that you sign up prior to going. For the official ones that are sanctioned by PASS, you need to show your conference badge and, in some cases, a wrist band as proof of attendance. The unofficial ones do have their own registration sites so be sure to check those out and register if you plan on attending.

Official PASS Summit parties

  • Welcome Reception – Tuesday, 15-Oct 6:30PM to 8:00PM (Convention Center)
  • Annual PASS Virtual Chapter Quiz Bowl – coincides with the Welcome Reception
  • Exhibitor Reception – Wednesday, 16-Oct 6:00PM to 8:00PM (Convention Center)
  • Community Appreciation Party – Thursday, 17-Oct 7:00PM to 10:00PM (NASCAR Hall of Fame)

Un-Official PASS Summit parties (with their registration links)

If you would like to get in on the unofficial parties, be sure to check out their registration links. As I’ve mentioned, there are a lot of those that are by-invitation only and I am not allowed to mention those.

I’m pretty sure you’re excited to attend the much awaited gathering of SQL Server professionals worldwide. You’ve got a few more days to go to prepare.

Preparing for the PASS Summit 2013 – Part 2

Tags

,


PASS_Summit2013

This is part 2 of the series of tips that I’ve prepared for those attending the PASS Summit 2013 in Charlotte, NC. In part 1, I talked about preparation for travel, accommodation and communication.  This blog post talks about what you need to bring to the event. Feel free to add to the list by posting in the comments section if you can think of anything else.


What To Bring

Don’t ever think it is too early to plan what you need to bring to the event. You need to be strategic to make sure that you bring your necessities but not overly packed that you incur charges for your excess baggage.

Gadgets, a laptop, power adapter and possibly transformer

You’re a geek so I know without a shadow of doubt that you’ll carry a laptop.  Besides, I’m sure you’ll sneak in some work in between sessions because you’re sharing the oncall DBA duties with the new hire. If you can, bring the lightest and thinnest laptop you possibly can have. I’m not suggesting that you buy one just for the PASS Summit, although, it doesn’t hurt to do so. But imagine walking around the conference center the whole day with your heavy laptop in your backpack. That’s a quick way to get a back pain. An iPad, Surface, or any Android tablet can be an alternative if you can do your work with those gadgets. I wish I can do that but most of the presentations that I do involve between 5-8 virtual machines for the demos so I can’t just ditch my brick-heavy laptop.

Bring the necessary power adapters that you need for your gadgets. I bet that you’ll be using your smartphone a lot during that week to instantly check emails, the next session, send a quick tweet about that great idea you’ve just learned, or just simply answering phone calls. Your phone charger will be your next best friend throughout that week.

If you are coming from a country that uses voltage other than 110V, you definitely need a step-down transformer to get your gadgets charged. Plan to either bring one with you or check with the nearest RadioShack in Charlotte if they have one available.

TIP: Don’t you know that power strips are a great way to make new friends? Since all attendees are geeks and carry their laptops and gadgets with them, the limited number of power sockets make them a scarce commodity. Bringing one with you to connect your own gadgets and share with others is a great way to be involved in the SQL Server community in a very simple way. That’s the main reason I carry one with me during these events.

The Mighty Pen and Paper

You might think I’m old school because I included the pen and paper. However, a very good friend of mine once said that the faintest ink is more powerful than the sharpest memory. I can’t even read my own handwriting so why am I encouraging you to do so? Studies confirm that the notes that you take with pen and paper helps you retain what you wrote better than typing it on your laptop or tablet. And, yes, the study includes using a stylus being used on tablets but using pen and paper is still better.

Business Cards

What’s the quickest way to recall someone else’s name and contact information? I bet a business card handed over to you is much quicker than you typing on your smart phone (unless you work for one of the sponsors or exhibitors who have those handheld scanners that scan your badges to take your contact details.) You still have several weeks to go before the PASS Summit. Make sure you bring business cards with you that you can easily hand out to people you will meet. You also need make sure that you have the correct information on your business cards, including social media accounts. Your PASS Summit badge will include your Twitter handle if you have provided it in your registration. And, don’t be afraid to ask for others’ business cards. It’s a great networking tool.

Proper Clothing

Charlotte is unlike Seattle during the fall. Weather forecast during the week of the PASS Summit will be between 10 C/49 F to 22 C/72 F. Bring the appropriate clothes for the weather. Keep yourself warm whether you’re outdoors or indoors. Conference room temperature is usually cold due to air conditioning. Pack sweaters and coats for the whole week. Just make sure you have enough space in your luggage to put in those swags that the vendors and sponsors give away during and at the end of the event.

Camera

Take a lot of pictures. Even your phone has a digital camera in it. I bet that you would like to see what Charlotte has to offer before or after the event. Or, maybe even just take a photo of the people you meet at the summit. If you’re not from Charlotte, you’re technically a tourist. And as most travelers usually say, ”Take nothing but pictures leave nothing but footprints, kill nothing but time.” Now, if you’re really into this digital photography thing that you spend a lot of money for those fancy gadgets and lenses, maybe you can hang out with your fellow SQL Server professionals who are into the same thing. Pat Wright (blog | Twitter) started the PASS Summit Photo Walk back in 2010 for photography enthusiasts attending the summit to get together and get geeky with photography. If you’re interested in joining, register at this website. You might also want to check out their Flickr page to see some of the interesting pictures taken during the previous PASS Summit events. I might join depending on whether or not I can squeeze my gear in my luggage.

Extras

I’ve already mentioned the possibility of bringing along extra luggage to squeeze those event swags in. For those in the US, this is as easy as buying a box in the local US Postal Service office and shipping it back home. For us outside of the US, this is easier said than done. Coordinate with your colleagues and friends who are also attending the summit. You can split the swags among you so you can carry them back home. Just be careful not to carry items that are not allowed by the US TSA. I remember Quest Software giving away sticky toys at a past event. Those traveling by plane had to leave them behind.

Carry extra cash (or credit card) if you plan to go sightseeing before or after the summit. For a list of recommended places to visit, check out SQLSentry’s President Greg Gonzales’ blog post about this for more details.

Giving Away FREE Access to My SQL Server High Availability and Disaster Recovery Deep Dive Course

Tags

, , ,


Tweet_HADR_Free
Yesterday, I tweeted about giving away FREE access to my online course on Udemy (and, yes, it’s a birthday gift from me). If you’ve been following my blog post, you may already know that I’ve launched my very first learning experiment last week via the online course. I haven’t really promoted the course yet (aside from SQL Server MVP and MCM Brent Ozar mentioning it on his blog post) which is kind of unusual for me since I also write about topics on the subject.

When I was preparing for the course, I had two things in mind. First, I wanted the course to have an impact on both the ones taking it and those who matter to them. I had several assumptions of those who might be interested in taking it. They’re the ones who really do care about their personal growth – those who invest time and resources to learn about something new so that they can improve themselves. These are the folks reading books, blog posts, whitepapers, articles and even someone else’s code during their spare time. They attend conferences, user group meetings and events so long as their time and budget allow them to. They search the internet for free stuff when their budget doesn’t allow them to invest in additional resources and they regularly try out something new. They do this not only because they feel the personal satisfaction of improving and developing themselves but also because they want to spend more time on the things that really matter to them – family, friends, loved ones, etc. Second, I want the course to become a part of their career. They say “experience is the best teacher“. I say learned experience is. What good is knowledge if it isn’t applied. How many books have been collecting dust on the bookshelf, waiting for their turn to be opened and read by their owners? How many concepts learned have been applied? We don’t need more ideas. What we need is to apply the ideas and lessons that we’ve already learned.

And, that’s the story behind why I am giving away FREE access to my online course. I have made the first five lectures of the online course accessible to anyone who has access to the internet – no need to register to Udemy to access them. If you’ve found this blog post, it means you are a SQL Server professional who is serious about personal growth (and I’m pretty sure you’ve also seen the free lectures.) The first five lectures contain very important concepts in high availability and disaster recovery, things that we technology professionals don’t even think about sometimes. In fact, this is the foundation behind implementing effective high availability and disaster recovery solutions. Even non-SQL Server professionals will benefit from these free lectures.

Udemy

In order to be one of the twelve lucky individuals who will receive FREE access to the full course, you must take the following actions:

  1. Leave a comment below. What are the TOP 3 ideas that you have taken away from the first five modules of the course? And how do you intend to apply those 3 ideas in your organization or your customers? Be creative. You’ll never know if those ideas end up being implemented – either by you or someone else.
  2. Fill out my Contact Form. Provide a valid email address that you check on a regular basis. You want to make sure that my email announcement doesn’t end up in your Spam folder.
  3. Share this this blog post via social media.  Use the #SQLHADRRocks hashtag on Twitter, share it on Facebook (I know Facebook now uses hashtags as well,) LinkedIn, Google+, Reddit, and anything else you can think of. Include at least one of the links in your comment below.

On Tuesday, 01-Oct-2013, I will be selecting twelve (12) lucky individuals based on my evaluation of their submission. If you have been selected, you will receive a personal email from me on 13-Oct-2013. If you didn’t receive any email from me, you can assume that your submission was not selected.

[UPDATE: 01-Oct-2013] I’ve received requests to extend the deadline to 07-Oct-2013 due to very tight schedules. So, you still have a week to go to take advantage of this. I guess I didn’t promote it well enough :-)

[UPDATE: 08-Oct-2013] The winners have been chosen. Expect an email from me and enjoy FREE access to the online course.

Preparing for the PASS Summit 2013 – Part 1

Tags

,


PASS_Summit2013

It’s 3 more weeks before the PASS Summit in Charlotte, NC. I prepared this series of tips and guidelines for some of my friends and colleagues to help them make the most out of their very first summit experience. I hope you find this useful.

Congratulations! You have finally decided to attend the largest SQL Server conference in the world. You’re not alone. Every year, more and more SQL Server professionals try their best to attend the PASS Summit. It’s like a mecca for anybody who works with SQL Server. And, whether it’s their first time attending or have been coming back since their first attendance, the feedback has been the same: this is the best SQL Server event you could ever imagine. I wouldn’t want to spoil the surprise but I assure you, you are in for a big one.

As you prepare to attend this year’s PASS Summit in October, I’ve put together several tips and guidelines on making the experience worthwhile. Like you, I was once a first time attendee back in 2007 when the PASS Summit was held in Denver, CO (it was also my very first time to speak at a North American event.) I will never forget that experience simply because it has influenced my career growth, my involvement in the SQL Server community, and developed my personality in the process. I hope you find these tips and guidelines valuable.

Travel

This year’s PASS Summit will be held in Charlotte, NC. If you are not from Charlotte, chances are that you will be travelling to attend the PASS Summit. I prefer the event to be in Seattle, WA because of several reasons but having it in Charlotte means that my body clock doesn’t need to be confused. Whether you’re flying or driving to Charlotte, here are several tips to help you prepare for your travel arrangements.

US Visa

If you’re from the United States or from a country that does not require a visa to travel to the United States, you can skip this section.  The reason I’ve included this section is because the PASS Summit has become a melting pot of SQL Server professionals from all around the world – Asia, Australia, Europe, Africa, etc. Make sure you have a US visa even before you arrange your flights. Citizens from countries that do not require a US visa are lucky enough that they can come any time they want. I had to apply for a US visa back in 2007 to visit Disneyworld in Orlando  :-)

Airfare

Whether you’re from the mainland US or outside, chances are that you will be flying in to Charlotte (or maybe you’re like me who prefer to do road trips and stop to see sights along the way.) Charlotte airport (Airport Code: CLT) is accessible via the local US carriers like Delta, US Airways, United, Alaska Air, etc. You should be booking your flights by now or you run the risk of increased airfare prices as you come close to the event. And, since Charlotte is a major hub for US Airways, don’t expect a direct flight from any other airlines. Plan which flights and routes you take. Sometimes, even the routes and the arrival/departure dates have an effect on the price. This is where travel sites like Expedia, Travelocity, Priceline, etc. can help you with the planning.

Accommodation

As of date, all of the hotels within the vicinity of the Charlotte Convention Center are all sold out. Your next best option would be about 5-10 kms away from the venue. If you can no longer find any accommodation, check whether or not you know somebody who would be willing to share a room with you. Just make sure you bring extra ear plugs in case you or the person you’re sharing the room with snores. I’ve done my fair share of room sharing on some of the events that I have attended due to budget constraints.  But these have been with people that I know and have engaged with. Trust is key here especially that you’ll be leaving some of your personal stuff in the room with someone that you don’t regularly spend time with.

It is recommended to find a place within walking distance from the venue. That’s because there will be activities and events outside of the main conference where you will be prompted to consume alcoholic beverages (I don’t drink so I don’t worry about this.) Parties from HP, PragmaticWorks, Microsoft, etc. will be hosted within blocks away from the venue. And, I’m pretty sure you wouldn’t want to miss those. It’s best to be very familiar with reading maps – Google, Bing, MapQuest or your good old-fashioned printed maps – to get an idea of how far away your hotel is from the venue and from the party venues. You certainly wouldn’t want to be bringing your backpack/bag to the party after the conference day is over.

Public Transport

Whether you’re taking a cab from the airport to your hotel or taking a bus daily from the hotel to the conference center, knowing your means of moving around helps relieve a bit of stress. I know, because back in 2007 when I attended my very first PASS Summit, my accommodation was about 2 miles away from the conference center (that’s all my budget can afford.) You can check the local Charlotte public transport website for options and the schedule. This also helps you plan your after-conference events to make sure you do not miss the last trip of the local bus. I’m renting a car this time because I was late in booking my accommodation. Plus, I know a bit of Charlotte to drive around and see places.

TIP: SQLSentry, maker of the popular tool Plan Explorer and whose corporate office is in Charlotte, is providing a fleet of trolleys to take Summit attendees to popular destinations in and around downtown Charlotte. This is a great opportunity to explore Charlotte without having to worry about getting to those places. Check out SQLSentry’s President Greg Gonzales’ blog post about this for more details.

Travel Packages

I’ve tried arranging flights and accommodation both individually or as a package. Depending on the availability, one may be cheaper than the other. This time around, I booked my airfare, accommodation and transportation thru Expedia which proved to be a more cost-effective option.

TIP: Think you’re saving a few hundred dollars with one option versus another? Think again. If you end up spending more time and effort and stress muscles, I doubt it would be cheaper in the long run.

Communication

You can skip this section if you’re from the US.

Roaming charges are expensive. You don’t want to blow up your monthly plan by incurring international calls. Besides, you already paid so much by deciding to attend the PASS Summit. When you roam, both incoming and outgoing calls are charged. Grab a prepaid phone from any 7-11 or CVS stores for US$20 and top it up with a US$20 load. That is usually enough for about 200 minutes. You can forward calls from your phone to this prepaid phone to save on roaming charges. Plus, you can call anybody at the event using this prepaid phone in case you need to meet up before you go to the next session or the after-event parties. I’ve been using TracFone for 2 years now and that has saved me a lot every time I travel to the US. Just keep work-related calls to a minimum. You’re here to attend a conference, learn and enjoy. J

Data plans are a bit challenging, especially if your phone is locked to your service provider. AT&T and Sprint used to provide prepaid data plans where you can just plug the SIM card on your phone and you can be online. They phased those out last year. I hope to find a replacement soon.

WiFi is available at the conference center. But don’t expect it to be as fast as what you have at work. Plan your internet usage when you’re at the conference center. You can download work-related emails while at the hotel and sync them back at the end of the day. It doesn’t hurt to be disconnected every once in a while.

Stay tuned for the next part in this series. Meanwhile, be sure to attend this webcast later this week for the PASS Summit 2013 First Time attendees hosted by SQL Server MVP/MCM Denny Cherry.

Follow

Get every new post delivered to your Inbox.

Join 25 other followers