SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
2019-03-14
2,987 reads
Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.
2019-03-05
2,916 reads
In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.
2019-02-25
2,336 reads
It’s hard to avoid privacy-based stories at the moment, with growing concern over government snooping and the limits of power. But where I’m based, in the UK, there’s a new, fully-privatised invasion of privacy. One marketing company has created an outdoor wi-fi basestation that grabs your phone’s MAC address as you pass, with the idea […]
2013-08-19
64 reads
A new technique to help anonymize medical research data has been developed, and could help with other types of data, but there is an issue.
2010-05-27
79 reads
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
247 reads
I'm bad about remembering error coding when I try and answer a question quickly. Glad it helped.
2005-05-24
That really hits home for me too. I agree with Del (above). I have a short list of developers that I actually consider savvy enough to build solid code and an immense list of developers that I [know] from experience code horribly. The "good" coders are the ones that take pride in their work. It's […]
2005-05-23
search help for sp_textcopy , you can insert binaries into image fields, very easy.
2005-05-20
Thanks for responding.Great point! However, wouldn't (01,02,03,10,12,20) sort as (01,02,03,10,12,20)? Would this concept mess it up if I had data such as (33256-0456, 33256)!!!?Here's what I did:1. I dropped the indexes, removed the PK and indenty, then rebuilt the table as follows:Set Zipcode to PK, Set ZipCodeID to Identity and it works fine.2. I wonder, with such […]
2004-02-20
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers