Viewing 15 posts - 1 through 15 (of 937 total)
December 17, 2018 at 10:51 am
December 17, 2018 at 10:09 am
A useful test might be to sort by a different column than you're selecting. Sort by date, name, etc., and retrieve a numeric value, for instance.
December 17, 2018 at 12:00 am
Got it resolved. It seems AOAG doesn't like it when the database username that owns the certificate used by the database mirroring endpoint is different from the associated login name.
September 24, 2018 at 1:41 pm
Looks like it was removed. The toolkit was actually an implementation specifically for SQL 2000, which is why it was probably removed. The primary encryption functionality is built into SQL...
October 10, 2017 at 1:52 pm
michael.rosquist...
June 5, 2017 at 11:01 pm
On SQL 2005, 2008, 2008R2 the password is hashed using SHA-1 hashing algorithm with salt. The result is a varbinary string with 0x0100 in the first two bytes. The salt...
April 30, 2015 at 10:29 am
TravisDBA (6/19/2012)
June 19, 2012 at 9:23 am
Duncan P (6/19/2012)
June 19, 2012 at 9:19 am
It does depend, and on a lot more factors than we've covered here so far. I'm not familiar with your apps but note there is a difference between significant inserts...
September 27, 2011 at 2:58 pm
Elliott Whitlow (9/27/2011)
Mike C (9/24/2011)
September 27, 2011 at 12:04 pm
j_depp_99 (9/24/2011)
so here goes -- I have less than 2 years experience so forgive the odd errors in design.
- The MD5 hash key...
September 24, 2011 at 11:59 am
Elliott Whitlow (9/23/2011)
Evil Kraig F (9/23/2011)
Addendum on a second look:[hashField] AS ([dbo].[getMd5Hash]([entryId])),
As a calculated column, non-persisted?
This table is just RIPE for pain.
Good catch on that.. The...
September 23, 2011 at 8:22 pm
Evil Kraig F (9/23/2011)
Mike C (9/23/2011)
September 23, 2011 at 7:41 pm
Viewing 15 posts - 1 through 15 (of 937 total)