Forum Replies Created
Viewing 15 posts - 4,426 through 4,440 (of 5,356 total)
-
RE: Do you think DBA is a desirable job?
quote:
You will! However, you must keep posting to the forum. It's half the fun of being a DBA!--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Do you think DBA is a desirable job?
Hello Dale,
quote:
I didn't become a DBA/programmer until I was 13 years into my career. Previous to that, I was an IS...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to Break a While ?????
quote:
I think the best way to learn how to write readable code is to have to work on someone else's.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL Server Security: Why Security Is Important
Hi Brian,
very good research work!
What I like is your fine, yet true distinction between hackers and crackers
From my point of view, a hacker has not malicious...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Dealing with ' and " in strings
Hi TomT,
quote:
I am struggling to find a way to deal with cases where one or both of these can show up in...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to Break a While ?????
Hi Greg,
quote:
I should have known there would be a debate over the GOTO. Well I suppose a GOTO is considered bad...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: QOD 30/07/2003 Incompetent Inc
quote:
Seems common sense made you choose the correct answer. Something that does not exsist in Incompetent Inc.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to Break a While ?????
quote:
You could try the GOTO command like so:just out of curiosity
Is...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: xp_servicecontrol
quote:
If MSSQLSERVER is running under an admin account you certainly can.Reminds me of the time I used it (for security...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: xp_servicecontrol
quote:
No secret there. I just ran it on my testbox here to see what happens when. The only thing that is confusing...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: xp_servicecontrol
quote:
startstop
pause
continue
querystate (Almost forgot that one as noted in previous posters post).
Parameter 2 is the Service Name.
For example "FTP Publishing Service" is MSFTPSVC....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: QOD 30/07/2003 Incompetent Inc
quote:
Very good!!You forgot the HR director
Mr Pay_Peanuts_Get_Monkeys
I thought Catbert had this job...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: QOD 30/07/2003 Incompetent Inc
quote:
Incompetent Inc :Is this an international company, because i have heard of them in all the palces i've been?--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: QOD 30/07/2003 - Another Documentation Error???
Hi Dan,
quote:
I was a little suprised to get todays QOD wrong. I answered 5) You can't run Enterprise Edition of SQL Server...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: DATETIME datatype
Hi gbn,
quote:
For stripping times off, I always prefer this:CAST(FLOOR(CAST (DateTimeCol AS real)) AS smalldatetime
try this...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 4,426 through 4,440 (of 5,356 total)