Jonathan Kehayias

Forum Replies Created

Viewing 15 posts - 481 through 495 (of 956 total)

RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jeff Moden (2/6/2009)
Jonathan Kehayias (2/6/2009)
so I did it the right way, rather than the easy way
BWAA-HAA!!! Man, I'm right there with you on that one! Now, all we...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 11:30 pm

#939912
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jeff Moden (2/6/2009)
Ya beat me to it on the other thing... I didn't realize the binary was quite so wide in your code and started fixing it as you were...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 10:58 pm

#939908
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Its taken me close to a year to create a series of articles that have sufficient utility to be worthwhile, and are logically good use of SQLCLR so as to...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 10:53 pm

#939907
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

sean hawkes (2/6/2009)
To me the SQLCLR vs. xp_cmdshell seems like the old script vs. small application debate. Seems that SQLCLR is very similar to writing a small application. ...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 10:26 pm

#939904
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jeff Moden (2/6/2009)
Heh... listen to you... Anyone capable of writing either the CLR or the T-SQL isn't going to miss the sp_OADestroy. Anyone who doesn't understand enough about T-SQL...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 10:15 pm

#939902
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jeff Moden (2/6/2009)
When I run that bit of computational heaven against the test data I built above, here's the results I get...
1263 ms for...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 10:01 pm

#939899
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Phil Factor (2/5/2009)
Oooh. This is getting very useful. I'd missed out on the advantages of passing string parameters as SQLStrings and the trick of passing back a NULL. It...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 9:43 pm

#939894
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Ok, what did I miss?? I don't quite know what I missed? If it was the exception from providing a bad path... I didn't miss that, like I...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 9:33 pm

#939891
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

noeld (2/5/2009)
I am not talking about UNSAFE. Not all developers have solid programming skills to write something that "scales". Putting bad code on the server is not a good thing....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 6, 2009 at 8:40 am

#939589
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

don_goodman (2/5/2009)
Just keep repeating those and you will be cured of you love of the CLR.
It's not that I love SQLCLR. In fact I more or less hate how...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 9:03 am

#938942
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

don_goodman (2/5/2009)
I did not read past the first paragraph. Instead I scanned the code samples. I saw a lot of code. If I was a DBA that wrote lots and...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 8:55 am

#938931
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Attached is a new installer that will includes the source file so you can view the code natively in SQL Server, and handles the exception being raised if the path...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 7:58 am

#938870
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Phil Factor (2/5/2009)
use of CLR makes it harder for a SQL Server administrator to see what's going on with their SQL Server.
Yes, Agreed! However, I've recently started using NET...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 7:52 am

#938865
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

noeld (2/5/2009)
Although SQLCLR has great power I think it is very important to tell the reader that it also brings MANY undesirable things in.
- Bad Exception handling is just one...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 7:49 am

#938860
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Phil Factor (2/5/2009)
I'd be interested to see if anyone has a solution to the problem of preventing a barf when an invalid path is passed to DirectoryInfo. The obvious...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

February 5, 2009 at 7:37 am

#938850

Viewing 15 posts - 481 through 495 (of 956 total)