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

Don't Get On This Page

The GDPR has been in effect for over a year. While the press has died down a little, outside of a few record fines, there is still plenty of activity. At Redgate, we have customers that still worry about compliance and are doing their best to ensure they properly handle and secure data. It's a tough job, but one that many organizations need to continue to focus on.

And there's a good reason. Who among you would want their boss to come talk to them about mishandling data? Who wants their boss to come after reading this page, with your organization and fine listed? I'm guessing most of us would prefer to not be on that page, or at least not want our boss to know.

There have been a lot of fines handed out, though most are relatively small. Still, every amount spent towards a fine is money that could be used for shareholders, investment, or even better security and systems to prevent future issues.

What's interesting is that many of these fines aren't for data breaches, but rather for other issues. There are some security issues (unauthorized access), and some inappropriate storage. There are also quite a few consent fines, where data is used without the appropriate permissions from the data subjects.

I find the list interesting, and I hope this is the type of thing that does drive change in organizations. Many of these fines might easily be eliminated with a few process and procedure changes and adding some security to prevent unauthorized access. While some companies might be willing to pay fines, I expect that subsequent amounts will rise, and it behooves organizations to change both their behavioral and technical practices.

This might be building archival processes, which would be one of the few ways that might reduce the amount of data that we need to manage and query. Hopefully, something that might improve performance for your clients.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
  Featured Contents

Let’s Start with Architecture

pamelamooney1966 from SQLServerCentral

In this article, we look at the conceptual design for gathering information about your servers to better understand how they are performing.

Database Build Blockers: Mutually Dependent Databases

Additional Articles from Redgate

Phil Factor demonstrates a clever way to create 'stub' objects, in SQL Change Automation pre-deployment scripts, in order to overcome the problems caused by 'missing objects' when building databases that have circular, or mutual, dependencies. In the subsequent deployment, SQL Change Automation fully builds every object in each of the databases, so all dependencies are fully tested.

From the SQL Server Central Blogs - Allow SQL Server Agent jobs management for non sysadmins

Cláudio Silva from Cláudio Silva

I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...

From the SQL Server Central Blogs - Graph Databases – Introduction

Diligentdba 46159 from Mala's Data Blog

I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...

 

  Question of the Day

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

 

Database Auditing

I want to audit my SQL Server 2017 instance with the SQL Server Audit feature. I want to audit backup and restore activity for 3 databases. What are the minimum Server Audits and Database Audit Specifications that must I create?

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)

Reading Part of a Dataframe

I am tracking some of my flights in this csv file:

Flight,Origin,Destination,FlightTime
UA9,IAH,LHR,"2019-04-30 17:34"
UA58,LHR,ORD,"2019-05-01 09:12"
UA99,LAX,LHR,"2019-06-17 20:18"
UA25,LHR,IAH, "2019-06-22 07:23"

I want to read this into a dataframe in R, but only the first two rows. How do I do this?

Answer: may.trip <- read.csv2("Flights.csv", header=TRUE, sep = ',', nrows = 2)

Explanation: The nrows parameter will limit the number of rows read into the dataframe. Ref: read.csv2() - https://stat.ethz.ch/R-manual/R-devel/library/utils/html/read.table.html

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
How do I encrypt a DB on SUBSCRIBER server to an encrypted DB on the PUB server? - I have a PUB on a SQL 2014 Ent server where the database is encrypted w/ TDE (Key algorithm=AES, Key Length=128) I have a SUB to that PUB residing on a SQL 2017 Ent server. When I check the PUB DB, it is encrypted. When I check the SUB DB is is NOT encrypted. I […]
Ports to be opened - Hi All, We have an on-prem to Azure IaaS migration going on, we have to copy the files between the on-prem windows DB server to Azure VM DB server.   Can someone help me how can I achieve this by opening the ports in the firewall. I know using storage explorer I can upload and […]
SQL Server 2017 - Development
T SQL Advance Report Month Range on the 16th - Looking For More Effect. approach - Greetings All, I'm looking for suggestions on how to improve the script below. Requirements: From the 1st of the month to the 15th, report on the current month plus 4 additional months ( total of five months). From the 16th of the month to the end of the month, advance the month range and report […]
New login doesn't appear in Security > Logins folder - I think my original login was DESKTOP-8J18OSS\micha which appears in the folder Security > Logins.  Then I changed the computer name to Virginia.  The top most value of the Object Explorer says: VIRGINIA\SQLEXPRESS2017 (SQL Server 14.0.2027 - VIRGINIA\Michael) Isn’t VIRGINIA\Michael the login name?  If so why doesn’t it appear in the Security > Logins folder? […]
sqlcmd sql agent job - I have a sqlcmd script, it runs fine if I open the command line to run it. sqlcmd -S (local)  -d mydb -E -s, -W -i D:\_ssisfiles\scripts\ProductMap.sql | findstr /V /C:"-" /B  > D:\_SSISFiles\Scripts\xtest.csv But if I makes it to a sql agent job, the job failed and it got the following error: Sqlcmd: Error: Error occurred […]
SQL Server 2016 - Administration
Query store is set to read only - I have the database and it says that the querystore is set to read only. Do i just run the following commands? --Clean it up ALTER DATABASE [QueryStoreDB] SET QUERY_STORE CLEAR; --Set it back to read write ALTER DATABASE [QueryStoreDB] SET QUERY_STORE (OPERATION_MODE = READ_WRITE); GO The threshold i have are 367 days- reduce it […]
SQL Server 2016 - Development and T-SQL
How to get the list of login accounts logged in over specific period of time - Hi, Can any one help me to give me the sql script for following requirement 1: List of login account stored in DB table for last 3 months against a specific DB like TestDB 2: The script should insert the records to table with following details Login name, Login DateAndTime, Database Name,Host name etc for […]
using trigger for tracing - Is it possible to create a trigger on a table for a specific column that will log the user who modified column and the sql text used to update the column?  I'm trying to track down where changes to a field is coming from. Or can SQL Server profiler do what I'm looking for?
Get an Output from a Stored Procedure - Hi Forum, I have an SP developed by Pinal Dave which is great for removing all text from a given table value. I want to apply the same logic via a Stored Proc that loops down a Column of a table, removes the text characters & then outputs the results to a temp table, external […]
Development - SQL Server 2014
Using Try Catch in Procedure with Multiple Update queries - All, I am trying to implement a Try Catch in a stored procedure that contains multiple Update routines (see below code). Is the below the correct way to do this? Any help is appreciated.   BEGIN TRY /*This routine sets any SOAP Note where there is no matched claims that has an encounter date >= […]
Customize a datetime field - Hi All, Looking to get advice on how to create a datetime field by combining int year and month fields with a '05' for the date. I'm trying this in my query for the field: Cast(Convert(nvarchar,(ib.InvoiceAccountingYear + '-' + ib.InvoiceAccountingMonth + '-' + '05'))AS smalldatetime) AS FirstInvDt but it's returning dates such as these, with […]
SQL 2012 - General
Update Stats or Code - Hi, Could you please let me know if the 'below script/code' OR..'Auto Update statistics'= True ( DB - Properties-Options )  does the SAME work for the specific DB. I see the below code running for some databases in SQL agent job. Now my questions is if we just set the Auto Update statistics = True […]
Amazon AWS and other cloud vendors
AWS RDS SQL Server Licensing - SSIS - We are planning on using an SQL Server Standard RDS instance on AWS to host a number of databases. For to load the database the intention is to a Windows EC2 Instance on which we would like run SSIS packages to fetch and load data onto the databases hosted on RDS instance. Does the Windows […]
SQL Server Newbies
Using SQL for multiple pulldowns - So, I need to be able to use SQL to provide options in a series of pulldowns related to an employee's space/location. They are: Pulldown #1: Building Pulldown #2: Floor Pullown #3: Room Number   The user would select an option in each pulldown but do them in sequential order (Building pulldown first, then Floor […]
Certification
Questions on Degree programs - Hey all, Junior DBA here in USA. There are several community colleges near me that offer Database management degree programs. I'm wanting to get into DB development, and i'm not sure how to make the leap since im coming from IT background. Does anyone have any experience with such programs? or recommendations in general?   […]
 

 

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

 

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