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

Daily Coping Tip

Breathe. In for a count of 3, hold for 3, exhale for 3, and pause for 3. Repeat for a few minutes

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 Data Attack

I got a new mobile phone and was going through the setup. On top of numerous Android updates, I had to reset a number of applications back up. While it's a pain, I also appreciate from a security standpoint that moving access to my data and sites to a new device could be an issue. One of the applications I was trying to set up was Garmin Connect, as I track my exercise, heart rate, and more on my watch. When I first tried this, I got a 404 in the app, which was strange.

Apparently Garmin was having issues. They had a large outage. The next day I saw that article, and while I could get to the main Garmin site and log in, I couldn't get a new install of the app to connect on my phone, and I couldn't get access to any of my workout data. Even old data, apparently isn't on my phone, as I thought. It's being read from the cloud. That's disconcerting, though I record my data separately at MapMyRun, so I'm not overly worried. I even found a procedure and tested it for saving my data locally.

Over the weekend after this happened, I didn't do much, but as of the Monday after the attack, the Verge reported that some data was visible and sync was working. Not for me, but for someone. That's good, and Garmin has a touch of information about the outage, saying they expect devices to begin syncing at some point. Mine didn't that day, but did a day or two later.

This is interesting as an attack because it's not just the company's own internal data, but also their customers' data. I don't know if that was the intention, but what better way to put pressure on a company that take away their customers' data. I don't know that this would make them respond differently than losing their internal data, but it  likely would be more public. It also might put more pressure on them to pay some ransom.

Ultimately, this is an area that I think the GDPR started to help, but allowing customers to access copies of their data, as well as have rights over how it is used. I think having the right to not only get a copy of my data, but a regular backup is something I think should be required of organizations that collect information about me. Likely there might need to be a charge, but perhaps some regulation about what is reasonable and how this data should be available is a something else that might need some regulatory boundaries.

Steve Jones - SSC Editor

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

 
 Featured Contents

Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware

Shree Das from SQLServerCentral

Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in various ways depending on business objectives. As more organizations continue to move application and […]

Storage 101: Data Security and Privacy

Additional Articles from SimpleTalk

No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.

From the SQL Server Central Blogs - How to Iterate Through A List of Objects with Terraform's for_each function

Sheldon Hull from Sheldon Hull

What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com

locals {
users_file = "local.users.yml"
users_file_content =...

From the SQL Server Central Blogs - Should I Transform My Data In My SQL Query?

Bert Wagner from Bert Wagner

Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...

 

 Question of the Day

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

 

Offline Filegroups

I have multiple files in a filegroup in my database.  There are two filegroup: Primary and Archive. I decide to run this code:
ALTER DATABASE FGTest MODIFY FILEGROUP (NAME = N'Archive', OFFLINE)
GO
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)

BDC Storage

A SQL Server BDC (Big Data Cluster) includes a scalable storage pool. How is this set up?

Answer: This is an HDFS structure

Explanation: The data storage pool is set up as HDFS. There are SQL Serer nodes that have mdf/ldf/ndf files, but those are separate from the storage pool. Ref: What are Big Data Clusters? - https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-overview?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 - Administration
Cost Threshhold for Parallelism and MDOP - will these always have an effect? - Sorry for the newb question, but as I explore the Cost Threshhold for Parallelism and Max Degree of Parallelism configurations in SQL Server and talk with colleagues, I'm getting more confused. My understanding is that the SQL Server engine will recognize larger queries expected to take a lot of time/resources, and will automatically make use […]
SQL Server 2017 - Development
CONNECT BY result - Hi friends, How can we get multiple dates and days for the given number? In this example, 10 is given with '01-Jul-2020'. So 10 dates and days from 01-Jul-2020 are displayed. Could you please help on this?  
Administration - SQL Server 2014
Ola Hallengren backup has a bug - Hello, I am trying to use the transaction log backup Ola Hallengren scripts, until i came across an issue, where if the string is too long, and has a line break or goes to the next line, then it will give error message: Cannot open backup device 'X:\Backups\SERVER001\Database0001\Log\SERVER001$SERVER001 _Database001_Log_20200731_203617.trn'. Operating system error 123(The filename, directory […]
SQL Server 2012 - T-SQL
update full path for record - Hi, I have a table as you can see in codes below. Can you please help me with generating the last column 'ExpectingResultofPath'? Considerations: The first record is the parent document with level = 1. The rest of records are children documents embedded in the parent doc, so I need the full path+filename from the […]
SQL Server 2019 - Development
get top 5 max count for each month - How do you return a list of the companies,  sales, and month for the top 5 sales for each month without merging 12 queries with a union? The script to create the table and data is attached.
string compare again .. :) - I have a meta data string with 5 different numbers, for example @mdtsr ='4,12,13,14,17' and i have few hundred thousand records in a table with same structure, i mean 5 numbered string with a comma separator. I need to compare the strings in the table to metadata string and find all the records with at […]
sp_OAMethod to make rest api call - Greetings, I have a need to call a rest api against a resource. It a POST and would like to send the following as POST option http.post(url, '{ "https": { rejectUnauthorized: settings.ssl }, "headers": { "Authorization": "BASIC dfsdkfdsfyduyfiuhdfiuyu5y43=", "Content-Type": "application/json", "Accept": "application/json" } }' ) Tried to this but it fails EXEC @ret = sp_OAMethod […]
insert update help in sql server - Hello All, I have a insert update procedure where I am getting data from 2 procedures and putting the data in to a table. So procedure 1 has data like this   AgentName Tickets Closed Agent1 10 Agent2 2 Agent3 4 Agent4 6 Agent5 9 Agent6 12 Procedure 2 has data like this AgentName Active […]
Cant figure out how to pull data from one table but get diffrent results - I have an Employee table that has a primary key. This key is used in another table for both a Welder column and a Operator Column. How can i get the query to show two different results. EX. we have a robots that weld. The welder would be RO1 but the operator would be NG. […]
SQL Server 2008 - General
2nd Server min requirements for transaction log shipping - I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the production (primary) database server in a vSphere environment. I was planning on creating a secondary server that mirrors the Operating system environment and SQL server configuration, which is where the primary databases transactional logs will be shipped and applied. Since this […]
T-SQL (SS2K8)
Update and Joins - In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query? Is there a shorter way to write this update query? Cheers, J. DECLARE @IDHUIS VARCHAR(4) = NULL, @IDBEW INT = NULL --SET @IDHUIS = 'PH' --SET @IDBEW = 1401 ;WITH MYCTE AS ( SELECT B.IDHuis, […]
Update and Joins - In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query? Is there a shorter way to write this update query? Cheers, J. DECLARE @IDHUIS VARCHAR(4) = NULL, @IDBEW INT = NULL --SET @IDHUIS = 'PH' --SET @IDBEW = 1401 ;WITH MYCTE AS ( SELECT B.IDHuis, […]
SSRS 2012
How do I pass parameters to a SSRS report? - This is one of those topics that always seem to confuse me. I've got notes saying I should do something like this: http://ourreportmanagerserver/Reports/Pages/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512 and I've also got notes that specify this: http://ourreportmanagerserver/ReportServer?/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512 Now, to complicate things further, I've made a selection report, so that a user, if they user the Report Manager server, can select […]
Analysis Services
Error processing SSAS cube using TMSL via SQL Server Agent Job - Hi, I am trying to automate SSAS cube processing by having an SQL Server Agent job run a TMSL script. I have 2 servers (SSAS where all the cubes live and ETL where all the jobs live).  Both are 2017 version. Below is what I tried and the error I am getting: Created TMSL script […]
Job Postings
Beta user call- Google Cloud Platform SQL 2019 solutions - We are looking for SQL developers as beta users for our SaaS solution ( SQL server 2019 ) in Google Cloud Marketplace. It is ready to use deployment package for SQL server at Google Cloud Platform, where you can deploy within seconds. Literally. https://console.cloud.google.com/marketplace/details/gclouds-public/sql-server-2019-express What we are asking to them; -test the solution and provide […]
 

 

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

 

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