How to Use PowerShell to Set Secure SA Passwords in Bulk (2022-09-16)

SQLServerCentral Newsletter for September 16, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to Use PowerShell to Set Secure SA Passwords in Bulk]( - [Managing Static Data in Flyway Database Development]( - [SQL WHERE Tutorial]( - [From the SQL Server Central Blogs - Future Data Driven]( - [From the SQL Server Central Blogs - Web Hosting SQL Database Management Made Easy With Linux]( Question of the Day - [Service Broker Issues]( The Voice of the DBA  Daily Coping Tip Aim to be good enough, rather than perfect I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Paying It Forward on the Internet A big part of SQL Server Central has been members of the community answering questions for others. We have an amazing community and over the years, it's been helpful to so many people. I often get the thanks, but really [the people at the top of the all-time list]( have been those that have helped many people. There are too many to list, but gilamonster, Jeff Moden, lynn-pettis, lowell, and more have been tremendous assets to our community. Part of the inspiration for StackOverflow years ago was SQL Server Central and the popularity of people helping others. The main thing their founders didn't like from us (and other sites) was the need to register. Hence, the ability to be anonymous on Stack if you choose. No matter what format or style of Q&A you like, Stack and many other sites have found that there is a lot of desire to ask and answer questions online. Brent Ozar answers questions regularly during [his office hours](. I enjoy watching the recordings, especially from the beach. I miss the beach, but I love the mountains, so I'm only a bit jealous. However, recently he had a number of questions come through that he declined to answer and instead put out [a post, inviting the community to answer](. There are some interesting answers in there, and some are worth reading. Maybe you even want to add your own thoughts to some of the questions. A big part of my career, and in life outside of my career, is helping others improve their lives. Answering questions for others got me started on this path of SQL Server Central and speaking at conferences. Coaching my kids led me to coach others. Thinking about both those things got me to volunteer at other organizations. I've had success, so I'm paying it forward in different ways. I'd encourage you to do the same. Whether online or in your local community, whether now or at some point in the future, paying it forward is good for your soul. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to Use PowerShell to Set Secure SA Passwords in Bulk]( Vincent92 from SQLServerCentral Learn how you can bulk set passwords using PowerShell for all your instances. [External Article]( [Managing Static Data in Flyway Database Development]( Additional Articles from Redgate If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell. [External Article]( [SQL WHERE Tutorial]( Additional Articles from MSSQLTips.com In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table. [Blog Post]( From the SQL Server Central Blogs - [Future Data Driven]( Steve Jones - SSC Editor from The Voice of the DBA I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the... [Blog Post]( From the SQL Server Central Blogs - [Web Hosting SQL Database Management Made Easy With Linux]( Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero If you’ve never used Linux before, you might wonder how to manage a database on a server. Managing a database can be simple or complex, depending on the needs...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Service Broker Issues If I want to check Service Broker conversations for issues or problems with the configuration of Service Broker services, which utility should I use? 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) The Migration Tool to Use II Which migration tool is suited to migrate DB2 to an on-premises SQL Server? Answer: SSMA Explanation: The SQL Server migration assistant is used to migrate DB2, Oracle, Access, and SAP ASE to SQL Server on premise. Ref: Compare SQL data migration tools - [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 [MDF size increasing without table size increase]( - We have a database whose data file size was 1500 GB and used space within the file was around 900 GB on Friday. Today when I checked, the file has grown to 5200 GB and it is growing continuously. When I did the breakup of table sizes, its still 920 GB, which is expected. How […] SQL Server 2016 - Administration [Node quarantined status not cleared]( - Hi, Two node AG cluster nodes . one of the node went to quarantined state due to we had network issues multiple times. Quarantined state remain same more than 14 hours. Node status green color up & running also cluster resource online and AG role also running. I tried below PowerShell commands Get-Cluster | Format-List […] SQL Server 2016 - Development and T-SQL [Query for abnormal differences / find ouliers]( - Hi , I am trying to build a query that will identify 'abnormal' differences in the values column between each successive date record available for each individual account. The table will have multiple accounts and I want to identify the abnormal differences. The difference threshold to be identified is an absolute value of 80. thanks […] SQL Server 2019 - Administration [Need TABLE DDL to define finite list of column values]( - Looking for sample DDL syntax to CREATE a TABLE w/ a COLUMN that includes list of finite values. For example, I only want 4 allowable SQL Versions stored in the column SQLServerVersion below. What is the correct DDL to accomplish this? CREATE TABLE MyTable (ID INT IDENTITY(1,1) NOT NULL, MySQLServerName NVARCHAR(40) NOT NULL, SQLServerVersion NVARCHAR(40) […] [how to remove schemabinding from all functions and view in one go.]( - I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done? 2) I have few cols with columns in my database where collations is specified, i want to remove them in one go,  how both things can be done with few […] [last time index was re-org or rebuilt?]( - i'm unable to find such script online. i found some that had last stats updated but it's not the same thing i'm looking for. any ideas/suggestions? thx [ACCELERATED_DATABASE_RECOVERY and increase in database size]( - Hello , I am looking please for your feedback on the activation of "ACCELERATED_DATABASE_RECOVERY" In SQL server 2019 Especially on the size of the database because I'm worried if I see this SQL Server 2019 - Bug? Databases Auto Growing Out of Control Thanks [SQL on Virtual Machine]( - Hello Fellow Database Enthusiasts, I am an old guy and virtual machines are new to me, normally on a SQL server installation that you are going to have several or more instances running, you would have separate partitions that the instances are installed on, is that necessary on a VM machine running Windows server 2019? […] SQL Server 2019 - Development [Renaming JUST THE EXTENSION OF multiple files in a folder using SSIS]( - Hi, I have three files in a folder - SourceFolder ABC.edifact DEF.edifact NJF.edifact I need to rename these three or more files which drop into the above folder every day to ABC.txt DEF.txt NJF.txt The folder should remain the same, I just need to rename the extension of all files in a folder. I tried […] [Problem : Passing a Variable is not working in Dynamic Query]( - Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop through a list of tables name stored in a table 'tbl_names' and produce an output of tbl_name, row count My code is a follows: /* Table tbl_names has 3 column (id, tbl_name varchar […] [Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)]( - Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supposed to alter a table. I am supposed to add two constraints, these being the addition of a primary key and the addition of a foreign key (Some_ID). However, Some_ID is NULL and I am supposed to […] [Pivot columns to get 0 /1 flag columns]( - Hi, I have a dataset of employees with different "Paytypes" in a single column. I am trying to pivot the table on the Paytype column so that each paytype can be treated as a flag column, i,e, the only possible values in this column should be 1 or 0 Below is a sample code with […] Amazon AWS and other cloud vendors [AWS Managed Grafana authentication]( - Hello. I have built a small project where I call Lambda which parses some data from a website with Selenium and then stores the results to RDS (Postgres). I'd like to visualize this data. It is timeseries data, so I would need something where I can drill down to a certain date, month, year... So […] Reporting Services [world map and errors loading map for VS 2022]( - [Updated 9/6/22] What is the easiest way to get a world map into the map gallery so that I can embed into my report? Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report: "An attempt was made to load […] General [What should I have done with this?]( - I received this in the mail today. Any thoughts?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -