Minding your manners, Database Job Titles, and so much more

Database Weekly for August 12, 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  What Counts For a DBA: Manners When most people were young, they had someone telling them to "Mind your manners." Such classics as: "Keep your elbows off of the table," "Use a fork," "Put on deodorant," as well as "Don't chew with your mouth open" were bandied about like there were laws of nature. However, manners differ significantly from laws in one crucial way: manners are optional. Laws have to be followed, or there are consequences. Drive too fast, and lose your right to drive. Jump off a building, and the law of gravity will teach you a lesson. Conversely, manners are there to help you get along with others. You won't die a horrible, toothless death if you eat your dinner smelling of the day's work with your elbows dug into the table, scooping creamed corn up with your hands into your mouth that you don't close for an entire dinner party (quite an image, right?). You will, however, probably only share one meal with your host. Manners are those things that are instilled in us as soon as possible in life for us to get along with society. Interestingly, as a computer scientist, it will turn out that manners play a far more significant role in our work than laws ever will. The compiler will generally enforce laws, giving you error messages like every SQL Server programmer's favorite "syntax error near 'a'." For the DBA/SQL programmer, we have patterns of development based on engine suitability and working well with other human programmers. The following items all fall under manners, and if you have never seen a seemingly successful database that doesn't mind its manners, then you have led a very sheltered life. - Following known database design patterns - No matter the RDBMS you choose, they share a common design pattern set called Normalization that will make life easier when working with data. Other database types have their own patterns. - Managing concurrent and isolated execution - it is quite rude to overwrite someone else's data just because you can. Well-mannered programmers make sure their operations are never lossy unless they can be. - Formatting code - Most programming languages let you format your code in any way you want, even all on one line. We don't do this because we have the manners not to. - Reducing super complex code - Getting carried away as a programmer and trying to be clever is far too easy. Code needs to be only as complicated as it needs to be. Too often, people who think they are clever write code that they can't read 10 minutes later. I know I have! - Writing reasonable comments - No one likes to write comments, but good programmers realize they are love notes to the next person to touch the code. Often yourself. So mind your p's and q's, and work like you are not alone. Someone else may want to work with your database creation and don't leave them a mess. Especially when that next person turns out to be you. Louis Davidson (@drsql) [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. AI/Machine Learning/Cognitive Services [The Download: political AI models, and a wrongful arrest]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. AI language models are rife with different... Administration of SQL Server [SQL Server 2022 Cumulative Update 7]( From Glenn Berry On August 10, 2023, Microsoft released SQL Server ... [How to Install SQL Server Containers on Linux Using Docker]( From Petri IT Knowledgebase Microsoft has officially supported running SQL Ser... [SQL SERVER – What is Instance Hiding? How to do it?]( From Journey to SQL Authority with Pinal Dave In this blog post, I'll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients. First appeared on SQL SERVER –... Azure DevOps [Prepare Azure DevOps for Microsoft Fabric Git integration]( From Kevin Chant Reading Time: 6 minutes In this post I want to cover how you can prepare Azure DevOps for Microsoft Fabric Git integration. To help you avoid any issues.... Azure SQL [Generally available: Azure Premium SSD v2 Disk Storage is now available in more regions]( From Azure Updates Azure Premium SSD v2 Disk Storage is now available in more regions and offers the most advanced general-purpose block storage solution with the best price performance. [Stop Azure SQL Database]( From Azure Database Support Blog We have several cases where our customers are looking for ways to stop an Azure SQL Database.  Some common scenarios where our customers request this option are when they... Computing in the Cloud (Azure, Google, AWS) [Unlocking the Full Potential of Cloud Technology: The Benefits of Managed Cloud Services]( From Dataversity Cloud technology has revolutionized how businesses operate, offering scalable, flexible, and cost-effective solutions to everyday tasks. And further progress is on the horizon – by 2024, Gartner estimates the cloud... [5 Best Practices for Optimizing Costs During Cloud Migration]( From IT Pro - Microsoft Windows Information, Solutions, Tools Maximize savings from the start by following these strategies for cost-effective cloud migration and management. Conferences, Classes, Events, and Webinars [100 Days to the Data Community Summit Keynote]( From SQLServerCentral Blogs The start of learning at the 2023 PASS Data Commun... ETL/SSIS/Azure Data Factory/Biml [Which Data Quality Issues Are Plaguing Data Engineers Today?]( From Dataversity We’ve all generally heard that data quality issues can be catastrophic. But what does that look like for data teams, in terms of dollars and cents? And who is... Editorial [How is the database landscape changing – and how can you be the first to know about it?]( From Blog – Redgate Software The database landscape is constantly evolving, from migrating to the cloud to introducing continuous delivery with DevOps, and from incorporating Platform Engineering approaches to using Generative AI. The pace... Excel [How to refresh an Excel file stored in SharePoint Online without the need for a Power BI Gateway]( From FourMoo I have been answering some questions on the Power BI (Or is it now Fabric?) community forum, and I have found recently that there are some people asking how... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Fabric Data Factory: Copy Activity is More Than Copy]( From RADACAD Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a destination. However,... [Serving layers with a data lake]( From SQLServerCentral Blogs Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is... The... Oracle/PostgreSQL/MySQL/other RDBMS [What Is an Execution Plan and How to Find It in PostgreSQL]( From Simple Talk In the last blog (When PostgreSQL Parameter Tuning... Performance Tuning SQL Server [SQL Server Diagnostic Information Queries for August 2023]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [Lesson Learned #414: Demystifying Execution Plans and Query Optimization in Azure SQL Database]( From Azure Database Support Blog In the world of database management, achieving optimal query performance is a crucial goal.As data volumes grow and applications become more complex, understanding how queries are executed and optimized... PowerPivot/PowerQuery/PowerBI [How to Create a Time Table in Power BI Using DAX]( From SQLSwimmer Lately, I’ve been having to create items in Powe... [Convert Power BI Card Visuals into Slicers to add Report Functionality]( From MSSQL Tips In this article, I will demonstrate how you can tu... Professional Development [Burnout Is Back in a Big Way — Here's Why]( From IT Pro - Microsoft Windows Information, Solutions, Tools Workplace wellbeing needs a reboot to cope with th... [T-SQL Tuesday 165 – Database job titles are in the eye of the beholder]( From Kevin Chant Reading Time: 3 minutes For this months T-SQL Tuesday contribution I want to share why I think database job titles are in the eye of the beholder. At... [T-SQL Tuesday #165 Job Titles – What do you need?]( From Curious..about data My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out... [T-SQL Tuesday #165 – Job Titles]( From Deb the DBA It’s another T-SQL Tuesday! This month, Josephine Bush (b | t) hosts our T-SQL Tuesday discussion. Her invitation is about the data platform job titles. I wrote a post... [T-SQL Tuesday #165: Comparing Database Job Titles]( From Callihan Data While my family and friends know what I do, I’m not sure how well they know “what I do.” While I can explain the details, for those with little... [T-SQL Tuesday #165–Job Titles]( From SQLServerCentral Blogs This T-SQL Tuesday is from a new host, Josephine Bush, leader of the Boulder group just North of me. It’s an interesting invitation, asking what our job titles really... The... Security News and Issues [August 2023 Patch Tuesday Updates are Now Available on Windows 11 and Windows 10]( From Petri IT Knowledgebase Microsoft has released today the August 2023 Patch Tuesday updates for Windows 11 and Windows 10. This month, Microsoft fixed 86 vulnerabilities in Windows, Office, and other components, and... [The Curious Case of… recovering from a ransomware attack]( From In Recovery... (The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something... T-SQL and Query Languages [Use T-SQL to Perform Statistical Calculations on SQL Server Data]( From MSSQL Tips In this article, we look at how to use T-SQL to perform statistical calculations on data within SQL Server tables, specifically using stock data for the examples. [SQL Logical Operators ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR, SOME]( From MSSQL Tips Learn to use logical operators when writing SQL co... [Fun With KQL Windowing Functions – Row_Rank_Min]( From Arcane Code Fun With KQL Windowing Functions - Row_Rank_Min [Finding Encrypted Stored Procedures–#SQLNewBlogger]( From SQLServerCentral Blogs I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts... The... Tech News [Windows 365 Switch Now Available in Public Preview]( From Petri IT Knowledgebase Microsoft has announced the public preview of its Windows 365 Switch service. The new offering allows users to switch between their Windows 365 Cloud PC and physical device on... Testing Software [SQL Unit Testing reference guide for beginners]( From SQLShack In this article, we are going to learn the basics ... The Lighter Side [Service Principal vs Service Principle -> not the same thing!]( From The Bit Bucket I can't tell you how many times lately, that I've ... [A New Word: Aubadoir]( From SQLServerCentral Blogs aubadoir – n. the outworldly atmosphere just bef...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -