Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Find a new perspective on a problem you face

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.

A Scary Situation

Today is Halloween, a holiday of costumes, candy, and scary movies. My family has enjoyed scary movies over the years, though not necessarily on this date. However, the theme has me thinking about the scary situations that you've encountered, or maybe those that worry you in your job.

I don't worry about too many scary things in my job. I do get some anxiety before some presentations, and there are times I've been nervous before recordings, but it's helpful for me to remember that none of these things are likely to be remembered for long if I do.

That didn't help me when I gave a keynote at the Rocky Mountain Tech Trifecta years ago. Most of the 600 people in the audience didn't bother me, but my wife was there to see me for the first time and that was scary. I had to talk to myself before I went on, reminding myself to relax and just deliver the talk I'd prepared. Fortunately, I didn't mess it up and she enjoyed it.

As a developer, I haven't been too scared when writing or deploying code. I came into this business watching so many bugs get thrown over the wall and deployed that I rarely worried something I submitted would have bugs. I knew there would be bugs in some code, and it wouldn't be a big deal. Others would have reviewed my code and when a bug report came back, I'd just write new code that solved that bug (and hopefully didn't introduce others).

As a DBA, the scariest times are when you actually have to restore a database that matters. I've had CEOs, VPs, CTOs, and plenty of managers in between staring over my shoulder, asking questions or commenting on the importance of the act. When you're bringing back a database with a bunch of log files, that creates some pressure and stress. Lucky for me, I've been able to perform well in those situations. If I hadn't, perhaps I'd have never started writing or built SQL Server Central.

What are your scary stories today? What things make you nervous or create some anxiety? I think the scariest times I've had in a few jobs were when companies were reorganizing and looking to lay off a portion of their staff. Those are never good days, and while I usually survived, the stress before knowing the results was very scary.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling

Surendra Kumar Reddy Koduru from SQLServerCentral

This article shows how one can use SSIS to find differences in SAP.

External Article

How SQL Monitor gives developers the information they need to develop faster and smarter

Additional Articles from Redgate

Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they become problems.

External Article

SQL Cheat Sheet for Basic T-SQL Commands

Additional Articles from MSSQLTips.com

In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.

Blog Post

From the SQL Server Central Blogs - Granular Cost Management for Azure Data Factory

Koen Verbeeck from Koen Verbeeck

A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost...

Blog Post

From the SQL Server Central Blogs - Where did this database come from??

gbargsley from GarryBargsley

Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The Scariest Data Type

What's the scariest data type in SQL Server?

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)

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?

Answer: Azure, AWS, Google Cloud Platform (GCP), and others

Explanation: Terraform codifies the cloud APIs and works with any of the major cloud providers. Ref:

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: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/ 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 FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -