Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 014
Credit for this one goes to my friend and teammate Matt Hester...
Q: What if I do no want to give SQL 2005 Management Studio to my Developers how to I give them access to the databases?
A: Matt was talking with some of his event attendees, and they recommend that you use SQL 2000 query analyzer for that type of access. During their testing this worked fine with the 2000 QA specifically if you used SQL 2005 Express.
My thought on this is that you should go ahead and USE THE MANAGEMENT STUDIO. The issue isn’t one of what tool is installed, but of security. If you’ve set things up right, you won’t be giving your developers anything they shouldn’t have… and you WILL be giving them a tool they can use powerfully.
Got an IT question? Give me a comment, or contact me.