Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

The Best SQL Server Tutorials Expand / Collapse
Posted Monday, August 20, 2012 9:55 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 19, 2016 5:50 PM
Points: 73, Visits: 513
I want to curate some of the best SQL Server online tutorials as part of my skill inventory. I'm particularly looking for good tutorials on SSIS, SSAS and SSRS, and I may add other topics to this list. I prefer written tutorials, but I will consider videos and presentations. If it worked for you, I'm interested in hearing about it. Thanks in advance.

(For the record, I am well experienced in SQL Server but am currently unemployed and shoring up my skills as I look for my next gig.)

Jay Bienvenu | |
Post #1347551
Posted Tuesday, August 21, 2012 2:06 AM



Group: General Forum Members
Last Login: Thursday, September 1, 2016 2:56 AM
Points: 5,969, Visits: 6,067
Take a look at the stairways, each one focuses on a topic like SSIS, SSRS, SSAS etc.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1347623
Posted Tuesday, August 21, 2012 3:30 PM



Group: General Forum Members
Last Login: Yesterday @ 2:49 PM
Points: 2,153, Visits: 7,254
The stairways are great. I also use Microsoft E-Learning; there is ton's of free stuff there.

-- Alan Burstein

Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL 2012+)
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K and PatReplace8K.

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001
Post #1348119
Posted Wednesday, August 22, 2012 3:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 4, 2016 12:49 AM
Points: 246, Visits: 669
Hello there,

The best practice to learn MSSQL is to practice on test machine while reading. Only reading will enhance your theory knowledge but as DBA you must be practical. As you said you are experienced, you must be cleared with the Basic MS SQL funda. According to my experience of learning of MS SQL I will prefer to read Stairways. the most important part as DBA is to manage logs and backup, so I will prefer you to read Transaction log management in Stairways.

However, just for interveiw purpose I will prefer to go with Pinal Dave's SQL interview Q and A.

Post #1348279
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse