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

Daily Coping Tip

Mentally scan your body and notice what it is feeling today

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.

You've Changed. Has Your Employer?

This past year has been one to remember. It's disrupted lives and changed the world in many ways. Whether you have been cautious or fearless, scared or angry, the pandemic has changed you and the world. There's an interesting read at Fast Company about life during the pandemic and how life has been turbulent from one point of view.

While I related to some of this, I didn't relate to a lot of it. I know I've been lucky, and relatively lightly affected by this pandemic. I've published, and needed, coping tips. I've looked back periodically, recording how I feel about life. I've changed, and I've struggled, but I've also been able to do things and I didn't have the lockdown, limited life that some tech pros had, and I certainly didn't have the struggles with security and finances that many less privileged dealt with.

I've also had a great company that recognized issues last February and started preparing us, even before the UK went into a lockdown. While I haven't visited with fellow employees in person, we've adapted and continued with some level of success for over a year. We hire and onboard people, software is getting written and sold, and life moves on, in many ways a reasonable facsimile of what we did in 2019.

We've also changed. Remote offices have closed. A limited, experimental opening has few people actually taking advantage of going to work in a group. We've adopted and abandoned some of the early coping meetings and are looking for new ones. We've promised people they can move away from a city with an office, though remain within a reasonable travel time, for the rest of the year.

We are experimenting with remote first, which is an attempt to adapt for the future to a distributed workforce, including our annual reteaming. I suspect trips to the office for many, including me, will be rarely scheduled, and used more for team building and brainstorming, with less tactical, let's do something for today, work.

I wonder how many of you will see your work change. We're the privileged group, working in a field where we can accomplish tasks without physical interaction, but one we many of us might find that we do crave some sort of social touch. Maybe the world has changed it, and maybe it's changed some interactions, but I also suspect some companies are looking forward to returning to the world as it was in 2019.

Steve Jones - SSC Editor

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

 
 Featured Contents

Converting Binary Numbers To Hex

Steve Jones - SSC Editor from SQLServerCentral.com

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

Power BI Anomaly Detection

Additional Articles from MSSQLTips.com

One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.

Redgate Tool Tips

Additional Articles from Redgate

Redgate recently invited customers to share their tops tips for improving productivity using Redgate tools. This blog outlines their hints and includes relevant training resources to further your learning.

From the SQL Server Central Blogs - The production database just went down! What do I do?

Adetokunbo Ige from Adetokunbo Ige

A few of my colleagues can relate with the title of this article, they might have experienced an issue with the database in production. Dear colleague, you are not...

From the SQL Server Central Blogs - The SQL Saturday Foundation Board of Directors

Steve Jones - SSC Editor from The Voice of the DBA

I’m pleased to announce that I have selected an initial board of directors for the SQL Saturday Foundation. I’m honored to be a part of this group: Andy Warren ...

 

 Question of the Day

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

 

Altering Database Roles

In SQL Server 2019, how should I add or remove members from a Database-Level role?

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)

Killing Stats Updates

An asynchronous statistics update job is running in SQL Server. How can I kill this?

Answer: KILL STATS JOB

Explanation: The KILL STATS JOB command will do this. Ref: KILL STATS JOB - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/kill-transact-sql?view=sql-server-ver15

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 - Administration
View using Cross Join and LIKE operator please suggest alternate syntax. - Hi, The below view is using cross join and as far as I know, Cross join is not good for performance. Can you please help me rewrite these views? Any suggestions are much appreciated on the below issues 1 & 2. FROM dbo.tbEmp er CROSS JOIN dbo.tbEmpType ect LEFT OUTER JOIN t ON t.Ece_ID = […]
Non clustered Index on #temp table - Hi, In order to avoid a SORT operation in my execution plan, I want to create a Non clustered Index on a Temp table. However I am getting the below error which makes sense since it is a temp table that is created on the fly, however, is there any other way? please advise. ERROR […]
how to properly uninstall SQL server 2008 ? - Hello , I will proceed to install SQL server 2016 after deleting SQL server 2008 properly I saw several programs that depend on SQL server all these propragrams must be uninstalled (Microsoft visual c++ 2008 redistrubutable , Microsoft SQL server CLR Type,SQL server Native client ...)  
SQL Server 2016 - Development and T-SQL
Rounding to 0 - How do I preserve the value (and not result to 0). In the below calculation, how do I preserve the value? I want atleast 0.01 to come out instead of 0. declare @q int declare @weight decimal(33,13) set @q = 6 set @weight = 0.0000000060240 select Sum(@q *COALESCE(NULLIF(COALESCE(@Weight, 0), 0), 0.01)) Result = 0.0000000  
How do I JOIN these records? - Hi, possible to give me a tip on how do I join these 2 tables? TABLE_A record must have the first nearest DateTime on TABLE_B Datetime record on B must be greater than or equal to A (top 1) Record on B can be matched with a record on A multiple times as long  as […]
SQL Server 2019 - Development
Convert teradata REGEXP_INSTR into SQL SERVER - Hi, I need some guidelines to convert Teradata REGEXP_INSTR logic into SQL server code. Please find the attached file in which I had provided a sample script. Appreciate your reply in advance. Thanks    
If Statement in Computed Column - Greetings, Thank You for taking the time to read and hopefully answer my question.  You will soon see how new I am to SQL Server. I am rebuilding in SQL Server a DB that I built in MS Access.  Several of the columns in one of the MS Access tables are calculated using IIF statements.  […]
What to expect on first day of PL SQL at new firm? - Hi All, Looking for answer on what do I expect to happen on very first day for PL SQL job role, given 5 years of experience in resume. Because it will be completely new firm for me, will I receive some time to learn their systems?     Thank you
The Future of Community
Forum Api Project: Setup #7 View Models - This script creates 2 procedures which return view models in JSON format.  The view models return the posts for a thread in either recent view (plain old normal view) or threaded view (similar to old Drupal with nesting expanded).  Both implement offset paging. set nocount off; /* determine if schema 'frm' already exits. If it […]
Forum Api Project: Setup #6 Example Posts (reply to Posts) - This script creates 7 posts in the 'frm.posts' table.  These are "indirect responses" to thread(s) or replies to (other) posts.  The variable declarations are repeated for each procedure execution (to step through 1 reply at a time).  For the purpose of creating example posts the reply p_id's are located by the post title which is […]
Forum Api Project: Setup #5 Example Posts (reply to Threads) - This script creates 5 posts in the 'frm.posts' table.  These are direct responses to threads. /* delete frm.posts; dbcc checkident ('frm.posts', reseed, 0) with no_infomsgs go */ set nocount on; set xact_abort on; begin transaction /*create proc frm.api_posts_post @t_id int, @u_id int, @title nvarchar(256), @body nvarchar(4000), @test_p_id bigint output, @test_msg varchar(2048) output*/ declare @t_id int=(select […]
Forum Api Project: Setup #4 Example Threads - This script creates 5 threads in the 'frm.threads' table. /* delete frm.threads; dbcc checkident ('frm.threads', reseed, 0) with no_infomsgs go */ set nocount on; set xact_abort on; begin transaction /*create proc frm.api_threads_post @f_id int, @u_id int, @title nvarchar(256), @body nvarchar(4000), @test_t_id int output, @test_msg varchar(2048) output*/ declare @f_id int=(select f_id from frm.forums where title='Title 4'), […]
Forum Api Project: Setup #3 Procedures - This script creates 3 stored procedures which create rows in the remaining 2 tables, 'frm.threads' and 'frm.posts' tables.  The proc to create new threads is a plain insert.  The proc to create new posts in response to threads is a plain insert.  As far as I can tell there's 1 key query in the whole […]
Forum Api Project: Setup #2 Seed Data - This script inserts seed data into 5 of the 7 tables created by setup1. 7 users were created: id email username 1 admin@abc123.com SysAdmin 2 stevej@abc123.com SteveJ 3 stevec@abc123.com Steve Collins 4 moderator1@abc123.com Jose SQL 5 moderator2@abc123.com Jane5687 6 member1@abc123.com AdamF 7 member2@abc123.com Bean When 8 claims were created: cl_id securitystamp claim hierarchy 1 74FEAEBE-B13D-4759-9B4F-F63636F48E3F […]
Forum Api Project: Setup #1 DDL - This script creates 7 tables.  The only requirement is there needs to be a schema available called 'frm'.  If one exists already the script fails.  If 'frm' is available for this purpose then the schema and tables are created.    
 

 

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

 

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