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

Is Data the Future of the Vibrant Web?

Data privacy is a fascinating subject. Since the GDPR was passed, I've had a lot of conversations with people about the GDPR and the way different people feel varies dramatically. Moreover, the way an individual feels often varies depending on the situation. I know plenty of people that want their own data completely private, but they also want no restrictions on what they do with data inside their organization. Others feel the exact opposite.

One type of data that many people don't think about is the cookie data that is used by Google and Facebook (among others) to track a user across many browsing sessions. This tracking is one reason that I see Redgate ads on a movie site or a new site. If I happened to search for SQL Compare, which I do sometimes to get a link, I might later see related ads on a site that has nothing to do with technology or SQL Server.

Apple, Firefox, and Microsoft have been experimenting with ways to give you some tracking protection in your browser. This should allow less data about individuals being captured, stored, analyzed, and then it couldn't get lost/stolen/hacked.

Google has a different approach, and one that I think benefits them and their paying customers more than the rest of us. The idea is to have some sort of data cap for types of information, above which the browser would return generic information. Potentially it could return inaccurate information, but I can't see that passing any sort of business relationship test with Google customers.

The goals here are relevant ads, and of course, information about you in order to serve relevant ads. While I think this goal will be met, I'm not sure it's much more private than the situation today.

Data privacy means allowing users to decide what data a company, including a tracking company, is willing to share. The way browsers have changed in the last few decades is complex and confusing. I have no idea what information they track from my system(s), and I'm not sure I would even understand the implications of enabling certain rights. While most of us wouldn't want to share our email, there are lots of other data that we might not be sure of the way it might be used.

Like most of the data privacy issues, I have no idea what to do here. The issues are complex and confusing. I would hope that Google would remember its "do no evil" origins and help us increase our ability to keep data private.

Steve Jones - SSC Editor

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

Redgate University
 
 Featured Contents

Using tsqlt Tests to Practice Queries

Steve Jones - SSC Editor from SQLServerCentral

In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.

Using PowerShell to Generate Logins, Server and Database Permissions

Additional Articles from Database Journal

Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.

Redgate need users looking to do CI/CD for Oracle Databases

Press Release from Redgate

Are you working with Oracle databases or know somebody that is? Does a company or client that you are working with also have an Oracle counterpart? If so, we want to talk to you/them about how they are currently working. We are currently running an Early Access Program (EAP) for a migrations-based solution for Oracle users. Sign up today, get the beta release and let us know your feedback!

From the SQL Server Central Blogs - SQL Server Quick Tips

Bert Wagner from Bert Wagner

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

From the SQL Server Central Blogs - Using Project Connections in SSIS

Tim Mitchell from Tim Mitchell

In SQL Server Integration Services, connection managers are used as gateways for most any external read and write operation. Connection managers are type- and format-specific, and in the case...

 

 Question of the Day

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

 

Quickly Dropping Columns

I have a table that contains 1 billion rows. I want to drop a column that our application is not using. Under which circumstances can I do this as a metadata operation?

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

 

 

 Yesterday's Question of the Day (by Carlo Romagnano)

Create temporary table on fly

I run the following code:

select col1 = 1/0.000 
into #a 
WHERE 0=0

What happens?

 

Answer: Temp table #a is created, Divide by zero error encountered., Column "col1" is numeric(10,6), Temp table #a is empty beacuse of error

Explanation:

According to the Logical Processing Order of the SELECT statement, the order is:

  1. FROM/INTO
  2. WHERE
  3. SELECT

This means that the table will be created and the WHERE clause evaluated before the column list is computed.

Discuss this question and answer on the forums

 

Featured Script

WorkDay Functions

habib from SQLServerCentral

Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.

 

More »

 

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
Stored Procedure - I have a table: Named  HighScores "INSERT HighScores VALUES ('Bob', 2500, '2 Jan 2013 13:13'), ('Jon', 1500, '2 Jan 2013 13:15'), ('Amy', 3500, '2 Jan 2013 13:18')" I want to create a stored procedure that would: The score must show the TOP 5 or so people. Show your position on the high score board Show […]
After 2014 to 2017 Upgrade, table unused space growing massively. - I have a database that we recently upgraded from SQL 2014 to SQL 2017. The application against the data are working fine, but we started to notice database file growth. After investigating, many tables are exhibiting a behavior where the unused_space is growing massively compared to the time before the upgrade, and I cannot figure […]
SQL 2017 Automatic Tuning (issue?) - Hello, This past summer we migrated to OS 2019 and SQL 2017.  I have the automatic tuning feature enabled for the DB in question and all has been fantastic until this morning.  Each morning index maintenance (Ola Hallengren) runs with rebuilding statistics option.  Once load began, (~ 5,000 users) massive blocking began (LCK_M_X) slowing down […]
SQL Server 2017 - Development
Using a CTE in a subquery - I have been tasked with identifying a set of users in one of our databases.  The following code should be reasonably self-explanatory: --There are 1,360 Users SELECT COUNT(*) AS NumUsers FROM Users; -- Use a CTE to identify all Users who are linked to Actions - there are 82 of these ;WITH ActionCentreUsers AS ( […]
Getting a result set from temp tables - So I have 5 queries . Each query fills a different temp table.  For each table the first two columns will be named (GovState, FirmID) . A third column will also exist. It will be named differently depending on the temp table. ("CountOfPolicies", "CountOfQuotes", etc)  This column will normally show a count of something. I […]
SQL Server 2016 - Administration
AlwaysOn 2 Nodes Next to Zero Downtime with SQL Edition Upgrade - I'll attempt to be as specific as I can with this question. I've been tasked with setting up AG's on our SQL Servers. We have a customer who provides translation services for medical facilities so downtime is hard to come by. I need to upgrade our SQL Server version from Standard Edition to Enterprise so […]
question on locking ? - Hi All, Heard about readers can also block writers. Can anyone provide a demo example to prove this? I was under the impression that only writers can block readers. Secondly, will INSERT block a SELECT ? Thanks, Sam  
SSIS catalog deployment from source server to target - powershell - I am looking for a good solution for automating the deployment of SSIS packages through environments. Right now the deployment is very manual but I am hoping to find a powershell script that will copy packages from source to target servers (including all configurations and environment variables). Does anyone have any suggestions? I have found […]
SQL Server 2016 - Development and T-SQL
how to call same logic using different parameter in if then else stored procedur - ALTER PROCEDURE [dbo].[employee] @isemployee int AS IF (@isemployee = 0) BEGIN DECLARE @Email Varchar (100) DECLARE @Name Varchar (100) SELECT @Email = text from dbo.emailtable WHERE email = 'XXX' SELECT @Name = name from dbo.nametag where refer = 'HJJ' SELECT @Name as NAME, @Email as EMAIL, '' as Test1, '' as Test2 END ELSE BEGIN […]
SYMMETRIC KEY Incorrect syntax near 'TRIPLE_DES' - Hi All   I'm using SQL2016 I'm having an issue with a piece of code generated in SQL2008 Sample code below This returns Incorrect syntax near 'TRIPLE_DES'. So, looking around, it appears as though TRIPLE_DES has been deprecated Is there an obvious replacement for TRIPLE_DES here? CREATE SYMMETRIC KEY [My_SYMMETRIC_Key] AUTHORIZATION [dbo] WITH ALGORITHM = […]
SQL 2012 - General
DB digram, Standard reports to use. - Hi, Please let me know.. DB Diagram: SSMS is not helping with so many tables and huge DB. Please advise if there are other ways which can be helpful to generate or create DB diagram. The goal is to understanding the tb lvl relationship and what is the MASTER table and get better understanding. 2. […]
XML Data singleton value not fixed???? - Hi Hope to explain this correctly I have some XML data that can vary on singleton value So in the example below I want to list the "Company" along with the "Service"  but [1] may be any value('Mental Health', Substance Abuse etc..)If the User entered Mental Health first it would be [1] if they enetered […]
Execution Plans - Hi, How do  you share execution plans.  Save the plan and share the .sqlformat file as take a screen shot what is the best practice. The only reason to do this to optimize the query. Thanks!
Security (SS2K8)
Remote Server calls failing since recent Windows update - Has anyone else had issues with linked servers, remote calls, double-hops, etc, since the July, August, or September 2019 Windows updates? We know the cause is in there somewhere, as we have re-imaged a PC to pre-July updates and everything works. As soon as the updates are applied, ka-blooey. We can't control the updates (and […]
Anything that is NOT about SQL!
SQL Licencing and a move to Opensource RDBMS' - Good day Quite a number of our larger clients are contracting us to assist them with migrating from SQL Server to other opensource RDBMS'. Their motivation is simple: Microsoft licencing is becoming way too expensive and is corroding their bottom line. This is a very similar to what happened a few years ago when companies […]
 

 

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

 

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