February 4, 2008 at 8:37 pm
Hi,
I'm looking for a text I can use in my work. I develop database apps, and recently started doing that with SQL Server (2005).
(Most of) my client base is small/medium business with no need or $$ for a dedicated DBA, so it does - or will fall to me.
I'm seeking opinions for a goodish book on the subject, something along the lines of a useful HowTo or "cookbook" on the subject. All your input is appreciated.
Thanks for reading this
Chris Kelly
February 4, 2008 at 9:25 pm
Kalen Delaney “Inside SQL Server 2005” is a good choice. And check her recommendation for books here:
http://www.insidesqlserver.com/recommended/recommended.htm
"SQL Server 2005 Books Online" is an essential e-book. "How do I" section is pretty straight forward, plus tutorials.
February 4, 2008 at 11:27 pm
Itzik's 2 books in the Inside SQL Server 2005 series are excellent. T-SQL Querying and T-SQL programming
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 6, 2008 at 3:26 am
If your work includes installing SQL Server, take a look at http://www.codeplex.com/SQLServerFineBuild. It is something I published that helps you get a 1-click install and configuration of SQL Server 2005.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 6, 2008 at 10:53 am
If you don't have internet access, then get a book. In fact get numerous books and e-books.
If you have internet access, then your main source should be http://www.google.com (or another seach engine). When you run into a problem or need more info, search on it, then read a little more than you need. Before long you will have a good grasp on various topics.
I personally don't like to learn everything from one source. Your knowledge tends to become biased and you don't learn the 'tricks of the trade'. You also never really think 'outside the box'. Also, doing the web search you will usually hit many forums and find out how other users dealth with the same problem, approaching it from different angles.
One example that comes to mind is that a coworker started learning SQL Server 2000 from this one guy on another forum. The guy on the forum bragged that he did everything from query analyzer and never used Enterprise Manager. The coworker then started only learning and doing that way. I heard about this and was like 'why would you do that, it makes no sense'. I understand that some things are easier to run through query analyzer, but some just aren't. I would much rather manage indexes through Enterprise Manager than through a sql command line. Just an example of one-track learning.
I would definitely say that this is the #1 site that I read and goto, but I do hit many other sites for problem solving.
I guess what I'm saying is that I would definitely not go the route of the 'cookbook' you are talking about, but develop your own version from research that you personally do. Thirst for knowledge goes a long long way.
February 7, 2008 at 4:13 pm
You might want to look at O'Reilly's "SQL Cookbook" or Deac Lancaster's "Transact-SQL Desk Reference" or Henderson's "The Guru's Guide to Transact-SQL". Finally, you might also want to look at "Inside SQL Server 2005: T-SQL Programming" from Microsoft.
Those are some of my more used references. 🙂
February 7, 2008 at 5:05 pm
If you need a DBA's book go for Microsoft Admin companion or Pocket consultant they are really really good books to start with.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 8, 2008 at 3:48 am
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply