Viewing 15 posts - 751 through 765 (of 956 total)
I actually didn't mean that post to seem like I was addressing you, but re-reading it, it sure does look like I was. Sorry about that. The use...
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]
December 3, 2008 at 7:23 pm
If all they are doing is queries, then dbdatareader role in the database they need to see the data in should suffice if you want to make it easy. ...
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]
December 3, 2008 at 7:16 pm
MANU (12/3/2008)
It looks itsAnnual Subscription, Support & Maintenance (Per Unit)-1200$
as per http://www.mysql.com/tcosavings
MJ
Don't put complete faith in those numbers, as they don't line up with what we pay per license...
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]
December 3, 2008 at 7:13 pm
It might be possible if you once took a full backup, and the recovery model is FULL using one of the Log Reader programs like ApexSQL Log, but these cost...
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]
December 3, 2008 at 7:06 pm
sqlcool (12/3/2008)
Also, it is a named instance, so SQLDR02\SQL2005 by name or 9.500.12.02\SQL2005 by IP address....
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]
December 3, 2008 at 7:03 pm
Matt Miller (12/3/2008)
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]
December 3, 2008 at 10:55 am
I definately agree with rbarryyoung on this. Service Broker conversations are async and will allow you to queue the work and continue processing.
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]
November 30, 2008 at 11:05 pm
Regular Expression matches and replacements, as we've discussed previously, but I have also found good utility in CLR Aggregations under specific scenarios, but the 8KB limitation in SQL 2005, kind...
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]
November 30, 2008 at 8:09 pm
Agree with Gail on that. The moderated forums and boards are great places to work for all but the most rare of exceptions that don't exist for very long...
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]
November 30, 2008 at 1:47 pm
GilaMonster (11/30/2008)
Jonathan Kehayias (11/30/2008)
The approved assembly list is in the Books Online at:Thanks. I'm more asking out of curiosity. I don't tend to write CLR.
I have yet to write a...
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]
November 30, 2008 at 1:44 pm
Jeff Moden (11/30/2008)
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]
November 30, 2008 at 9:19 am
GilaMonster (11/30/2008)
I assume the list of approved assemblies exists somewhere? Books Online? MSDN?
Gail,
The approved assembly list is in the Books Online at:
http://msdn.microsoft.com/en-us/library/ms403279.aspx
There are also some coding model restrictions that you...
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]
November 30, 2008 at 9:10 am
Also loving the long weekend. My wife has had me moving furniture around the house consolidating the family room and living room into a single living room, and moving...
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]
November 29, 2008 at 8:20 pm
I am not beyond asking for help either. I have answered thousands of posts on various forums, but there are times where I need help, and it is rarely...
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]
November 29, 2008 at 8:18 pm
Jeff Moden (11/29/2008)
Jonathan Kehayias (11/29/2008)
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]
November 29, 2008 at 8:12 pm
Viewing 15 posts - 751 through 765 (of 956 total)