Where Does Your Inspiration Come From

Database Weekly for March 11, 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   I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on learning. OK. Well, I'm clearly stuck in a rut. Let's talk, instead, about inspiration. When we talk about inspiration, we have to break it down. There's the concept that inspires you, personal freedom is a big one for me. There's the person that inspires you, historically I've always had a soft spot for Teddy Roosevelt. However, by inspiration in this context, I mean, what drives us to make the choices we make. Deciding to write about learning vs writing about inspiration, that idea has to come from somewhere. Myself, I spend a lot of time thinking about learning, from the standpoint of the ignorant person who needs information, and from the standpoint of the informed person trying to share information. Learning and teaching are fundamental to my everyday job. This is why I've so frequently put learning into my editorials. I generally get my inspiration from the things I do the most. Hence, references to history (reading an interesting, not sure I can say good, book on the Alamo, "Exodus From The Alamo"), ham radio (doing more with DMR), and travel (off to [SQLBits]( this week), will pop up in the stuff I write quite a lot. I get inspiration for blog posts from the questions I get when I present and the ones I see here on SQL Server Central. I even get ideas sometimes from watching stupid stuff on TV. It all comes together, eventually, to inspire ideas. My question to you today is probably pretty obvious by now: where does your inspiration come from? More specifically, I'm curious where your solution inspirations come from? How did you decide to try a CROSS APPLY instead of a JOIN on that query you're tuning? What made you look into AWS RDS as the host for the latest data project? Where are you finding your technical inspiration? Grant Fritchey [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 [The business value of frequent deployments]( The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps. [Piping, Filtering and Using Flyway Output in PowerShell]( I'll show how to use some pipeline-aware PowerShell functions to filter out and save the bits we want and pass the results along in a form that is useful to the next process in the pipeline. [Finding and Tuning Expensive Stored Procedures using SQL Monitor]( SQL Monitor's Top procedures list makes it simple to find the procedures having the biggest impact on performance, allowing you to prioritize your tuning efforts, reduce risk and keep pace with the requirements of your growing database estate. [Find 40 Problems in this SQL Server Stored Procedure]( I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why. The procedure might pass review in a lot of shops, but not in mine. AI/Machine Learning/Cognitive Services [Implement ReAct (Reason+Act) with OpenAI GPT and LangChain]( From tsmatz ReAct (Reason + Act) is a flexible LLM chain frame... [Microsoft Adds New Open-Source Capabilities to Azure AI]( From Petri IT Knowledgebase Microsoft announced yesterday several new features... [Senior Software Engineers with Experience in NLP, AI in Demand]( From IT Pro - Microsoft Windows Information, Solutions, Tools Organizations are seeking software engineers with both hard and soft skills — as salaries rise from 2020 levels, a new report finds. Administration of SQL Server [SQL Server Diagnostic Information Queries for March 2023]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [CREATE VIEW SQL Server Tutorial]( From MSSQL Tips Learn the basics of creating VIEWs in SQL Server i... [Blocking in SQL Server 101]( From Steve Stedman Blocking in SQL Server can occur when….. one que... [Why a monitoring tool is an essential tool for growing server estates]( From Simple Talk When I was a DBA involved with the management of a... [[Cross post] Top 25 most common SQL Server Engine Errors (MSSQLSERVER_XXXX)]( From MS SQL Server Blog Please take a look at the following blog post by @Joseph Pilov (and team) to get detailed explanations, causes, and user actions for the top 25 most common SQL Server Engine... [Do you need Trace Flag 460?]( From Jonathan Kehayias For most people that are reading this post, I’d ... [SQL Prompt Safety Net Features for SSMS: Tab Coloring]( From Product learning – Redgate Software The Tab Coloring component of SQL Prompt’s SSMS Tab management could save you from accidentally doing something apocalyptic on a production server, ever again. The post SQL Prompt Safety Net... [SQL Prompt Safety Net Features for SSMS: SQL History]( From Product learning – Redgate Software Mistakes occasionally happen. Sometimes you accidentally close an SSMS query tab without saving it, before realizing it contained an essential bit of code. Occasionally, you make some ill-judged 'refinements'... Azure Synapse (SQL Data Warehouse and Data Lake) [Synapse Serverless and Dedicated Pool: The differences no one told you about]( From Simple Talk The basic differences between Synapse Serverless a... [Synapse Analytics workspace – deployment challenges]( From SQLPlayer Azure Synapse Analytics is not just “another ser... Backup and Recovery [Rethink your backup & recovery strategy w/ T-SQL Snapshot Backup in SQL Server 2022 | Data Exposed]( From Azure SQL In this Data Exposed episode with Anna Hoffman and Perry Skountrianos, we will discuss the new capability in SQL Server 2022 that introduces new cross platform T-SQL commands to... Career, Employment, and Certifications [Who’s Hiring in the Microsoft Data Platform Community? March 2023 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position as ... Computing in the Cloud (Azure, Google, AWS) [AWS Application Composer Now Generally Available – Visually Build Serverless Applications Quickly]( From AWS News Blog At AWS re:Invent 2022, we previewed AWS Applicatio... [Cloud Architecture Mistakes: Losing Visibility and Control Over Data Processing]( From Dataversity This is a five-part series of articles examining f... [How to rename files or objects in Amazon S3?]( From Hadoop in the Real World Amazon S3 is not a filesystem so there is no rename command to rename objects or files. However this is a well known workaround. Workaround Issue […] The post How... [Meet the Newest AWS Heroes – March 2023]( From AWS News Blog The AWS Heroes are passionate AWS experts who are dedicated to sharing their in-depth knowledge within the community. They inspire, uplift, and motivate the global AWS community, and today,... [How Cloud Computing Has Intensified Cybersecurity Challenges]( From IT Pro - Microsoft Windows Information, Solutions, Tools The cloud has changed cybersecurity. Here's why these changes make security more challenging. Conferences, Classes, Events, and Webinars [Join Redgate at SQL Bits, March 15-18]( From castles and dragons to swordfights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. And come say “hi” to us at the Redgate booth. Get 10% off registering with 10REDGATE DMO/SMO/Powershell [Microsoft Updates Teams PowerShell Module to Version 5.0]( From Petri IT Knowledgebase Microsoft has announced the release of version 5.0... [PowerShell: Enabling Strict Mode]( From Sid 500 PoSh PowerShell is very forgiving of errors. For exampl... [Combine CSV Files Using PowerShell]( From Callihan Data I recently had a handful of CVS files that needed ... [Use PowerShell To Scan Network for Connected Devices]( From IT Pro - Microsoft Windows Information, Solutions, Tools This PowerShell script lets you scan your network ... Data Mining / Data Analysis [Metadata: 5 reasons why you should understand its analytical value]( From AllAnalytics Analytics can get you answers from data. With an e... [identifying tension in data stories]( From Storytelling with Data  ... Data Science [Domino Data Lab’s Jack Parmer on “Code First” Data Science]( From Past News - RSS Feeds I spoke with Jack Parmer, Product Strategy Advisor... Data Warehousing [A Powerful Pair: Modern Data Warehouses and Machine Learning]( From Dataversity Artificial intelligence (AI) technologies like machine learning (ML) have changed how we handle and process data. However, AI adoption isn’t simple. Most companies utilize AI only for the tiniest... Database Design, Theory and Development [ON NORMALIZATION AND THE SCIENTIFIC METHOD (t&n)]( From Database Debunkings (originally published August 2002) Note: "Then &am... [embrace constraints]( From Storytelling with Data Has a manager or a stakeholder ever asked you for a single slide update on a tight timeline for an important meeting? This can be stressful and can impose... [Making the Case for Data Ingestion Pipelines]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here's how data ingestion pipelines fit in the broader data management ecosystem. [Zero-Copy Integration: How Small Data Practices Will Replace Big Data]( From Dataversity The future of data is small. As organizations grapple with ever-increasing amounts of data, the limits of the big data movement are becoming clear. Over the last two decades, big... DevOps and Continuous Delivery (CI/CD) [CI/CD for SQL Server 2022 using GitHub Actions]( From Kevin Chant Reading Time: 6 minutes In this post I want to co... [Automation Helping Organizations with Sustainability Efforts]( From IT Pro - Microsoft Windows Information, Solutions, Tools Automation is playing a critical role in helping companies meet their sustainability goals, thanks to its ability to increase efficiency and speed to value. [Deploy a dacpac to a serverless SQL pool using GitHub Actions]( From Kevin Chant Reading Time: 4 minutes In this post I want to cover how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Yes, you are reading... DocumentDB/Key-Value/Graph/other NoSQL Databases [How to delete duplicate data from the Hive table?]( From Hadoop in the Real World This is a common problem if you are bringing data ... [Next week: Kobo's Journey Into High Performance and Reliable Document Databases at InfoQ]( From Ayende @ Rahien Trevor Hunter from Kobo Rakuten is going to be speaking about Kobo’s usage of RavenDB in a webinar on next Wednesday.When I started at Kobo, we needed to look... Oracle/PostgreSQL/MySQL/other RDBMS [#PGSQLPhriday 006: Wrap Up & Summary]( From Scary DBA (Grant Fritchey) Your mission, if you chose to accept it, was to sh... [Understanding the Scalability in Oracle Database]( From SQLShack When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle... [Build a Better WordPress Archives Page Using MySQL]( From Simple Talk I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2).... Performance Tuning SQL Server [SQLpassion Live Training about SQL Server Query Tuning Fundamentals]( From SQLServerCentral Blogs On April 4, 2023 I will run an SQLpassion Live Tra... [Performance Considerations with SQL MERGE vs INSERT, UPDATE, DELETE]( From MSSQL Tips In this article, we look at the SQL MERGE command ... [Tuning SQL Server Queries With Computed Columns, Filtered Indexes, and Indexed Views]( From Erik Darling Data Tuning SQL Server Queries With Computed Columns, F... [Intelligent Query Processing (IQP)]( From SQLServerCentral Blogs In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by... The... [Tuning SQL Server Queries With Filtered Indexes Demo]( From Erik Darling Data Tuning SQL Server Queries With Filtered Indexes Demo Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering... PowerPivot/PowerQuery/PowerBI [PowerPoint Integration with Power BI Visuals]( From Excelerator BI Microsoft has just announced the general availabil... [How to Create a Sunburst Chart in Power BI Desktop]( From MSSQL Tips Learn how to build sunburst charts with Power BI i... [Why Embedded BI Is the Best Option for Analytics]( From Dataversity When a business considers the implementation of an analytics solution, it may be focused on choosing the easiest, most flexible solution to encourage its users to make analytics part... [Dataset permissions required for App report in Power BI? What am I missing???]( From Guy in a Cube Struggling with Power BI App permissions when usin... Professional Development [Closing the Skills Gap Brought On by Innovative Technology]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here's how to build a technically skilled workforc... [T-SQL Tuesday #159– Resolutions]( From SQLServerCentral Blogs I missed T-SQL Tuesday last month. I got busy and ... [How to Prepare Your IT Organization for a Possible Recession]( From IT Pro - Microsoft Windows Information, Solutions, Tools The jury is still out on whether or not the global economy is headed toward a recession, yet it's never too early to begin developing a contingency plan. R Language [Copilot for R]( From Revolutions It was my great pleasure to present last week to t... SQL Server Security and Auditing [18 Misconceptions: Your Database is [NOT] Secure!]( From StraightPath Solutions SQL Blog Welcome to Myths and Misconceptions Month, or “M... [Securing SQL Server: Windows Local Groups as SQL Logins]( From Steve Stedman In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you can add users to... Security News and Issues [Understand the “Why” in Your Data Security Woes]( From Dataversity Companies are drowning in data. This is a swelling... [Employees Are Feeding Sensitive Biz Data to ChatGPT, Raising Security Fears]( From Dark Reading: Dark Reading News Analysis More than 4% of employees have put sensitive corpo... [Ransomware's Favorite Target: Critical Infrastructure and Its Industrial Control Systems]( From Dark Reading: Dark Reading News Analysis The health, manufacturing, and energy sectors are ... [Top 10 Open Source Software Security Risks for IT Pros]( From IT Pro - Microsoft Windows Information, Solutions, Tools Endor Labs has outlined 10 risks of open source so... [Proposed FCC Rule Redefines Data Breaches for Communications Carriers]( From Dark Reading: Dark Reading News Analysis If the proposed rule is approved, organizations wo... [AT&T Vendor Breach Exposes Data on 9M Wireless Accounts]( From Dark Reading: Dark Reading News Analysis AT&T is notifying customers of a Customer Prop... [Medusa Gang Video Shows Minneapolis School District's Ransomed Data]( From Dark Reading: Dark Reading News Analysis Much like a hostage's proof-of-life video, the ran... T-SQL and Query Languages [How to Start Learning the SQL Query Language on SQL Server]( From MSSQL Tips Learn various ways to get started with the SQL lan... [Learn SQL: Insert multiple rows commands]( From SQLShack This article explains the different approaches use... [Essential SQL Server: Creating Databases and Tables]( From Petri IT Knowledgebase SQL Server is Microsoft’s premier data platform.... [Optional Code in T-SQL Scripts using SQLCMD]( From Simple Talk When you are writing T-SQL scripts to save away, f... [Simulating TRY_PARSE in SQL Server 2008]( From SQLBlog.org Certainly not to encourage people to stay on ancient versions if they don't have to, I took a crack at replicating TRY_PARSE on older versions. Tech News [Sam Altman invested $180 million into a company trying to delay death]( From Technology Review Feed - Tech Review Top Stories When a startup called Retro Biosciences eased out ... [How women are revolutionizing fashion with AI]( From AllAnalytics Women are trailblazing new ideas across industries... [40% of Global ICS Systems Attacked With Malware in 2022]( From Dark Reading: Dark Reading News Analysis Led by growth in Russia, more than 40% of global I... [These companies want to go beyond batteries to store energy]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. If y’all have been around for a... [More than 200 people have been treated with experimental CRISPR therapies]( From Technology Review Feed - Tech Review Top Stories This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. I’ve spent the last few days...  [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -