data protection

External Article

Execution Plans and Data Protection

  • Article

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.

2018-04-30

3,411 reads

External Article

Questions About the GDPR That You Were Too Shy to Ask

  • Article

The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask.

2017-12-14

3,329 reads

SQLServerCentral Article

Configuring Backups Using Veritas Netbackup with AGs

  • Article

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.

You rated this post out of 5. Change rating

2017-07-18

3,780 reads

SQLServerCentral Editorial

Wanna Cry? Me too

  • Editorial

I don’t doubt for a minute that on a certain level you’re sick to death of people talking about the Wanna Cry ransomware. However, bear with me, we need to go through it just a little more because it actually has some bearing on us as data professionals. OK, more than some bearing, it’s a […]

4 (1)

You rated this post out of 5. Change rating

2017-06-05

172 reads

Technical Article

RE: Replication error when using IP address

  • Reply

Hi SRB,I don't know if a push subscription would have the same error because the publisher does not know the address of the subscriber, as the ip address may constantly change etc. Plus the nature of the system is such that only a pull subscription is feasible.I would assume it would have the same error […]

2005-05-29

Technical Article

RE: Import XLS to table; data in 1 field set to NULL in the table

  • Reply

I would save your XLS as an MSDOS CSV file.  Use an Active-X Transform and format each source column in the manner expected at the destination:Function Main ()     '** Force text values from column one     DTSDestination("foo") = Left(Trim( "" & DTSSource("Col001"), 50)     '** Force non-nullable numeric field with default to zero from […]

2005-05-27

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers