#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.
antalya escort bayanantalya escort bayanantalya escort bayanbursa escort bayanbursa escort bayankonya escort bayankonya escort bayaneskişehir escort bayanurfa escortçanakkale escortsamsun escortafyon escortmanisa escortmersin escort bayandenizli escort bayankıbrıs escort bayanbalıkesir escort bayanaydın escort bayanhatay escort bayansivas escort bayanvan escort bayanadana escort bayanelazığ escort bayanizmit escort bayanyalova escort bayanerzurum escort bayanısparta escort bayankocaeli escort bayanmuğla escort bayansakarya escort bayantekirdağ escort bayandiyarbakır escort bayantrabzon escort bayanuşak escort bayansinop escort bayanrize escort bayanmardin escort bayannevşehir escort bayançorum escort bayanbatman escort bayankırşehir escort bayanaksaray escort bayanamasya escort bayanniğde escort bayanağrı escort bayanbolu escort bayanadıyaman escort bayanyozgat escort bayanzonguldak escort bayankütahya escort bayantokat escort bayangiresun escort bayanmaraş escortkarabük escortbilecik escort bayankayseri escort bayandüzce escort bayanistanbul escort bayanistanbul escort bayanistanbul escort bayanbursa escort bayankonya escort bayankonya escort bayankayseri escort bayankayseri escort bayanmalatya escort bayanmalatya escort bayanmalatya escort bayanmalatya escort bayanmalatya escort bayangaziantep escort bayangaziantep escort bayangaziantep escort bayanhatay escorthatay escort bayanankara escort bayanankara escort bayankırıkkale escortbartın escortartvin escortbingöl escortbitlis escortçankırı escortedirne escortkastamonu escortgümüşhane escortkaraman escorthakkari escort bayanmuş escort bayanordu escort bayansiirt escort bayantunceli escort bayanbayburt escort bayanşırnak escort bayanardahan escort bayanığdır escort bayankilis escort bayanosmaniye escort bayandüzce escort bayanerzincan escort bayankars escort bayanburdur escort bayanistanbul escort bayanizmir escort bayanankara escort bayanbodrum escort bayangaziantep escort bayaneskişehir escort bayankonya escort bayanşanlıurfa escort bayanafyon escort bayandenizli escort bayanizmir escort bayanbursa escort bayansamsun escort bayançanakkale escort bayanhatay escort bayanizmit escort bayankayseri escort bayanantalya escort bayanvan escort bayanzonguldak escort bayanbalıkesir escort bayanmanisa escort bayanbodrum escort bayankıbrıs escort bayansivas escort bayangaziantep escort bayanadana escortadıyaman escortafyon escortağrı escortaksaray escortamasya escortantalya escortankara escortardahan escortartvin escortaydın escortbalıkesir escortbartın escortbatman escortbayburt escortbilecik escortbingöl escortbitlis escortbolu escortburdur escortbursa escortçanakkale escortçankırı escortçorum escortdenizli escortdiyarbakır escortdüzce escortedirne escortelazığ escorterzurum escorterzincan escorteskişehir escortgaziantep escortgiresun escortgümüşhane escorthakkari escorthatay escortığdır escortısparta escortistanbul escortizmir escortizmit escortmaraş escortkarabük escortkaraman escortkars escortkastamonu escortkayseri escortkıbrıs escortkilis escortkırıkkale escortkırklareli escortkırşehir escortkocaeli escortkonya escortkütahya escortmalatya escortmanisa escortmardin escortmersin escortmuğla escortmuş escortnevşehir escortniğde escortordu escortosmaniye escortrize escortsakarya escortsamsun escortşanlıurfa escortsinop escortsivas escorttekirdağ escorttokat escorttrabzon escortuşak escortvan escortyalova escortyozgat escortzonguldak escortescortısparta merkez escort yalvaç escort bulancak escort çorum merkez escort biga escort kadirli escort elazığ merkez escort zonguldak merkez escort zonguldak ereğli escort kozluk escort afyon merkez escort sandıklı escort yakutiye escort palandöken escort altınordu escort ünye escort ortahisar escort bergama escort ödemiş escort mudanya escort serik escort erdemli escort kırıkhan escort samandağ escort alaşehir escort soma escort salihli escort canik escort çarsamba escort kapaklı escort akyazı escort erenler escort çiğli escort yenimahalle escort gebze escort girne escort derince escort gaziemir escort fethiye escort buca escort lefkoşa escort atakum escort gölcük escort pursaklar escort izmit escort bandırma escort akçaabat escort kızıltepe escort artuklu escort odunpazarı escort tepebaşı escort milas escort pamukkale escort merkezefendi escort adapazarı escort serdivan escort süleymanpaşa escort çerkezkoy escort efeler escort nazilli escort söke escort kuşadası escort ipekyolu escort erciş escort onikişubat escort dulkadiroğlu escort karesi escort altıeylül escort balikesir edremit escort ilkadım escort bafra escort yunusemre escort akhisar escort turgutlu escort şehzadeler escort antakya escort iskenderun escort defne escort dörtyol escort kayapınar escort bağlar escort yenişehir escort tarsus escort toroslar escort yenişehir escort akdeniz escort silifke escort mezitli escort darıca escort körfez escort gölcük escort şahinbey escort şehitkamil escort haliliye escort siverek escort bosna escort selçuklu escort meram escort ereğli escort seyhan escort yureğir escort çukurova escort sarıçam escort ceyhan escort kozan escort kemer escort alanya escort lara escort side escort manavgat escort fethiye escort konyaaltı escort osmangazi escort görükle escort nilüfer escort yıldırım escort inegöl escort gemlik escort karabağlar escort bayraklı escort torbalı escort menemen escort çankaya escort mamak escort altındağ escort gölbaşı escort kızılay escort bor escort keşan escort bodrum escort keçiören escort etimesgut escort buca escort esenler escort escort fethiye escort dalaman escort marmaris escort çorlu escort kuşadası escort didim escort bafra escort melikgazi escort kocasinan escort talas escort gebze escort eyyubiye escort karatay escort kepez escort finike escort kaş escort elmalı escort muratpaşa escort demre escort korkuteli escort kumluca escort buca escort bornova escort karşıyaka escort çiğli escort keçioren escort ankara yenimahalle escort etimesgut escort sincan escort bozuyuk escort safranbolu escort yüksekova escort çayeli escort lüleburgaz escort sorgun escort sungurlu escort patnos escort tavşanlı escort kovancılar escort erbaa escort kahta escort sivas merkez escort şarkışla escort fatsa escort yeşilyurt escort battalgazi escort polatlı escort aliağa escort menderes escort nizip escort başiskele escort kartepe escort çayırova escort reyhanlı escort menteşe escort esenyurt escort çankaya escort şahinbey escort osmangazi escort şehitkamil escort küçükçekmece escort seyhan escort bağcılar escort pendik escort ümraniye escort selçuklu escort mamak escort yıldırım escort bahçelievler escort sultangazi escort maltepe escort üsküdar escort muratpaşa escort başakşehir escort gaziosmanpaşa escort kadıköy escort kartal escort karabağlar escort sancaktepe escort avcılar escort kağıthane escort onikişubat escort esenler escort ataşehir escort odunpazarı escort eyüpsultan escort kayapınar escort altındağ escort yüreğir escort bağlar escort gebze escort beylikdüzü escort antakya escort haliliye escort çukurova escort fatih escort tepebaşı escort sarıyer escort sultanbeyli escort pamukkale escort tarsus escort meram escort ilkadım escort ipekyolu escort konak escort ortahisar escort merkezefendi escort toroslar escort adıyaman merkez escort arnavutköy escort battalgazi escort efeler escort bayraklı escort zeytinburnu escort çekmeköy escort inegöl escort çorlu escort tuzla escort şişli escort güngören escort adapazarı escort bayrampaşa escort büyükçekmece escort siverek escort kızıltepe escort yunusemre escort akdeniz escort karaköprü escort iskenderun escort beykoz escort manavgat escort atakum escort beyoğlu escort altınordu escort bakırköy escort dulkadiroğlu escort darıca escort mezitli escort süleymanpaşa escort ayvalık escort foça escort bozcaada escort kuşadası escort datça escort gökçeada escort alanya escort kemer escort nilüfer escort silifke escort anamur escort side escort bosna escort belek escort görükle escort taksim escort
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.
https://sqlserverblogforum.com/2011/03/difference-between-truncating-and-shrinking-the-transaction-log-file/
https://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.