PASS – Meanderings

As most people reading this would know…the PASS organization is in a state of crisis now following the decision to go virtual. We are in a place where we are obligated to get very high attendance #s for the virtual summit, or risk going under if not. While on the face of it this seems like a financial crisis, I believe that is only one aspect of what it is..some of these wounds have been festering a long time and now broken open and gone septic. Many people have written posts on the financial part/association with C&C. I don’t have a head for accounts and am not going there. I will address what it means to be a PASS volunteer and what it has come to mean, over time.

Being a volunteer is hard, thankless work. When I started my sql saturdays at Louisville, I was the only person on the team with community association. I had volunteers, but they were people who would do what they were told to do, not the ones handling money or doing other publicity for it. I did this almost 100 percent on my own for 8 years, after which two dear friends who are community members came in and started to take over. I was burned out and tired to the bone doing it although I got many valuable contacts from doing it. I was also co running my user group at the same time, with similar challenges. I’ve also done plenty of other volunteering with PASS over the past 20 years that have helped me grow as a person, and helped enormously with my career. BUT it has also shaped my thinking a certain way, that seems a little dated for today’s world. My thinking and my rules/values by default run as below.
1 You have to work and contribute a lot to be seen. I mentally associate this with actual grunt work, significant hours, running around, searching for speakers, sponsors, presenting, helping and coaching people and such. So anyone who is newer and wanting recognition typically get this line from me – to pick up and do something and keep doing it a while until you are seen as worthy/respectable/sincere volunteer.
2 You have to support the organization at some level even if you disagree with their decision making. Like, a ‘core loyalty’ is needed, without which it is really difficult to get people to understand where you’re coming from when you have feedback. You can’t say ‘I hate PASS and its time they were gone’ and simultaneously offer feedback on how to improve.
3 You have to be willing to risk speaking up and let concerned people know at PASS that whatever they did wasn’t ok and why.
4 Have some heart, and be willing to forgive what other volunteers, including people on the board did – since we are all doing it for free, because we care and have many personal obligations to cope with.

In today’s world, none of my above values are holding up. Based on experiences using those lines – a lot of people get and want quick recognition. A lot of people think loyalty is about being brain washed and kool aided. A lot of people do not want to speak up anywhere for fear of being bullied or drawn into long winded arguments that end up making them feel defeated and regretting it. A lot of people think the board is like the White House, a huge static entity constantly making bad decisions that have negative impact. They don’t care to even know who is there, let alone forgive or think about why those people did what they did. Not all of these stances are right or wrong, but they exist and are impacting us a lot as a community.

In short, PASS has gathered ill will to an enormous extent that even those of us who were not part of any ill will are having significant challenges promoting the cause. Looking at some of the reasons why this could have happened –
1 Diversity issues – WIT is literally the only user group supporting diversity, they do an awesome job, but more sub groups are needed that actively push other causes – neuro diversity, LGBT, Racial inclusivity..everything. People from these sub groups feel their cause is not out there and acknowledged.
2 Old model of conferences and user groups – we did have online conferences with 24HOP (which was an enormous success when it started and one of its kind), but we did not keep up very well. The technical focus of PASS itself is very sideways skewed, after the move away from being a core SQL Server user group and conference. It seems a hotch potch of a lot of stuff broadly grouped under ‘Data’.
3 Speaker model – many speakers have asked about what they get in return for sessions. Advanced sessions especially need a ton of effort – and what they get in return does not seem to add up to it. Speakers need to be compensated well and not fed the line that the money coming in is going to other causes. That line is seriously old.
4 Weak anti harassment policy – Atleast two community leads I respect enormously left on grounds of this. It is becoming standard practice too everyone to adopt a strong policy and stand up for what it is.
5 Affliations for user groups and sql saturdays – The value of the affiliation, aside from a website has been seriously and repeatedly questioned. We have run some day long events virtually from our local user group here, and not used any tools PASS provided. We have had considerable success there and there is no reason that cannot continue. Sponsorships are also mostly local and enough to make a decent local event happen. In short, this affiliation is meaning less and less by way of value.

So..what next?

I wish for PASS to survive. Or to put it another way, I have to train myself to imagine it won’t exist since it was such a significant part of my life and am not quite there yet. It gave me a platform where I was seen – as a woman, as a person of color. That is not easy to find everywhere. I have been among other non affiliated user groups – it is really hard to get people to see who you are and sometimes they are so white male dominated that you don’t even exist even if you are physically present. I am not sure just saying PASS has to go and ‘lets do things locally’ is going to fix that problem. I will absolutely miss the big party that is the summit, but that is hardly on top of the things I will miss.Getting seen as a community member who added value and worked hard tops that, and many volunteers like me who are not mvps or even speakers in high standing are going to miss that, A LOT.

But, sometimes changes are needed even though they seem difficult to get used to. Pumping money into a system with all problems as above is not going to work very well. Or it is going to be a question of time, again, when a crisis comes up and everyone is re evaluating the need for their existence.

I wish for a new PASS, maybe smaller or less powerful, but with a clean slate and more acceptance from various parts of the community. I wish for more acceptance for free speech and more respect for volunteering in general. I wish for people to be seen and respect regardless of age, ethnicity,religion,sexual orientation or gender in this community. How all this will happen – I really don’t know. Maybe it will involve the organization to dissolve and re emerge as a smaller entity. I have hope and I hope for the outcome to be something meaningful for us all.

Deleting packages from SSIS Catalog

I was fortunate to attend a training on SSIS by my good friend and SSIS expert Andy Leonard(b|t). We already use the tool for ETL purposes where I work and I have mid level familiarity with it. I was able to pick up many best practices and tips and tricks. I highly recommend Andy’s training for those who want to get familiar with SSIS.
I will be blogging on a few things I learn on my journey to SSIS expertise. This is the first one. This came about as a result of wanting to delete a few packages from ssis catalog. We do not use these packages any more, and I wanted to clean them out from the project which resides on a few servers. I looked into a few ways of doing it.
1 Using SSIS to delete the packages from the project, and then re-deploy the project without the said packages on to the servers. This is probably the simplest way to do it.
2 Delete the entire project from ssis catalog and re deploy it.  This is not possible when you have some packages that are in use, particularly in production.
Both of these methods are discussed another SSIS expert Tim Mitchell(t) ’s blog post here

I found a third method that was a bit more elegant and easier to use for deployment – particularly in situations where the SSIS developer has limited access to production. This method uses varbinary project stream that is generated from the catalog.  

1 I have an SSIS project with 3 packages as below.

2 I deploy this project to my development server from SSDT.

4 Now, I delete the packages I do not need – package1.dtsx and package2.dtsx. My project looks like below.

5 5 I repeat step 2 and redeploy the project to SSIS catalog on my development server. This project does not have the packages I do not need. I can push the same to production using scripting as below.

6 I generate the varbinary stream for this project using below script on development server, where it is already deployed.

USE SSISDB
GO
DECLARE @ProjectStream TABLE (Stream varbinary(max));
INSERT INTO @ProjectStream
EXECUTE SSISDB.[catalog].[get_project]
@folder_name = N'LearningSSIS',
@project_name = N'Integration Services Project1';
SELECT  CAST('0x' + CONVERT(varchar(max), stream, 2) as XML)
FROM @ProjectStream;

7 I can cut and paste this into my deployment script as below:

USE SSISDB
GO
DECLARE    @folder_name nvarchar(128) = ' LearningSSIS',
@folder_id bigint = NULL,
@project_name nvarchar(128) = 'Integration Services Project 1’,   @project_stream VARBINARY(max) = xxxxxxxx,
@operation_id bigint = NULL,
@message nvarchar(max);
--Create the folder if it doesn't exist
IF NOT EXISTS
(SELECT 1 FROM catalog.folders AS f WHERE f.name = @folder_name )
BEGIN
    PRINT N'Create folder for ' + @folder_name
    EXECUTE [catalog].[create_folder]
        @folder_name = @folder_name,
        @folder_id = @folder_id OUTPUT;
END;

PRINT N'Deploy project ' + @project_name
EXECUTE [catalog].[deploy_project]
    @folder_name = @folder_name,
    @project_name = @project_name,
    @project_stream = @project_stream,
    @operation_id = @operation_id OUTPUT;
SELECT @message = om.message
FROM internal.operation_messages AS om
WHERE
    om.operation_id = @operation_id;
IF @@ROWCOUNT > 0
BEGIN
    PRINT @message;
END GO

8 Run this query on production (or get the deployment process to do it) – results as below.

9 If I look at the catalog on production server now, I can see that the packages I did not want are gone from there.

Learning Postgres:Installation

I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of this platform and decided to write some blog posts on it. I will be focusing quite a bit on how this compares with SQL Server as I go along and hope it will be useful.

PostGreSQL is an open source based relational database – it is easy to download and install from here. I chose the version available for Windows since mine involves a comparison with SQL Server on Windows and this is easier. The install is really simple and one has to click through screens as below:

The first option is the database engine. The second, pgadmin 4, is the PostGresQL equivalent of SSMS. We can use Azure Data Studio as well but would be good to have this too to make a comparison if needed. Stack Builder is an install utility that helps with add-ons to PostGreSQL. Command Line Tools can come in very useful for many commands. So in short, it is good to have all these installed.

The second option asks for a password for SA equivalent of PostGreSQL. Be sure to record this in the password vault as there is no secondary mechanism to recover if it is lost.

The default port for PostGreSQL to listen on is 5432 so unless something else is using this port it would be best to leave it as is.

Locale is similar to collation – but is more than just that. It is a combo of preferences that are specific to country/location. There is a detailed explanation of what it includes here. I left it as default.

After this the engine will install. It would be good to reboot once the install is complete. Then, type pgadmin and the prompt will appear for you to enter the SA password created above. Once that is entered, you should see a screen with the master ‘postgres’ database as below. In the next post we can step through server settings and creating a database.

Telecommute Resources

This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter conversation on subject. This is not an attempt to promote any way of working, nor does it mean you need all of these resources to telecommute. It is entirely any individual’s call on what they need/afford to make working from home a satisfying experience.
I will start with my own experience. I am a minimalist when it comes to gadgets. I go into an office most days. When I work from home my needs are limited to my laptop, a keyboard and a mouse and a simple headset with a microphone. I used to have an extra monitor but it did not have any glare adjustment with made it hard to use. But most of us need a bit more than just a laptop – essentials seem to be monitors, headphones, standing/sitting desk and chair.
Monitors: Some people seemed to prefer 4k monitors like this one. There was a great suggestion by Monica Rathbun(b|t) on a portable monitor. If we don’t want to or have a lot of money the cheaper monitors like ASUS may be helpful. If you are the kind to have all your work displayed on a large screen – there are big ones like this. These cost a lot of money. By and large most people were in agreement that an extra monitor seems to add to one’s comfort and ease while working, so just having a cheap one might help in that regard.
Headsets: The options suggested were Plantronics , Yeti, and Surface noise cancelling headphones. My personal favorite has been Bose.
Buck Woody (b|t) and John Morehouse(b|t) also suggest Jabra speakers as well.

Keyboards and Mouse can be found anywhere for cheap. I personally like the Amazon essentials line. I have also found good options on sale at Staples or Office Depot. Majority laptops come with a built in camera that one may need to show demos or share screen during conference calls.

Spare power cords are absolutely necessary, as pointed out by Lisa Bohm (b|t)and Kellyn Pot’Vin-Gorman(b|t). Kellyn also has suggested a 1 TB drive and having a set of accessories you can pack and move with quickly.

Furniture including chairs and sitting/standing desks are personal with regards to comfort level and easy to find. I am fine with an ordinary folding table from walmart and a chair I found many years ago on Office Depot. It is important to find what works for your body/how many hours you are going to be standing or sitting and so on. A lot of health conditions can be created by improper desk arrangements.

Lastly, aside from gadgets, telecommute is a radically different way to work. It is a privilege for us to have it in tech – the vast majority of other professions in the world have to be worked on on site and the vast majority of people have to travel to work. But in order to enjoy and get the most out of it, self care is absolutely essential. I worked for nearly 6 years so I have some idea of what kind of needs there are :
1 Do not under estimate your need for being around real people. For many, the convenience factor and not having a commute is so exhilarating that we completely lose sight of our needs in this regard. Being around other humans creates a sense of connection and warmth that computers cannot absolutely provide. Find time, atleast at lunch, to dine with fellow human(s). Find office spaces for shared work if that is possible. Go to user groups or other meetings to be around real people.
2 Take frequent breaks. Buck Woody and Tim Ford mention having pets that allow for this to happen .It is important to step outdoors and get some fresh air/sunshine in. Having a fitness watch can help to remind one of this.
3 Start and end on time and maintain physical hygiene. I have never relished the ideas of working in jammies or nightwear much. It helps to start the day showering and clean set of clothes. And ending the day and calling it done. These are rituals that help sustain balance and create boundaries, which are very necessary.

Hope this was helpful and thanks to everyone who contributed.


T-SQL Tuesday 123: Life Hacks to make your day easier

This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life simpler/easier. Two of mine are as below.
1 Before I accepted the current gig I am at – I worked several years in telecommuting positions. I found myself struggling in two ways with this – one, not getting enough walking/exercise, and two, not being around real people. I liked the benefits of telecommute though – which is, no commute and the ability to eat warm home cooked meals for lunch. I wanted to combine benefits of both – so for the next gig, I rented an apartment that is walking distance from work. It was not cheap – but got me all the benefits I needed. Fast forward – two years and this has been a wise call. I am loving the combined benefits I get and feel healthier, physically and emotionally. This might not work as a solution for all jobs but it does for this one and am grateful.
2 We all struggle with finding time to learn. About two years ago I discovered the joy of podcasts. I made it a point to listen to a tech podcast during my evening walk and was able to get both exercise as well as learning done. But I started to run out of material there – not that there is any shortage of podcasts in general but my focus was data specific tech podcasts and there were not that many to feed my needs on a daily basis. This year I decided to go one step further – I put a laptop on the dining table right in the middle of my living room. I have a long hallway that i can walk up and down on, and watch a pluralsight course, or a pass summit recording as I walk. This does not work for very demo-heavy recordings, but it does for a lot of lectures and am getting a lot of learning done this way.

I think we all need ‘hacks’ to make our lives easier and maximise value and pleasure we get out of doing what we do. Thank you Jess, for hosting.

T-SQL Tuesday #122: Being authentic

This month’s T-SQL Tuesday is hosted by Jon Shaulis – the topic is an evergreen one, dealing with Imposter Syndrome. I learned of this word via Mindy Curnett a.k.a @sqlgirl in one of her presentations. I was aware of it in a different way for a long time. Trauma victims know what it is better than most others. To deal with trauma, especially as a kid, one learns to dis associate or pretend it is happening to somebody else. It is a form of survival since you don’t have the necessary skills to deal with it as a child. Entire fantasies can form around such disassociation, many people do not recover from it. I knew I had it because I was given to frequent day dreaming as an adult. I was rarely present in the moment and always carried a perpetual sense of loss about me. In essence dealing with Imposter Syndrome is about being in the present and feeling life as it happens. Below are my strategies.
1 Mindfulness practice – breathing and meditation.
2 Using present tense as often as i can in conversation – this is an excellent tip I got from somewhere. If other tenses are needed use them and consciously return to the present.
3 Keeping track of when I disconnect/wander off – typically triggers that cause this.
4 Find moments when I am in the moment – and try to make more of these happen. I was surprised to see how trivial some of these ‘moments’ where – I remember them because I was fully prsent in body and mind when it happened.
5 Read and get more tips whenever possible. I read an excellent book on this recently. It is called ‘Presence: Bringing your boldest self to your biggest challenges‘ by Amy cuddy. The author went through a traumatic accident and describes her process of recovery and finding her sense of connection/meaning/authenticity through it. Her tips include posture (she has diagrams on how to develop good posture), Surfing,smiling and singing to ourselves, and giving ourselves tiny nudges of encouragement constantly.

Every person wants to be seen for who they are .Being authentic and present is the biggest gift we can give ourselves to handle imposter syndrome. Thank you Jon, for hosting.

Epic Life Quest – 2020 Update

I started keeping a written record on bigger goals in life from the year 2018 – following the example set by Steve Jones and Brent Ozar. This method of keeping track is called ‘Epic Life Quest’. I wrote my first blog post on it in 2017, and then another in early 2019. This is my post for 2020. Below are the goals I set and how or if I met them.

1 Finish off Microsoft Big Data Certification. I am already working my way through it. I will devote every saturday evening to it and hope to get it done.
Wheeee….the certification is gone 🙂 Considering the track record Microsoft has until now with certifications I think it is not longer valid to make them a goal in of itself.
2 Continue with watching pluralsight/pass summit videos and listening to podcasts whenever time permits.
I’ve done well in this area, although I could do better. Pluralsight was hard to dedicate time to. This year, I made a change. I bought a galaxy tab and keep it on my living room table. I have a rather large living room and walk up and down there as part of my fitbit goal in the evenings. I usually listen to podcasts while I walk – this year, am going to turn pluralsight videos on instead. And keep weekend for podcasts. I think this will help me find the necessary time as well as get some good learning in.
3 Complete writing second book I have committed to. 
I went about half way down the road with this, learning about graph data and the feature in SQL Server. But the feature did not evolve to the extent expected and was not book worthy. But I learned a tremendous lot about trees/hierarchies and graphs while working on it. This learning will be very useful for further blog posts/ug talks and so on.
4 Read two pages of a tech book every day evening with tea. I am intentionally keeping this goal very small and doable. This is also based on a few experiences with reading.
I failed miserably here. Not because of the goal but because I set it for mornings and am just not a morning person. Even though I live really close to work, I just get up in time to swallow some breakfast and get ready to get in. Also, am suffering some sleep trouble with mid age feminine stuff and it is really hard to predict a morning very well. So for 2020, there are no early morning goals.
5 Blog @ one post every two weeks – again, scaled down from one post per week and trying to keep it modest and consistent.
I could not keep up any schedule with blogging and most of my blog posts ended up to be community related or personal growth related. I did however, write 3 articles for SQLServerCentral and one for Simple Talk, which left me thrilled. I think if I find a juicy tech topic I will still stick with writing for one of these two sites instead of on my personal blog. It gets me more exposure, lots of interesting questions and some pocket money as well. 
6 I am planning on 4 tech events – SQL Saturdays at Raleigh, neighboring Charlotte, Louisville and then the PASS Summit towards end of the year. 
This happened. And this will be the same goal for 2020 as well. The only difference perhaps is that I plan to submit to speak as well at all events. I am unsure of submitting to PASS Summit or participating in Speaker Idol, which has been a longtime goal. It will depend on how I do health wise as well as how work/job and personal goals pan out. I leave it as a loose goal for now.

On personal front – 
1 I plan to continue with hiking and exploring national parks. I am planning a trip in Spring/early summer with some visiting family members.
I do not think an overseas trip will materialise this year.
Yes, this happened. Visited Colorado/Rocky Mountains as well as Smokies.
2 I plan to continue with healthy eating and exercising goals. 
Yes, Fitbit is happy. My allergies have gone up sky high so eating ‘healthy ‘ is not even an option. Am able to keep up with what I can eat and come home for a hot meal, both of which are blessings.

Goals for 2020 are as below.

1 Have one book ongoing to read. Alternate between a tech book and a book on personal growth. Blog book reviews so that others can benefit. Ideally, the time to read is a good 15 minutes to half an hour on the recliner after returning from work.
2 Listen to Pluralsight/PASS summit videos during evening walks.
3 Submit at least one article to SQLServercentral or SimpleTalk every month.
4 Keep weekends free of tech stuff or social media.Ideally, this is time to do some artwork/cook and clean/read something fun and various activities that help rejuvenate.
5 Keep up physical activity and eating habits.
6 Plan to visit one national park or another country in spring/summer, and 3 week vacation in India with family during the holidays.
7 Attend SQL Saturdays Louisville,St Louis,Raleigh,Charlotte and PASS Summit. My goal is to attend these events regardless of if or not am chosen to speak.

My learning goals include – in-depth Query Store and Xevents, R Programming, some SSIS and SSAS and if time permits some C#/F#.
On the art side – have taken up a rather ambitious cross stitch project and loving every minute of it. Plan to take this to completion.

That is my rather simple goal list. Hope to live through it. Wish everyone a happy new beginning in 2020!

T-SQL Tuesday 121 – Gifts received – Summary

I got several responses for the last T-SQL Tuesday of the year that am honored to host. My topic was to blog on whatever you considered to be a gift that you received during the year. Below is the summary.

 Todd Klienhans talks of using his hobby – virtual reality, to make a project that helps post dog pictures online. His goal is to help motivate a friend, Jeff Rush, as well as others who like seeing pictures of pets when they want to.  It is Todd’s gift to community, and a really nice one at that.

 Rob Farley, my friend from down under, talks of his speaking gigs, encouraging people to speak at PASS speaker-idol(one of whom actually won the contest – Deborah Melkin), and a good friend of his, Hamish Watson, winning the Passion Award. Seeing our mentees succeed is one of the greatest rewards of community.

 Taiob Ali talks of getting nominated and winning the MVP award, and all the people who helped him through it. He also calls out the volunteer team he runs the SQL Saturday at Boston with, and his friend Deborah Melkin winning the speaker-idol award. Congratulations Taiob, and thanks for all you/your team do for community!

Koen Verbeeck talks of a new feature of PowerBI, and performance enhancements in Azure Data Factory , in addition to his speaking engagements. These are what he considers gifts for the year.

Deborah Melkin a.k.a. ‘Deb the DBA’ has had a great year with winning the speaker idol as well as getting to be an IDERA ACE. Way to go, Deb!

Shane O’Neill chooses to divide his gifts into SQL Past, Present and Future, and talks of what he received spanning each time zone that way. He prizes his community contacts over everything else he considers gifts in his professional life, and I couldn’t agree more myself.

Reitse Eskins talks of the gift of community, and of his incredibly supportive wife, as being his true gifts.

 Tracy Boggiano, one of my good friends in the community – talks of her book writing experience with Grant Fritchey, her mentor Kelly Pot Vin-Gorman, and championing the cost of mental health, as well as finding a new job, and her work with foster kids. Tracy is a natural giver, one for whom I have huge respect for. Thank you Tracy, for all that you do.

Aaron Bertrand talks of his career change as the defining point of the year, and reasons why he did it. This is probably the most popular/most RT-ed post of all, since Aaron is a highly respected figure in the community .(Aaron also mentions the ‘loose definition’ of the theme, which is a point I personally note to do better next time– thank you).

My friend and xevents expert Jason Brimhall talks of the using the free tool from microsoft to resolve the dreaded ‘cannot generate SSPI context error’. He also rightly mentions that we should be blogging in gratitude more often than once a year.

Jeff Miller talks of finding his dream job with Kevin Hill as a DBA. It is always motivating to see people get their first break..Well done, Jeff and Kevin.

Jess Pomfret also talks of her dream job and relocating back to her native England – a job she found via John Martin’s tweet. I am continually amazed at how many careers are made by #sqlfamily connections, this is another one. Good luck on the move, Jess.

Kevin Hill talks of growing his team/consulting business with two more people,and growing prospects in 2020. Best of luck, Kevin!

Steve Jones, my good friend and owner of #tsql2sday as of now talks of his trip to Australia with his family, and how he was able to enjoy it both personally and professionally.

Andy Levy talks of yet another job transition, and one that he did not quite expect. He also mentions a vacation and deepening ties with #sqlfamily as rewards for the year. Well done, Andy, and good luck with the new gig!

Matt Gordon, my good friend and ug lead out of Lexington mentions the two sessions at  SQLSat-Charlotte that made a big difference to him – Tracy Boggiano talking on mental health, and Donna Ellis Wilson on ‘Failure needs to be an option’. I personally attended both these classes and found them gifts at a very profound level – or as Matt says, the lines ‘ When you are fairly reserved, as I am, seeing other people call attention to issues that you are also dealing with is a greater gift than a free book, t-shirt, or some new bit of technical knowledge.’. Thank you Matt, for sharing that, and also Donna and Tracy, for speaking up on important issues that most people shy away from.

Ken Fisher talks of being an introvert and still feeling accepted among community – also includes an anecdote about an online twitter conversation with his wife that was misunderstood by a friend and ended well.

I have received many, many gifts in 2019. It has been among my roller coaster years, to be honest. There were several ups and downs and lessons all the way. My recap is here.

Lastly, my friend and DevOps expert Alex Yates micro-blogged on having a new baby and how that has changed his life. Congratulations Alex!

7 people out of 18 people talk of their new dream jobs. This should give all of us hope that there are good gigs out there, if we are stuck in a bad place. No gig is perfect, of course, but it helps to have a dream and a direction to get to a better place. Almost everyone mentions their involvement with community/#sqlfamily as a huge reward. If you are reading this and not an active part of community yet – please consider doing so. It helps to be among supportive, uplifting people who care for you and have similar goals as you do.

To conclude – I really liked these lines from Shane O Neill’s post – ‘ I believe the best gift is the gifts that you can give back. So, here’s hoping that the next year sees us all help more than hinder, learn more than laze, and teach more than troll.’

Best Wishes for a Safe and Happy holiday season!

T-SQL Tuesday #121 Gifts received

I am hosting 2019’s last T-SQL Tuesday of the year. I chose to ask people to write on gifts they had received – by way of community, relationships, or even tech features. A rather loose definition , as the one and only Aaron Bertrand calls it 🙂

I have a lot to be thankful for this year –

1 I took a strong liking to the graph data table feature in SQL Server and actually planned a book around it with another very popular author and mentor-friend. But the feature didn’t quite take off as I thought it would. But in the process, I relearned a lot of graph theory that I had learned in school, and also quite a bit about graph databases and how they work. Overall, it was a gift, although it didn’t quite pan out the way I thought it would.
2 I got more comfortable into my new role as dev/architect, which was a huge step away from DBA roles I had worked in for 20+ years. It has taken me a good two years to get comfortable with using GIT, working with devops as practiced at work, relearning TSQL and all that is needed in my job. It has been tough and very rewarding in the process. I consider the gig a gift, and have nothing but gratitude for the people I work with – in particular I would like to single out my colleague and dear friend from Spain – Efraim Sharon, our DBA team lead Mark Wilkinson, data science team lead Kevin Feasel and fellow dbas Andrew Pruski and Derek Fitzpatrick-Jolley. It is impossible to find a better group of people to work with.
3 I got back into speaking in a small way – i did two talks, one for the local user group and one for the PASS WIT chapter. Eugene Meidinger was my speaking mentor – he helped me with many tips and tricks, in addition to reviewing my slide set and giving valuable feedback. I consider it a true gift to have Eugene as my mentor-friend.
4 I was suspected of a serious illness and declared clear after many tests. It renewed my gratitude for the fragile gift that is life, and a renewed effort to appreciate every day I get and live it to the fullest.
5 I enjoyed hiking and exploring national parks in North Carolina and the Colorado mountains with my dear sister.
6 I attended my PASS Summit #16 and renewed many friendships, as well as made new ones. It remains to me the one place I go to recharge and refocus my professional life every year.

These are a few of my gifts for this year. I will end this post with the following quote and I believe this is important:
“When it comes to life the critical thing is whether you take things for granted or take them with gratitude.” ― G.K. Chesterton

T-SQL Tuesday #121: Gifts received for this year

It is December again. 2019 has gone by in a flash. I have the honor of hosting the last TSQL Tuesday blog party of the year. This monthly blog party started by SQL Guru Adam Machanic since 2009 has completed 121 months this year. I am the lucky host of event #121. If you are participating in this month’s party (kindly coordinated by my dear friend Steve Jones (b|t) – please be sure to read the housekeeping rules all the way below that are necessary for participation.

This is a time for material gift giving, for many of us. It might also be a time to consider the many gifts we have received through the year, and perhaps use this opportunity to appreciate people or situations that we were blessed with. So my question would be – what are a few things would you consider as gifts, and why? Some examples as below –

  • Getting to know someone in the community better,
  • Getting to speak at an event you always wanted to,
  • Attending a conference or training that you always wanted to attend,
  • Landing a job you never thought you would,
  • Published a book that you wrote,
  • Wrote for sqlservercentral/simpletalk/any of those cool websites
  • Got to play with a cool new technology that has you excited,
  • A feature of SQL Server that you always wanted and eventually showed up in 2019-I love lightweight query profiling to track query progress, for example.
  • A new cool feature that you never even thought possible is now there (I was just oooh-ing about how easy it is to script objects in Azure Data Studio, and how nice it is to have it store my query history for me).

Below are the rules of the game when you are ready:

  1. Write your post.
  2. Schedule it to be published at some point on Tuesday, December 10th, 2019. (UTC calendar day).
  3. Include the TSQL Tuesday logo in the top of your post.
  4. Link your post back to this one. Trackbacks should work, but it is a better idea to write a comment with the link on this post. Please give me some time to moderate your comments.
  5. If you are on twitter, tweet a link to your post, adding the #tsql2sday hash tag. Most people filter by hashtag and it increases the visibility of your post by quite a lot.

Look forward to reading about your gifts and learning from them!! Thanks in advance for participation.