Viewing 15 posts - 316 through 330 (of 814 total)
It is almost never recommended to shrink database or log files, even less likely to need them done all at once, and absolutely not in a scheduled job. Shrinking...
November 2, 2012 at 11:55 am
I definitely approve of cross-training; I'd note that the most advanced DBA written maintenance, backup, etc. scripts I've seen are extremely simple by any experienced developer's standards, and I often...
October 23, 2012 at 8:16 am
Phil Factor (10/8/2012)
October 9, 2012 at 9:35 am
You need the over X12N layout.
AND
You need the companion guide.
AND
More than likely, you need to speak with someone at the generating end, because (more than likely) the layout +...
October 9, 2012 at 8:38 am
GSquared (10/8/2012)
Nadrek, please add to your list, "Download using a disposable machine".
Hmm... I'll rate that one just below the two LiveCD ones, both of which should be considerably easier than...
October 8, 2012 at 11:07 am
WayneS (10/6/2012)
Hi Phil,I'm curious as to the source of the password list that you utilize. Is it something that you can share a link with?
1) Be careful looking -
...
October 8, 2012 at 10:40 am
I agree completely on performing password audits. PWDCOMPARE, however, is good for a first pass but not for the only pass. If you can find a password with...
October 8, 2012 at 9:15 am
CptCrusty1 (10/5/2012)
October 5, 2012 at 12:49 pm
Abu Dina (10/5/2012)
Can you give an example of a "tough" question?
0. Ask a question that they can answer based on rote memorization
Then
1. Why?
2. Explain more.
3. So, is that better or...
October 5, 2012 at 12:44 pm
cphite (10/3/2012)
Or, you might check into recruitment firms in your area and see if any of them do technical screening for candidates.
Candidates who have poor or surface/rote memorization knowledge?...
October 3, 2012 at 4:30 pm
Miles Neale (10/3/2012)
October 3, 2012 at 2:56 pm
GSquared (10/2/2012)
And so on, but with real questions. Someone with no real knowledge of SQL Server could memorize those, and spit them out rotely.It's about ethics.
I've seen...
October 3, 2012 at 2:47 pm
Check for enabled but untrusted constraints.
Log performance/error/etc information to a monitoring server
Log security information to a monitoring server
Log backup/agent job/error log information to a monitoring server
Optional: Restore a database backup...
October 3, 2012 at 2:35 pm
Those are almost certainly HIPAA formats, i.e. ASC X12 270 ASC X12 271 ASC X12 834 ASC X12 837
A very...
October 2, 2012 at 1:31 pm
TheSQLGuru (10/2/2012)
I will add that I DEFAULT to using temporary tables and only switch to table variables in VERY exceptional situations.
I do the same; I've almost never seen any situation...
October 2, 2012 at 10:52 am
Viewing 15 posts - 316 through 330 (of 814 total)