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

Daily Coping Tip

Buy and extra item and donate it to a local food bank

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.

An Experiment in Building Culture

While I have found that some aspects of my job with Redgate improved with our move to remote work this year, I think others have deteriorated. I have spent lots of time over the years trying to build relationships with people in lots of different departments. This year, I've gotten lots of time and more communication with those I often work with, but the connections across groups have been limited. I have worried this is affecting the great culture at Redgate.

We have a group of people who spend time trying to deepen and strengthen team relationships. They have a budget each year and typically try to plan different types of activities for teams, departments, and groups inside the company. During the pandemic, we've had some competitions (quizzes, exercise goals, best picture), and they've been good, but for our end of year celebration, they really did a fantastic job.

First, I saw Kendra post a picture of her end of advent calendar. Interesting, but I wasn't sure what I thought. Plenty of other Redgaters posted similar pictures, which intrigued me, as I hadn't gotten anything.

Then I got a package with a note not to open anything before Dec 1. It contained my advent gifts, 24 boxes, and I spread them out on a table. I opened the first few myself before my family got interested. Day 3 was a mug, which my wife promptly grabbed, washed, and filled. Since then I've been looking forward to seeing what I get each day, with my gifts slightly different than what my UK colleagues are posting each day.

Each year we usually have a large award ceremony, fancy dinner, and dancing with partners and colleagues. We can't do this year, which I had expected to be a big loss when each office gets the chance to celebrate together. We're separated, but this gift was an excellent substitute. Some teams jointly together get to celebrate our individual moments of joy with co-workers, bringing us together in a unique way when we can't be together as a group.

Culture is hard to build and maintain, but Redgate did a fantastic job, despite the challenges. Hopefully some of you find your organizations trying to do something that brings you together as well.

Steve Jones - SSC Editor

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

 
  Featured Contents

Load Extended Events via Powershell

aakash9 from SQLServerCentral.com

Learn how you can load Extended Events with PowerShell, nice and fast.

How to Configure Amazon RDS SQL Server for Windows Authentication

Additional Articles from MSSQLTips.com

This article will show how to use Windows authentication for AWS RDS SQL Server by setting up an AWS Managed Active Directory and integrate it with an AWS RDS SQL Server instance.

Whitepaper: Enabling fast and easy database migrations with Flyway

Additional Articles from Redgate

High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams

From the SQL Server Central Blogs - Is On-premises SQL Server Still Relevant?

John Morehouse from John Morehouse | Sqlrus.com

Unequivocally, yes on-premises SQL Server Instances are still relevant. While I’m a firm believer that the cloud is not a fad and is not going away, it’s just an...

From the SQL Server Central Blogs - AutoCorrect in Git

Steve Jones - SSC Editor from The Voice of the DBA

I can’t believe autocorrect is available, or that I didn’t know it existed. I should have looked, after all, git is smart enough to guess my intentions. I learned...

 

  Question of the Day

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

 

Removing Git colors

I want to ensure that no colors are used in the git command line at all and just the plain colors I have configured for my terminal are there. What settings do I change?

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)

Database Firewall Rules

I am working in Azure SQL Database and I want to set a database level firewall rule. How can I do this?

Answer: Use T-SQL and sp_set_database_firewall_rule

Explanation: You must use T-SQL and sp_set_database_firewall_rule to set the rules. Ref:

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
Always on AG group - One of our DR server went down over the weekend with blue screen and cause the synchronization to fail. The DB monitoring system crashed cause no notification sent. I found the DR server issue after 2 days. I agree lot of things need to be straightened out, why windows team did not notify us and […]
SQL Server 2017 - Development
Alter authorization on view - Hi I have created a view in viewschema against table1 in tableschema I would like to change the owner of the view to to the tableschema. ALTER AUTHORIZATION ON  viewschema.viewName TO tableschema When I run the above, I get Cannot find the principal tableschema, because it does not exist or you do not have permission. […]
SQL Server 2016 - Development and T-SQL
How to Find Duplciate Data stored in multiple tables - There is probably a name/term for this problem and I'm just unaware of what it is. I know how to find duplicate data in a singular table but not when the data your comparing is stored in multiple tables, 2 tables with a parent child relationship. I Restored a copy of the AdventureWorks DB but […]
Trouble dynamically rolling up some accounts - Hello, Hopefully someone can help we with the following issue that i have. I have provided some test data in the format of two basic tables that closely replicates the issue. Sample data: CREATE TABLE xdbExample ( [Period] INT ,[Site] VARCHAR(6) ,[Account] VARCHAR(4) ,[Value] INT ) INSERT INTO xdbExample ([Period], [Site], [Account], [Value]) VALUES ('1901','SITE01','ACC1','1') […]
Combine Date & Time parts for Two Dates, then subtract - Hi,   I'm trying to combine a Date and a Time field into a DateTime, and then again for two more Date and Time fields, and then subtract the two combined DateTime fields within one select field of the SELECT statement...  I can combine through CAST a Date field with a Time field, and I can […]
SSIS Config Files vs Config Tables - I have recently run into multiple solutions where they are using Configuration Tables to store Config parameters instead of Configuration Files. I'm a little leery to continue using the table approach. We don't have SSISDB, so that's not an option. What are your thoughts on using the table vs file approach? I've always used the […]
SQL Server 2019 - Administration
Connection to SSIS after upgrade - I've just upgraded from SQL server 2014 to 2019 and also installed the latest version of SSMS. My server has always been on a local machine (i.e. server name was (local) as far as I can remember, or if not it was just the name of the machine in Windows).  I don't have external users, […]
Secure Sockets Layer (SSL) encryption. Error: \"SQL Server did not return a respo - Bonjour , J'ai un problème de connexion sur le serveur SQL Joindre le message d'erreur Le pilote n'a pas pu établir une connexion sécurisée à SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur: «SQL Server n'a pas renvoyé de réponse. La connexion a été fermée.». La connexion SSMS fonctionne correctement si ce […]
SQL Server 2019 - Development
SSIS Script Task for PowerShell - HI everyone! How do i update the script task to run on a specific server. This would change for each run. Or is there another way to run the powershell? SSIS runs the below: ssis exists on server 1 Copies powershell to server 2 Run powershell on server 2. (Assistance needed)
Access to SQL expression - Hi folks, I'm trying and failing miserably to convert an Access Expression to SQL query The MS Access Expression strips the following field data formats to extract the middle text between the 2 hyphens 2C00P02-CRIW-93201 (Extracted value: CRIW) Any help appreciated Left(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),InStr(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),"-")-1)
TSQL Script: Min, Max function - Hello All, I hope you are doing well. I have difficulties to write a sql script. May be you could help me. I have a table like this. And I want to have a result like this:     I used the min and max function but it doesn't work. Do you have any idea […]
Reporting Services
SSRS and subscriptions with office365 - Hi.I have a detail with the subscriptions in Reporting Services (SQL Server 2014).I have configured DBmail using Office365. When I run the report to send it by mail it sends: Failure sending mail: Error in processing. The server response was: 5.7.3 STARTTLS is required to send mail [BN6PR03CA0006.namprd03.prod.outlook.com]Mail will not be resent. I opened the […]
Integration Services
PowerShell Process Task fails in locked down Windows 10 - Hi Guys A weird one here. I run a process task to run powershell.exe with the argument -File C:\Ace\ResetSpreadsheet.ps1 This script runs a macro in a spreadsheet in the same folder to clear existing data and then saves and exits. Because the IT people lock our boxes down to the nth degree I had issues […]
MySQL
TERADATA - Execute procedure permissions - im finding it hard to get a reply on other forums because of low activity in general, so apologies if this is in the wrong place Im a working in Teradata and i create a procedure and all is well then he following day, having logged off and back on, i dont have execute permissions […]
Job Postings
Looking for article writers - Hi there, I'm looking for a few freelance writers who would be willing to help with some quick turn around posts about PostgreSQL and MySQL. We're also looking for people who may have already written pieces they'd like re-syndicated. Both opportunities are paid. Right now, we're offering $50-150 a piece, with some bandwidth to increase […]
 

 

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

 

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