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

Daily Coping Tip

Give sincere compliments to people you talk to 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.

Viva

I want holographic screens and meetings. Heck, I'd like Teams/Slack/Zoom/etc. to recognize multiple screens and let me separate out different cameras to different screens. I'd like to be able to see more than a tiny thumbnail of a presenter, or of other people that are in a meeting. That might be one of the things I miss most about these virtual meetings. I can often barely see others.

Microsoft Viva is a new platform for remote work and collaboration. I'm not completely sure what it is, though there is a video with the cool, enticing holographic screens. It's not an app, but appears to be some way to connect various information in an organization into Teams. It's like an intranet from the 90s, but designed to help someone navigate their organization and work environment.

I'm all for bringing together more data, and especially making it easier for people to do so. I love all the single-sign on we have at Redgate, but everyone produces so much data through tickets, feedback from customers, notes in chat apps, emails, announcements made everywhere, including our internal site, video updates, and more.

What I really need is some prioritization and triage for me. For my role, which becomes more like a personal assistant, which I don't know I'd have confidence in. I suppose I wouldn't have confidence in a human assistant until I'd trained them, so maybe this is a similar task I'd need. I'd have to build trust, and I'd worry about data privacy, which are still issues with humans, but there is less scale issue, and less secret access to human knowledge than to bits stored somewhere.

At least I feel there is. Maybe I'm just worried, but many of the problems I see with computers have to do with the scale of data access, both in the volumes of data, but also the variety of people that can see the data. Microsoft has already had some issues with trying to boost productivity with some of their evaluation of individual's work. Perhaps they are going to find a balance with insights and privacy, but I don't want to be a test subject for this.

Changing the way we work, helping individuals be more productive and accountable, while protecting their rights privacy is hard. I applaud Microsoft for trying something, but I suspect that this is like many of their new ideas, half-baked and incomplete. Whether they continue to invest and grow this into a useful tool remains to be seen, but I hope they do. I'd certainly like to have more useful ways to collaborate and communicate.

Especially if they build holographic screens.

Steve Jones - SSC Editor

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

 
 Featured Contents

Microsoft Azure ADF - Dynamic Pipelines

kumarsanjeev from SQLServerCentral

Azure Data Factory (ADF) is a cloud based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. Azure Data Factory does not store any data itself. but it allows you to create data-driven workflows to orchestrate the movement of data between supported […]

Unlocking the “PASS Pro” Educational series

Additional Articles from Redgate

Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.

sqldf in R Example for SQL Server

Additional Articles from MSSQLTips.com

R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.

From the SQL Server Central Blogs - Power BI Monthly Digest – February 2021

Devin Knight from Devin Knight

In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.

From the SQL Server Central Blogs - Upgrading Durable Function Extension of my Azure Function App

Rayis Imayev from Data Adventures

(2021-Feb-22) With more applications and services being placed into a vendor cloud environment, it does require almost no effort to manage and maintain the infrastructure these applications and services are...

 

 Question of the Day

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

 

The Future Synonym

I have a new instance of SQL Server 2019 installed. The only database I have created is the "sandbox" database. I run this code:
CREATE SYNONYM mysyn FOR newdbw.dbo.sometable
What happens?

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)

Shortcutting Git Commands

If I want to make a shortcut in Git so that I can type "git co" instead of "git checkout", what should I run for this to work in all repos on my machine?

Answer: git config --global alias.co checkout

Explanation: The git config command with the --global flag is used to change something for all repos. In this case, alias.xx, where xx is the alias, is used to set a command. Ref: Git Basics - Git Aliases - https://git-scm.com/book/en/v2/Git-Basics-Git-Aliases#_git_aliases

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
SQL Server elevation of privilege vulnerability patch and sp_pkeys SP - We have a SQL Server 2017, which was recently updated with https://support.microsoft.com/en-us/topic/kb4583468-microsoft-sql-server-elevation-of-privilege-vulnerability-b51e9244-d952-0372-0cf0-2929da230340.  Against a database on this server, we run an application which connects via RDO and SQL Server Native Client.  As a result of this patch, the application has slowed down to a state that it has now become unusable - operations that previously […]
CU update-SQL 2017 - when i try to install CU 22 for SQL 2017 my current version is not recognized by the installation file. My current version is RTM-CU14-GDR. What could be the cause for this.
SQL Server 2016 - Administration
Performance Issues - Im running on a problem concerning performance issues and my main question is when i check the activity monitor while the performance is at the lowest possible, i have about 40 active processes and suddenly the count goes at around 2000-3000 processes as also i have seen a number as 33000 active processes for about […]
Report taking long time to render for large reports - Report Server URL is used within the application. The SP used within the report when executed from SSMS returns data in about 10-20 seconds, also it returns data in about the same time when the report is called within the application when accessed from the application server.But, when the application is accessed from the desktop […]
SQL Server 2016 - Development and T-SQL
Connecting to SS2016 from Visual Studio 2015 - NOTE: Due to vendor requirements and not my own preferences I am using SSRS (rdlc type) via VS 2015 If I can on my workstation I connect my copy of SSMS (v18.6) to a cloud based instance of SQL Server 2016 using SQL Server authentication than on that same machine should I also be able […]
Check if File Exists with Dynamic Name - Dear Group: I need to check if a file exists on our server, and if it does, then execute code. I know I can use the following code to do this: DECLARE @fileExists int EXEC master..xp_fileexist '\\server\feed.txt', @fileexists OUT IF @fileExists = 1 -- The file exists PRINT 'File Exists' -- Do what you want […]
Forcing serialization of incoming stored procedure calls - Hello, We have implemented a data import system based on an webservice which receives from an external system the necessary data to be imported as payload in XML format. We have a stored procedure interpreting the XML file received and doing the necessary actions to import data according to the type of data received (product […]
Not selecting numbers in first 3 characters of cell only letters - File - left([File],3) output wanted in case statement... NJU000123 - NJU 99392288 - NULL   left([File],3 = office except if there are numbers. How can I improve this left statement to allow only for letters to be pulled while any cells with numbers in the first 3 get left out?
Development - SQL Server 2014
How to get the last occurrence of a field - Hi, I have a simple query that returns two fields. I need to modify that query so that it only returns the last or highest number for each pair of fields.   It's easier to show than explain. Here's my query: SELECT WONum, OpNum FROM tblHistory ORDER BY WONum, OpNum   It returns something like […]
Need to create gaps in a table of date ranges - The internet is full of examples of how to find gaps in date ranges but I need to create gaps in a table of date ranges. I have a table of date ranges IF OBJECT_ID('tempdb.dbo.#DateRanges') IS NOT NULL DROP TABLE #DateRanges create table #DateRanges ( id char(15), SubType char(15), effdate datetime, termdate datetime ) insert […]
SQL Server 2019 - Administration
Need help with installation issue - Hi, I work in a small company and do not have a to of experience in this are. Someone installed SQL Server 2019, before I took it over. They seemed to have left out SSIS and Reporting severer when they installed it. I would like to add these, but I do not want to have […]
Amazon AWS and other cloud vendors
SQLBackupAndFTP backup S3 - hello , I use the SQLBackupAndFTP tool to transfer the backup from the local server to the S3 backut during the S3 connection phase, the tool asks me ACESS KEY, SECRET KEY Who can how I can get these items back Thanks
Reporting Services
Error occured up on clicking subscribe button - On click on subscribe button i am getting below message. first i checked the rdl that is uploaded by the account has access to report server and report server database, it has. still showing same message.. what could be possibilities An error occurred within the report server database.  This may be due to a connection […]
Analysis Services
Convert sql query to MDX - I want to find an mdx equivalent of this query: Select a.shopId , Month(TransactionDate) Month_Transaction, Year(TransactionDate) Year_Transaction, count(distinct b.UserID) UniqueUserCount FROM [dbo].[shop] a JOIN users b ON a.UserID = b.UserID where TransactionDate >= '2018-01-01' Group by a.shopId ,Month(TransactionDate), Year(TransactionDate)   This is what I have so far which produces unique count irrespective of date. I […]
Integration Services
SSIS Installation for Visual Studio - Dear Group: I have two versions of Visual Studio installed:  VS 2015 and VS 2017 on two different machines. As such, my question is two fold as each has an issue. VS 2015:  I am able to create SSIS packages in VS 2015 and I am trying to build a package that works with Excel […]
 

 

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

 

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