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

Daily Coping Tip

Try out something new to get out of your comfort zone

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.

Are You a Good Engineer?

I would guess that many of us think we're good at our jobs, or at least that we do a good job. Whether you're a system administrator or software engineer, I'm sure you think you earn the compensation you get.  I wonder if others in your company would see you this way? If they know what you do as a job, and understand the role, then you should hope they see you a good engineer/admin. Perhaps you should even ask a few people if they do.

There is a good thread about software engineers, talking about some of the things that make a good developer. It's from a longtime engineer, and it talks about some of the things that you might consider as a software developer.  Actually, I think most of these learnings would apply to admins and even other business people.

The first item in the thread really caught my eye because I see many people taking requirements as facts and then working to meet them exactly, or complaining and trying to avoid meeting them exactly. It isn't often that I find people really digging in and trying to be a partner with their clients. Too often we're too accepting or too argumentative, without trying to find a solution that makes the entire system better.

The second item about not being a jerk is also important. It took me some time to learn that, and I still find too many people that think being right, or more talented, makes up for poor behavior. I'm sure it does in some places, but none where I'd want to work. Instead, follow the other advice and build relationships with others. That's important, especially over time in your career. I know plenty of people who get poor recommendations from peers, and that causes them issues when looking for a job in their local area.

There are some other items, but the one I find especially important is work ethic. Often hires need to be taught about our environment, even if they are the 10x engineer. I'd rather have someone willing to learn, someone I like working with, and someone that isn't going to be afraid to work hard and help improve things. I'll take those skills over past "expertise" in most situations.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Is Your SSIS Catalog Migration Ready

Kunal Rathi from SQLServerCentral

In this article, we will see if the given SSIS catalog is ready for migration without any issues using SSIS Catalog Migration Wizard inspect feature.

SQLServerCentral Article

SQL Server Monitoring Using Free Tools

Wingenious from SQLServerCentral

You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!

SQLServerCentral Article

Debugging Flyway Callbacks and Migrations that Use Placeholders

Additional Articles from Redgate

Placeholders come in very handy in Flyway, but troubleshooting the SQL migration and callback scripts that use them can be tricky. This articles demonstrates how to develop, test and debug these scripts in a tool designed for these tasks, such as SSMS, leaving Flyway to do what it's designed for, which is running the scripts.

External Article

Install SQL Server and Oracle using PowerShell and Windows Containers

Additional Articles from MSSQLTips.com

In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.

Blog Post

From the SQL Server Central Blogs - Microsoft industry clouds

James Serra from James Serra's Blog

In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this...

Blog Post

From the SQL Server Central Blogs - CosmosDB and Consistency

Steve Jones - SSC Editor from The Voice of the DBA

I was doing a little work with CosmosDB recently, and there were a few things that surprised me about the platform.  I’m also not 100% sure I completely understand...

 

 Question of the Day

Today's question (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)')

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)

Fully Indexing Views

I have an indexed view created in my SQL Server 2019 database. Can I create a full-text index on this view?

Answer: Yes

Explanation: You can create a full-text index on an indexed view. Ref: CREATE FULLTEXT INDEX - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-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 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

 

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