Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Growing Your SQL Server Skills without Breaking the Bank


Growing Your SQL Server Skills without Breaking the Bank

Author
Message
Mike Hillwig
Mike Hillwig
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 102
Comments posted to this topic are about the item Growing Your SQL Server Skills without Breaking the Bank
Koen Verbeeck
Koen Verbeeck
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24511 Visits: 13268
Great overview. I'll refer to this post every time someone asks for free training :-D


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Cadavre
Cadavre
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3582 Visits: 8456
In the UK, there's also SQLBits. Again, not cheap (although there is a free day), but excellent. And they do upload videos of the talks (eventually :-P)


Forever trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...

(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock


Craig Wilkinson - Software Engineer
LinkedIn
thierry.vandurme
thierry.vandurme
SSC Eights!
SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)

Group: General Forum Members
Points: 929 Visits: 528
Very true, Paul, Kimberly, Brent... plain rock.
But at times I don't even start my browser. I open up the locally installed BOL and just grab a topic or two.
KenpoDBA
KenpoDBA
SSC Eights!
SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)

Group: General Forum Members
Points: 890 Visits: 619
This is Sean from MidnightDBA and what you said wasn't exactly accurate.
Sure, we have a weekly webshow that starts at 11pm CST on fri, but we've also got hundreds of recorded training that's completely free. You can download it at any time and pass it around to all of your friends. Even the shows themselves are recorded and you can download them and watch at your leisure.

So while we'd love for anyone to come join us for the live show, if you really can't make it, then come download us. We're about to start season 5 here in the next couple weeks. You can follow @MidnightDBA and get the official date when we land on it.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:


Rodan
Rodan
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 47
I also enjoy the content here - at least several times a week some good info that I use - http://blog.sqlauthority.com/



CGSJohnson
CGSJohnson
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2034 Visits: 1686
Another good resource is Simple Talk (www.simple-talk.com).

Another event is SQL in the City.
piotrka
piotrka
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1076 Visits: 683
Will share this article with others at the office.
lshanahan
lshanahan
Mr or Mrs. 500
Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)

Group: General Forum Members
Points: 500 Visits: 436
I'll add one that's so obvious it's easy to miss:

PLAY

Speaking as one who is living proof you can learn and improve SQL Server skills on the cheap, one of my greatest assets in addition to the excellent resources in the article is having my own SQL Server sandbox. I have a Developer Edition on my desktop at work that I can try out all kinds of things, including the Things-You-Should-Never-EVER-Try-On-A-Live-System. Most PCs these days are powerful enough to run it, and you can pick up a copy of SQL Server Developer 2012 for under $50 (no, that isn't a typo) at Amazon. Granted you're not going to be able to play with the entire gamut of SQL Server (mainly thinking of enterprise-wide architectures and the skills needed for those scenarios), but there's certainly enough to keep you entertained and learning. I can learn a great deal from reading and listening, but until I throw it on the hardware and say, "What happens when I do THIS?" does it really stick in my head.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
lptech
lptech
SSC-Addicted
SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)

Group: General Forum Members
Points: 407 Visits: 3333
For some more advanced topics:

sqlcat.com

and

http://sqlblog.com/blogs/linchi_shea/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search