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

Daily Coping Tip

Pick three things you are looking forward to this year

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.

Teams Security Issues

At some point in my career sharing files and links in email became a security concern. There were all sorts of malware issues that spread throughout organizations because someone unknowingly forwarded on a malicious item. At a couple of large organizations, we had to turn off email for days while we cleaned out systems. Fortunately, antivirus and other types of scanning software improved to prevent a lot of these types of problems.

It seems that not all developers learned the lessons of the past. Microsoft Teams has a few vulnerabilities inside it based on link sharing in the chats. The preview features aren't well implemented, though Microsoft security doesn't think this is a problem as a user would notice the link would be incorrect.

I don't use Teams often, and as a Slack user, I find it rather confusing, busy, and unintuitive. I know lots of others that like Teams and find it very productive. No matter which type of communication mechanism is used inside of your organization, the security protections ought to be very strong. We are often busy with work and distracted. We are often expecting the information here to be safer than browsing sites on the public internet. Perhaps that's not the way things should be, but it is.

Attack vectors that use code inside a webpage are very common, and I dislike many of the "preview" features that I've seen in various pieces of software. They slow down the application, especially on a mobile network, and take up unnecessary space. As someone that often can see bandwidth constraints, I've prefer that all of these features were optional. Let me decide if I want a preview.

The trend to build richer experiences in applications and pre-fetch data can make the experience better, but there is a tradeoff. Apart from potential security concerns, these features can make the experience more enjoyable, or unnecessarily slow things down and interfere with the way we use an application. More isn't always better, especially when the pattern for an individual user might not match what the majority does. If 51% of users always use a feature, I'm not sure the other 49% view this as a positive way of architecting the system.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

The Changing Landscape of Information Management

roopesh.uniyal@gmail.com from SQLServerCentral

A high level view of how enterprises should manage their data and information.

External Article

Getting Started with Cloud-hosted Databases using Spawn

Additional Articles from Redgate

This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.

External Article

How to filter DAX for paginated reports

Additional Articles from SimpleTalk

DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.

Blog Post

From the SQL Server Central Blogs - When You Can’t Change the Connected Git Repo on ADF

Meagan Longoria from Data Savvy

I was working on an Azure Data Factory project for a client who is new to ADF, and there was a miscommunication about the new Git Repo to be...

Blog Post

From the SQL Server Central Blogs - Stability and Reporting – Love at First Sight

SQLRNNR from SQL RNNR

Stability and reporting go hand in hand. You cannot truly have stability without reporting. Take the time to share the stability successes with the business. Let them revel in...

 

 Question of the Day

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

 

Amazon RDS

What type of database is Amazon RDS?

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)

Easily Saving PoSh Results

I am running a PowerShell script, but the results scroll off the screen. I want to easily paste the results into Excel, but I can't easily highlight the entire result set and copy/paste it. How can I send the results to the clipboard so I can paste them into Excel?

Answer: add this to your script: " | clip"

Explanation:   Ref: Send PowerShell output to the Clipboard - https://devblogs.microsoft.com/scripting/powertip-send-output-to-clipboard-with-powershell/

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
Generate scripts with least privilege - How to execute "Generate scripts" option for database with minimum privilege ? I am using "Generate scripts" for "Types of data to script" - Schema only option. There are some confidential data in some database , hence we don't want to give other user data view/modify permission. Is it possible to give a User/login  "view […]
SQL Server 2017 - Development
Case Statement - I am having an error with this code:   select customer_name, order_id, (case when sum(status = 'delivered') = count(*) then 'completed' when sum(status = 'delivered') > 0 then 'in progress' when sum(status = 'submitted') > 0 then 'awaiting progress' else 'awaiting submission' end) as status from customer_order group by customer_name;   error = Msg 156, Level 15, State 1, Server dbrank-tsql, Line 2 Incorrect syntax near the keyword 'when'
Is it possible to migrate a solution from SSMS to SSDT?? - VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SSMS to SSDT? The main purpose is to incorporate large solutions with multiple files into TFS that SSMS is not supporting.
SQL Server 2016 - Administration
Tempdb Showplan for user without login - I'm running into the following issue. The stored procedure I need to performance tune uses a user without login. This is needed for row-level security. But the problem I ran into is that I cannot give this user showplan rights in the tempdb database. Does anyone have a solution or workaround for this?
SQL Server 2016 - Development and T-SQL
Complicated insert - I want to insert values from Table1 to Table2 Conditions: when thier is a location with "xx", the row needs to be inserted twice the Empno in table2 is  a primary key with identity seed. Expected Output  
Missing Indexes - We are noticing a lot of I/O latency on our SQL server. Is it common to have a lot of missing indexes? We are trying to narrow down what could be causing all the I/O latency we are seeing. Thanks for any help!  
Administration - SQL Server 2014
Backup SQL database generates error - Hi I have a server running Microsoft SQL 14 on window server 2012. At december 06 it stopped to take backups every night. I got following error message: The operating system returned the error '1(Incorrect function.)' while attempting 'ReadFile' on 'C:\Program Files\Microsoft SQL Server\MSSQL12.OPUS\MSSQL\DATA\OPUSDATA\a488f2a0-564d-44ce-8e57-7d5425d5b798\c55b8372-9595-4dce-9b68-16f5f5466a44\00016be8-000001a9-0005 I have checked if the file in the error message exist […]
No objects listed for "SQL Server performance condition alert"? - Hi All, Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition. Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box. SQL Server event alerts are working. Issue is only with "SQL Server performance condition […]
SQL Server 2019 - Administration
password expiration policy- should it be enabled? (linked servers/SSRS) - Hi, I would like to ask you for 'best practices' regarding password expiration policy for accounts used by linked servers and SSRS, or other applications. I can see that due to security reasons it makes sense to enforce password policy expiration for all accounts which use SQL server authentication. At the same time, I can […]
Linked server to Unisys DMSII - HI,     I am creating a linked server to Unisys DMSII database. I installed MCP driver and created a ODBC connection. The ODBC was working 2 weeks ago, but now the ODBC connection could not remember the password. If I put the password in the password field and test it, it works, but if […]
SQL Server 2019 - Development
Start Sql server agent job after a trigger - Is it possible to start Sql server agent job after a trigger? what i want to do is after a certain table updates a certain column, then it runs a job that has various sql stored procedures. if not possible at all, is there something similar to this?
The same value across 5 or more columns in a table , How can I write a query -   I got a table with 5 integer columns and one varchar(100) column. Select * from tbl1 where col1 = col2 or ....col5=col4 ..... I dont want to do this. Can we concatenate these fields and somehow comeup with a RegEx or some other way to find the rows that have the same integer values across […]
Trying to print barchart to PDF file using Python within SQL Server ML module - There are likely to be several unrelated errors here, but I'm going to start with the first one what I can get my mind around.  I'm trying to use the "Python within SQL Server" mechanism to generate a barchart to PDF.  I get an error message that I don't have permissions to the directory I'm […]
Reporting Services
accessing a shared data source that is created in report server, by report desig - Hello There, I created a shared data source over SSRS report server web-portal; I am wandering, if it can be used /accessed by report-designer while building a report? I got this concern, because, as I tried to find a way out to access a shared data source by right click on shared data source > […]
Anything that is NOT about SQL!
SSC Fantasy Football 2022 - Placeholder for the 2022 league. Congrats to the 2021 winners: First - Jimbabwe Seahawks - $100 Second - British Bulldogs - $75 Third - Green Machine - $50
 

 

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

 

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