Viewing 15 posts - 181 through 195 (of 956 total)
Multiple users can use Developer Edition, you just have to have a Developer Edition License for each person. They are generally really cheap, like $50 IIRC. Your best...
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]
January 5, 2010 at 10:18 am
David Portas (12/28/2009)
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 28, 2009 at 6:48 pm
Your connection string should look something like this:
connectionString="server=SERVERNAME;database=DATABASE;Integrated Security = true";
FILESTREAM requires that you use Integrated Security to work properly. Whatever Windows User your application is running under...
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 24, 2009 at 10:20 am
philcart (12/23/2009)
Great article Jonathan, looking forward to more. Especially interested in extended events.
Event Notifications and Extended Events are completely different animals in SQL Server. Extended Events are new in...
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 23, 2009 at 8:54 pm
Post the TSQL that you used to do this. Its probably just a single missing step in the setup you did. It should follow the instructions on the...
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 23, 2009 at 2:33 pm
Stan_Segers (12/22/2009)
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 22, 2009 at 3:00 pm
greggoble2 (12/22/2009)
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 22, 2009 at 2:55 pm
Jr or Sr, if you are responsible for SQL, this should be a concern that you raise, and be loud about it. Document the concern in an email 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]
December 21, 2009 at 8:15 am
I don't know, looking at client statistics, which removes the SSMS overhead populating/display gridview data in .NET, the SQL 2008 appears to me to be faster. I think...
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 20, 2009 at 10:26 pm
I paid $599 for my Dell Insprion 1440 which has a 14.1" screen T4200 processor (x64), 4GB RAM but supports 8GB, and then I paid $300 for a 120GB OCZ...
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 18, 2009 at 11:02 pm
I haven't used it nor do I plan to anywhere in the near future, but just reading the descriptions, its typical of most SAN's, touting self tuning configuration and really...
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 18, 2009 at 7:51 pm
Hmmm... A number of factors here aren't equal, so its hard to say that it should perform the same. Which server has the faster CPU clock speed, front side...
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 18, 2009 at 7:33 pm
I am pretty sure that what you are attempting falls under dynamic assembly loading which is disallowed in SQLCLR for security:
http://blogs.msdn.com/sqlclr/archive/2006/10/18/dynamic-assembly-loading.aspx
Just because you can doesn't mean you should. This...
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 18, 2009 at 7:04 pm
simon.murin (12/17/2009)
CREATE PROCEDURE [dbo].[TestSendMail].....
WITH EXECUTE AS <account with rights to send e-mails>
Wouldn't it be easier that way?
Have you tried it without TRUSTWORTHY ON? It won't work for a number...
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 17, 2009 at 4:21 pm
It's not a stupid question and it is easy to miss even if you are reading through it. I just wasn't sure how to answer the question being asked...
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 17, 2009 at 1:37 pm
Viewing 15 posts - 181 through 195 (of 956 total)