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

Daily Coping Tip

Say hello to a neighbor and get to know them better

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.

Making Video Chat Better

I ran across an article on Zoom fatigue and new tech that was written in July 2020. That month seems like ages ago, and at the same time, not too long ago as the world seems to have still been in some sort of suspended animation for much of 2020 and 2021. However, one thing that has remained since that time is a regular stream of Zoom and Teams meetings that I attend.

I've been dealing with video meetings for over a decade. For most of the time I've worked for Redgate, I've had regular meetings every week with various people that are in Cambridge, UK. I'm in Denver,  US, and while I enjoy going to England and visiting the office, that's a few times a year. Across the years, we've tried a number of platforms, and various different configurations, including a dedicated conference room with extra mics and sound-absorbing padding on the walls. None of this made for a great experience, though I have to say our adoption of Zoom across the last 2-3 years has been the best experience overall.

Still, when I have multiple meetings in a day, I feel fatigued. Many people feel similarly, and that has not gone unnoticed. While we do try to cut down on some of the meetings as a company, they aren't going away entirely for us, or likely, for your company. Some companies are going back to the office, at least part-time, but many employees are resisting, which means we need better tech. Something I hope is coming.

The article I liked above talks about some of the changes taking place, with some newer tech being tried. I don't know I'll ever like video chat without some sort of VR-style view of a room or holograms, but perhaps something will come along that makes these meetings better. I've certainly found that having larger views of speakers is good, but when they rapidly switch from one person to another it feels like a 5-year old directing a live TV show. I want to turn off my video and just listen. Or end the call.

One thing that I've found helps is I try hard to get more done through Slack and email, avoiding meetings that aren't needed. The best way to combat something that doesn't work well for me is to do less of it, so I work to minimize video, type more, and hope for more live face-to-face meetings a few times a year.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

PostgreSQL in Azure Data Studio

Daniel Calbimonte from SQLServerCentral

Learn how to install PostgreSQL and using Azure Data Studio to work with it.

External Article

7 Trends in DB DevOps & Monitoring: The infographic

Additional Articles from Redgate

Earlier this year, we surveyed 5,700 global IT professionals and found out what the most pressing issues in DevOps and monitoring were. Read the round up in our infographic.

External Article

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

Additional Articles from SimpleTalk

The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.

Blog Post

From the SQL Server Central Blogs - Trusting the Fine Print or connecting Azure Data Factory with Salesforce

Rayis Imayev from Data Adventures

(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...

Blog Post

From the SQL Server Central Blogs - Two Clustered Indexes?

Grant Fritchey from The Scary DBA

Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...

 

 Question of the Day

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

 

Azure SQL Database (2022)

What deployment options are available for Azure SQL Database in Jan 2022?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Carlo Romagnano)

How many columns?

How many columns does this SELECT return?

DECLARE @x XML = '

    EVEN

'
,@y XML = '

    ODD

'

SELECT Seconds = DATEPART(SECOND,GETDATE()) 
      ,Parity = CASE WHEN DATEPART(SECOND,GETDATE()) % 2=0 THEN @x ELSE @y END 
      .value('(//T)[1]','varchar(100)')

Answer: Two columns: Seconds,Parity

Explanation: From BOL, the CASE statement: "Evaluates a list of conditions and returns one of multiple possible result expressions" In this example the CASE returns a result expression of type XML to which is attached the XML function "value()". Ref: value() method - https://docs.microsoft.com/en-us/sql/t-sql/xml/value-method-xml-data-type?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 2017 - Development
Collaborative online projects - I am interested in joining an online project effort.  Where is a good place to look?
SQL Server 2016 - Administration
Rewriting Query for performance - Hello, I'm trying to test and rewrite an SP PROC ( to reduce run time if possible) using temp table and insert data from a very big table and has couple of joins to other tables to get desired data .. here are some questions 1# how can I ensure my join order is correct. […]
why am i seeing SQLTRACE_FILE_READ_IO_COMPLETION in top waits? - why am i seeing SQLTRACE_FILE_READ_IO_COMPLETION wait in top 5 waits all the time? What is it, and should or can it be reduced/turned off?
SQL Server 2016 - Development and T-SQL
sql query help - hello everyone, i have a query with respect to pivot. As per my understanding pivot is used to transpose rows to columns. however as i was going through the documents and examples, the pivot works with a aggregate value. what if i don't want to do any aggregate ? what if there's any varchar value […]
Loading Data To Normalized Tables - Something I've always wondered is how is data loaded in a normalized OLTP database? One example that I think about is an ATM transaction because it captures data ranging from customer to ATM location. If the database is designed in at least 3NF then it would have multiple tables related to customer to handle name, […]
Development - SQL Server 2014
UPDATE all or only changed values - UPDATE MyTable SET Num = 999 UPDATE MyTable SET Num = 999 WHERE Num <> 999 --ignoring nulls issue for now If a large table in production, I do the second. So treating an UPDATE as changing values only. Though no doubt there are situations where collecting information on overwrites would be important. I've assumed […]
Simple trigger for auditing - I'm after a simple trigger to audit inserts and deletes on a single table. If the PK does not exist in the audit table (i.e. an INSERT has occurred) then insert into the audit table. If the PK exists in the audit table (i.e. an UPDATE has occurred) then insert into the audit table the […]
SQL Server 2012 - T-SQL
Compare columns within the same row - I have the following row:   And, I need to compare the Amts to only pull back the Reason for the largest Amt Value.  In the example above Amt2 has the largest values, so I would need to SELECT only Amt2Reason of YY-This2. I have been at this a few hours now and nothing is […]
SQL Server 2019 - Administration
Restored database with encrypted data - I have a database which contains a table with encrypted data. I have restored this database onto a new instance (and upgraded from SQL2016 to SQL2019) but now, when I try to access the encrypted information, I get the error: Msg 50000, Level 16, State 1, Procedure [database].[schema].[procedure], Line 27 [Batch Start Line 7] Please […]
SQL Server 2019 - Development
Create a matrix view from a table - Hi, I have a table called facility: id   name 123 Hospital blah blah 124 Dr's office 1 125 Dr's Office 2 126 Hospital 2 It joins on a table called patient patient_id  facitility_id 1234          124 1234           236 2345         236 2345        124 […]
Issue with the the new Microsoft managed Oracle data source component for SSIS - During preparation for a large SSIS upgrade project from SSIS 2012 to SSIS 2019 we have identified an issue with the new Microsoft managed Oracle data source component for SSIS 2019. This component replaces the Attunity component used in earlier versions of SSIS. If you are fortunate the upgraded SSIS packages will simply fail but […]
Selecting data from one table and multiple counts from another - I have a table called AgentGroups which just has two columns, GroupID and GroupName. I then have two other tables AgentGroupMapping and SkillGroupMapping that both also have a GroupID column. I want to select all of the rows from the AgentGroups table and then the count from both of the other tables where the GroupID […]
SQL Server Newbies
Using Results from CASE Statement to create a calculated Field - Hey all, Sorry for asking so many questions, but I'm usually not able to easily find solutions to the problems I face. This particular problem is as such. I have a numerical column and a string. If the string matches a condition, I want to make it negative and then add with another column. Let's […]
Unable to append strings to record from SELECT Statement - Hi All,   Just had another newbie question, I practiced some sql commands on the w3 schools sandbox, basically my goal is to take all records from a column and append a string before each record. So in the W3 SQL Sandbox, https://www.w3schools.com/sql/trysql.asp?filename=trysql_asc I can type in the query SELECT 'A1-' || CustomerID FROM Customers […]
Integration Services
How can I execute OLEDB Command without Result Set - I am working with an application that has many INSERT and UPDATE stored procedures for our tables.  I am migrating data from one version of our system to another version using a formatted text file.  The text file has columns that I can map to the parameters of a stored procedure using an OLEDB Command.  […]
 

 

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

 

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