Data Oriented Cloud Security Mechanisms (2023-04-14)

SQLServerCentral Newsletter for April 14, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Data Oriented Cloud Security Mechanisms]( - [Finding and Tuning Expensive Stored Procedures using SQL Monitor]( - [Three Use Case Examples for SQL Subqueries]( - [From the SQL Server Central Blogs - Autonomous Driving Around London]( - [From the SQL Server Central Blogs - Typing with Your Tongue Part 2: Voice Access]( - [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Question of the Day - [DOP Feedback Compatibilty]( The Voice of the DBA  The Loss of Knowledge [This article]( has a great opening quote. It says: "We are drowning in information but starved for knowledge". It's from John Naisbitt, who wrote the book, [Megatrends]( in 1988. I think this quote can be very apropo in organizations as we have data, we have plenty of reports deriving information, but sometimes we don't have a lot of knowledge, especially when there has been turnover in our staff. We can train new people on many things, but not everything. The knowledge of the culture, of what others know, of the little strange bugs or behaviors that can't get fixed, the tribal knowledge accumulated by living in an environment. These are the learnings that can't easily be replaced, and until they are, often new employees are less productive. Of course, sometimes new employees will view the world in a different light and find solutions others haven't considered. That happens, but it's more likely that they will make mistakes, break something, or just be less effective than their predecessors. There are no shortage of articles, like the one above or [this one](, that discuss the concerns IT leadership has about employee turnover. Perhaps the leadership does see that as a problem, but often first level managers don't. Often leadership doesn't realize how poorly trained or effective first line managers are when working with their technical staffs. I sometimes think that the world in Dilbert is far too prevalent precisely because of very poor management skills. It certainly seems that efforts made to retain employees are relatively rare in many companies. In my career, we've had some boom and bust times in the market for developers. There have been times where anyone with a certification or a hint of experience could get hired (or get a raise). There were other times when people were careful to hold onto their jobs because finding a new one could be hard. I think employers should not only invest in their staffs, but work to train and upskill them, demand more from them over time, but treat them fairly with more than just a paycheck. The dividends from a hardware allowance, a training budget, and more can easily pay for themselves with better productivity and the lack of fees to recruiters. You should certainly hold staff accountable and responsible for getting work done, but make sure you also treat them fairly and support them. That's if you also spend time managing your managers and ensuring they balance the demands they make of employees with the support needed to ensure their staff performs well. If you ignore the managers, you might as well ignore the staff, set aside more recruiter fees in your budget, and hope for the best. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Data Oriented Cloud Security Mechanisms]( Kenneth Igiri from SQLServerCentral This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS. [External Article]( [Finding and Tuning Expensive Stored Procedures using SQL Monitor]( Additional Articles from Redgate 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. [External Article]( [Three Use Case Examples for SQL Subqueries]( Additional Articles from MSSQLTips.com There are many great tutorials on syntax, performance, and keywords for invoking subqueries. However, I wish to discover a tip highlighting selected SQL subquery use cases. Please briefly describe three SQL subquery use case examples. For each use case, cover how a subquery interacts with outer queries and the T-SQL for implementing the use case. Review excerpts from each example to show the value of implementing the use case. [Blog Post]( From the SQL Server Central Blogs - [Autonomous Driving Around London]( Steve Jones - SSC Editor from The Voice of the DBA There’s a video of Bill Gates taking a drive in an autonomous car around London. I’ve been to London dozens of times, ridden and cabs and Ubers, and even... From the SQL Server Central Blogs - [Typing with Your Tongue Part 2: Voice Access]( DataOnWheels from DataOnWheels A few months ago, I wrote a post on how I use voice technology to continue working with my ALS condition. Since that post was written, Microsoft released a... [Expert Performance Indexing in Azure SQL and SQL Server 2022]( [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Site Owners from SQLServerCentral Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]   Question of the Day Today's question (by Steve Jones - SSC Editor):  DOP Feedback Compatibilty If I have a SQL Server 2022 database, what compatibility level needed? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Waitfor Threads I have some code that uses a WAITFOR in it. When a lot of people call this code, what happens with the threads associated with the calls? Answer: The threads running a WAITFOR are assigned to that code and not reused. Explanation: WAITFOR causes a thread to be assigned to it and this is not reused. A lot of users calling WAITFOR can cause thread starvation issues. Ref: WAITFOR - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Can not Truncate the database because “Secondary has no log was added”]( - I got an error when trying to truncate the database: "Database can not shrink until all secondaries have moved past the point where the log was added". When I check the status of the secondary on the primary machine (Always On High Availability Dashboard), it has heath: good and Synchronization state: Synchronizing. But the status […] [Blocking query]( - Hi All, Seeing blocking on production server. There is one particular sql statement which is causing the blocking all the time. Please guide and on how to resolve or minimize the blocking for this statement. I always see this as a head blocker. These sql statement is executed quite a lot. Why it is holding […] SQL Server 2016 - Development and T-SQL [Hierarchy related calculation]( - Hello all, I have a hierarchy of businesses. example can be created as follows: create table #temp (LeafLvl varchar(20), L1 varchar(20), L2 varchar(20), L3 varchar(20), L4 varchar(20), L5 varchar(20)) insert into #temp (leafLvl, L1, L2, L3, L4, L5) select 'L2-1', 'Top', NULL, NULL, NULL, NULL UNION ALL select 'L3-1', 'Top', 'L2-1', NULL, NULL, NULL UNION […] SQL Server 2019 - Administration [if then else issue]( - I'm trying to use the if then else to check if a member exist in a server role. if it does, do X, else do Y. but not getting the desire outcome. BEGIN DECLARE @member nvarchar(50); USE [master] SELECT @member = members.name FROM sys.server_role_members AS server_role_members INNER JOIN sys.server_principals AS roles ON server_role_members.role_principal_id = roles.principal_id […] [Can not Truncate the database because “Secondary has no log was added”]( - I got an error when trying to truncate the database: "Database can not shrink until all secondaries have moved past the point where the log was added". When I check the status of the secondary on the primary machine (Always On High Availability Dashboard), it has heath: good and Synchronization state: Synchronizing. But the status […] [database schema and permissions]( - Hi - trying to find a t-sql to list all db schemas and their permissions. unable to find anything helpful on google. thanks SQL Server 2019 - Development [Find the records based on group by Student ID]( - Data looks like below Status 1 is Active and 2 is Clean For one Student ID we may have one active, one clean status; I want to find the records only with Clean status for a student ID. Student Id        Student_Status 12345        […] [problem of slowness in my requests]( - hello, I am having a major performance issue , with this part of code which is still blocked on my server , Attached is the part of the code that is causing the problem. DELETE R FROM #RESULTS_DEM AS R INNER JOIN dbo.Dem_trans AS DEM ON DEM.NUM_DEM = R.NUM_DEM WHERE ( NOT EXISTS ( SELECT […] [Joining CTEs Causing Performance Issues]( - Hi everyone I am not sure why the query is taking so long to run. If I run each CTE separately then it runs in less than 2 seconds. However, when I join them they take forever to run. I stop the query after about 10 minutes. I am pretty sure I am joining them […] [Need to create a .xml file in specific format using SQL Query.]( - I have a table of data that I need to create a .xml file from in a specific format. CREATE TABLE [dbo].[XML_TABLE]( [ProductID] [nvarchar](25) NULL, [Name] [nvarchar](25) NULL, [ParentID] [nvarchar](51) NULL, [AttributeType] [nvarchar](10) NULL, [AttributeID] [nvarchar](255) NULL, [AttributeValue] [nvarchar](4000) NULL ) ON [PRIMARY] GO Here are some values to insert: INSERT INTO WORK.DBO.XML_TABLE([ProductID], [Name], [ParentID], […] SQL Azure - Development [Copy DB from Prod to Test !!]( - Good morning. I would like your advice. I work on Azure Sql. We have 3 environments (Dev, Test and Prod) Each environment has a specific tenant. Every month, I would like to copy the database from Production to the Test environment. What solution do you recommend to perform this task? Regards Reporting Services [SSRS 2019 not able to connect to Oracle 2019]( - Hello, I have issues with SSRS 2019. I moved SSRS 2012 to 2019 on OS 2019,. after restoring key ssrs comes up fine. But when i try to create oracle data source it errors out with TNS: could not resolve the connection identifier specified. I have oracle 2019 client installed. also installed ODP 19(64 bit). […] SSRS 2014 [Open linked report in new tab with multiple parameters (javascript)]( - I have a report that links to another report on the server, while the way I have it currently works the users are requesting that it opens in a new window. The report being linked to has two multi select parameters ="javascript:void(window.open('20Report%20All%20Clients&FiscalYear=" & Fields!FiscalYear.Value &"'))"  I am close to getting this but not sure […] Anything that is NOT about SQL! [Need information on past SQL Summits, please...]( - I'm endeavoring to convince my employer to send me to SQL Summit this year, but I'm going to need to "sell" that it would be worthwhile for them to do this. And sell it not just to my supervisor, but to his supervisor and to her superior. Now, I fully expect that there's going to […] SQL Server 2022 - Development [What are some SQL commands that data scientists should be familiar with ?]( - Hello As an individual who is new to the field of data science, I am keen to gain insights into the fundamental SQL commands that data scientists should possess knowledge of. I would appreciate your guidance on this matter.   [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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -