Good Career Advice

Database Weekly for April 8, 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  Keeping Things Running Today and tomorrow, as I write this, the [Green Country Hamfest]( will be running up in Claremore, OK. Tomorrow morning, I'll be there to check out the tables and maybe pick up some new radio gear. I'll also be volunteering to help run the doors. Largely it involves just checking to be sure people paid to get in, but I'm also there to answer questions and generally provide a friendly face to welcome people in. Why would I do this? Well, let's talk about it. The hamfest is put on for a number of reasons. It acts as a fund raiser for local clubs. It's also a way to advertise the clubs. There will be classes during the day on all sorts of radio things, so the hamfest also serves an educational purpose. Finally, it's a way for a bunch of people, who by nature of their hobby, normally sit alone and apart from each other, to get together and share some direct human interaction. It's a community. And the one thing I can tell you, from very direct, personal, experience, communities need love and attention, or they go away. In addition to the hamfest, the local clubs also take part in assisting the National Weather Service (NWS) as storm spotters. We help out at public events like bike races. We also practice radio for emergencies (although, thankfully, we're almost never needed). We hold classes to teach radio to others. In short, we do stuff for the world around us. But, without volunteers, and lots of them, all that goes away. And while you may never think about, how is it that the NWS knows exactly what kind of damage a tornado is doing? Part of it is probably a volunteer on the radio who has been trained in how to report accurate, helpful, even life-saving information. Now imagine for a moment, no volunteers. Sure, the modern radar can tell you that a tornado is on the ground. It can even tell you that debris is in the air, and how high it goes into the air. Scary stuff. What it can't tell you is, what that actually looks like on the ground. Is it just tossing up lots of loose stuff or is it leveling buildings? Eyes on the ground are necessary. And, the NWS can't pay enough people to have them everywhere to help report back, just how scared of a storm people should be. Without the volunteers, it's possible, more people could be hurt by storms. Volunteers are a part of what keeps the world running. From open source software projects, to Data & SQL Saturday events, and all sorts of stuff in between, volunteers move things forward. So, I want to say thanks to those who do the selfless tasks. We appreciate that you're keeping things running. Please, keep going. Also, if you don't volunteer, think about it. There are any number of things around you that are run by volunteers. They need help or those things go away. I've seen, way too often, people say stuff like "Why don't we have X any more" when X was volunteer run, and ran out of volunteers. You are needed. Please help, somewhere. 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 [How to Automate Cross-Platform Database Development]( In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases. [Working with Flyway And Entity Framework Code First: An Overview]( This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain. AI/Machine Learning/Cognitive Services [We are hurtling toward a glitchy, spammy, scammy, AI-powered internet]( From Technology Review Feed - Tech Review Top Stories This story originally appeared in The Algorithm, o... [Eye of the Beholder]( From O'Reilly Radar - Insight The notion that artificial intelligence will help ... [It Takes AI Security to Fight AI Cyberattacks]( From Dark Reading: Dark Reading News Analysis New threats from generative AI demand a generative... [An AI 'Pause' Would Be a Disaster for Innovation]( From IT Pro - Microsoft Windows Information, Solutions, Tools Like every worthwhile technology, artificial intelligence poses risks. That's no reason to stop progress. [Data Scarcity Challenges? Enter Generative AI]( From Dataversity Data has been one of the most important talking points in business for the last few years, with good reason. The more data available and harnessed, the easier it... Administration of SQL Server [Data Processing using Apache Spark and SQL Server using pymssql]( From MSSQL Tips Microsoft and Databricks have created a high-speed... [Resolved: Database Stuck in Single-User Mode]( From Eitan Blumin Learn how I resolved an interesting use case of a ... [Installing SQL Server on Linux]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we will show... [Ranking in SQL Server]( From Callihan Data Have you ever needed a Top 10 list? It may sound l... [Cheat Sheet for SQL Server DBA Daily Operations]( From MSSQL Tips This article contains various code fragments and s... [Maintaining Database Integrity with DBCC Checkdb Command]( From Steve Stedman As a database administrator, ensuring the integrit... [Microsoft SQL Certifications Program Changes]( From MSSQL Tips Microsoft made changes to its certification program and knowing about these changes can help you plan for future certifications related to SQL Server or other Microsoft technologies. [Registering SQL Server on Azure Virtual Machines with New IaaS Agent Extension Benefits (Ep. 12)]( From Azure SQL In this episode with Logan Carrington and Aditya Badramraju, you will learn why enabling the automatic registration feature in the Azure portal is necessary to register all current and... [SQL Server DBCC Commands: DBCC IND]( From Steve Stedman SQL Server’s DBCC IND command is an undocumented database console command that is used to display the allocation and deallocation status of the data pages in a table or... [New Job -> Week 4 -> Set Up Auditing]( From SQLServerCentral Blogs This is part of a series of new job blog posts. Yo... [SQL Server 2022 Pause and Resume Creation of Table Constraints]( From MSSQL Tips In this article, learn about the new feature in SQL Server 2022 that allows you to pause and resume the creation of constraints on tables. [Spreading your SQL Server wings with the Microsoft Intelligent Data Platform series]( From Kevin Chant Reading Time: 3 minutes Consider this post as an introduction to upcoming spreading your SQL Server wings with the Microsoft Intelligent Data Platform series that I will be... [Ordered Columnstore Indexes in SQL Server 2022]( From Simple Talk One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a... [Free JOIN Types PosterÂ]( From Steve Stedman One of the most important operations in SQL Server is joining tables. Joining tables involves combining data from two or more tables based on a common column or set... Analysis Services / BI on the MS Stack [Displaying only child values in parent-child – Unplugged #46]( From Sqlbi Student question: how to display only child values... [Star Schema Merchandising Available]( From SQLServerCentral Blogs Those of you who follow me on social media (twitte... Azure Databricks, Spark and Snowflake [What is a Snowflake Schema and how to use in Power BI]( From MSSQL Tips In this article, we look at what a snowflake schem... [Using Transactions in Snowflake Stored Procedures]( From MSSQL Tips Learn about using transactions in stored procedures when working with Snowflake with these code examples and explanations. Azure SQL [Azure SQL News Update: 2023 Q1]( From Azure SQL I’m baaaaaaaaaaaaaaack! Thanks for all the messa... [Azure SQL Dbs are in an inaccessible state on the Azure Portal]( From Azure Database Support Blog When I am not able to connect to the Azure SQL db,... [One Way to Provision an Azure Key Vault]( From AndyLeonard.blog() One way to keep confidential information confident... Azure Synapse (SQL Data Warehouse and Data Lake) [Common Azure Synapse Link for SQL storage permission issues]( From Kevin Chant Reading Time: 4 minutes In this post I want to co... Backup and Recovery [Public Preview: Support for Azure VMs using Ultra disks in Azure Backup]( From Azure Updates Public preview for the support for Azure VMs using... [How to Cut Planned Downtime Down to Zero]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are tips on how to minimize planned outages across your IT estate. [Park ‘N Fly Adopts Keepit for Microsoft Backup and Recovery]( From IT Pro - Microsoft Windows Information, Solutions, Tools Airport shuttle service Park ‘N Fly chose Keepit’s cloud-based backup and recovery service to overcome Microsoft backup limitations. Learn about the implementation and results. Big Data [How to transpose or convert columns to rows in Hive?]( From Hadoop in the Real World  Career, Employment, and Certifications [What to Do if You Get Laid Off: Tips for Tech Pros]( From IT Pro - Microsoft Windows Information, Solutions, Tools As layoffs of tech workers continue at companies l... [What IT Soft Skills Tech Talent Scouts Look for in Job Candidates]( From IT Pro - Microsoft Windows Information, Solutions, Tools The top soft skills that IT professionals should focus on are communication, problem-solving, and project management, according to a new study. [magic happens when people are together]( From Storytelling with Data  ... [WIT Women Speakers Survey]( From SQLServerCentral Blogs There is a survey from the WIT group for female sp... [How to Choose a 'Secondary' Programming Language]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learning a secondary programming language can advance your career. Here are four options to consider when deciding which language is best for you. Community Interests [Data Ceili 2023 – Schedule and Registration]( From DBA From The Cold Today we have announced the schedule for Data Céi... [Tales From The Field Weekly Wrap Up for the Week of 03-27-2023 & MegaCON]( From SQLServerCentral Blogs Zach's 1st MegaCon 2011 Hello Dear Reader! This... [EightKB Topics]( From DBA From The Cold Hello all, I’ve been speaking to various people ... [WIT Engagement Survey For Female Speakers]( This is a survey from us at dataplatformwit.com to understand why /how you, as a woman technologist are engaging with community. Computing in the Cloud (Azure, Google, AWS) [Cloud Architecture Mistakes: The High Costs of a DIY Mindset]( From Dataversity This is a five-part series about the costly mistak... [AWS Week in Review: Public Preview of Amazon DataZone and AWS DataSync Updates – April 3, 2023]( From AWS News Blog Last weekend, I enjoyed the spring vibes at Seoul ... [What SQL Server People Should Know About Amazon Aurora Serverless]( From Brent Ozar Unlimited You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set your pencil down for a second because you’re not going to... [Flexera’s Brian Adler on the State of the Cloud, 2023]( From Past News - RSS Feeds I spoke with Brian Adler, Sr. Director, Cloud Mark... Conferences, Classes, Events, and Webinars [New PostgreSQL 101 Webinar: Why PostgreSQL in 2023?]( Join Redgate Advocate, Ryan Booz, and find out about the history of PostgreSQL, the different PostgreSQL variants, and the reasons behind its increasing popularity. [PASS Data Community Summit registrations are open!]( In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more. DMO/SMO/Powershell [ArcaneBooks – PowerShell and the Advanced OpenLibrary ISBN API]( From Arcane Code ArcaneBooks - PowerShell and the Advanced OpenLibr... [In-place encryption with the Sqlserver PowerShell Module]( From Azure SQL Always Encrypted with secure enclaves supports in... [Always Encrypted Token-based authorization with PowerShell]( From Azure SQL Some Always Encrypted cmdlets in the SqlServer PowerShell module need to communicate with key stores holding SQL Server column master keys. When a key store is an Azure service,... Data Mining / Data Analysis [Why use rank correlation?]( From AllAnalytics A previous article discusses rank correlation and ... [Exploring the interplay of technology and society]( From AllAnalytics If you’ve ever contemplated AI's messy reality a... [Jugaad innovation: The key to resilient analytics capabilities in a changing world]( From AllAnalytics One of the great things about visiting SAS offices... [Weak or strong? How to interpret a Spearman or Kendall correlation]( From AllAnalytics A SAS user asked how to interpret a rank-based cor... Data Privacy, Compliance, and Governance [Data Governance: How Can It Be a Crucial Enabler for Managing Data Risks?]( From Dataversity In July 2021, one of the world’s leading banks r... Database Design, Theory and Development [The difference between libraries and frameworks]( The concept behind frameworks and libraries is to provide reusable code that you can use to perform everyday tasks so that developers don’t have to write all of the code from scratch for every project. However, there are some differences that you need to understand as you start writing code, which I will cover in this article. DevOps and Continuous Delivery (CI/CD) [4 Steps for Shifting Left & Winning the Cybersecurity Battle]( From Dark Reading: Dark Reading News Analysis If companies prioritize communications and make th... [FinOps Can Be a Big Waste of Money]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are reasons why your organization might not n... [Jenkins Installation, Configuration and Automation for DevOps Projects]( From MSSQL Tips Learn about a scheduling tool called Jenkins that ... [Deployment Pipelines in Power BI; How the Software Development Lifecycle Works?]( From RADACAD In any software application, the need for multiple... [Fully Automating the Deployment of a Self-Hosted Integration Runtime]( From Adatis Fully Automating the Deployment of a Self-Hosted I... [How DevOps is shaping Financial Services #2: The challenges in insurance]( From Blog – Redgate Software In this series of blog posts, we speak with database professionals from Financial Services organizations around the world to better understand how DevOps is shaping the sector. On the... [FinOps Is Getting a Seat at the Executive Table]( From IT Pro - Microsoft Windows Information, Solutions, Tools Executives have caught onto the FinOps buzz and want to know what it can do for them and their business. Oracle/PostgreSQL/MySQL/other RDBMS [A First Look at PostgreSQL Monitoring in SQL Monitor]( From Product learning – Redgate Software PostgreSQL monitoring is now supported by Redgate ... [PostgreSQL Tutorial for beginners]( From SQLShack Introduction to the PostgreSQL tutorial In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th most popular database in the world... [General availability: Read replicas for Azure Database for PostgreSQL Flexible Server]( From Azure Updates The Dlsv5 and Dldsv5 VM series provide 2GiBs per v... [Audit Data with Triggers: PGSQL Phriday #007]( Welcome to another #PGSQLPhriday post! This month... Performance Tuning SQL Server [How Does SELECT * Affect Query Store?]( I live for questions and recently, I had someone ask me, does using SELECT * affect Query Store. My immediate gut reaction was, hell no. Of course it doesn't. Then, yeah, I started thinking. It might. Let's test it and see. [Large number of OR in predicate "IN Clause" SQL Server]( From Azure Database Support Blog In some cases, like when customers use Object-rela... [Inner vs Left Outer vs Right Outer JOIN Types]( From Steve Stedman As someone who has worked with SQL Server for many... [Why SQL Server’s OPTIMIZE FOR UNKNOWN Hint Hurts Performance]( From Erik Darling Data “Best Practice” It’s somewhat strange to hea... PowerPivot/PowerQuery/PowerBI [Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!]( From Guy in a Cube Hybrid Tables can be very useful for mixing archiv... [What’s New With Microsoft’s Power Platform in March 2023]( From Petri IT Knowledgebase Did someone say it’s already Spring? It sure fee... [Where are the Power BI Gateway logs? I thought I knew…]( From Guy in a Cube Do you know where the Power BI Gateway log files are? I didn't! I'll show you a tool I use to help figure something like this out. And also... [(Livestream Replay) Where to Find Data for your Power BI Practice? - with Roland Szirmai]( From Havens Consulting ABSTRACT While it’s easy to download the official Advetureworks database from Microsoft to sharpen your Power Query / DAX / Dataviz skills in Power BI, it’s not always the... Product Reviews and Articles [Book Review: Expert Performance Indexing in Azure SQL and SQL Server 2022]( This book discusses indexes, a primary means of improving performance in SQL Server, how does it fare? Python [Modifying MySQL data from within Python]( From Simple Talk In the previous article in this series, I introduc... [Getting Started with Python Integration to SAS Viya for Predictive Modeling - Working with Dates]( From AllAnalytics In part 1 of this series, we examined our data bef... Security News and Issues [How Biden’s Cybersecurity 'Dream Team' Was Undone by Internal Strife]( From IT Pro - Microsoft Windows Information, Solutions, Tools National Cyber Director Chris Inglis resigned due ... [Phishing Attacks Continue To Dominate Cybersecurity Landscape]( From IT Pro - Microsoft Windows Information, Solutions, Tools A news study showed that cybercriminals are using ... [FBI (and Others) Shut Down Genesis Market]( From Schneier on Security Genesis Market is shut down: Active since 2018, Ge... [eFile Tax Return Software Found Serving Up Malware]( From Dark Reading: Dark Reading News Analysis In the height of tax-return season, a popular tax ... [5-Step Checklist for SaaS Businesses to Enhance Cloud Security]( From Dataversity Most SaaS businesses leverage the cloud to manage and store their data, applications, and workloads. With appropriate cloud security measures, SaaS businesses can ensure device and user authentication, resource... [Garage Door Openers Open to Hijacking, Thanks to Unpatched Security Vulns]( From Dark Reading: Dark Reading News Analysis CISA is advising Nexx customers to unplug impacted... [MSI Confirms Cyberattack, Advises Caution With Firmware]( From Tom's Hardware US MSI confirmed it was the victim of a cyberattack, and is advising customers to only get BIOS updates and firmware from its website. T-SQL and Query Languages [SQL School: Master the TSQL Output Clause with My SQL Server Course]( From Steve Stedman Hey there, fellow SQL enthusiasts! I’m Steve Ste... [Paging Data in T-SQL]( This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause. Tech News [How Can Natural Language Processing (NLP) Help My Business?]( From Dataversity Research reveals that the global natural language ... [How Russia killed its tech industry]( From Technology Review Feed - Tech Review Top Stories Seven days after the invasion of Ukraine, Vladimir... [What Is Technical Debt? Definitions, Examples, and More]( From IT Pro - Microsoft Windows Information, Solutions, Tools Tech debt arises when IT or development teams do n... [Amazon Looks to Grow Diamonds in Bid to Boost Computer Networks]( From IT Pro - Microsoft Windows Information, Solutions, Tools The artificial diamonds would be part of a component that lets the data travel farther without breaking down -- something necessary for quantum computing. Diamonds may wind up in... [These deep-sea “potatoes” could be the future of mining for renewable energy]( From Technology Review Feed - Tech Review Top Stories I’ve been on the road this week, and by a stroke of luck I got to visit one of my favorite places in the world: the whale shark exhibit... [Cisco Destroyed $23.5 Million Worth of Equipment During Russia Exit]( From Tom's Hardware US Cisco stops business in Russia, then destroys equi... [Raspberry Pi Pico W Brings Retro Nintendo Controllers to Switch]( From Tom's Hardware US Acting as the bridge between the past and the pres... [High-quality data enables medical research]( From Technology Review Feed - Tech Review Top Stories One unexpected side effect of the covid-19 pandemic was that the usually obscure world of health data was brought to national attention. Who was most at risk for infection?... [How to Downsize IT With Minimal Damage]( From IT Pro - Microsoft Windows Information, Solutions, Tools Facing a sagging economy, many enterprises are downsizing their operations. This leaves IT leaders with the task of shrinking their departments without sacrificing performance or security. [Cost Optimization Top of Mind for CIOs in 2023]( From Dataversity The last three years have been a rollercoaster for CIOs. Leading expansive digital transformation in 2020 so organizations could stay afloat during the pandemic, CIOs now face tough questions...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -