Shared Work Spaces

Database Weekly for June 25, 2022 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  Shared Work Spaces: Hell, Heaven, Both? I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are all these strangers. Don't get me started on the open, shared work environment where you're just sitting with a bunch of people at long tables. Ugh! All that said, I've been at these places for meetings with co-workers. Many of whom, due to the, let's say, interesting last couple of years, I have never met. Further, some of them had never met each other. Just getting to see the people I depend on at work, talk with them, look them in the eye as we talk (and really in the eye, not looking either at my camera or at their face, online meetings are not the same, no matter what you say), are marvelous experiences. More than that, we get work done. Fast and efficient. Sure, the environment pings on my paranoid, introvert self in ways that are hard to describe. However, I can't deny that these shared work environments are essential tools in today's world. While I may not care for the concept, there's absolutely no denying the utility, at least from what I've seen so far. Have you used these? What do you think of them? Oh, I do like the fresh coffee that I don't have to make. That's very nice. 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 [Four ways to elevate team efficiency and code quality]( IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes. Administration of SQL Server [New in SQL Server 2022 – Generate_Series]( From SQLServerCentral Blogs One of the new language features added in SQL Serv... [SQL Server vs Oracle: Semantic Search]( From MSSQL Tips Learn about semantic search capabilities in SQL Se... [Pour One Out for Distributed Replay. It’s Deprecated in SQL Server 2022.]( From Brent Ozar Unlimited I love how Microsoft treats deprecated and discont... [Why shouldn't I create 15,000 partitions in advance?]( From SQLBlog.org In this tip, I show some real-life reasons why you... [SQL Server 2022 – GREATEST and LEAST]( From Callihan Data Have you had an opportunity to play around with SQ... [I’m Installing SSMS Version 18.12.1…]( From AndyLeonard.blog() … and you can install it, too! Visit Download SQ... [xp_cmdshell and sp_xp_cmdshell_proxy_account stored procedures in SQL Server]( From SQLShack This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands. What is the xp_cmdshell stored procedure?... [SQL Server Health Checks Webinar]( From StraightPath Solutions SQL Blog Hey there! This post is the “Summary/Recap” fo... [What I did in my first month at Stack Overflow]( From SQLBlog.org I talk about a few of the things I worked on in my... Azure CosmosDB [Public preview: Continuous backup enhancements in Azure Cosmos DB]( From Azure Updates Azure Cosmos DB accounts can now take advantage of... Azure Synapse (SQL Data Warehouse and Data Lake) [Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!]( From Guy in a Cube Trying to get started with a Modern Data Lakehouse... Computing in the Cloud (Azure, Google, AWS) [Becoming a Cloud Data Platform Driven Organization - Part 2]( From MSSQL Tips This article explores the benefits of adopting a c... [AWS Week in Review – June 20, 2022]( From AWS News Blog This post is part of our Week in Review series. Ch... [File-Based Log Monitoring on AWS MYSQL RDS]( From Journey to SQL Authority with Pinal Dave The way the cloud platform works on Azure is very ... [Public preview: Azure Data Studio MongoDB extension for Azure Cosmos DB]( From Azure Updates Use the new Azure Data Studio MongoDB extension fo... [Azure SQL—Generally available updates for late June 2022]( From Azure Updates Generally available updates made in late June 2022... Conferences, Classes, Events, and Webinars [DevOps 101 webinar: The role of Automation]( Join Grant Fritchey to discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck. DMO/SMO/Powershell [How to Create Files and Folders with PowerShell]( From Petri IT Knowledgebase When you need to create files and folders on a... [Top 10 PowerShell Tips of 2022 (So Far)]( From IT Pro - Microsoft Windows Information, Solutions, Tools Our most-read PowerShell articles included instructions for encrypting scripts, initializing disks, and using If Else statements. Data Mining / Data Analysis [Five Tips for Telling a Compelling Data Story]( From Dataversity Running a business is impossible without data. Dat... Database Design, Theory and Development [Automating Flyway Development Chores using Database Diagrams]( If you can generate a quick Entity-Relationship diagram for any version of a database, you'll have a simple way to 'sanity check' it for unreferenced tables, missing keys and other design flaws. This article shows how to auto-generate these diagrams when running a migration, using Flyway Teams and PowerShell. DevOps and Continuous Delivery (CI/CD) [Including reference data into a database deployment process or passing lookup tables to Production]( From SQLServerCentral Blogs (2022-Jun-20) As it takes a village to raise a ch... [What is a data pipeline?]( From MSSQL Tips In this article we cover what data pipelines are, how they compare to ETL and some of the tools that are available. [DevOps 101: Introducing Database DevOps]( From Blog – Redgate Software In this fourth session in our DevOps 101 series, w... MDX/DAX [Understanding the optimization of SWITCH]( From Sqlbi The SWITCH function in DAX has been optimized over... Oracle/PostgreSQL/MySQL/other RDBMS [Learn PostgreSQL: Install PostgreSQL on CentOS Linux]( From SQLShack In this article, we are going to learn how we can ... PowerPivot/PowerQuery/PowerBI [Why can’t Power BI connect to my cloud source???]( From Guy in a Cube You have a cloud data source like Azure SQL Database. Why can't Power BI connect to it? They are both in the cloud! Adam shows you some things to... [Datamarts and exploratory analysis using Power BI]( During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example. [Azure Synapse Link for SQL: From production to a data warehouse in a few clicks]( Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature. Professional Development [What’s next?]( From SQLStudies As I’m sure a fair number of you already know I ... [Perhaps Too Much Validation]( From Los Techies Several factors have influenced my coding style over the years leaving me with a preference toward lean code syntax. I’ve been developing for quite a while, so it would... [Who benefits from your technical blog? You do!]( From SQLBlog.org In this article, I discuss several advantages to m... [Consulting From The Client's Perspective]( From BlueGranite Blog When clients and consultants tackle MBI and MDP projects together, there can often be an assumed "one right way" to get the job done. This myopic focus on the... R Language [Little useless-useful R functions – Plotting the decimal and binary conversion]( From TomazTsql How does the conversion between decimal to binary ... SQL Server Security and Auditing [How to generate a self signed certificate for SQL Server with New-SelfSignedCertificate]( From SQLServer-DBA.Com Create a self-signed certificate to use with SQL S... [TLS v SSL : which should you use]( From SQLServer-DBA.Com When setting up encrypted connections - one of the... Security News and Issues [Getting a Better Handle on Identity Management in the Cloud]( From Dark Reading: Dark Reading News Analysis Treat identity management as a first-priority prob... [Microsoft 365 Users in US Face Raging Spate of Attacks]( From Dark Reading: Dark Reading News Analysis A voicemail-themed phishing campaign is hitting sp... [The Rise, Fall, and Rebirth of the Presumption of Compromise]( From Dark Reading: Dark Reading News Analysis The concept might make us sharp and realistic, but... [ShiftLeft: Focus On 'Attackability' To Better Prioritize Vulnerabilities]( From Dark Reading: Dark Reading News Analysis ShiftLeft's Manesh Gupta join Dark Reading's Terry... T-SQL and Query Languages [5 use cases of SQL Average]( From MSSQL Tips Learn various ways to calculate the average of a s... [Advanced T-SQL String Searching And Parsing Techniques In SQL Server]( From Erik Darling Data IndexOf First, I want to advise you to avoid doing things as much as possible like this in T-SQL. Use CLR, if you can. Or do it outside of your... [Steve Demonstrates Data Paging with CTE’s]( From Steve Stedman Transcription of Video: Here’s an example of a CTE that’s been created for data paging, where the select statement inside of the CTE that shown in blue is just... [CTE’s in Stored Procedures, Functions and Views]( From Steve Stedman Transcription of Video: Now on to CTE’s in stored procedures, functions and views. When I first started doing this presentation several years ago, people would ask, “oh, can the... Tech News [Sysadmin Role Isn't Dying – But It Is Under Threat]( From IT Pro - Microsoft Windows Information, Solutions, Tools The role of sysadmin may not be going away anytime... [Microsoft Disables Windows 10 and 11 Downloads in Russia]( From Tom's Hardware US Perhaps it is more surprising that Microsoft has t... [Open Source Software Security Begins to Mature]( From IT Pro - Microsoft Windows Information, Solutions, Tools Only about half of firms have an open source softw... [Energy-hungry data centers are quietly moving into cities]( From Technology Review Feed - Tech Review Top Stories In 1930, the telegraph giant Western Union put the... [Microsoft Lists Calendar View Gets Color Coding with Conditional Formatting Rules]( From Petri IT Knowledgebase Microsoft Lists calendar view is getting better with conditional formatting... [The Download: Retrofitting cities, and Alexa mimics the dead]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our w... [Mars Probe Running Windows 98 Receives Software Update in Space]( From Tom's Hardware US The European Space Agency's Mars Express orbiter r... [Reinventing How Farming Equipment Is Remotely Controlled and Tracked]( From Dark Reading: Dark Reading News Analysis Farmers are incorporating high-tech solutions like... Virtualization and Containers/Kubernetes [5 Best Practices for Simplifying Kubernetes Management]( From IT Pro - Microsoft Windows Information, Solutions, Tools Most people find setting up and managing Kubernetes to be difficult, but it doesn't have to be — if you follow these five best practices.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -