Forum Replies Created

Viewing 15 posts - 136 through 150 (of 813 total)

  • RE: Password checker automation

    Separately, the phpbb password list is an excellent, small starter list - add in words related to your company, your software products, names from your employee list, etc. Just...

  • RE: Password checker automation

    If you want to get into more advanced checking, I would recommend using Hashcat (http://hashcat.net/oclhashcat/[/url]) against passwords extracted in bulk (i.e. multi-server query) with a rules-based dictionary attack.

    You will need...

  • RE: Compression

    ipounder (1/30/2014)


    The question requires you to make some assumptions (the compressed database is wholly compressed, and the data is basically the same in both databases, for instance).

    The answer is based...

  • RE: Software Patents

    I'm going to go out on a limb here.

    First, the U.S. Constitutional clause that allows IP:

    "To promote the Progress of Science and useful Arts, by securing for limited Times to...

  • RE: Servicing SQL Server in the Future

    Microsoft is encouraging us to pay continuous per-year fees (like the EA agreements for SA licensing), taking that money, and then failing to provide us with properly tested updates (i.e....

  • RE: Backup Encryption options with SQL Server 2008 R2 SE?

    You can also backup to an encrypted drive/directory, be it http://www.vormetric.com/products/encryption (paid), or http://www.truecrypt.org/ (free)[/url], or the old http://sourceforge.net/projects/freeotfe.mirror/ (free)[/url], or an external drive with hardware encryption like...

  • RE: DBCC CHECKDB Questions on general practice

    taseedorf (1/27/2014)


    Do most people run DBCC check DB daily? Weekly?

    As often as fits into my maintenance windows. If it runs within my "slowdown OK" daily maintenance window, I run...

  • RE: QA and DB Design team sleeping in same "bed"?

    Jeff Moden (1/26/2014)


    I guess I understand their outrage, then. I could be wrong but I've always understood that Design Review Meetings were supposed to happen before new changes and...

  • RE: need T-SQL to delete ALL subdirectories within a Directory

    Netbackup or not, I agree with Jeff - failing to wait until your new backups are verified before deleting your current backups is shooting yourself; perhaps the netbackups make it...

  • RE: Best way to get large amount of data for a join from another server?

    Can you give some more detail on the big cases? From what I understand, you need to join IA.DA1.SA1.TA1 to IB.DB1.SB1.TB1, where both are "large". Please extend to...

  • RE: Common Checks

    Untrusted, but enabled constraints (autofixed when possible)

    Index fragmentation (autofixed)

    Database owner not "sa"

    Too many VLF's or too few MB per VLF

    Autoshrink

    Autoclose

    Log files almost full

    Data files almost full

    Page verify other than CHECKSUM

    Full...

  • RE: SQL Server Security and linked tables in Access.

    Access linked tables can definitely use Windows Authentication, DSN or not. Each table in each Access DB can use its own authentication.

    Pass-through queries, too, can use their own authentication.

    Here's...

  • RE: compressing read only file groups

    I agree with everyone above - if at all possible, use SQL Server Enterprise edition data compression - you just need to be sure every (large) table has a clustered...

  • RE: HASHBYTES

    L' Eomot Inversé (1/21/2014)


    Of course the answer relies on there being no hash collision between one of the three 24-bit strings and the corresponding 160 bit string, which is true...

  • RE: Software in 2014

    I'd say coding has changed very little - and most SQL coding, much like most C or even C++ coding, also hasn't changed much. Sure, we're maybe using window...

Viewing 15 posts - 136 through 150 (of 813 total)