Saturday, September 14, 2013

[SQL 2012] Encrypting a Coulmn in SQL Server 2012

[SQL 2012] Encrypting a Coulmn in SQL Server 2012

Encrypting a Coulmn in SQL Server 2012

Posted: 14 Sep 2013 12:20 AM PDT

Hi,Need help on how I could encrypt a field (For Example a Password Field) in a Table in SQL Server.Table contains about 50 rows of data which includes username and password only.Thanks in advance.

checking things after database restore

Posted: 13 Sep 2013 07:04 AM PDT

Hi,I have restored a backup from server A to server B.After restoring I found that broker enabled and trustworthy was set to true on server A and not on server B.I manually set them to true.I also checked CLR.Are there any additional things that we need check that will not be done with restoring?Thanks.

Rounding a number up to the nearest 5

Posted: 13 Sep 2013 07:08 AM PDT

So I am attempting to mimic some legacy code on an old server at my work. It has a calculation to determine cost. What I need to do is round the number up to the nearest 5th.For example:1.0 -> 5 (everything less than 5 gets rounded to give)5-> 55.75->58->1011->1586.5->90so any number that has a 5 in it before the decimal - will stay rounded to 5. Example - 75.65 -> 75. I have the following code:declare @mon numeric(10,2)set @mon = 86.5 select case when (round(@mon/5,0)*5) < 5 then 5 else (round(@mon/5,0)*5) endHowever - when I run it - 86.5 gets rounded to 85. I need it to round to 90.Any suggestions?

Using FTP task in SIS 2012

Posted: 13 Sep 2013 08:00 AM PDT

I have an SIS package in 2012 that I'm trying to setup the FTP connection to pull a file from an FTP server.I can setup the FTP connection and test with no problem.I go to the FTP task and set up everything to receive filesI have the local Path set as to the folder it is supposed to go toOperation is to Receive filesClick on the Remote Path and I can see the file I want to pull down and I can select itSaveWhen I try to execute the task though I get the below errorI have an identical package written in SIS 2008 that is giving the same error and using the same steps outlined above.Am I missing something.Thanks in advance FTP Task Error:Unable to connect to FTP server using FTP Connection Manager

SQL 2012 SAN lvl Replication for DR - Issues and Thoughts

Posted: 13 Sep 2013 06:52 AM PDT

I will try to break up the picture as much as i can so i could get some feedback / thoughts from experts. [color=#000000][b][i]---------- Current Setup ----------[/i][/b][/color]I will just talk about Test for now1) 2 Node cluster2) 2 instances (08r2 & 2012)3) Binaries / data (not talking abt mdfs lfds) files are not on SAN. they are local. [color=#0000FF][b][i]---------- Trying to Achieve ----------[/i][/b][/color]1) set up a DR to a different location2) Since step 2 (see above) cannot be replicated via SAN we decided to replicate the Mdfs, Ldfs, Temp (data/log)3) Install a new sql 2 cluster node and installed only SQL 2012 instance (it can support 08/r2/2012)5) Successfully brought all databases online in testing. [color=#FF0000][b][i]---------- Questions I have ----------[/i][/b][/color]1) Are there any Pros & Cons that have been faced when having SQL binaries / data on SAN and using SAN lvl replication only to bring SQL up and running on Dr site?2) Would there be a need to involve any other HA process with SAN replication?3) How hard ([i]will this require a new installation?[/i]) will it be to re-do test (2 node cluster) / qa (2 node cluster) / prod(4 node cluster) and get binaries / data on SAN. I would appreciate if i can be pointed in the correct direction or if the experts have any thoughts, exp to share. Something to kick start.[b][i][u]Noli Timere[/u][/i][/b]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog