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

CCPA Preparation

There's an old Ron White joke about a small airport also being the tire repair center and hair salon. I thought about that when I saw a law firm became a software developer. I don't know what other enterprise might make a fun trio of businesses, but perhaps a sunglasses shop? Divorces, software, and a new look?

The CCPA (California Consumer Privacy Act). takes effect in less than a year. This is a law based on the GDPR, and the first strong attempt to regulate data in the United States. I think it's a good move, though I'm sure large corporations like Google and Facebook will fight it and find exceptions that allow them to play fast and loose with information about many of us humans. I also think, like the GDPR, this will force many smaller companies to better secure, manage, and handle the data they process about companies. I wouldn't surprise if this also brings about quite a bit of work for consultants and software vendors that help others better classify, protect, and manage their data.

A new product released by a law firm is designed to help other organizations in a number of ways, based on the knowledge and experiences of the lawyers that have worked in privacy law and compliance for years. They spun off a software development company who built an application that assists with four areas that organizations struggle with: compliance with consumer requests, mapping information flow, generating policy documents, and training employees.

I've worked in a few companies that needed to do most of those things to comply with some standard or regulation. It's not a difficult task, but it is complex, it's hard to stay organized, and it's hard to ensure that everyone understands how the new processes work. While an Excel spreadsheet can track everything you need, once you get beyond a trivial number of employees and systems, the entire system becomes unworkable.

Instead, some organized system needs to be in place that helps keep all your employees coordinated. I don't necessarily recommend buying software over building it in many situations, but here I would. There are lots of moving parts when trying to organize your data practices, lots of legal rules that you have to understand, and software is likely much cheaper than legal advice. Your employees will need to learn how to use new software, buy into new processes, and alter workflows, but capturing and documentation is the first step. Once you start to have a handle on what information you store, you can then decide what to do with the data.

Steve Jones - SSC Editor

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

 
Redgate WebinarsRedgate Database Devops
 Featured Contents

Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens

zippy1981 from SQLServerCentral

Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.

How to Linux for SQL Server DBAs — Part 4

Additional Articles from SimpleTalk

In this article, Kellyn Pot’Vin-Gorman continues teaching SQL Server DBAs how to navigate Linux. She demonstrates usings aliases, setting up environment variables, and examining processes.

A DBA’s Journey towards Database DevOps

Additional Articles from Redgate

John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.

From the SQL Server Central Blogs - Scalar Valued Functions in SQL Server 2019

Klaus Aschenbrenner from Klaus Aschenbrenner

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

From the SQL Server Central Blogs - Public Role Permissions – Back to Basics

SQLRNNR from SQL RNNR

If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...

 

 Question of the Day

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

 

Clearing Backup History

If I want to clear the backup history for only the Scratch database from my instance, and not remove history for the Sales database, how do I do this?

Think you know the answer? Click here, and find out if you are right.

 

Redgate SQL Change AutomationRedgate SQL Compare
 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Removing Ghosts

Which command would I use to immediately remove ghost records from a page that have not been cleaned up by the background process?

Answer: sp_clean_db_file_free_space

Explanation: Of all these answers, only sp_clean_db_file_free_space is a real procedure. This will clean the ghost records from pages. Ref: sp_clean_db_file_free_space() - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-clean-db-file-free-space-transact-sql?view=sql-server-2017

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
AlwaysOn AG versus FCI Licensing - AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) Checking to see the licensing cost for 2 and 3. Would there be licensing cost for secondary replica or the cost would be for secondary server only? Please advise? FCI is for HA scenarios. An AG synchronous secondary replica, co-located with the primary, is for […]
Powershell for Automating SQL Server Restore. - Team, Has anybody written a Windows Powershell Script to Automate the SQL Server Restore process. I am looking for following Input Parameters:- DB Name Backup Path The script should be able to script out the Logins before starting the Restore process. I am looking for to Restore the Databases using it's most Recent Backup copy. […]
Verifying Backup Integrity. - Team, If DBCC CHECKDB is successful; do we still need to perform Verify Backup Integrity while taking the DB Backups. As far as i believe; if DBCC CHECKDB is successful then it means that the Database is free from any sort of corruption. In that case; there shouldn't be a need to perform Verify Backup […]
Updates are failing - Hi All, We are facing a roadblock in production server, hope experts can give some solution here. we are having a 900GB MS-CRM on premise database with replication in place. In every 6-8 hours interval DB is declining all updates from application, unable to find the exact reason. any updates to any table is giving […]
FO cluster.... Sql browser behaviour - Apologies if this topic has been cleared away many times. I can't locate the specifics of this if so. A new Sql 2017 Ent FO cluster default instance (1433) named instance 1 (1434) named instance 2 (1435) named instance 3 (1436) named instance 4 (1437) named instance 5 (1438) I can connect to the default […]
SQL Server 2016 - Administration
Cluster with Multipal Editons - Can I have a AG cluster with six nodes , three with Sql2014 and three with Sql 2016 or 2017 ?, if yes, is this supported configuration ?    
Create table structure if the source table structure changes - Hi, I want to implement a logic where I need to check if the table that I'm archiving from source database is exists  or it's structure changed  and if Yes, then drop and recreate the table structure in archive database. Can you please advise the best way to achieve this?
Archiving data - Hi, I'm trying to archive tables that have data older than 6 months into an Archive database from source database. There are many parent child tables and I've created them in Archive database with the same structure. I've created a stored procedure similar to the one explained here at:  http://vyaskn.tripod.com/sql_archive_data.htm It works fine few runs […]
SQL Server 2016 - Development and T-SQL
Disappearing posts - Hi all I've tried to post an issue that got marked a SPAM (for no reason that I could see, although I did try to edit it to correct some typos). The forum will not allow me to post the question again as it's saying "Duplicate post" but I can't see it.   The post […]
Development - SQL Server 2014
How to find materialized/indexed views in a database? - My manager tasked me to find all materialized views in our database. In SQL Server i guess it translates to "indexed" views. But anyway, I checked sys.views, sys.objects and there is nothing there that can indicate it, all views are shown the same V. Is there is anything else in dictionary objects that I should […]
If we pass the DB name paramter should take the backup in the same server - Hi Team, Please help me on this below metioned code. Requirement: If we pass the DB name should take the Full or Diff or Tlog backups in deafult location where the data files existed  in the same server. First it should check the DB size and drive space is avaialble then it create or disply […]
SQL 2012 - General
No answer from answers.microsoft.com on this problem yet... - I posted the below in the answers.microsoft.com forums, but after three days have yet to receive a reply. Perhaps I posted to the wrong forum there: *********************************************************************** Below is from answers.microsoft.com *********************************************************************** looked at this thread... https://answers.microsoft.com/en-us/education_ms/forum/all/excel-2016-what-is-the-connection-string-for/75eeba94-bb05-4c86-8195-185d07e7ea49   So I tried using the Excel 2007 connection string: EXEC sp_addlinkedserver @server = 'ExcelLinkSrv2', @srvproduct = 'Excel', […]
Reporting Services
ssrs 2012 subreport is running really slow - I have an existing ssrs 2012 report that is running really slow this year. Last year it did not run as slow. Basically there is a driver report and this driver report can run up to 9 subreports. The number of subreports that are executed depend upon how many reports the user selects to run. […]
Disaster Recovery
Attaching Multiple MDF and having LDF regenerated - There are a bunch of posts for attaching a single MDF and having the LDF regenerated using sp_attach_single_file_db. Can anyone see anything wrong with this approach for doing the same thing with multiple MDFs? 1. Detach the database 2. Delete or move the log file to a new location so it will not be found. 3. […]
Administering
FUll Text Index Very slow - I am using full text indexing for partial match and Today it started to be very slow when I use the following queries It takes more than 1 min to return the results. SELECT * FROM [Syn].[CustomerNamesSyn] AS Customer WITH(NOLOCK) WHERE CONTAINS(Customer.CustomerName, ‘ ”any input string *” ’)   The full text index is set […]
 

 

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

 

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