#SQLHELP
This post will help folks, where to get SQL help quickly from knowledgeable people. In other words, Where to get right books and website links, blogs and forums to improve their knowledge and to become an excellent DBA.
Recently I got an email from a developer and other folks too. And its encouraging me to write this post.
“Is it possible to get into DBA with development experience”
“Help on SQL is needed ASAP”
1. Web sites
Twitter (http://twitter.com/)
Twitter #SQLHELP is a great place to get an answer as soon as possible. Most of the SQL gurus are there, to help you. I know some of guys don’t know how to use twitter (Initially me too) here is the twitter book of Brent Ozar. http://www.brentozar.com/twitter/book/
SQLServerCentral (http://www.sqlservercentral.com/)
It’s a great website as well as a forum, where I have been learning and answering.
MSDN (http://social.msdn.microsoft.com/Forums/en/category/sqlserver/)
MSDN is Microsoft forum you can find great folks there.
For more SQL blogs visit my home page it has “Top SQL server blogs” widget links from the worldwide DBAs.
2. Books
Here is list of best SQL server books and links. You can read and improve your knowledge yourself.
Microsoft SQL Server 2008 Internals
http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243
Professional SQL Server 2008 Internals and Troubleshooting
http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284
SQL Server MVP Deep Dives volume 1 & 2
http://www.amazon.com/SQL-Server-MVP-Deep-Dives/dp/1935182048
DBA Survivor: Become a Rock Star DBA
http://www.amazon.com/DBA-Survivor-Thomas-LaRock/dp/1430227877
SQL Server 2008 Query Performance Tuning Distilled
http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025
SQL Server Execution Plans by Grant Fritchey (Free)
http://www.sqlservercentral.com/articles/books/65831/
Troubleshooting SQL Server A Guide for the Accidental DBA (Free)
3. User Group
Chennai guys, you can attend Microsoft Chennai SQL Server User group (CSSUG) sessions. It’s absolutely free http://sql-articles.com/category/cssug/ have conducted by my friends Vidhya Sagar and Deepak. I have attended three more sessions. See me here http://sql-articles.com/blogs/presenter-chennai-sql-server-user-group-september-meeting/
This post will update occasionally whenever I get new books and websites.
11 Comments
Beardslee Hillike
That is really fascinating, You’re a very skilled blogger. I have joined your feed and stay up for in quest of more of your magnificent post. Additionally, I have shared your site in my social networks
Wilford
Good day! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this write-up to him. Fairly certain he will have a good read. Many thanks for sharing it on http://www.sqlserverblogforum.com !
Jack
Aw, this was a really nice post. In idea I would like to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and by no means seem to get something done.
Ali
The truth just shneis through your post
Joel Edgeger
Good article
ashish
please Solve my query
one of my silverlight application is running.
this application has one central database(sql server 2008).
and three others database at client side.
our requirement is whithout changeing in silverlight application
when we make change in central database(insert update and delete in multiple tables) these change
automatically happened in all client database.
and when any change made in any client database all client as wll as central database should be updated automatically.
For this i read some about Sync Framwork and SQL Server 2008 Change Tracking.
but i have no idea about how i will do this.
Please help me. how can we acchive this.
Muthukkumaran kaliyamoorthy
This case you can go for replication. I suggest you to ask this in forum you can get an idea and more opinion.
SQLServerCentral (http://www.sqlservercentral.com/)
MSDN (http://social.msdn.microsoft.com/Forums/en/category/sqlserver/)
MARTIN
hi
(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server
I restored a backup which i was not created to a new database and if i connect above said issue is coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below in the script.
CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
kindly let me know whats the problem ..
Muthukkumaran kaliyamoorthy
The “error: 40” will come lots of cases, you need to check and go step by step. But check is the server is UP and TCP/IP is enabled.
http://blogs.msdn.com/b/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx
aryan
Please Solve My query
My server databse recovery option is set to simple
I am running another software on pc based on sql databse
I want to know that when I take backup of data , is transaction logs deleted or zippied ?
In this case Can I recover deleted or modified rows of sql table in database
Muthukkumaran kaliyamoorthy
I suggest you to read a transaction log management.
The t-log file play a major role in every DB, all the writes are written here and later it moved to data file. It’s very important for recover purpose.
Now coming to your question:
1. T-log file will not “deleted or zippied” any of the recovery model. In simple internally it overwrites the committed transaction/inactive VLF , meaning it will reuse the inactive VLF so on … like a circular.
http://www.sqlserverblogforum.com/2011/03/difference-between-truncating-and-shrinking-the-transaction-log-file/
http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/
“In this case Can I recover deleted or modified rows of sql table in database”
2. It depends on your backup strategy. If you have a table in the full or differential backup, yes you can restore. Since, you cannot take a log in simple mode. This why for high RPO DB, we place the DB in full and run frequent log backups and PITR too.