SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

ADF Checking the Starting String

The Voice of the DBA

Daily Coping Tip

Make sleep a priority tonight

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.

A Work Conference

I like the idea of a work conference. We're actually having one at Redgate this week, though it's all virtual. I'd like an in person one, and it sounds like that will happen at Atlassian four times a year when they require employees to be in the office. That's it.

Four times a year.

They are going all in on work from home, allowing employees to be in any place that Atlassian has a legal presence for work. As someone that's dealt with this, it is a hassle for a company doesn't have any setup for an employee in a new locale, especially in the US. So I understand them limiting employees to places where the company has a corporate entity. Still, that's a lot of places for Atlassian.

Many Atlassian employees do expect to go to offices about half the time, but they won't be required to do so. I think there are lots of their staff that want to be able to go to an office, at least some time. I do wonder how they will handle meetings and collaboration with people being able to move their schedule around and be in or out of the office. At Redgate we've said remote first, but sitting at my desk for a meeting with one person that's at their desk in the same room and one person that is remote feels strange.

Getting everyone in a region together a few times a year is a really interesting idea. It will feel like a SQL Saturday or other event when you know everyone will show up. I can see this generating some excitement. Especially if those days are different from normal workdays.

It's something I think I'd be interested in, and perhaps excited by. I think I'll suggest each Redgate office have a few days a year, and then see if I can get invited to each office on those days. Fingers crossed that it happens.

Steve Jones - SSC Editor

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

Featured Contents

Step by Step Guide to Install Jupyter Notebook

diponkar.paul from SQLServerCentral

Whether you work as a Data Engineer or a Data Scientist, a Jupyter Notebook is a helpful tool. One of the projects I was working required a comparison of two parquet files. This is mainly a schema comparison, not a data comparison. Though the two .parquet were created from two different sources, the outcome should […]

How to Manage Date Formats in the Power BI Service

Additional Articles from MSSQLTips.com

Learn how to properly configure input date formats for Power BI reports for any type of browser so users always get the results they expect.

Win DevOps books with Redgate’s competition

Additional Articles from Redgate

Redgate is giving you the chance to win your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’

From the SQL Server Central Blogs - All jobs that ran during a given time frame.

Kenneth.Fisher from SQLStudies

Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading

From the SQL Server Central Blogs - Powershell Practice with a War Game

Steve Jones - SSC Editor from The Voice of the DBA

I attended part of the recent PowerShell + DevOps summit, and one of the sessions was from Fernando Tomlinson (@wired_pulse and @underthewire_ps) on incident response. He talked about a number...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	ADF Checking the Starting String
I want to know if a string in Azure Data Factory starts with a particular substring and return a true or false. What is the best expression to use?
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)

Container Logs

I ran a Docker container for SQL Server 2017, but it stopped quickly after the command completed. How can I get the logs of what happened during the container startup?

Answer: docker logs

Explanation: The "docker logs" command will allow you to get the log from the container execution. Ref: Docker logs - https://docs.docker.com/engine/reference/commandline/logs/

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 - Development and T-SQL

Comma separated value string and compare against other values - Hey all I have been trying to wrap my head around how to go about doing this for a while now and I'm not really coming up with anything. Here is my query: DECLARE @ATID AS VARCHAR(3) = 12 DECLARE @AssetID AS VARCHAR(7) = 306 SELECT tblXDataA.AssetID AS 'LID', tblA.AssetID AS 'AID', tblEM.[Custom] AS 'ABC/S […]

Development - SQL Server 2014

Between dates SQL help needed - Hi, I required duplicate values in the below table For e.g staff date 10192 first record To date is between the second record's From date and To Date

SQL 2012 - General

SQL 2012 Standard - Index highly fragmented - Hi there, Complete newb. Need some guidance. Running SQL 2012, running INFOR ERP. Indexes are constantly fragmented... it's like whack a mole. Server is set to index nightly but sometimes, queries run slow and we have to re-index on the spot. Once re-index, back SQL queries are back to normal. Can anyone provide me with […]

SQL Server 2019 - Administration

Azure SQL Database and SQL Managed Instance Security Best Practices - Hello, I have 7 different SQL Managed Instances which were newly migrated over from SQL VM. I also have 7 different Azure SQL Databases which were also newly created. I want to make sure that I completely secure all my SQL MI and Azure SQL to eliminate any security vulnerabilities and also avoid any SQL […]

Export encryption keys to SQL 2019 from MySQL - Hi My customer is migrating from MySQL to SQL 2019 using SSMA, thier current MySQL uses PHP and encrypts columns within a few tables, is there a way to get this decrypted or the key copied over to SQL Server. I have not done an MySQL to SQL migration before the reason for the question. […]

Retrieve Encrypted data from SQL in MS Excel - Hi I have a customer who has an SQL database and would like to encrypt columns i.e bank details. but they want to retrieve the data using Excel. Is this possible? I cannot find any articles to support this. Thanks in Advance Regards Raxs01

sql login schema instead of dbo schema - Hello, In SQL server, when running select into statement for creating an object, the object is being creating with schema with my sql login ([Domain_Name]\[Sql_Login]) instead of dbo schema. When I use select * into dbo.table_name, the object is being creating with dbo schema, but it is a bit annoying to have to use dbo […]

SQL Server 2019 container kubernetes - Hi everyone, can anyone tell me, if the sql server 2019 is ready for container and is there an official image for kubernetes? My colleague told me, he was not able to find an image for 2019, only for 2017. thanks a lot, stay healthy, Andreas

SQL Server 2019 - Development

Removing prefix and suffix from a column - Hi I have a table with a could that has over 3000 rows for employees name, in some of the rows there is names 'ZZZ Atkin (left)' How can I remove prefix starting with ZZZ and suffix with (left)? Regards Raxso

Reporting Services

SSRS - exporting to csv issue - I have an SSRS report and have a field called "Ticket". "Ticket" is a VARCHAR(20) field and in my clients DB, they have a "Ticket" value of "00000000007" for example. I created an expression as such for this field in my report: =CStr(Fields!Ticket.Value) I preview my report and it previews the value as I want. […]

ssrs function code to get value from dataset - Hello, hopefully this makes sense, but i am a little familiar using SSRS function code to grab build in variables like date or page number and use them from header to body, BUT, now i want to be able to use something that is from the body, into the header... but not sure how to […]

General

Linux data and index files - Hi Does anyone know where the data and index files are stored on a Linux server? I want to extract the data from a linux database and store it in sql server. Thanks in advance

Integration Services

Failed Because Truncation Occurred - Dear Group: I am getting the following error on my SSIS import process. "Workbook.Outputs[Excel Source Output].Columns[XYZ]" failed because truncation occurred, and the truncation row disposition on "Workbook.Outputs[Excel Source Output].Columns[XYZ]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component." I understand the issue relates to the column XYZ being […]

Manual tasks in SSIS design - Hi, I am getting CSV files with hundreds of columns many of which have irregular characters in the column names, such as |, " ", -, /, etc. I've created table by manually importing the file, which renamed those columns in the table nicely by removing the character and replacing some of them with underscore. […]

Loading a csv file into sql server table - Hi, I've created a simple dataflow with flat file source and sql server destination. I am getting the following error messages: [MyDB MyTable table [2]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: […]

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.