Monday, October 17, 2016

NOT NULL - SQL Saturday Portland Presentation Coming Up!

I am really excited to present a brand new session this coming weekend at SQL Saturday Portland. In my role as a database performance engineer this past year, I have been keeping notes on some 'gotchas' that come into play with database design and data storage. Thusly, I am very happy to be presenting:

NULLs ...and other SQL gotcha's

Wherein I discuss the ups and downs of NULL usage, what to do when you have 'no data' to store, some pitfalls to avoid and a few other bonus topics as time allows.


Last week, I was invited to give this presentation in front of the New England SQL Server User Group. About 50 or so people attended, and we had a lot of really great discussion about the use of NULL in a database.

I hope to see many at the PASS Summit next week, and while I'm not presenting there, it will be nice to have the opportunity to do so this Saturday!



Wednesday, October 5, 2016

Global Growth for PASS

I have had a few very productive conversations recently with PASS members and SQL Community members from around the globe. How can PASS be relevant outside the US/Canada region?

The EMEA region (Europe, Middle East and Africa) has a long history of well established user groups in some areas. PASS comes strolling by and wants to partner with these groups in an effort to grow community and provide resources. What is the value proposition for an established group? I see these challenges and have enjoyed conversations regarding what works and what does not. What PASS must realize is that what works for one region or geographic location might not provide the same success in others. I'm looking forward to building stronger relationships here and helping provide solutions where needed.

Contrast this with SQL Community growth in LATAM over the past several years. Under the PASS umbrella, many amazing volunteers have stepped up and started up local Chapters, hosted SQL Saturdays and worked as Regional Mentors and Board Advisors for their community. I am very excited to see PASS welcoming the first Director at Large from the LATAM region to the Board this term!

PASS cannot rest on these laurels for LATAM region, however. Support and encouragement must continue in order to grow additional leadership and continue outreach into under-served areas. I am hopeful to continue working on the Board and will work with volunteers to ensure the success of the region as a member of the Global Growth Committee. My goal is to work toward more international representation on the Board and at the regional levels while also providing support for local community efforts.

I don't want to discount activity in other regions, however. PASS has very active communities in both the Pacific (Australia, New Zealand for example) as well as thriving groups in China and India. I have worked to make sure that Virtual Chapters are providing content at hours equally convenient to members in those regions. While there has been some success, more work still needs to be done. I am very much looking forward to the growth and partnerships forthcoming in these next few months!

Elections are upon us! I'm excited to see Eduardo Castro on the ticket for LATAM and I hope to enjoy the honor of working with him and the rest of the Board for another term.

If you are so inclined, your support is greatly appreciated when you cast your ballot!


Election season! Please vote for PASS Board of Directors Oct 5-11

It's that time of year again. If you live in the US, you have an opportunity to have a voice in who will be President for the next four years; who will serve as representatives for your state at the national level; who will represent your district at the state level; etc. etc. etc.

What PASS members aren't always aware of is their opportunity, no matter where in the world you live, each and every year, to vote on who is elected to the PASS Board of Directors. Directors serve two year terms, so there is an election every year to select three (3) of the six (6) Directors At Large.

Once again, I have put my name up for election for our organization. Why? I have currently served for just over 3.5 years on the Board. I have worked hard to keep focus on Community by working on Chapters and Virtual Chapters portfolios over this time. With the growth of the organization and the increases in costs for maintaining the resources PASS provides to Chapters and SQL Saturdays, for example, I have heard rumblings that PASS is not about Community any more.

I am here to state that is definitely not where I see PASS and the Community headed. A vote from you to re-elect me to the Board of Directors will mean YOU have a voice on the board. Change is inevitable. PASS is a growing organization and there will be changes no matter who is elected. What I want to provide for the community is an earpiece and a champion to always ensure YOU are being represented at the table. When PASS started discussions around Business Analytics community, I was the loudest voice in the room stating my support, but only if it meant that no resources were moved from the current community. PASS could not afford to allow the current community to go on as status quo only. If PASS is growing BA community, it also has to not only maintain, but enhance the community it already has.

These are not simple discussions. There are not easy answers or paths to success for most issues. I am here to fight the good fight and keep PASS the great Community organization it historically has been. I love PASS. I love my #sqlfamily. I am happy to represent YOU all on the Board.

Balloting opens today October 5th and runs through next week, Tuesday October 11th.

Please vote!

I'm also honored to have the support of others from the Board and Community. See the links below (more added as they come in)
My Statement of Support of Wendy Pastrick for the PASS Board
@SQLBek - PASS Board of Directors Elections
@IrishSQL - Time to make your voice heard
@dmmaxwell - PASS Election Endorsements
@Jenstirrup - What I learned from David Bowie, and Statement of Support for Wendy Pastrick for PASS Board of Directors
See Page 3 of my Board Application

Tuesday, May 10, 2016

#tsql2sday - What did you learn?

Make sure to comment and link to your post for this month's #TSQL2SDAY installment. I'm really looking forward to seeing what the community has to share, and I'll bet you are, too so check back throughout the day!

I'll be posting my own later today...update to come!


Monday, April 18, 2016

It's time for T-SQL Tuesday #78 - May 2016 edition!

Plenty of heads-up for this installment of #tsql2sday because this time, I'm challenging you to learn something new and blog about it! 

There are so many new things to play around with, some brand-spanking newly released, and others that have been around for a bit, but you've probably still not taken any time to try it out. 


Here's a short list of ideas to get you started:

  • PowerBI
  • Azure (remember you can get $150 monthly credit just for trying it out!)
    • Virtual Machines
    • SQL Database
    • Stretch tables
  • SQL Server on Linux
  • SQL 2016
    • Always Encrypted
    • Query Store
    • Row Level Security


The Rules (completely stolen from Bob Pusateri!)

There’s only a few rules for T-SQL Tuesday:
  • Your post must be published between 00:00 GMT Tuesday May 10 2016 and 00:00 GMT Wednesday May 11 2016.
  • Your post must contain the T-SQL Tuesday logo (see above) at the top and the image must link back to this blog post.
  • Trackbacks should work, but if they don’t, please put a link to your post in the comments section so I (and everyone else) can see your contribution!
There’s also a few optional things you can do that might help:
  • Include “T-SQL Tuesday #78” in your blog post’s title.
  • Tweet about your post using the #tsql2sday hashtag
  • Contact Adam Machanic and tell him you’d like to host a T-SQL Tuesday from your blog.

Friday, February 13, 2015

PASS presents Business Analytics Conference April 20-22

I have to say, I'm really excited about the great content being presented at this year's PASS Business Analytics Conference. The Program Team at PASS has outdone themselves this year to recharge and direct the content to include incredibly meaningful, useful and timely training to data professionals in all industries.

Take a look for yourself at some of the sessions which were presented during the BA Marathon recently. Go ahead, it's FREE!

Some of the most exciting news about the conference is the amazing line up of Speakers for both sessions and keynotes. The incredible Mico Yuk (author of Data Visualization for Dummies) will be featured as a keynote speaker on day two. Then, there's the likelihood of running into and having the opportunity to talk with data superstars such as Chandoo, MrExcel: Bill Jelen and Oz du Soleil from ExcelTV!

But wait, there's more than just Excel going on here. Want to learn more about R or Hadoop? Check out sessions with David Smith from Revolution Analytics, and Michelle Ufford from GoDaddy. Plus, so much more...

Mostly though, PASS events are a great place to network, meeting people who have similar work, and tackle similar problems. Having a low pressure environment where you can enjoy some time to just chat with one another (maybe even hang out in the evening for dinner!) and learn from each other is worth every moment away from the office. But don't just take my word for it. See what KDNuggets has to say about the BA Conference:


So, what are you waiting for? Do you or someone you know work with data ALL DAY LONG? Leave me a comment and I'll send you a special rate discount code only provided to  PASS Board members.

Spread the good word and see you in Santa Clara!

Tuesday, November 11, 2014

TSQL Tuesday! Learning new things



We are all constantly learning. It's a life long endurance race to collect knowledge, learn facts, perfect processes and build on the foundation of our early childhood education. The mountain of knowledge can become overwhelming if you try to look at it from too high up. I think about all the things I know regarding SQL Server, and then sometimes all it takes is a single conversation with a colleague to realize how much I still have yet to learn!

So what have I learned recently? Certainly plenty of technical one-offs; some great NDA stuff from the MVP Summit; and always something more about myself...but for this blog post I want to write about networking.

This year at PASS Summit I made a point to spend more time with people I don't typically have much opportunity to hang out with. I decided to let the setting or the occasion determine the people around me and it was really a lot of fun! I had the chance to make several new friends, and even bonded with a great vendor/sponsor who is going so far as to help out with the local SQL Saturday venue. It's incredible what can happen when you just say 'hi' and start a conversation. We all have our inner circle, and it's tough when we mostly see each other only once a year to give up some of that time to meet more people and make more connections. Just a few of the folks who I had time to get to know better, or meet for the first time (in no particular order and my apologizes for those left off, long list!): Jamey Johnston - love the new twitter handle!, Jim Murphy - would you like another umbrella in that drink?, Catherine Wihelmesen - we need to hang out more!, Elysia Barber - next time I'm in Texas, watch out!, and certainly Kirsten Benzel - muahahahaha. In addition to being just crazy fun people, we managed to have some great conversations along the way and I'm looking forward to seeing you all again at the next event we happen upon.

Lastly but in no way least, while my time in the Exhibitor hall was limited, I really enjoyed meeting the great teams of people at Kroll Ontrack and Solarwinds. People, you just never know who you are going to meet and what kind of impact or impression they may leave upon you. It's worth having that conversation, even giving up your email address because great, and sometimes amazing things and partnerships can come out of it.

So what did I learn? I learned that I have an amazing group of friends in #sqlfamily and PASS. I also learned that by continuing to add to my network, more things are made possible.

To those of you whom I did not get to spend our typical dinner/lunch/afters with, I did miss you but I know there will be future opportunities to meet up....and I'll bring a new friend along, too!

Thanks to Chris Yates (b|t) for hosting this edition!


And totally unrelated, some pics from Summit :)













Tuesday, October 14, 2014

Ada Lovelace Day 2014 - My Heroes - #tsql2sday

 Well here it is, Tuesday again and another installment of #TSQL2sday this time brought to you by Tracy McGibben (t|b) in honor of Ada Lovelace Day! Many bloggers today will write in honor of her accomplishments and where we are in technology today because of her work. Cool stuff :)

While Ada is certainly one of my personal Women In Tech heroes, there are many others who have paved a path more recently contributing to my career in tech. I couldn't write about heroes without a significant nod to my Mother who raised two girls on her own in a time when being a single parent was seriously frowned upon and without a higher education. Mom, you will always be the pinnacle of inspiration for me!

This year, I want to honor those wonderful women I have worked with in the past 12 or so months. Whether you realize it or not, you all have inspired me in one way or another, specifically professionally. Without further ado, my list of inspiring women:

Hope Foley (@hope_foley) - Hope's work ethic alone is enough to inspire anyone!
Kathi Kellenberger (@auntkathi) - Kathi's ability to take any technological problem and break it down into understandable pieces is something I aspire to do!
Ginger Grant (@DesertIsleSQL) - Ginger can tackle any problem put before her with finesse and polish!
Melissa Coates (@SQLChick) - Melissa loves what she does and it shows in everything she presents!
Kim Hathaway - Kim knows her stuff and she is never afraid to share her expertise!
Kathy Vick - Kathy knows more about SQL Server (the whole stack) than anyone I've met. It doesn't matter what questions I come up with, Kathy has an answer!

Thanks, ladies for being an inspiration and making me want to be a better Woman In Technology.

Monday, October 6, 2014

SQL Server in Azure : Additional Storage

When you provision a SQL Server virtual machine (VM) in Azure, by default you are given two drives:









The C:\ volume is, as you would expect, where all of the system files and system databases have been created. As a DBA, I know I don't usually want to store my database and log files on the root directory. Call it habit, but it still doesn't seem like the right thing to do, even in Azure. Plus, there is only about half the drive available anyway. That is not going to scale as my database files grow. Time to look elsewhere.

The D:\ volume looks very tempting at 192 GB of free space! To be fair, the size varies depending on the server size you choose - this example used a D4 VM allocation. Officially, MSFT states that this drive is used to save the system paging file. While you can save files here, it is at your own risk. Since this drive could and likely will be recreated on occasion, anything you save there will be lost. Remember these are VMs, and any reason for the VM to move to a different host will cause the D:\ drive to be rebuilt. Full details regarding the "Temporary Storage" can be found on the Microsoft Azure Support Team Blog.

Okay, so let's create our own, persistent storage for this server. This way, we can determine what allocation to use. It is very simple, just locate your VM, and select it. You can do this from either the Virtual Machines dashboard, or the individual VM dashboard. 

Just make sure you have the correct machine selected before you "Attach". You will be prompted to choose a size for disk, and that's all you need to go! Now, when you connect to your SQL VM, you will see the additional Data drive on E:\. You can attach multiple drives, so if you want to isolate your log files and TempDB as you would normally on-premises, you can.



So, how much is this going to cost? At the time of this writing, storage in Azure is really on the reasonable, if not downright cheap, side.

Depending on how much Azure-related redundancy you want to configure for your additional drives, you can pay as little as $0.024 per GB (up to 1 TB). Yes, that is UNDER 3 cents per GB - per month. So, let's say you need 100 GB, over a year's time, that will cost you $7.20 x 12 months = $19.20. That's it!

Full pricing on Storage and information on redundancy can be found here: http://azure.microsoft.com/en-us/pricing/details/storage/

I hope to continue my SQL Server in Azure series over the next serveral months, so thanks for stopping by and check back again!

Wednesday, October 1, 2014

PASS Summit 2014....here it comes!

Once again, the PASS community will come together in Seattle for the annual Summit. If you haven't registered yet, there is still time (the countdown is on)!

For those who have not attended previously, there are some things you should know about visiting Seattle and making it through Summit with the best possible experience. To that end, PASS is putting together a series of 'Get to Know Your Community' sessions throughout the event. Hear from these great SQL Community voices on how to get the most of out Summit and your PASS membership! Full details can be found on the PASS Summit Schedule page.
Kevin Kline  |  Mark Broadbent & Buck Woody  |  Jose Rivera  |  Wendy Pastrick
Jes Borland & Kendal VanDyke  |  Ryan Adams  |  PASS Program Committee 
 I also have some tips and thoughts to share. Before you leave home, a little prep work will make your trip better. There are a few things I like to do before Summit:

  1. Get a flu shot. It's a long week of shaking hands and making new friends, so I'm scheduling my flu shot for 2 weeks before Summit arrival.
  2. ELECTION TIME! In the USA, it's time to vote, so make sure you do your civic duty and get that Absentee ballot in. You will be in Seattle on election day.
Packing Tips
  1. Shoes - you will be walking. Bring comfortable shoes. Bring a spare pair of shoes. The Convention Center is massive and just about everything in the evenings is a short walk.
  2. Don't bother with an umbrella. Many of the buildings downtown have awnings for the misty, drippy substance that falls down most of the time. It is rare to have a full downpour, although it HAS happened and if you need to go more than a few blocks, just catch a cab. Best idea - bring a coat with a hood!
  3. Ladies - consider a small purse you can wear under your jacket, or opt for pockets only when going out for the evening. 
Seattle is a really awesome city. My father lived there for several years and I got to know the area well over that time. This year will make 11 (12?) years I've been attending Summit. There are some tips and info I'd like to share to make your stay more enjoyable.

  • Take the train! When you arrive at SEATAC airport, you could hop in a cab and it will be about $40-60 to your hotel and will take about 30 minutes. Another great option is the Central Link Light Rail which will run you $2.75. The ride is about 40-45 minutes and if you come in on Sunday, you might get to witness all the Seahawks fans going to watch the game.
  • Pike's Place Market is a Must See. After your full day of brain stuffing, walk down the short 6-7 blocks from the Convention Center toward the Sound, and you can't miss Pike's Place area. Tons of food options (watch out for flying fish!) and catacombs of shopping to explore here! This is the perfect spot to pick up those souvenirs to take home. 
  • A host of other museums and fun spots abound (Space Needle, Science Museum, etc). Check them out here and learn how to access them via the Monorail!
  • Eat Seafood! You are in Seattle, and many awesome restaurants are along the piers - just down, down, down the stairs from Pike's Market. Grab a group of your new SQL friends and have a nice dinner out.
  • Go off the beaten path and hit up some clubs in the Pioneer Square area, or check out some local breweries, or - you do know that Seattle has awesome bands, right? A host of spots can be found on Seattle Nightlife.

Nightlife around Summit is the best time to meet people in a relaxed, fun atmosphere. There are a few places you are bound to see many Summit attendees.
  • Tap House Grill, not even a block from the Sheraton, is open late and anyone still out after midnight often will congregate here.
  • Bush Garden is the #sqlkaraoke spot. This one is a good walk for those so inclined, but many take a cab. Singing not required. Just go and have a good time!
  • Speaking of #sqlkaraoke, Mr. Denny Cherry and SIOS host another party on Tuesday night.
  • Many vendor parties spring up as the dates draw nearer. If you don't hear about them beforehand, don't worry - many give out wristbands or tickets at the Exhibitor Reception or just by stopping in at the booth before the evening festivities.
  • A whole list of After Hours Events are posted on the Summit site, too! This is updated frequently, and some require RSVP, so check back now and then.
Get out, meet people, enjoy the evenings; this is what makes Summit the best conference for SQL professionals! 

Final note - as with any major city, keep your wits about you as you are getting around. Don't walk around with your nose and eyes in your smartphone. There are a lot, and I mean a LOT of homeless people in the downtown area. They will constantly hit you up for a dollar, or whatever. Mostly they don't cause any trouble, but it's always best to walk with purpose, keep your head up and be aware of your surroundings.

I'm looking forward to meeting you in Seattle. Just stop by the Community Zone and say "Hi!"

Wednesday, September 24, 2014

Thanks for the support!

Running for the PASS Board of Directors is always a process. There are forms to complete, interviews, online and virtual events to attend...it's a lot of time and effort and hopefully it serves the community in helping make the ballot choices clearer. One piece of the process, though relies on others providing statements of support and recommendations for your spot on the Board. This year, I had several people willing to speak on my behalf. While you can find those in the application online, they have been copied here for convenience. Also, there were some which couldn't be used on the application due to limitations so those are here, too.

Check out what these people had to say about my candidacy below.
Angela Dugan (t|b)
Allan Hirt (t|b)
Kathi Kellenberger (t)
David Klee (t|b)
Tim Mitchell (t|b)
Allen White (t|b) 
Andy Yun (t|b)  

I'm always incredibly humbled by the words of my peers - thank you so much for taking time out of your day to support me.

When you have your ballot arrive in your inbox today, please take a moment to vote! Thank you!


Anglea Dugan
I have known Wendy for about 6 years now, and we have interacted at the MVP Summit, at Girls in Tech Chicago, and at a number of other community events in the Chicagoland area.
Wendy’s enthusiasm is contagious, and she brings a lot of energy to any event she attends. She is also deeply technical with an amazing network, and has been able to connect me with a lot of great people in the Chicagoland technical community when I needed assistance. I would recommend her to any group looking for an active member or leader. 
Allan Hirt
I have known Wendy Pastrick for eons and would also consider her a friend as well as a colleague. Those of us that are acquainted with her know that her personality always shines, and she would be the first person lending a hand or even just providing a smile if someone needed it. If you looked up either selfless or volunteer in a dictionary, Wendy would fit the definitions in every way, shape, and form.
One thing about Wendy besides her warm personality is that she can bridge diverse groups together. I have seen that at play not only in the SQL Saturdays that she has helped to organize, but in social situations as well. She has a natural way of making everyone feel comfortable which is a great quality to have in a role of leadership. Wendy treats everyone the same – newbie or veteran.
At the same time, Wendy is not a pushover or unrealistic. For example, she states in her application, “As much as the organization has pushed toward transparency, the speed at which some decisions and directions are chosen can be difficult to relay to the community at large in a timely manner.” As long as I’ve known Wendy, she’s always strived to improve herself both personally and professionally, and I know she wants the best for PASS even if it will not be an easy road to get to the brass ring. Wendy is certainly a straight shooter, which I appreciate. I would rather have someone be up front with me than skirt around the issue. PASS certainly needs people who want the organization to be better, are also honest, and not just wanting to be a figurehead. She’s also not someone who is afraid of rolling up her sleeves and get down to hard work.
Besides her devotion to her family, I know Wendy’s other passion is her dancing group. I know I strive for work/life balance, and I think anyone in a leadership role needs to do the same. It is always clear to me that she has her priorities in order.
Wendy has also served many roles with PASS over the years. From my vantage point, she’s given each one her all. I would expect nothing less of her in this position as well. 
Kathi Kellenberger
Wendy Pastrick has been a dedicated PASS volunteer for several years and has served on the PASS Board for the past two years. I have worked with Wendy on the WIT Virtual Chapter and WIT panels at many SQL Saturdays. Wendy not only works for PASS at the organizational level, she is also very involved with her local user groups and has organized several SQL Saturdays in Chicago. Wendy even won the PASSion award a few years ago and is a SQL Server MVP. She is always ready to assist PASS in whatever way is asked of her.
To me, the best thing about PASS is the wonderful community we have formed. When I think about community, Wendy is one of the first people who comes to mind. Making sure that everyone feels welcome is very important to Wendy. Wendy is just one of those people who makes others feel comfortable and accepted. She also encourages new speakers which is very important for the health and growth of PASS.
Because of her many contributions to the SQL Server community and dedication to PASS, I would like to recommend Wendy Pastrick for the PASS Board of Directors. I am certain that she will continue to serve the best interests of the organization and faithfully represent the membership.
David Klee
I truly cannot think of anyone more deserving to be elected to the SQL PASS Board of Directors than Wendy Pastrick. She is easily the most dedicated PASS volunteer that I personally am aware of, and her eagerness to involve herself in the PASS community is second to none. From contributing leadership and guidance to the Chicago SQL Server User Groups, WIT Virtual Chapter, and WIT sessions at SQLSaturday, all the way to being the chief coordinator for the most successful SQL Saturday in the last two years that I attended, Wendy works very hard to contribute to the success and growth of PASS and the community that has evolved around it. 
On a personal level, Wendy is one of the sweetest and most vibrant people that I know. Her warmth and ease at which she can make anyone - from the most senior professional to the newbie attending their first SQL Server Users Group meeting - comfortable and eager to contribute to the community is unparalleled in our technical communities. Her personal attributes are guaranteed to positively reinforce the professionalism that Wendy exudes 24x7 to help the Board of Directors continue to be even more successful as PASS continues to grow. 
Because of her passion for PASS, strong involvement in the community, years of experience, and fantastic personality, I would like to wholeheartedly and without hesitation recommend Wendy Pastrick for the SQL PASS Board of Directors. 
Tim Mitchell
I have had the pleasure of working with Wendy Pastrick in various capacities during the past four years.  In that time, Wendy has always exemplified the qualities I would expect to see of a community leader.  She has demonstrated a selfless work ethic and a strong desire to help others.  As a prior PASSion Award winner, her passion for the SQL community is second to none.  Further, I have observed her in her current board service as a true community leader, willing to tackle difficult matters in the interest of community harmony.

In short, Wendy is exactly the type of person I want to have representing me on the PASS board.  I am happy to endorse her candidacy.
Allen White
Wendy and I first worked together as part of the Election Review Committee and were partners on the PASS Quiz Bowl a few years ago. I've also spoken at SQL Saturdays she organized, and have spent a good deal of time with her at SQL events where she was always active in helping out in any way she could.  On the ERC there were times where issues caused people to "get their dander up", and Wendy was instrumental in keeping the discussions professional and focused, and helped us get to an outcome we could all agree upon.  She not only did a great job getting the Chicago SQL Saturday off on a great foot, but set up the organization so that it could continue successfully after she moved on.  That is a skill that many leaders don't understand - that of leaving the organization stable and healthy when passing the baton to someone else.  I believe she's done a great job with her past two years on the PASS Board of Directors, and will continue to do so on reelection.

Andy Yun
I am writing today to provide a Referral Statement of Support for Wendy Pastrick.  

For PASS, I worked with her to help organize SQL Saturday #291 Chicago.  She was the event's team leader & primary organizer.  In her role, she exhibited exceptional organizational skills, along with smart delegation capabilities.  She knew when to let other team members continue to complete work, and when to step in if someone needed assistance or fell behind.  Her communication was also very strong.  Wendy operated with an open ear, welcomed feedback and acted upon suggestions and areas that needed improvement.  
Wendy Pastrick's strong leadership played a critical role in making SQL Saturday #291 an extremely successful event.  

Tuesday, September 23, 2014

PASSion for PASS

I am running once again for the PASS Board of Directors. One of the questions in my Board interview by the Nominations Committee was "What is the biggest challenge currently facing the Board?" My answer could have included many things, but the top issue I see was highlighted by the current slate of candidates you have for this year's election.

Why are there only four candidates for the Board?
Why do people not want to run for the Board?
Why would you not want to give back to your community or become more involved in an organization that has given you so much be it training or networking or opportunity?

If you base perception of what it means to be a Board member on reading many of the more vocal critics of PASS, I can see how that can make it daunting. It is not easy to have your character, your motives and your decisions picked apart by people for every communication or path which is chosen. In that vein, I would like to clear up a few misconceptions about my involvement in PASS and my work status.

1. I am a DBA. My title is Data Platform Consultant. Majority of my work relates to performance tuning, high availability and more recently delving into the realms of APS and Azure. Yes, I do sometimes work in SSIS or (gasp!) SSRS and have even had some exposure to Analysis Services, but primarily and foremost I am still a SQL Engine DBA.

2. I have been very fortunate over the years to build an amazing network of friends, colleagues and technical experts. This is what PASS is to me - not an acronym but a community sharing their knowledge and supporting each other. I regret not blogging about my decision to accept the PASS name as it stands, without the words behind it. It had nothing to do with dropping SQL Server out of the name. PASS is a global organization - did you know that in some countries, it is actually illegal to call yourself a "Professional" anything unless you have been granted that designation by the local government? Trying to manage different org names for various countries is not a good use of our resources. I would have preferred we come up with another name, but PASS has so much branding already behind it, that route didn't stand a chance. I did make the suggestion, more than once, to come up with a separate entity name for the BA focus. No, I didn't have anything in mind but I did share my thought with the Board. (Example: Coinstar bought Redbox, but they now operate under an umbrella called Outerwall) I'm hopeful that using PASS is only a first step and we can come up with a more meaningful naming.

3. Yes, I now work for Pragmatic Works. Many of you who know me know that this was one of the toughest decisions I've had to make in a long time. From afar, it may appear that I was wooed away but alas, that is not the case. I found myself in a position where I needed to find new employment. Every person I talked to over a several week period suggested I really look at what I wanted to do. I want to work with PDW. "Have you talked to Adam?" No, I didn't - not for several weeks until it became clear that it wasn't fair of me to exclude them as a potential employer. I love consulting. I love learning. I've found a place to work that promotes both, while also supports my efforts to maintain involvement with the PASS community. There is a reason there are so many amazing people who work with PW! I can assure you that Adam and I understand working on the Board has nothing to do with our employment at the same company. We were on the Board prior to my employment here and I will not be changing the way I think or involve myself just because I've changed jobs. If Adam didn't respect me for my own decision making ability and thought leadership, then PW would not have hired me anyway.

4. Groupthink. This one is tougher. As a Board member, each person has their own portfolio. We don't micromanage the other portfolios. We come together at Board meetings and give each other status reports or present ideas. I take the criticism for anything that comes from "PASS" whether I had any direct involvement or not. Not everything is a vote. Not everything is a discussion. Sometimes, things happen and I find out about it maybe hours or days before the rest of the Community. If there is any groupthink happening, it would be between a portfolio owner and the HQ counterparts. I can tell you that my Community Evangelists know what direction I'm planning and they make suggestions and have questions and we involve others, too. I was very open with the Chapters and Regional Mentors during the Chapter Agreement rewrite process. I moved my deadline back three times to ensure they had ample time to respond and we made a lot of additional changes based on that feedback. Was I swayed by groupthink? Absolutely - from the community.

I will always be involved with PASS in some fashion or another. With any luck, I will be able to continue to encourage people to step up and become involved. PASS needs volunteers. PASS needs YOU - yes, YOU. This organization is more than the sum of its parts, it is #sqlfamily. I am forever thankful for the support and encouragement I get (especially in these past few days) from those friends and colleagues.

As with everything else politically related, I want to encourage you to make up your OWN mind about who you want to vote for and why. Each candidate has their information and application posted on the Elections website. Check us all out. Decide who you want on the Board, but make it your decision.

Just make sure to Vote!

Smiles,
Wendy

Tuesday, September 9, 2014

#Tsql2sday - Passwords


It's another installment of the always fun and informational #TQL2sday series! This time, I'm going to share my super secret method of creating passwords AND being able to remember them. I know, it's impossible, right? How can you possibly have a unique password for every account, plus keep it secure and at the same time fulfill all those darned requirements? Well, dear friends, it can be as simple as KISS.

Yes, there is is: Keep It Simple Stupid Silly

No actually, that it only part of the story. Here is the key: come up with a meaningful sentence that you can recall easily. 

Here is my recipe:
Step 1: "I cannot remember my password for this site!" 
Step 2: Take the first letter of each word: icrmpfts 
Step 3: Substitute captials/numbers where it makes sense: Icrmp4ts
Step4: Add punctuation if needed: Icrmp4ts!

This way, you are really recalling a phrase instead of a word or a series of characters. I have a few key phrases I like to use and they have, so far, served me very well.

Thanks again to our Host Sebastian Meine (B|T) and Adam Machanic (B|T) for coming up with this idea in the first place!

Monday, May 6, 2013

It's time for T-SQLTuesday #42! The Long and Winding Road

It's May - hopefully Spring has finally found you wherever you may be! I know it's been a rough one for much of the US this year (really, SNOW in Kansas City in April?!? My grandmother is not pleased, to say the least.) and weather patterns all around have been getting more and more abnormal it seems. I'll admit it, I love living in a place where the seasons flow from winter into spring then summer and fall and back around again. Okay, great, what does this have to do with T-SQL Tuesday, anyway?

Here's what I thought it would be fun to share with the community this time around - we all experience change in our work lives. Maybe you have a new job, or a new role at your company. Maybe you're just getting started and you have a road map to success in mind. Whatever it is, please share it next week, Tuesday May 14th. Make sure you note what technologies you find are key to your interests or successes, and maybe you will inspire someone to look down a road less traveled.

One thing I think would be great to see included in these stories is to hear about how you always thought technology "X" was so awesome, and either it lived up to the hype for you, or maybe it morphed into something else over time. Let's make these stories about the tech and how that has led you down a certain path.

(Stealing the 'Fine Print' from Bob Pusateri @SQLBob)

The Fine Print


  • Your post must be published between 00:00 GMT Tuesday May 14, 2013 and 00:00 GMT Wednesday May 15, 2013.
  • Your post must contain the T-SQL Tuesday logo at the top (see above) and the image must link back to this blog post.
  • Trackbacks should work, but if not please put a link to your post in the comments section so everyone can see your contribution!
Don't forget - you can use the #tsql2sday hashtag on Twitter, too.

Huge thanks once again to the incomparable Adam Machanic (@AdamMachanic) for the T-SQL Tuesday format. This is what #sqlfamily is all about!

Tuesday, October 23, 2012

As David Bowe said: Ch-ch-ch-changes

I'm excited to make two big announcements! First, I have swtiched jobs. While I'll still be working with SQL Server, and I'll still be using my DBA skills, I'm making a switch over to the Business Intelligence side of the fence. I've always had a soft spot for really making the data useful to the people (okay, call them users if you like) who need to work with it day in and day out. I realize that Excel has been the go-to for data manipulation for many years now, and it's not going anywhere. What I find exciting is that SQL Server continues to evolve the ETL and reporting tools to make better use of Analysis Services. I'll be working with several amazing people in the Business Intelligence community at BlueGranite, a Michigan based company. Yes, I have ventured back into the realm of consulting. As Aaron Lowe once said, "once you have worked as a consultant, it's hard to go back" (or something very similar anyway).

This new role brings many exciting opportunities ahead to learn so much about Business Intelligence and Analytics. I am really fortunate to be working with people like Rob Kerr (@Robkerrbi) and Josh Fennessy (@JoshuaFennessy) and Garrett Edmondson, to name just a few. While it may be challenging to work out my home office in the chilly basement, it's been easy enough to stay connected with all of the technical options now out there (Lync, Skype, Twitter) so I don't feel isolated really at all.

The other piece of amazing news I have is that I will be joining the Professional Association for SQL Server (PASS) Board of Directors this coming January! It is a two year term, and while I'm not sure what tasks will be assigned to me, I'm very much looking forward to serving the community and growing PASS. I invite you to leave comments or send me emails with any issues you feel should be addressed by the Board at any time. We need the input from the community at large to know where we need to focus our efforts.

I hope to have an opportunity to meet you at the PASS Annual Summit in Seattle. If you will be there, don't hesitate to stop me and say "Hi" at any time. I will be at all of the meetings on Tuesday(SQLSaturday roundtable, Regional Mentors meeting and Chapters meeting) plus you can find me at the Lightning Talks on Wednesday or the WIT Luncheon on Thursday. While I'm not a current sitting Board member yet, I will be at the Board Q&A on Friday as well in the audience (I haven't missed one yet)....and, if all else fails, I may run into you at #sqlkaraoke on any given evening.

One of my personal goals this year is to make it out to at least one User Group meeting in my region or surrounding cities each quarter. I definitely plan to make it up to Wisconsin and hopefully can also get out to Indianapolis. With the new job, I'm confident that hitting the Western Michigan meeting will also be in the cards, and I would like to make it down to my hometown of St. Louis as well. I'll be contacting the groups to find out if there is some way I can help out when I stop by.

2013 is going to be an amazing year, for sure!

Wednesday, October 10, 2012

Running for the PASS BOD: doing it for the Bacon

You may have heard I'm running for the Board of Directors for PASS. Why, you ask? I'm in it for the bacon, of course.

Wait, you say, I didn't know Board members got bacon as a perk! Well, they don't, sadly. It sure would be nice, though. Okay, so if there isn't bacon, then what is the motivation? Looking from the outside inwards, you might think people run for the Board because they have masochistic tendencies. Really, how much abuse can one person take? In the past few elections, it seems there has been one thing or another that the BOD has taken a beating over. (Fortunately, as it turns out, there really isn't so much to be concerned about.)

Okay, all kidding aside, for me it's really about giving back to the community. Having spent close to 10 years with PASS, I have seen so much growth - and with it some missteps -  but even more spectacular wins in that time, such as 24 Hours of PASS. Having the opportunity to contribute to the current state and future of the organization is surely a challenge and it is one I am eager to take on. Over the years, I have contributed at many different levels from Chapter Leader (both physical and virtual) to special task committees (Election Review Committee, post 2010 elections) to running SQL Saturday events. These widely varied experiences make me a great candidate for your Board of Directors as I can bring both lessons learned and future vision to the organization.

As my running mate Allen Kinsel has so aptly stated: Campaigning is Hard. You may have not heard as much from me as some of the other candidates. I'm not known to go around shouting my own praises, or asking people for votes, or standing on a soapbox touting an agenda. However, I'm not a quiet person, either. What I am is a person who cares very much about PASS, about the people who are our members, and the future of our organization. I humbly ask you to lend me your vote so I can not only continue to contribute but have the opportunity to do so at the Board level.

But what about the bacon? Oh, yes, if I should be elected to the Board this year, that would be as sweet as having a whole plate of bacon! (and I might even share...)

Even if you don't know me, take a few words from some others who do and were kind enough to endorse me. Fellow Women In Tech superstar and MVP Jen Stirrup had this to say about her choices in the election. You can also find two additional interviews with me from Denny Cherry's People Talking Tech and DBAs At Midnight show with Sean and Jen McCown. Plus, I've had much encouragement and guidance from these three people who support me as a candidate:

Kevin Kline (Past PASS BoD President): "I had the pleasure of meeting Wendy on her first trip out to Seattle to attend a PASS Summit.  Wendy was striking then, and now, for her contagious enthusiasm.  Wendy doesn't settle for idly soaking up the benefits of other people's hard work.  She is one of those rare persons who starts to consider how to give back right away.  Wendy immediately saw the benefit of PASS community and went to work right away to bring that benefit back to the Chicago area.  Wendy isn't afraid of hard work or of planting small seeds today, then painstakingly investing the months and perhaps years needed to bring those seeds to fruition.  This tenacity and attention to the long-term is amply demonstrated in the outstanding SQL Saturdays that Wendy oversees in Chicago.  Every speaker I know wants to be at Wendy's event, not because it is in Chicago, but because it is Wendy's event in Chicago.  I give my full support to Wendy's nomination for the PASS board of directors, convinced in the strength of her character, and confirmed in the value of her talents.  -Kevin Kline, PASS President Emeritus 2005-2008."

Allen White: "I've known Wendy for three or four years now, having worked together on the Election Review Committee and were partners on the PASS Quiz Bowl a few years ago.  I was impressed by her contributions to the conversations we had on the ERC in putting together the rules for the PASS Board elections process, as the issues were critical to the public perception of the integrity of the elections process.  We had discussions that could have easily become ugly, and she always helped keep them objective and positive.  This skill is critical to serving on a board with such a (necessarily) diverse makeup.  I also was a speaker at the Chicago SQL Saturday #67 in March, 2011, where Wendy led the team putting together a great event that had something like 400 attendees.  An event of this size needs a solid leader to keep everything running smoothly, and Wendy managed it with a smile on her face the whole time.  Personally, Wendy and I have become good friends, and she allowed me to leave my car at her home when in 2010 I took the train from Chicago to Seattle for the PASS Summit, and when my return train was delayed by 5 hours, she drove into downtown Chicago to pick me up at the station, almost an hour drive each way.  Her PASSion award indicates the level of support and commitment to PASS she always exhibits, and the fact that she's been nominated for MVP indicates the support she has from the community.  I truly believe she'd be a great board member based on her past accomplishes and her ability to get people with disparate views to find common ground and work out a solution that benefits the entire community."

Kevin P. Davis: "I have worked with Wendy for the past year, and I have been immensely impressed with her and her work.  She has led multiple cross-team small projects in her role as Database Administrator, and I have worked with her closely on these.  Wendy is capable of organizing large efforts even with shifting priorities and timelines.  She is easy to work with, gregarious and contagiously enthusiastic.
That enthusiasm bleeds over into a rich life outside of work, but still in the development community.  She demonstrates commitment to both her own growth and the growth of others through frequent conference appearances, not just as a speaker but an organizer.  Such enthusiasm and commitment is rare and refreshing to see.  The PASS Board of Directors would benefit from Wendy’s energy, and I wholeheartedly endorse her for the position."

Friday, March 2, 2012

SQL Saturday Roadmap!

My Spring/Summer is just bursting with SQL Saturday events! It's amazing how many there are to choose from, but alas, that comes with some tough decision making at times.

As I type, I'm headed off to SQL Saturday #109 in Mountain View, CA. I'll be representing both Women In Technology and Idera ACE groups this weekend. I'm really looking forward to working with fellow PASSWIT members Denise McInerney (twitter), Meredith Ryan-Smith (twitter) and Jen Stirrup  (twitter) on the Luncheon panel. We will be discussing: Why Do Women Matter in the Tech Community. I'm also looking forward to making a new friend in the 4th member of the group, Nikila Srinivasan (twitter)!
Later in the afternoon, I get the chance to talk about one of my favorite features in SQL Server, Transactional Replication (I know, I'm such a geek....)

The best part of any SQL Saturday is the networking - so if you're around, please say "Hi", I love to meet fellow SQL people!

In April, I'll be heading to Houston for their SQL Saturday. They haven't released their schedule yet, but I'm sure it will be an amazing lineup.
Alas, I won't be able to make the Madison, WI event since I'll be in Houston already. Bummer.

Then, come May 19th, we're back for our 3rd Annual SQL Saturday in Chicago!

Also on the horizon is Indianapolis at the end of July. I'll be helping out with the Women In Technology panel there, too.

Wednesday, February 8, 2012

Hope for the Future

In the locker room at the gym the other day (yeah, again, another gym story!) I witnessed a conversation amongst three high school aged girls. It went something like this: Sue: You're taking Algebra, right? Amy: Oh, of course! I'm having a hard time with squares though. Rachel: Squares? Oh, those are so easy! Sue: But cubes are more fun, I mean, squares are easier, but I like cubes. Rachel: I don't know, squares and cubes aren't too bad - it's the radicals that give me trouble. Amy: I don't get radicals at all. Sue: I just love solving problems with cubes! Rachel: As long I don't have to deal with radicals, I'm fine. Rachel: Does my hair look stupid? If I could have hugged them for having such a frank conversation about an Algebra class, I would have! Best not to be labelled the 'creepy old lady' though... I was so happy to hear very typical girl teenagers talking about math, and worrying about their hairstyle, I could have just popped. The future of WIT is alive, I say! All names are made up...in case you were wondering.

Thursday, February 2, 2012

After a lunchtime workout, I looked in the mirror to notice one of my earrings was missing.
There was a frantic search which included my gym bag, the floor all around where I was changing, and a conversation with the other person in the locker room. She also joined in the search, but to no avail. The earring could not be located.
My search expanded to the area around the treadmill I had used, which now had another patron. She was also very kind in helping me search the area thoroughly. Alas, still no earring.
My only choice remaining was to retrace my steps and hope against the odds it has dropped somewhere near my car, or on the walk to/from the car and buildings. Sadly, none of these places revealed the location of my missing earring. Now, we all lose things from time to time, and often we have to resign ourselves to the fact that we may never get it back. This particular set of earrings was made especially for me for my wedding day. The emotional value far outweighed the actual value of the item, so I was eager to keep hope alive.
For all I knew, it could have fallen off any time from the time I put it in that morning until I had happened to see it missing. That was a span of many hours, and it could be almost anywhere.
I continued to retrace my steps back to the office building and decided that it was at least worth asking at the front desk if anyone might have chanced to find it.
As I approached the desk, I took off the remaining earring and showed it to the attendant, knowing it was a long shot. To my utter surprise, his face lit up, and he turned around and pulled my missing earring out of the inbox! To say the least, I was amazed - and very happy.
I have no idea who the person is who returned it, or even where they found it. All I can say is a very heartfelt THANK YOU to you for doing so. It was a small thing to you, but a very important thing to me. How many times have we seen something we *could* have done something about, but felt that someone else would do it, so why bother?
Please remember that in your daily routine even something small and insignificant to you could mean very much to someone else. Thank You!