SQLServerCentral Newsletter for October 23, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central](
Featured Contents - [Transform your Winning team into a Champion Team](
- [The promise â and the perils â of GitHub Copilot](
- [Understanding Locking, Data Modification and Committing Data in SQL Server](
- [From the SQL Server Central Blogs - Common Mistakes in SQL Server â Part 4](
- [From the SQL Server Central Blogs - Using the Pure Storage PowerShellSDK2 - Part 2 - Working With Data](
- [Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database]( Question of the Day - [The Column Synonym](
The Voice of the DBA
 Bad Culture Bad Security I ran across a [blog]( noting that [Cisco has a vulnerability]( in a new product. The blog also lists two ([one]( [two]( articles showing that Cisco has had hard-coded credentials in the past. I understand that many times a known process is repeated, essentially copy-pasted between people, and we have similar issues as we have had in the past. However, in 2022 or 2023, it's unacceptable to hard-code credentials in digital systems that will be used in today's world. What's worse than having this issue is stating that the fix is "an upgrade". Their verbiage for those without a service contract is: "Customers should have the product serial number available and be prepared to provide the URL of this advisory as evidence of entitlement to a free upgrade." Which, to me, is not only bad for the world, but it's equivalent to the stuff that bulls leave behind in the fields. I suspect that this product and software were based on something that already exists, and it was rushed out without a good security evaluation. Or perhaps there are developers and managers who don't think that hard-coding credentials will compromise security. That's a cultural problem. Either you're going too fast, or you don't take this seriously, either way, you don't have a good culture that values quality and protection. Certainly, their disclaimer about needing valid contracts or proving you have a device to get a security patch for a flaw they built is also a sign of a poor culture that doesn't really understand the problems they are creating, nor are they taking responsibility for the issues. At the very least, fixing their poor security ought to be free and easy. I get that there are likely some software upgrades included in this patch, given the nature of software development and limited branches under support. However, there are other ways to ensure those features aren't enabled for customers who shouldn't have them. Making the entire world of computer network infrastructure less secure because you want customers to pay for your mistakes isn't a model I'd want to adapt. I know many people don't want more regulation or guidelines from governments (or even from insurance), but if I were going to accept some universal restriction, this would be the place. If you use hard-coded passwords, your product can't be sold and no insurance claims apply if you are sued. Maybe that would change the way Cisco and others build software. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](
Â
 Featured Contents [SQLServerCentral Article]( [Transform your Winning team into a Champion Team]( Girish Ganesamanian Tirunelveli from SQLServerCentral Businesses worldwide now operate on a team basis, and a high-performing team is crucial for high-performing organizations. Winning teams are more focused and better than regular teams. They focus on synergies and achieving significant results. They are an extension of regular teams with a higher sense of commitment to objectives and mutual purpose. Winning teams have a clear mission and achievable performance goals for each member, aiming for extraordinary goals. They are more committed to the vision and have a passion for achieving the mission. Winning teams work collaboratively to discover new work approaches, principles, and practices, focusing on decision-making, creative problem-solving, industry standards, and effective communication. They establish processes from beginning to end to complete tasks effectively. The difference between winning team and a regular team is very clear. However, what makes a winning team a champion team. This paper aims to provide valuable insights into the differentiating factors of a champion team from a winning one. [External Article]( [The promise â and the perils â of GitHub Copilot]( Additional Articles from SimpleTalk Thereâs been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation. [External Article]( [Understanding Locking, Data Modification and Committing Data in SQL Server]( Additional Articles from MSSQLTips.com Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes. [Blog Post]( From the SQL Server Central Blogs - [Common Mistakes in SQL Server â Part 4]( Hemantgiri S. Goswami from SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server â Part 3. This week I would like to draw your... [Blog Post]( From the SQL Server Central Blogs - [Using the Pure Storage PowerShellSDK2 - Part 2 - Working With Data]( aen from Anthony Nocentino Blog Welcome back to the second installment of our series using the Pure Storage PowerShell SDK2. In this post, weâll dive into working with object data using Pure Storage PowerShell... [Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database]( Site Owners from SQLServerCentral Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instanceâs performance.   Question of the Day Today's question (by Steve Jones - SSC Editor):  The Column Synonym Can I create a synonym for a column? 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) TRUNCATE an FK I have this table in a database with a lot of data. CREATE TABLE Employee
(EmpID INT NOT NULL
, EmpName VARCHAR(20)
, MgrID INT
)
GO
ALTER TABLE dbo.Employee ADD CONSTRAINT FK_Employee_Employee FOREIGN KEY ( MgrID ) REFERENCES dbo.Employee ( EmpID ) ON UPDATE NO ACTION ON DELETE NO ACTION GO TRUNCATE TABLE isn't allowed with tables that are referenced by a FOREIGN KEY constraint. What happens if I run TRUNCATE TABLE on dbo.Employee? Answer: It works fine always Explanation: This works. The documentation notes you cannot use TRUNCATE on tables that "are referenced by a FOREIGN KEY constraint. You can truncate a table that has a foreign key that references itself." Ref: TRUNCATE TABLE - [ [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 - Development
[Canât return role based on employee no from three columns?]( - I need to write a SQL Server query return only one role from table dbo.F6000059 based on employee no, but I face issue I don't know how to return the correct role. I will return only one role from table dbo.F6000059 if "employee no" exists in columns REAN82 or REAN83 or REAN84. And role name will return will be only one roles from below [â¦]
SQL Server 2016 - Development and T-SQL
[Delete large number of rows help]( - I have a batch process where i have to delete around 75 MIL rows out of 1.3 Billion rows table. And then insert the new rows back. I have been told that there is no way to do incremental load on these. I believe the DELETE operation is taking very long (2-3 hours). Database is [â¦]
SQL 2012 - General
[how to calculate the RAM used while running a query]( - how to calculate the RAM used while running a query
SQL Server 2012 - T-SQL
[Adding records between records]( - Hi, Trying to figure out how to approach this... I will have data where these is an ID and a date. I want to add records between the two dates Max up to 6 days between the actual dates. example DATA: ID, SomeDate, Flag 3642570, 2023-09-01 00:00:00.000, X 3642570, 2023-09-06 00:00:00.000, X 3642570, 2023-09-13 00:00:00.000, [â¦]
SQL Server 2019 - Administration
[How to enable Always Encryption in SQL Server Agent Jobs]( - I am trying to run a SQL Agent job to select an encrypted column, but it's still shows as encrypted. How can I run SQL agent job to run with Always Encryption enabled.
[SQL SSIS job failing with out of memory error]( - Hi All, Most of the time SQL SSIS job failing with out of memory error. The package are hosted in SSIS catalog. My question is - Will SSIS & SSAS use memory within SQL max and min memory (or) out of SQL server? I have SQL SSIS, SSAS & two instance of DB engine. I [â¦]
[Ola IndexOptimize - USER_DATABASES failed]( - EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y' Job Name                           IndexOptimize - USER_DATABASES Step Name                         IndexOptimize - USER_DATABASES Duration                             01:00:14 Sql Severity       16 Sql Message ID 50000 Operator Emailed Operator Net sent Operator Paged Retries Attempted         0  Message Executed as user: NT SERVICE\SQLSERVERAGENT. ...0) Server: SERVER1 [SQLSTATE 01000] (Message 50000) Version: 15.0.4316.3 [SQLSTATE 01000] [â¦]
[Ola IndexOptimize - USER_DATABASES failed]( - EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y' Job Name                           IndexOptimize - USER_DATABASES Step Name                         IndexOptimize - USER_DATABASES Duration                             01:00:14 Sql Severity       16 Sql Message ID 50000 Operator Emailed Operator Net sent Operator Paged Retries Attempted         0  Message Executed as user: NT SERVICE\SQLSERVERAGENT. ...0) Server: SERVERABC [SQLSTATE 01000] (Message 50000) Version: 15.0.4316.3 [SQLSTATE 01000] [â¦]
[Expand disk size for SQL 2019 High Avalability Group]( - Hi, Due to the data growth, we have to increase the disk size where the data files resides. Our SQL 2019 high availability group is running in VMWare v.7. 2 nodes. Do I right click the VM, Edit Settings, then increase the disk size, then expand it in disk manager? I assume I have to [â¦]
[KB5029375 - SQL Server 2017 GDR]( - I have been trying, on and off, to install the latest CU/GDRs on test servers since Friday by obtaining the updates from: Latest updates and version history for SQL Server - SQL Server | Microsoft Learn I have had no problem with SQL2019 CU23 or the SQL2016 GDR. I cannot get the SQL2017 GDR to [â¦]
SQL Server 2008 - General
[MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError]( - Hi Experts, how can I fix this error NT-AUTHORITY\SYSTEM Cause: Error opening the explicitly specified database. [CLIENT: ] Thank you, Stephan
[MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError]( - Dear Experts, Nothing special, just an annoying returning entry in Windows-Event- Protocol. => SQL Server 2008 However, the Event viewer is throwing permanently an error: Error logging in for the user 'NT-AUTHORITY\SYSTEM'. Cause: Error opening the explicitly specified database. [CLIENT: ] - System - Provider [ Name] MSSQLSERVER - EventID 18456 [ Qualifiers] 49152 [â¦]
SSRS 2016
[100% stack bar chart with periods and time axis]( - Hello, I am trying to develop a report that would display periods of time (segments) on time axis and grouped by equipment, like below: Colored bars are segments (Duration in seconds). On X-Axis i would like to display time. But as long as i am using X-Axis as a default 1-100 i can see segments, [â¦]
Integration Services
[Trouble Upgrading SSIS Project and Packages from Targeting SQL 2014 to 2022]( - Taking an existing Visual Studio SSIS Project that targets SQL Server 2014 to now target SQL Server 2022 through the suggested course of the "Upgrade All Packages" has been unsuccessful. The reason being was we were trying to avoid having to recreate the project and packages from scratch. We are using Visual Studio 2019 version [â¦]
SQL Server 2022 - Development
[Extract file in zip format]( - Good afternoon, Devs. My name is André, and I'm new here. I'd like to ask for your assistance with a problem I'm currently facing. I've taken over the migration of an application where the database is in SQL Server, and there's a table containing files stored in a column of type "ntext." According to the [â¦]
  [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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -