Using Graph Theory To Group Records (2022-07-04)

SQLServerCentral Newsletter for July 4, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Using Graph Theory To Group Records]( - [How to Import and Export Connections from SQL Server Management Studio]( - [Accelerating Digital Transformation: The role of DevOps and Data]( - [From the SQL Server Central Blogs - Shutting down nodes in Azure Kubernetes Service]( - [From the SQL Server Central Blogs - T-SQL Tuesday 151 Round up: Coding Standards]( Question of the Day - [The July Fourth Anniversary]( The Voice of the DBA  Daily Coping Tip Notice how positive emotions are contagious between people 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. Independence Day 2022 Today is July 4th, Independence Day in the US. While many countries have a similar day marking a similar milestone in their history, I live in the US, so it's a holiday for me and I usually take the day off. Always a good time to rewatch [Independence Day](, though this year I may take a little time away from chores and watch [the sequel](, just because I haven't seen it. While it's a day of celebration here, it's often a day that somewhat marks the halfway point of the year for me. Just over six months are gone and almost six more to come. I usually look at these milestones and think about whether it's been a good year, am I approaching life as I want to, and are there things I might want to change for the next half of the year. 2022 has been great for me, and I can't complain about anything. I've gotten to travel, I had a great season coaching kids, my kids are all 21+ adults and doing well, I'm healthy, and I couldn't really ask for more. The second half will continue things, though with a little less travel. April/May/June was a rough stretch of time away from home. Hopefully you can say that 2022 has been good for you, but if not, what will you change in the second half? Happy Fourth of July. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Using Graph Theory To Group Records]( Glen Cooper from SQLServerCentral Learn a little basic graph theory in this article that replaces a GROUP BY clause. [External Article]( [How to Import and Export Connections from SQL Server Management Studio]( Additional Articles from MSSQLTips.com In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS. [External Article]( [Accelerating Digital Transformation: The role of DevOps and Data]( Additional Articles from Redgate SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization. [Blog Post]( From the SQL Server Central Blogs - [Shutting down nodes in Azure Kubernetes Service]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in... [Blog Post]( From the SQL Server Central Blogs - [T-SQL Tuesday 151 Round up: Coding Standards]( Diligentdba 46159 from Mala's Data Blog I received a great collection of blog posts in response to my T-SQL Tuesday 151 – asking people to write on T-SQL Coding Standards. Rob Farley (t|b) is of...   Question of the Day Today's question (by Steve Jones - SSC Editor):  The July Fourth Anniversary Which of these gives us number that represents today's anniversary of the Declaration of Independence? 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) Choosing Filestream At what size should you consider using Filestream for storing blob data in the filesystem instead of a Varbinary column? Answer: When the BLOB is > 1MB Explanation: You should consider Filestream when BLOBs are > 1MB. Ref: FILESTREAM - [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 2016 - Development and T-SQL [Create Multiple XML Files using SSIS]( - Hi community, I have a table in my database which consists of 100,000 rows. I am trying to move this data to 10 XML files (10,000 each rows). I am able to convert my data to XML format using ZS Export XML Task. I basically want my XML files like this: Individual_1.xml, Individual_2.xml, Individual_3.xml and […] [Designing a table]( - I have a scenario where: a company can have many workers(01,02) & worker can have multiple jobs (jb01, jb02) within the company, and in each job the worker can have 3 training courses (tr01,tr02,tr03) every year (2020,2021,2022). I need to create one table to accommodate this scenario to record the courses each worker did in […] [Replace calendar table multiplier column with date logic]( - Hello All, It's been a while. See the DDL/DML. I have a multiplier field associated with each day in a calendar table that I would like to replace with date logic. Updating the multiplier data is a yearly chore requiring an UI/data entry but really we would like to encapsulate the logic rather than relying […] Development - SQL Server 2014 [Best practice]( - Hello friends, I am planning to setup some process for archival. The configuration part I have thought of but execution wise all I can think of sequential. I want to make it generic but can't think of a way around. Setup I am thinking of us something like this: 1. Configuring table with base table […] SQL Server 2019 - Administration [SQL Server authentication issue with linked servers & mixed authentication types]( - I have a target server that I have read-only access to with Windows authentication. We'll call this Server01. I need to aggregate some data and do some analytics that isn't always easy in-session so I need to store some data more permanently than in temp tables. I also need to correlate with other data from […] [Performance problem]( - Hi I have one server running SQL server 2017 and one running SQL server 2019. The developer has reported that the SQL 2019 is much slower than the SQL 2017. Both servers are virtual and has the same spec regarding memory, CPU, OS ( Windows 2019). The settings in SQL is the same on the […] [AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password]( - Hi, I am having error in creating AG Group Listener. We finally try to create one from Failover Cluster Manager by right click on AG role and added Listener from there. Listener IP comes online but Listener name still shows offline state. Please if anyone having same error, how to fix this. I am lost. […] [How to take offline backup in sql without interrupting Application connectivity]( - Hello All, My requirement is to to take full backup of the databases in below two production environments. We were doing Prod migrations. Before that we were planning to perform mock cutover. Without any down time or stop the application we would like to take the backups in both environments. 1st environment: Always on Configuration. […] SQL Server 2019 - Development [Retrieving date from next from to fill in column on row above]( - Hi all, I have a very short query that contains an effective date but not expiration date. I would like to populate a expiration date set to 1 day before the next row's effective date. Here is query and results. For example, on part 100-121-0000, Revision A2; I'd like the Expiration Date to be 08-09-2009 […] [Getting count from Scheduled job procedures]( - I have a new requirement to create a Power BI Dashboard that shows current running jobs, average duration and a number of other KPIs including how many records are returned from a particular scheduled stored procedure. Is there an easy way to return this value? Most of the other data I can get from the […] SQL Azure - Administration [How to set up Replication Alerts in SQL MI]( - Hello, Since Operators are not supported in SQL MI, how do you set up in SQL Managed Instance the Alerting on the normal Replication Monitoring?  Normally can setup the 'Latency exceeds the threshold' and 'Warn if a subscription will expire' but they are configured with Alerts which isn't supports in SQL MI.  Thanks,  […] General Cloud Computing Questions [MySQL and Cloud SQL]( - Hello all, I’m working on a go web app and am using the app engine. Right now I am trying to set up a landing page for an email list (for a soon to come site). I’m a bit confused as to how cloud SQL works. From my understanding I still have to install MySQL […] Azure Data Factory [Data factory question]( - Upon my adventures of Azure data factory and all the wonders it can do I have stumbled upon a issue that Microsoft support has no answer as of yet. Long story short, I am trying to ingest data from a storage blob in another tenant. That customer will only allow us to connect to that […] Powershell [Attempting to run PS / DBA tools script as a SQL Agent job]( - If I run my PS script with PS as an ADMIN interactively it runs fine. If I attempt to run it as a SQL Agent job it has issues. I think the problem is it needs to run as an ADMIN but I cannot figure out how to do that. Has anyone had issues running […] SQLServerCentral.com Website Issues [Alerts and default font]( - I have not been receiving e-mail alerts in the last few days. Also, when I type a post, it looks like the default font has changed to Courier 9pt or similar ... even though the published post renders as usual.   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -