Daily Coping 3 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

Today’s tip is to make uninterrupted time for your loved ones.

I have less of these now, with all the kids away from the house. However, my daughter has called a few times to chat. Often she takes time between classes, or shortly thereafter, but those are not always good times for me. I’m often working then.

However, I’ve made it a point to stop, not multi-task, and walk away from my desk when she calls. Focus on her, and enjoy the time.

Posted in Blog | Tagged , , | 1 Comment

Using Dynamic SQL

There are many ways that you can structure your T-SQL code to solve complex problems. Throughout my career, I’ve learned different ways, and also some patterns to avoid. However, those change over time. For example, there was a time when heavily loading tempdb caused issues in the v6 era. As a result, I tried to avoid using them. These days, I’d consider them a good option to think about.

One of the techniques that I see people trying often is Dynamic SQL. This is where you don’t write the code directly, but you write code that will put together a string of code to execute, and then you call this with EXECUTE() or some other mechanism to get your results.

There are places where you might find Dynamic SQL useful. I saw an article from Erik Darling recently that gives you some situations where Dynamic SQL can help. These are often situations where performance is worse with a bunch of conditional code that is jumbled together. Separating out code into different procs or functions can help here, but that becomes a maintenance headache in many ways.

Dynamic SQL isn’t something to just try without thinking carefully about the ramifications. SQL Injection is a real concern, though you can mitigate the risk with some careful coding. However, you need to be careful how you structure code, and don’t just concatenate strings together and execute them. Read up on good practices from others, and ensure you test your code thoroughly. In fact, this is one place where automated testing can become important, as you learn of different injection techniques, you can add new tests to ensure your code isn’t vulnerable.

As you work with T-SQL, it’s important to continue your education, learn how the platform and language work, how performance changes between versions, and what options are to be adopted or dropped. Becoming a better T-SQL developer takes work and practice, and it’s an area in which we should all be constant students.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Comments Off on Using Dynamic SQL

Daily Coping 2 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

Today’s tip is to thank three people you feel grateful to and well them why.

I decided to pick three people that make me think and widen my view of the world. I sent a note to each of them individually, but the gist is here:

Rie Merritt

I don’t get to sit and chat with Rie often, but over time, we’ve had some interesting chats. I really appreciate the way she has passion and advocacy for various aspects of life and work, trying to make the world better. At the same time, she’s rational and listens, willing to debate about things.

I especially appreciate her view as a woman in the SQL Family, as her experiences, her thoughts, and more help me to see the world in a wider way.

I’m grateful that I’ve known her.

Andy Mallon

Andy and I have run into each other at various events. He’s been a fun person, full of excitement and passion. He’s compassionate and has supported many causes that are also important to me.

He’s also very opinionated and very strong willed, especially around diversity and inclusion. We don’t always agree, but I do think he makes many valid points, and I think the world is better for having him in it, as is the SQL Family.

I am grateful for all the words we’ve exchanged.

Steve Rezhener

Steve runs the LA Data Platform group and their SQL Saturday, actually Data/SQL Saturday now. Steve has been a critic and advocate for SQL Saturday for years, and he’s often pushed me on how to view events, and how they’ve been managed in the past.

We don’t always agree, but I do appreciate his view and his passion. He helps me to remember that there are other ways to view the franchise than my own.

I’m grateful to Steve for the hospitality in LA, and the ways he challenges me.

Posted in Blog | Tagged , , | 1 Comment

Viva

I want holographic screens and meetings. Heck, I’d like Teams/Slack/Zoom/etc. to recognize multiple screens and let me separate out different cameras to different screens. I’d like to be able to see more than a tiny thumbnail of a presenter, or of other people that are in a meeting. That might be one of the things I miss most when I’m in these virtual meetings. I can often barely see others.

Microsoft Viva is a new platform for remote work and collaboration. I’m not completely sure what it is, though there is a video with the cool, enticing holographic screens. It’s not an app, but appears to be some way to connect various information in an organization into Teams. It’s like an intranet from the 90s, but designed to help someone navigate their organization and work environment.

I’m all for bringing together more data, and especially making it easier for people to do so. I love all the single-sign on we have at Redgate, but everyone produces so much data through tickets, feedback from customers, notes in chat apps, emails, announcements made everywhere, internally and externally, video updates, and more. I find it extremely hard to keep up, or to even know if I’m keeping up enough, too little, or too much.

What I really need is some prioritization and triage for me. For me personally my role. That sounds like I want a personal digital assistant, which I don’t know I’d have confidence in. I suppose I wouldn’t have confidence in a human assistant until I’d trained them, so maybe this is a similar task I’d need to complete, whether it’s a computer or human. I’d have to build trust, and expectations about how to deal with different situations.

With software, however, I’d worry about data privacy. I know this is still an issue with humans, but there is less scale for humans. They can’t learn and remember as much, and there is less secret access to about what my human assistant might know. After all, they know, or should know, if they tell someone something. However, what a digital system stores can be accessed by, well, who knows.

At least I feel there is a potential problem here. Maybe I’m just worried, but many of the problems I see with computers have to do with the scale of data access. Both in the volumes of data someone can see, but also the variety of people that can see the data. Microsoft has already had some issues with trying to boost productivity for individuals. They’ve gotten complaints over what they store and report on, and more data might make that worse. Perhaps they are going to find a balance with insights and privacy, but I don’t want to be a test subject for this.

Changing the way we work, helping individuals be more productive and accountable, while protecting their rights privacy is hard. I applaud Microsoft for trying something, mostly because I think remote work will continue to be a part of our lives and it’s not great. I suspect that this is like many of their new ideas, half-baked and incomplete. They want to release something, and it might not be much more than minimally viable. Whether they continue to invest and grow this into a useful tool remains to be seen, but I hope they do. I’d certainly like to have more useful ways to learn, collaborate, and communicate.

Especially if they build holographic screens.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged , | Comments Off on Viva