tag:blogger.com,1999:blog-7663979858060068082024-02-07T18:04:07.674-06:00Life, The Universe and SQL ServerWendy's musings on anything that comes to mind today.Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.comBlogger64125tag:blogger.com,1999:blog-766397985806006808.post-17197610198348849392016-10-17T22:44:00.000-05:002016-10-17T22:44:17.947-05:00NOT 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-31576406026554427002016-10-05T10:39:00.000-05:002016-10-05T14:04:36.207-05:00Global Growth for PASSI 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 provideWendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-66546913524361340432016-10-05T10:02:00.000-05:002016-10-06T08:41:02.113-05:00Election season! Please vote for PASS Board of Directors Oct 5-11It'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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-73224050897403734002016-05-10T08:49:00.002-05:002016-05-10T09:19:38.710-05:00#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!
Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com2tag:blogger.com,1999:blog-766397985806006808.post-41039129430127688252016-04-18T12:28:00.000-05:002016-04-18T12:30:22.692-05:00It'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:
Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com5tag:blogger.com,1999:blog-766397985806006808.post-7209597720312283742015-02-13T10:44:00.000-06:002015-02-13T15:37:38.182-06:00PASS presents Business Analytics Conference April 20-22I 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com1tag:blogger.com,1999:blog-766397985806006808.post-91106834678029928472014-11-11T12:56:00.004-06:002014-11-11T13:11:41.354-06:00TSQL 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-19709272190285864062014-10-14T14:58:00.000-05:002014-10-14T14:58:14.218-05:00Ada 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-40487956503325707582014-10-06T17:43:00.003-05:002014-10-07T09:35:27.351-05:00SQL Server in Azure : Additional StorageWhen 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-34497513693818846072014-10-01T18:29:00.000-05:002014-10-02T13:54:09.359-05:00PASS 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-68744018990976774502014-09-24T12:01:00.001-05:002014-09-24T12:02:43.917-05:00Thanks 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-76865448392850166992014-09-23T12:55:00.001-05:002014-09-23T12:58:55.245-05:00PASSion for PASSI 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?
Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com1tag:blogger.com,1999:blog-766397985806006808.post-71374581750618958692014-09-09T15:59:00.001-05:002014-09-09T15:59:15.465-05:00#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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-58690290850145721942013-06-27T12:44:00.000-05:002014-01-17T22:19:16.007-06:00Monitoring Virtual Machines for the DBAHere is the list of resources for the webinar from the Performance Palooza on June 27, 2013. Thank you for tuning in!
VMware Performance Counters
http://communities.vmware.com/docs/DOC-3930
http://www.mssqltips.com/sqlservertip/2512/monitor-your-virtual-sql-server-environment-part-4-of-5/
http://www.mssqltips.com/sqlservertip/2806/viewing-vmware-counters-in-perfmon-for-sql-server/
http://Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com1tag:blogger.com,1999:blog-766397985806006808.post-19520112201617826492013-05-06T14:30:00.000-05:002013-05-06T14:30:35.762-05:00It's time for T-SQLTuesday #42! The Long and Winding RoadIt'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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com28tag:blogger.com,1999:blog-766397985806006808.post-13098916411334701202012-10-23T14:27:00.002-05:002012-10-23T14:39:36.233-05:00As David Bowe said: Ch-ch-ch-changesI'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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-42734963086419778752012-10-10T21:24:00.000-05:002012-10-11T09:26:59.106-05:00Running for the PASS BOD: doing it for the BaconYou 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com1tag:blogger.com,1999:blog-766397985806006808.post-75348323909689177702012-03-02T13:32:00.001-06:002012-03-02T13:32:34.358-06:00SQL 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 Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-21866395403364623052012-02-08T17:09:00.001-06:002012-02-08T17:09:58.370-06:00Hope for the FutureIn 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: Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-84111013424907732172012-02-02T14:59:00.000-06:002012-02-02T14:59:24.555-06:00After 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, Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-25981412598510615982011-11-11T09:47:00.001-06:002011-11-11T09:52:33.884-06:00SQL Family is......not having to explain what your job is when you tell someone you're a DBA...being a more valuable asset to a company because of the readiness of others to share their expertise...meeting a friend for the first time in person...having a shoulder to lean on when things get tough...knowing there is someone out there who has encountered this problem before and they are willing to share their Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-91826178706811675202011-10-07T14:20:00.000-05:002011-10-07T14:20:59.567-05:00Ada Lovelace Day, October 7It's become an annual tradition, on October 7th to celebrate Women In Technology and honor the legacy of Ada Lovelace. This year, many are talking about the women who have influenced them in their careers.
I plan to do the same in this post, but probably not honoring the people you would at first think.
As a member of the SQL community, there are the women who are at the top of all of our lists:Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-91018398002196490342011-09-17T09:00:00.000-05:002014-10-14T09:23:02.596-05:00Links for PresentationsRead Dirty To Me...Isolation Levels in SQL Server
http://www.littlekendra.com/2011/02/08/isoposter/ (Kendra Little - FREE Poster!)
http://www.littlekendra.com/resources/isolation/ (Excellent reference page)
http://michaeljswart.com/?p=604 (Transaction Phenomena)
Nolock info:
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
http:Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0tag:blogger.com,1999:blog-766397985806006808.post-21342138514263817762011-09-16T13:00:00.000-05:002011-09-20T19:53:17.681-05:00PASS Summit MemoriesAnother #memeMonday
Yeah, I know...It's Friday. Deal.
**Authors note: I scheduled this to post last Friday, apparently that did NOT happen.
All week, people have been posting some of their favorite memories from the PASS Annual Summit. I am fortunate that for me, there are many to choose from. Some, people have heard me tell a few times, others I'm under strict NDA, so you'll just have to Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com2tag:blogger.com,1999:blog-766397985806006808.post-84071112710050517882011-09-15T23:09:00.004-05:002011-09-16T00:07:05.211-05:00On Tour...Hope to Meet You Soon!There have been a number of changes in my career these past few months, and one of the more exciting things for me was being picked to join five other SQL Server community members as part of Idera's ACE program! I am very happy that they will be assisting me and the others in making it out to more community events around the country.
So, where can you find me? Take a look!
Saturday, September Wendy Pastrickhttp://www.blogger.com/profile/12855857844896595551noreply@blogger.com0