August 22, 2011 at 12:03 pm
Christi Wilson (8/22/2011)
Okay, I have been getting my ducks in a row to get this started. Only thing I need is a domain name and I cannot think of one. 😛I also have a question about citing another persons work. For instance, I have read a lot of the eBooks here on SSC, some of the books refer to an important detail of what I want to cover and do not know the rules of citing information. Should I link to the ebook and cite page and paragraph? Sometime I want to cover some point of information, but someone else says it so much better! I do plan on using just a few lines to back up what I am doing not the whole book (but I will encourage them do down load and read the ebook). Can anyone help with citing?
In my blog I plan to discuss how imperative it is to use BOL, tech books,eBooks, SSC (I will encourage people to register here for the daily emails- I cannot tell you how many times that helped me! They are a wealth of information just begging to be read) msdn and finally let them know that google is their friend. Then when all else fails post your question here.
When blogging, if you're quoting something, make sure it's clearly marked as a quote (quote marks or indented, both, whatever, make it clear) and that you provide a link to the source. After that, make sure you're only "quoting" not copying a page or more of text. A paragraph or two, clearly marked, is great. Anything else and people tend to get weird about it. Other than that, it's all good. If you're providing links back to others, everyone is happy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 22, 2011 at 12:58 pm
Grant, to show you an example of what I was thinking and combined from your explanation, do I have this correct? I would do something like this when discussion execution plans.
my brilliant statements here blah blah blah and then I summarize using a cite to your book
"This reuse avoids the overhead of creating actual execution
plans for large and complex queries or even simple plans for small
queries called thousands of times in a minute." *
* excerpt by Grant Fritchey SQL Server
Execution Plans pg 21
is that the proper way?
by the by I have just started reading the book, one of my weaknesses is the reading and understanding execution plans. I never had the time to learn in previous job as I wore many hats.. Now my only job is to learn how to use all tools correctly. YAY
August 22, 2011 at 3:33 pm
Christi Wilson (8/22/2011)
Grant, to show you an example of what I was thinking and combined from your explanation, do I have this correct? I would do something like this when discussion execution plans.my brilliant statements here blah blah blah and then I summarize using a cite to your book
"This reuse avoids the overhead of creating actual execution
plans for large and complex queries or even simple plans for small
queries called thousands of times in a minute." *
* excerpt by Grant Fritchey SQL Server
Execution Plans pg 21
is that the proper way?
by the by I have just started reading the book, one of my weaknesses is the reading and understanding execution plans. I never had the time to learn in previous job as I wore many hats.. Now my only job is to learn how to use all tools correctly. YAY
Yeah, that's perfectly acceptable as far as I'm concerned.
BTW, new version has gone through two drafts and is off at the editors. I haven't heard back but I think we were going to attempt to get a version out for the PASS Summit, but I'm not holding my breath.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 22, 2011 at 4:01 pm
Grant, I tried in vain to learn the execution plan in query analyzer. That and Indexing!! I think if I can learn a great deal about those, my life as a dba programmer would be much easier.
I read the first page in your blog, I feel lazy! It's wonderful that you are able to go to all of those events. Please please please share your information when you get back! My friends think I am weird because I love technical books 😛
August 22, 2011 at 4:05 pm
Thanks. I just try to help out.
Hey, I like technical books too. Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2011 at 6:02 am
You could try WordPress (PHP based). A lot of sql Server bloggers use it. It's also what I intend to use as I will be starting my own Sql Server blog soon. It's rather easy to set up and there is a version that can utilize Sql Server, although its mainly suppoerted by MySql. You could also try DotNetNuke (ASP.NET based) although it has a much higher learning curve.
I'm mainly going to be blogging about issues I come across in my job, as well as things I'm learning.
I think your plan to blog is a good one and will help you internalize the topics your learning about.
August 23, 2011 at 6:14 am
Grant, I do the same thing. I've always got a tech book with me. I was reading that same book, Sql Server 2008 Internals, in between meetings, at the dentists, on lunch, etc. When I have time and a copy of Sql Server at my fingertips, I experiment based on what I'm reading, I find those 5 minutes of reading here and there can really add up to a lot of learning.
August 23, 2011 at 6:58 pm
Brandon, I have a hosting plan that allows me 20 SS2k8sr2 databases, unlimited mySQL 5.x unlimited MSAccess databases with 20 domain names and and unlimited sub-domain names. Pretty good plan for 20 bucks a month.
Currently I have WordPress on one domain and DotNetNuke on another. (the domain names are just blogs to sell some skin care products)
When my fiance comes home I am going to purchase yet another domain name that references SS2k8.(Darn Fiance has my credit card!) I am not just trying to come up to speed on SS but also the .NET stuff. I would like to play around with and learn Expressions Blend and SilverLight.
But my absolute focus right now is SS, all the other programs are good to put on my resume as soon as I am able to go back to work full time. I figure 6 months so that gives me time to get up to speed to remember and learn as much as I can to market myself. (crossing my fingers and knocking on wood that I don't have yet another medical relapse!)
I really really wish I had saved a backup from my last employers database as that was completely not normalized. I am being generous when I say it was about 2NF. Working and blogging about Adventure Works is great in the how to's, but when you get out in the real world you encounter databases that are so messed up you don't know where to start. That is when you really learn those skills. And I cannot wait for that opportunity! (does that make me weird?) :hehe:
I love reading technical books. While waiting at drs offices people would look at me as if I am insane as I was thoroughly enjoy myself. Plus it makes me look smart ha ha.
August 24, 2011 at 9:40 am
For a general intro to SS2k8 I would suggest the training kit "MCTS 70-432: SQL Server 2008 Implementation and maintenance". That will give you a nice overview of Sql Server administration. After that Grant Fritchey has written some great books on Performance tuning such as "SQL Server 2008 Query Performance Tuning Distilled". He also wrote chapters for "Beginning SQL Server 2008 Administration". Both book are from Apress. Grant Also mentioned Kalen Delaney's book "SQL Server 2008 internals", from Microsoft press, an excellent book on how SS2k8 works under the hood.
I tend to sit somewhere between Developer and DBA. I'm spending my days currently overhauling an application and the SQL Server infrastructure that sits underneath it. So I'm both building the application and trying to tune performance of SQL Server. It controls the stock room operations of each of our plants across north america.
My company is large enough that it should have dedicated DBA's, but the closest we have are network admins. I'm looking at this as an opportunity to step into a full time DBA role. The old system has some severe performance issues that used to bring plants down. I've been able to reduce this a great deal through simple query tuning.
You might consider volunteering for a nonprofit. Volunteering is a great way to learn and get some experience at the same time.
I pretty much continually learn. I buy a LOT of books each year. I read and reread all of them while taking some time to try and experiment. If you haven't already consider downloading Denali CTP3. It's well worth checking out.
August 24, 2011 at 9:54 am
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
If they thought you were weird by reading Kalen Delaney's book then they are not too smart.:-)
That was a smart move on your part.:cool:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 24, 2011 at 10:57 am
Welsh Corgi (8/24/2011)
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.If they thought you were weird by reading Kalen Delaney's book then they are not too smart.:-)
That was a smart move on your part.:cool:
I did say "old job."
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 11:18 am
I did not mean to offend you.
I did not mean it that way.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 24, 2011 at 11:42 am
Welsh Corgi (8/24/2011)
I did not mean to offend you.I did not mean it that way.
No offence at all. I was joking. Sorry that came off harsh. It sure wasn't meant that way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 3:39 pm
[font="Verdana"]Well I purchased my domain name(s) yesterday and now I am currently trying to figure out what type of CMS I want installed.
Funny story. I purchased LearnSQLServer2008WithChriti.com pointed to the correct named servers. Then I went to the control panel to add the domain to the hosting service. I put in the wrong domain name. I put in LearnSQLServerWithChristi.com and had them install .NET Sorce Forge then I looked at the domain name and something was off, then I noticed I didn't have the correct domain name. I had to laugh as the first word in my domain name is LEARN! 😛 so I ended up spending the extra 20 dollars for the domain name.
Anyway. I started my freeMind to started planning my first entry. If anyone doesn't know about this handy dandy free utility here it is. I love it and use it for everything. Even my fiance's honey do list. It's like have a huge white board.
I will post when I have the first blog entry :unsure: I am nervous but very good at handling constructive criticism.[/font]
August 24, 2011 at 4:59 pm
Welcome to the site Christi! Please post back to this thread once your blog is up and running. Lots of people add their blogs to their signatures around here too 🙂
Going back to the beginning intent of the thread, check out the APPLY operator too:
http://technet.microsoft.com/en-us/library/ms175156.aspx
APPLY was added in SQL 2005 along with some of the other great features already mentioned and I think it has had a major impact on how data can be retrieved from SQL Server.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 15 posts - 16 through 30 (of 81 total)
You must be logged in to reply to this topic. Login to reply