SQL Server Engineering Using Free Tools (2022-10-28)

SQLServerCentral Newsletter for October 28, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [SQL Server Engineering Using Free Tools]( - [Expert-led PASS Data Community Summit Pre-cons]( - [SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more]( - [From the SQL Server Central Blogs - Memphis SQL Saturday 2022 & a Notebook]( - [From the SQL Server Central Blogs - Composite Models in PowerBI -- The solution to poor search performance in SSAS]( Question of the Day - [Terraform Targets]( The Voice of the DBA  Daily Coping Tip You can’t do everything; what are your three top priorities now? 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. Using Time Wisely As I get older, I realize more and more the value of time. I also realize this is a very limited quantity for me, getting more precious each day, and one of the more valuable assets I have. Time with my wife, time with my kids and my extended family is precious. Time for hobbies, work, and more is difficult to come by. At the same time, I've been learning to take time off from things and enjoy the lack of trying to use that time. I find myself looking at email or checking some work item less and less on weekends and holidays. At least, I avoid working if I've had a productive week. Quite a bit of my work is independent and can be asynchronous with others. I might spend time during the week on something personal and then make up time on weekends. Often that's the case when I am called on as the emergency ranch worker if someone else isn't available. In trying to efficiently use time, I find myself often trying to think ahead and work on things well in advance of deadlines. I can procrastinate as much as others, but I tend to look forward a week or two all the time. This helps me avoid last minute crunches, though sometimes I find myself stressed about multiple things that are due next week and the week after. I still have time management issues and stress, it's just not for something due today or tomorrow. Usually. Like everyone else, I'm human. Despite my best intentions, I don't always use time wisely. I find my moods vary throughout the month. My energy can peak or wane. My focus can be strong or weak. I'm fallible, and that in and of itself can bother me and affect my efforts. I know time is valuable, so when I haven't had a productive day or gotten enough done, that can carry over into the next day. As I try to be better, I am learning a few techniques. First, if I am productive, I usually lean into this. I can be very productive in a short time, so when I am in the zone and focused, I work hard. Even if this impacts something else. I might skip the gym one day, not cook dinner, and work late because when I am efficient with my time. When this happens, I've also learned to forgive myself for not following my plan. Sometimes my plans fall apart, even when I am the one that is often in control of the creation and execution of the the daily plan. I've also learned to move away from difficult creative tasks. Whether that's writing or assembling some code, when I don't feel like doing that work, I move on to something else. Often administrative things, catching up on meeting recordings, or other somewhat low focus tasks keep me using time wisely, even if less efficiently. Finally, I am lucky in that I can abandon work some days. Not any day, but sometimes things fall apart, and I accept that. I'll handle something in my personal life, or go do something fun. I know this means I will need to make up the work, and let my wife know that my schedule has shifted, but it's a way of remembering that time is valuable everywhere. Both for work and in my personal life. If I need to work on a Saturday, then I need to be sure I can recapture that time away from work somewhere else. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [SQL Server Engineering Using Free Tools]( Wingenious from SQLServerCentral You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit! [External Article]( [Expert-led PASS Data Community Summit Pre-cons]( Additional Articles from Redgate Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now. [External Article]( [SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more]( Additional Articles from MSSQLTips.com In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure. [Blog Post]( From the SQL Server Central Blogs - [Memphis SQL Saturday 2022 & a Notebook]( DataOnWheels from DataOnWheels Back in person again! It is awesome to be able to get back into the SQL community and see fellow data professionals. A huge shout out to the Memphis... [Blog Post]( From the SQL Server Central Blogs - [Composite Models in PowerBI -- The solution to poor search performance in SSAS]( sqlrunner from SQLRunner With the release of composite models in PowerBI, Ive been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Terraform Targets Someone asks me to use Terraform to define the types of infrastructure our organization needs in the cloud. With which cloud providers can I use Terraform scripts? 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) Robust Plans What does the ROBUST PLAN query hint do? Answer: Tells the optimizer to plan for the max potential row size Explanation: This query hint tells the optimizer to plan for the max potential row size, to avoid potential errors when processing wider rows with certain operators. Ref: Query Hints - [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 [Publish AWS RDS SQL Server Database]( - I am in the process of migrating an on-premises application to AWS. The on-premises app publishes a SQL Server db, subscribed to by a couple of other servers in our environment. I am struggling to find a way to replicate that functionality in AWS RDS SQL Server. Lots of guides on replicating into RDS, but […] [Get Read and Writes per a duration]( - Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month. Currently, I am using the following query: SELECT name AS 'Database Name' ,SUM(num_of_reads) AS 'Number of Read' ,SUM(num_of_writes) AS 'Number of Writes' FROM sys.dm_io_virtual_file_stats(NULL, NULL) I […] SQL Server 2017 - Development [Update Column query]( - Hi All. Need help in implementing this logic. I have a table in below format. Currently, a new Config ID is generated for every item number- Revision combination. I want to take the config ID of minimum(Revision) for every item number and update it per item number. Expected Config ID is desired output. It is […] SQL Server 2016 - Administration [Patching AlwaysOn AG]( - Hello Everyone, I have Availability Group, one primary replica and one secondary replica. SQL Server version is 2012. It is configured for automatic failover and is in synchronous mode. I already googled but found different answers, so I want to know the correct procedure. How to do patching step by step. SQL Server 2016 - Development and T-SQL [Create table having a StartDate and EndDate for each week]( - I want to create a table that has a StartDate, EndDate, WeekNum for the year 2021 starting with the First Wednesday of January to the end of December ( I know the last week may land in 2022, that's fine). So in 2021, the first wednesday is January 6. So the table would start with […] [SQL server help]( - I need to show the total count for a particular field with my select statement. But this should be shown only once for each VID. I wrote the following to get the count, but it displays it for every record. Is there away to display it only in one row for a specific VID? I […] [SQL 8144. Error: Procedure \'InitiateLoad\' has too many arguments specified.]( - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:  CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] [SQL 8144. Error: Procedure 'InitiateLoad' has too many arguments specified.]( - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:  CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] [Capturing what calls a trigger]( - I have a DML trigger and I need to know where the action is being called from, whether it be a simple T-SQL command or a stored procedure. For example, if I have an insert trigger on Table A and that trigger runs, I want to know what code was executed that caused the trigger […] SQL Server 2019 - Development [How do I JOIN to a Linked Server in a VIEW without using a CTE]( - I need to create a VIEW that joins a table in the current database (SSMS2019 environment), to a table in a database on a different server (SSMS 2014 environment). The VIEW will be created in the 2019 environment server. To start, I created a Linked Server in my 2019 server called [REMOTE_SERVER_2014_ENV] which successfully connects […] SQL Azure - Development [What can we do about SSRS and SSIS in an Azure VM?]( - We have a third-party product which uses SQL Server 2016. It also uses both SSRS and SSIS. The network group wants to migrate the test version of this database into an Azure VM - basically a lift and shift approach. We asked the vendor of the application for their input as to the viability of […] SSRS 2016 [Drill down Action: one main report with two subreports]( - Hallo, i have to implement one main report with two sub reports. In the main report and the subreports the columns are closed. By a drill down action, the selected column in each of the three reports should open. How can I implement this drill down behaviour in all three reports? Thanks, duloran  General [When using Microsoft 365 tools, how do you backup your data?]( - Is there any easy way to automatically backup my data using the microsoft 365 tools, and it is possible to set schedules? and is there any option to retrieve my loss file?. Thanks by the way. Integration Services [How to keep For Loop Container continue on error?]( - Hi all, So I found a solution of a problem I was having with For Each Loop Container in my SSIS package. If error was received on any of the task inside container the package was failing instead of going to next iteration. The solution found here: is to create event handler on error and […] SQLServerCentral.com Website Issues [E-mail Notifications]( - I've noticed that I've received no alerts today. Are others experiencing this?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -