Viewing 15 posts - 1,276 through 1,290 (of 6,105 total)
One of the best resources online is Safari (not the browser):
Basically, for print books on-line for a monthly subscription fee. Some professional organizations, like ACM (see Andy Warren's...
March 31, 2008 at 5:22 pm
You're not likely to get a real good answer on this one. SQL Server 2008 is still in CTP and final features haven't been determined. SQL Server 2008 RTM is...
March 31, 2008 at 5:20 pm
mostar5 (3/30/2008)
IF there's user.keys then look for that keyword in JOBS.PROFILE (LIKE %'keys'%)
This is certainly killing your performance. There is no way this is SARGable. Have you considered something like...
March 31, 2008 at 5:17 pm
When you encrypt a value, it's going to end up being sqlbinary as a data type. That's why the examples show the encrypted columns as sqlbinary. And when you decrypt,...
March 31, 2008 at 5:12 pm
That's easy to test. From a command prompt:
runas /user:**domain\user** cmd
Where **domain\user** is replaced by the Windows user account you were given. When prompted for the password, enter what you have....
March 31, 2008 at 12:43 pm
If you're not a member of the sysadmin fixed server role, the SQL Server Agent proxy account must be set, as previously discussed. So if you have a non-sa level...
March 31, 2008 at 12:28 pm
I have two bachelor's degrees in related fields, Physics and Mathematics. But I don't have a Comp. Sci. degree. I would say because I have the degree in related fields,...
March 31, 2008 at 10:21 am
Oh, there are a ton of bugs. As SQL Server MVP Hugo Kornelius blogged, Microsoft has said there hasn't been enough feedback requesting it. That's why it's important to go...
March 31, 2008 at 10:02 am
MD5 is not the hash you want to use. It has been clearly demonstrated over the last couple of years that collisions can be forced.
With respect to encryption, is...
March 31, 2008 at 9:57 am
xp_cmdshell is in the master database. Also, by default it has no security permissions assigned against it, meaning only members of the sysadmin fixed server role have the ability to...
March 31, 2008 at 9:49 am
It's going to be found at:
%systemroot%\System32\Logfiles\Cluster\Clcfgsrv.log
on one of your two cluster nodes.
March 31, 2008 at 9:47 am
Yes, we've used it in our non-production environments. We've also had a couple of cases with SQL Server 2005 Express Edition in production. A lot of it depends on the...
March 31, 2008 at 9:45 am
Marios Philippopoulos (3/27/2008)
I'll confess I'm addicted to this site...Every time I get an email notification on a new posting, it's as if it goes straight to my veins! :w00t:
This...
March 31, 2008 at 6:35 am
Viewing 15 posts - 1,276 through 1,290 (of 6,105 total)