A Season of Reflection (2023-09-02 DBW)

Database Weekly for September 2, 2023 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  A Season of Reflection As I think about heading into the fall conference season (and seeing so many familiar faces!!), I realize that I'm going to be asking myself a set of familiar questions. - Who am I? - What skills do I need to improve on in the coming year? - Who do I look up to in the community and want to connect with more regularly? As I am preparing for some major life changes, these questions feel even more relevant, both professionally and personally. Let me dig in a bit. Who am I? This first question helps me think about where I am at this point in my life and career. Now more than 25 years after college and having grown through numerous jobs, marriage, and family, where am I now? What skills do I bring to the table in any given situation? Am I using those skills to the best of my ability given whatever circumstance I find myself in? Are my contributions beneficial? There's great power in being able to take time and reflect on who you are now, in this current time and place. For me at least, I can get stuck in the "go, go, go" of life and forget to stop and really consider where I'm headed, and if those around me are happy with that journey, too. My guess is that your life has some regular rhythm and markers, appropriate times when it makes sense to sit and reflect on a question like this. For me, life is happening fast right now despite me, and focusing on work and life isn't always easy. So, heading into this next season of travel and connection, it's been a good time to ask the question. What Skills Need My Attention? After some time for reflection in both work and personal life, some areas that require focus and (possibly) change will inevitably come to the surface. Over my career, one particular skill that always needs some focus is… well… focus! There are so many changes, new shiny things, and conversations happening in all corners of my tech community. It's easy to say "yes" to everyone that asks for help, because I love helping and learning. But with each "yes", the list gets a little longer and I tend to get more distracted, "because I want to learn all the things!!" More specifically, I'm realizing that there are real-world PostgreSQL skills that I haven't invested in and need to deepen my knowledge. Sometimes it's easy to have head knowledge that doesn't translate fully without more hands-on experience. As I head into this conference season, I've started to take note of talks that I can attend, experts that will be present that I can learn from, and opportunities to dig deeper. Who Can I Connect with More Regularly? Having considered all the above, it becomes a little bit easier to identify folks in my various communities that can help me grow in each of these areas. This is the reason we have conferences, blogging events, meetups, and other ways to connect with those around us. But it's not enough to identify people that you want to connect with. You must do it, somehow. Every speaker I know will clearly indicate you how to connect with them, either at the conference or asynchronously after the fact. Speakers are present to do this work because they want to help. True, they might not become your best friend, and you need to have awareness of how much you ask of someone (speakers are not free long-term consultants), but all of them expect people will follow up later. And the best speakers, honestly, will know how to connect you with the wider community and point you to resources for growth. They don't live in a vacuum. So don't be shy. Take a chance and connect so that you can grow beyond your current station of your professional and (maybe) personal life. Parting Thoughts For various reasons, this is where my mind is at this moment in time. There's a lot to reflect on and there will be a lot of time to make personal connections in the months ahead. Maybe this isn't exactly what you need to be thinking about right now. No worries! But, if you're in a season of reflection and change like I am, potentially heading to some of these conferences in the months ahead, I hope that hearing my thought process can help spur you forward, too. Ryan Booz [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [State of the Database Landscape survey]( We’re launching The State of the Database Landscape survey. It will reveal what’s going on, why it’s going on, and what you can do to meet the new challenges. Be one of the first to read our industry report by sharing your experience in our Survey. [SQL Server Terms Translated into PostgreSQL]( When looking at SQL Server, it has many similarities to PostgreSQL, but there are several big differences too. To better understand these, we’ve created a useful reference guide that will help you translate well-known SQL Server terms into their PostgreSQL equivalents, making the journey to PostgreSQL that bit easier. AI/Machine Learning/Cognitive Services [Embracing Generative AI, Automation, and Dynamic AI Agents]( From Dataversity Technological revolutions rarely happen all at once. The commercial internet launched in 1989, but it would take almost a decade before most businesses depended on it to function. This... [OpenAI Unveils ChatGPT for Businesses, Stepping Up Revenue Push]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Enterprise version of its best-known product offers extra privacy safeguards and longer text prompts. Administration of SQL Server [Restoring a Database with Standby in SQL Server]( From Curated SQL Steve Jones stands by for station identification: Sometimes you want to restore part of your data, but you still want the option to continue restores.… [Adding SQL Server Access When You’re Locked Out]( From StraightPath Solutions SQL Blog As consultants we are sometimes asked the following question: “We have an old version of SQL that we can’t turn off and no one has access to it. Is... [Yet Another Reason to Not Use sp_ in your SQL Server Object Names]( From Simple Talk In 2012, Aaron Bertrand said most everything I kne... [Maximizing SQL Server ROI in M&A]( From StraightPath Solutions SQL Blog The Hidden Goldmine: SQL Server Due Diligence in A... Conferences, Classes, Events, and Webinars [Secrets Declassified: How Federal agencies can streamline cybersecurity compliance with DevSecOps]( The Federal sector has traditionally been slower in adopting advanced software development practices like Agile and DevOps, but organizations like the DoD and DISA are now raising the game to a new level with DevSecOps. Data Visualisation [when below goal is a good thing]( From Storytelling with Data We all develop constructs of the world around us—especially with information perception. For instance: I associate red with bad and green with good; seeing time flow from left to... Database Design, Theory and Development [What Counts for a DBA – Discretion]( I was looking at the list of topics I have talked about in my “What Counts for a DBA” posts over the years, and a topic really stood out as a topic I have not touched. To be fair, it is really the most essential aspect. One aspect that, if not truly understood and taken on by the DBA (and really any user with superpowers on any computing system), significant problems are going to occur. It is often discussed that data is power, but this is 100% not the attitude you should have if you are the keeper/protector of the database. DevOps and Continuous Delivery (CI/CD) [Managing Test Data for Database Development]( Louis Davidson 13 July 2023 0 657 views 5 Printer friendly version It’s Only Summer, but I am ready for PASS Data Community Summit Now! In coming up with a strategy for managing test data, first you need to understand what the many test requirements are likely to be for the particular database you are developing. Next, you need to create all the different categories of test data required to suite test requirements and, finally, work out how to manage it in a way that allows a test-driven approach to development. Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Storing Log Analytics Data in the Microsoft Fabric Lakehouse]( From Curated SQL Gilbert Quevauvilliers needs a place to store this data: Following on in my series, in this blog post I am going to use the dataflow… [Comparing the Microsoft Fabric Data Wrangler and Power Query Editor]( From Curated SQL Reza Rad performs a comparison: Power Query Editor and Data Wrangler are data transformation and preparation tools in Microsoft Fabric. There are similarities between these… [The POWER of shortcuts in Microsoft Fabric]( From Guy in a Cube We feel shortcuts are one of the most power capabi... [Microsoft Fabric: Loading On-Premises and External Data]( From Simple Talk Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this preview stage, Microsoft Fabric brings many surprises (and, should... Performance Tuning SQL Server [Index Tuning Essentials: Fixing Blocking]( From Erik Darling Data Away Days It’s August, and that means one thing: Family Vacation. I’m taking this month off from regular blogging, and posting some of my paid beginner training content for... [Index Tuning Essentials: The Problems With Eager Index Spools Demo]( From Erik Darling Data Away Days It’s August, and that means one thing: Family Vacation. I’m taking this month off from regular blogging, and posting some of my paid beginner training content for... PowerPivot/PowerQuery/PowerBI [A quirky Bookmark scenario with Filters in Power BI. Pay Attention!]( From Guy in a Cube A question came up about why bookmarks weren't working and how to solve a particular scenario regarding filters in Power BI. Adam shows how to solve this and uses... [Setting Table and Matrix Column Widths in Power BI]( From Curated SQL Kurt Buhler controls the horizontal, Kurt Buhler controls the vertical: One challenge of the table and matrix visuals in Power BI is that it’s difficult… R Language [Interesting R Functions for Package Dependencies and File Analysis]( From Curated SQL Maelle Salmon shows off a few interesting functions: How does this package depend on this other package? pak::pkg_deps_explain() The pak package by Gábor Csárdi makes installing packages easier.… [Operating on Vectors in R]( From Curated SQL Adrian Tam continues a series on getting started with R: Read on for a few examples of how to work with vectors, including in set… [Little useless-useful R functions – Return matrix elements in spiral order]( From TomazTsql Another one from the Leetcode challenge. This time, get the elements (single values) from the matrix in a spiral order with a starting position of [1,1]. So, the basic... SQL [The Concept of Schema in Relational Databases]( From Curated SQL Adron Hall explains how different relational database management systems describe schemas: From the viewpoint of someone familiar with the general idea of a schema, it… Security News and Issues [Authentication Outage Underscores Why 'Fail Safe' Is Key]( From Dark Reading: Dark Reading News Analysis Duo's service outage last week, impacting schools and businesses, highlights how companies should build in resiliency and business continuity into their authentication schemes. [Vendors Training AI With Customer Data is an Enterprise Risk]( From Dark Reading: Dark Reading News Analysis While Zoom has scrapped plans to harvest customer ... T-SQL and Query Languages [How You Can Use IS [NOT] DISTINCT FROM]( From Callihan Data One feature introduced with SQL Server 2022 that I’ve recently been playing around with is IS [NOT] DISTINCT FROM. This new feature can help when it comes to dealing... [Data Type Conversions and Snowflake Performance]( From Curated SQL Kevin Wilkie is implicit in this whole thing: One of the ways we can get better at speed is to attempt several slightly different ways… Tech News [The Tropical Island With the Hot Domain Name]( From IT Pro - Microsoft Windows Information, Solutions, Tools Anguilla is expected to make millions this year from a surge in demand for web addresses ending with .ai, thanks to the frenzy around artificial intelligence.  [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -