One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
2007-09-22 (first published: 2001-07-17)
33,394 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/encryptfunction.asp
2001-07-15
33 reads
2001-07-12
3,298 reads
Not again you sigh... 🙂 Well, its on for young and old and im in the thick of it yet again. Table and column naming conventions are what I am after as far are recommendations and tried and tested schemas. I have gone for the following for sometime now: Tables : name as required to […]
2001-07-11
407 reads
Hi all I read a while back (somewhere!) about what msdb stored procedures to restrict to prevent users from a) Creating or modifying packages b) Viewing (seeing a list of) packages) I can take some pot guess and spend hours doing it, but can any point out the exec privs for some of the sp_enum […]
2001-07-10
6 reads
Hi - I am continuing to hang my EM sessions when trying to define a transformation on a very large DB (a SAP DB with 15,000 tables). All I want to do is copy 15 tables routinely into another db for analysis services, but when trying to define this DTS wants to read all table […]
2001-07-09
11 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lsmith/usingcomtooutputqueriestoatextfile.asp
2001-07-09
7 reads
My datacenter has a 100 MBPS network. I sit outside the Data center in a 10 MBPS network. Here's the scenario: The 42 GB dump of a database is on Server X within the 100 MBPS network The restore has to happen on a server Y also within the same segment/network. My computer Z in […]
2001-07-08
2 reads
I am trying to change field type from 'char' to 'datetime', the enterprise manager gives error message stating "- Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been […]
2001-07-05
15 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/droppingadatabase.asp
2001-07-05
10 reads
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