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

Daily Coping Tip

Be a realistic optimist. See life as it is, but focus on the good.

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.

To-do list: good, bad or indifferent?

Today we have a guest editorial as Steve is on vacation.

All of us have to organize our efforts at work to get things done. I would guess a number of us use a to-do list. It might exist in Excel, OneNote, Notepad, just a plain piece of paper, or just in our minds. A list helps us to stay focused on what needs to be accomplished. It can also give us a sense of accomplishment when we cross something off the list. It also can make us feel like we are making progress toward a goal. Hopefully, we know what the end goal is and where it is leading us.

There can also be downsides with a to-do list. The list can become overwhelming and unmanageable. Sometimes things never seem to get crossed off. Perhaps it is because nothing seems to get fully completed, or just because we are pulled in so many directions, it can be hard to focus and to get much done. What does it matter if our to-do list gets accomplished since we can’t see above the waves of chaos that is our job?

In some situations, the demands on us are already so overwhelming, we are just dealing with issues and emergencies all day long. In this case, a to-do list is almost meaningless since it is never even looked at. You are just too busy trying to keep the ship afloat to even worry about where things are heading. The current fire that needs to be put out is what you are working on.

Sometimes not having work direction can be a problem. It is hard to create a to-do list if you don’t know what your priorities should be. If you do have a manager that clearly passes down to you what you should be working on, that can be helpful. Still, in some cases, the directives being passed down can be pretty general so it isn’t always easy to get down to the specific steps of what needs to get done.

It seems like the to-do list is only as good as the vision and plan behind them. If you know where you are going, you can figure out the steps to get there. If you don’t know where you are going, then it doesn’t matter what you are working on or in what order you try to accomplish things.

I think planning sessions can help with this. Having a team of people thinking about where, as a company / department / team, you are trying to go and what you are trying to accomplish. What issues are you currently facing? Where you want to be in six months to a year or 5 years from now? Once a plan is decided on, the steps to get there can be formed and directives can be given to groups. Then they can know what they should be working on and what should be their priority. Then it is up to you to use a to-do list or some other method to manage the things you need to accomplish.

How about you? Do you use to-do lists? Do you have clear directions on what you should be working on where you work?

bkubicek

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

 
 Featured Contents

How to Delete Large Amounts of Data

Jim Youmans-439383 from SQLServerCentral

As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables.  This is especially true with logging tables.  Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]

Model and Log Trend Reversals for Time Series Data in SQL Server

Additional Articles from MSSQLTips.com

This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.

Monitoring Large Estates at BMW

Additional Articles from Redgate

BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges.

From the SQL Server Central Blogs - PASS Data Community Summit 2021: I’m Excited!

Grant Fritchey from The Scary DBA

I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...

From the SQL Server Central Blogs - Quick Database Copies and Branching with Spawn

Steve Jones - SSC Editor from The Voice of the DBA

I delivered a talk last week at the Future Data Driven summit. It’s one I’ve done a few times, but I really enjoy it. It’s on the Future of...

 

 Question of the Day

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

 

Concatenating Dynamic SQL

I execute this code on SQL Server 2019. Each of the tables has one row in it. What happens?
DECLARE @SQL NVARCHAR(4000);

SET @SQL = '
 SELECT mystring 
   FROM TableA;';

SET @SQL += '
 SELECT mystring 
   FROM TableB;';

select @SQL

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)

Minimum Point in Time Recovery for Azure SQL Databases

There is a default period of time for point in time recovery (PITR) on Azure SQL databases for 7 days. However, this can be reduced to lower your storage costs. What is the minimum number of days you can configure for PITR for active and deleted databases? (as of Aug 2021)

Answer: 1 day for active databases, and 0 days for deleted databases

Explanation: As of Aug 2021, you can set your PITR to 1 day for active databases and 0 days for deleted databases. There are considerations in terms of recovery, so be aware of the implications of shrinking this window. Ref: Backup storage cost savings for Azure SQL Database and Managed Instance - https://azure.microsoft.com/en-us/updates/backup-storage-cost-savings-for-azure-sql-database-and-managed-instance/

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
Inline Table - Please assist creating an inline Table Valued Function. Output  https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=drivesdk Data https://drive.google.com/file/d/1mkBA8Uc8tZjhWdzqGaxLAPnNoqpBSfMZ/view?usp=drivesdk
Inline Table - Please assist creating an inline Table Valued Function. Output should look like this: https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=drivesdk Data https://drive.google.com/file/d/1mkBA8Uc8tZjhWdzqGaxLAPnNoqpBSfMZ/view?usp=drivesdk
SQL Server 2016 - Administration
Shrink never ends - Hello, Sorry for my English. I am aware of the problems and why we should never perform a shrink, however, in this case it is necessary. I have a database where the mdf file is about 1.6Tb, but the database only uses 800Gb and I need to reduce it. I tried to reduce only 10Gb […]
SQL Server 2016 - Development and T-SQL
Need help with calculating data between 6pm-6pm instead of 12am-12am - Hi, I am looking to calculate some data. We have orders dropping every day, and I need to calculate the number of orders that dropped between 6pm yesterday till 6pm today. I tried doing DATEADD(HOUR,-6,cast(CONVERT(VARCHAR,CREATE_DATE)+ ' '+ CONVERT(VARCHAR,CREATE_TIME) as datetime)) but that just changes every hour to go back 6 hours. I need to create […]
Dynamic SQL? Inserting Sproc data into table variable - Hello, I have a bunch of stored procs that I'd like to execute all at once,  insert their results into a table variable, and then insert those results into a physical table.  I can get the code to run fine to actually execute all the sprocs one after the other using a cursor (there aren't […]
SQL Server 2019 - Administration
SQL 2016 to 2019 upgrade benefits - Can someone help me with good reasons / selling points to upgrade from 2016 to 2019?
SQL Server recovery - Hi  There! Question related to recovery of SQL Server....When an SQL server crashes, from where does SQL server know the recovery path, as the buffer (RAM)contents are lost during crash ? Thanks in advance. Best Regards Arshad
How to start an Index Review Project - Dear Colleagues, I’m not sure this is the proper channel If you were in charge of review a group of databases and give index recommendations, and this is the particular point of interest. How could you start your session, I’m thinking in Current index inventory Current index usage New indexes recommendations What do you think […]
Unable to uninstall sql 2005 on windows 2008R2 - Dear, unable to uninstall sql server 2005 on windows 2008R2 server, when i click on uninstall from control pannel, after a while the uninstall window will disappear and it is not uninstalling. Thanks
SQL Server 2019 - Development
Non-clustered Index - I have a blog. To log in, I request a User Name. Should I have a non-clustered index on that column? Also, in another table, I query on the email address, should I have a non-clustered index on that column? In both tables, I have an integer field as the primary key.
View or Stored Procedure? - To create an output like this: Do i create a stored procedure or view that would allow this end result above?   SQL:  
Extraction of mean, max, min and sd extraction inside 5-95 quantiles - I'd like to extraction the mean, max, min and sd extraction inside 5-95 quantiles for the variables B2, B3, B4, B8, NDVI, SAVI, SIPI, SR, RGI, TVI, MSR, PRI, GNDVI, PSRI, GCI aggregate by AGE and ESPAC variables inside CMPC table: CREATE TABLE CMPC( x NUMERIC(8,4) NOT NULL ,y NUMERIC(8,4) NOT NULL ,stand VARCHAR(11) NOT […]
Azure Data Factory
data flow "delete if" setting- sink Delta lake - Hello, I have the upsert if working for the .parquet files by selecting the upsert if setting to true() For example when the source is update ,then the parquet sink is updated accordingly. But if a row is deleted in source it is still shown in sink parquet even when check the Allow Delete. Any […]
Connecting
AZ Sql Database Cross Database Query Identity syntax - Attempting to follow directions from @SteveJones & MS documentation for setting up key for Azure Sql Server cross database queries. CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''; CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH IDENTITY = '', SECRET = ''; We're receiving an error with the IDENTITY parameter. The examples look very straightforward but aren't […]
General
Is it possible to improve one's environment, by going rogue? - Today Steve Jones posted an excellent article on whether or not your company has a talent gap. I recommend you read it. While responding to Steve's article I had a thought. I felt my ideas were too far off Steve's article, so I didn't want to detract from his thread. So, I'm going to ask […]
 

 

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

 

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