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

Kendra’s Top 3 Tips for Working Remotely

Today we have a guest editorial from Kendra Little because she has amazing things to say.

As concerns about COVID-19 spread, I’ve seen lots of folks online sharing their tips for working remotely. While I’ve recently moved to the UK and have begun working regularly from the Redgate office in Cambridge, prior to this I worked remotely in the United States for around 10 years. Trial and error led me to develop three important habits which I recommend for successful remote workers.

Use a webcam in meetings whenever you possibly can

I know, I know: most of us database types don’t love the idea of turning on a webcam. In fact, we often feel the urge to stay hidden during calls.

However, I’ve found that remote meetings work dramatically better when as many people in the meeting as possible use webcams. This isn’t about looking pretty, it’s about helping people feel they are being listened to, and about helping people pick up nuance about what you are saying. I also find that when I have a webcam on, I am far less likely to multi-task and I tend to focus more on the meeting.

I recommend asking your employer if they will reimburse you for a reasonably priced USB webcam for joining meetings remotely, if you are open to using one. The built-in webcam on a laptop usually doesn’t make for the best experience due to poor camera quality and awkward camera positioning.

Don’t work out of Slack/Teams or your Inbox; check them regularly instead

When you change your work environment, it’s easy to spend all your time staring into a team chat window or your email inbox. This becomes your way to be connected to people, and the next thing you know you’re in a mode of constant response to things as soon as they come in.

Then, after a few hours, you’re exhausted and you aren’t even sure what you’ve accomplished.

Remote work is much more productive for me if I regularly close out my email and chat windows to focus on a task, and re-open them periodically to update status and check in on what my team is doing. If I need to be reachable for a critical task or project, I’ll look at alerts on my phone, but otherwise I try to leave it be for 30 minute periods. I also find that some of those issues which creep up in email may be solved by someone else if they sit for a few minutes.

Use a timer if you need help breaking up your work day

For some of us, it’s easy to accidentally over-work if we are working from home. Sure, I took a break during lunch to watch a Netflix show for half an hour, but … did I actually get up from my desk at all in the afternoon? It’s easy to end up dehydrated with a bad neck ache at the end of the day.

When working remotely, I use different tools to make sure I get up throughout the day: sometimes I use calendar entries, sometimes I use a free Pomodoro app, sometimes I use a time-tracking tool like Toggl (their free tier is enough for me).

Want to read more about work practices in light of COVID-19? Our team has written a few posts on the Redgate blog recently with our thoughts on this topic:

Kendra.Little

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

Redgate SQL Prompt
 
  Featured Contents

Using the RANKX function in Power BI

aveek22 from SQLServerCentral

Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]

Enterprise Insights from the 2020 State of Database DevOps report

Additional Articles from Redgate

17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.

Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause

Additional Articles from Brent Ozar Unlimited Blog

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class.

From the SQL Server Central Blogs - Import Databases to Azure SQL Database

jsterrett from John Sterrett

I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...

From the SQL Server Central Blogs - Performing a real-time replay with WorkloadTools

spaghettidba from SpaghettiDBA

In a previous blog post, I showed you how to use WorkloadTools to replay a workload in two different scenarios. However, there is a third scenario that is worth...

 

  Question of the Day

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

 

Memory Optimized Table Limitations

In SQL Server 2017, what are the restrictions for Memory-Optimized Tables (MOT) and Foreign Keys (FK)?

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)

Capitalize the name

I am loading a name into a variable in Python. I will get this from a user field, but for testing I am doing this:

Username = "steve"

I want to be sure that the name is proper cased, as in Steve. Whether someone enters "steve" or "Steve" or "Steve", I want to display "Steve. What code should I use?

Answer: name.capitalize()

Explanation: There is a capitalize() method that will return the proper case for a word. This is capitalizing the first letter and lower casing the rest. Python capitalize() results Ref: Python String Functions, 7.1.5 - https://docs.python.org/2/library/string.html

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
Missing dumps during unexpected server reboot - One of my critical database server had an unexpected reboot followed by server hung issue but sadly we are unable to find any related errors in the event logs or SQL logs . Also there was no dumps generated . I recollect there is a way that the dumps can be generated later as well […]
SQL patching solution and automation - Hi All, Would like to get some suggestion of SQL patching solution and automation for multiple servers. I have 150+ SQL with each version 2012,2014,2016 & 2017. We do not have cost to buy patching tool, is there any easy and good solution to automate this like WSUS, PS etc.
SQL Server 2016 - Administration
Finding databases with no dependencies - Hello experts, This is more of a conceptual question - I'm pretty sure I can do all of the legwork once I get pointed in the right direction. How does one go about finding which databases on a server have no dependencies? I realize this may not be totally possible because some developer might have […]
Weird issue with data transfer to Oracle - Hello all...  had an odd issue crop up and was wondering if anyone had ideas on what might have caused it... We have a nightly job that copies data from one of our local databases (SQL Server 2016) to an Oracle database at our corporate headquarters.  The setup is pretty basic - we have a […]
SQL Server 2016 - Development and T-SQL
count(*) locking a table? - Hello, Why would select count(*) from a table encounter a lock? The table in question had initial bulk insert (append records) and then update happens on those new records. In the meantime I queried the total rows - count(*) and it locked the whole thing. Eventually I had to kill the query with count(*). Did […]
Administration - SQL Server 2014
SQL Server CPU utilization - Hi there, i am using this script to get the cpu utilization. Unfortanetly I get wrong results. The NonSQLCPUUtilization is always negative. It's a SQL Server 2014 with CU4. We have an other SQL Server 2014 with CU4 where it works correctly. Any hints are appreciated. Regards select top 10 id, SQLServerCPUUtilization, 100 - SystemIdle […]
Configuring SQL Replication using Remote Distributor: Create Publication Error - Dear Team, I am currently on SQL server 2014 R2 and I have been trying to replicate my LIVE database to a report server using a remote Distributor. Currently, i am getting the error as shown below: TITLE: New Publication Wizard ------------------------------ SQL Server could not create publication 'XXDB_PUB'. ------------------------------ ADDITIONAL INFORMATION: An exception occurred […]
Encrypted Log Shipping - I've found a number of articles on encrypting backups and transaction log backups, but all these are based on manually generated code to include the encryption details in the backup command. Is there anything out there covering how Log Shipping can be enabled to include encryption, and if so what version of SQL has this […]
Setting up replication - Hello, I'm am an experienced DBA and developer but am new to replication.  I have to set up replication on a ~100 GB database and have some questions.  I am replicating from our production database to a reporting database on a different server. Any estimates on how long it will take to do the initial […]
SQL 2012 - General
String extraction - SQL 2012 - Hi, I need to make changes to the below to only extract '2002' as the result. select REPLACE(REPLACE(SUBSTRING('CKnovelty2002_pouch-5AR-OneSize',1,CHARINDEX('-','CKnovelty2002_pouch-5AR-OneSize',1) - 1),'CKnovelty',''),'CKflower','') At the moment, I am getting '2002_pouch' as the result which is incorrect. The expected output is '2002'. Can somebody please help in this regard ? Many thanks.          
SQL Server 2019 - Administration
not in vs in - I was looking at a T-SQL report query and saw that not in was being used..  I know its better to use IN than NOT IN.. Any inputs?
SQL Server 2008 Performance Tuning
Optimise/ speedup query - Below query is used for inserting and updating the tables in the SQL Server database. The XQuery is slow while executing in SSMS for first time.I am using SQL Server 2008 R2. The total time taken for 500 queries is 20 to 40 seconds. How can I optimise this query to speed up the execution? […]
SSRS 2016
PowerBI Paginated Reports vs SSRS reports - I have a reportserver where I am currently deploying both PowerBI desktop reports, and SSRS rdl reports. We're setting up standards for the team for our PowerBI reporting to match up to our SSRS standards (logos/header/footer elements/color schemes/etc.). Searching online has led us to the conclusion that adding header/footer is best served by using PowerBI […]
Integration Services
extract all data with week - Good morning all I have a table that contains the history of a table over 1 year old he asked me to extract one file per week so we total I must have 54 files Who can help me with this need please
Importing files from azure blob source into SQL Tables - by date range - I'm trying to pass a date to an azure blob storage source within a ForEach Loop and it doesn't look like it takes a dynamic filename.  The ForEach Loop needs to find files after a date specified by a variable and then import it into a SQL Table. For the life of me I can't […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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