I'm a production DBA and have been for a good while.
I can query, join filters but how do I get my T-sql skills to a developer\Report writer level.
Books don't do it for me, links to useful youtube sights will be most usefull.
Are an MVP to follow. I have been putting this off for years now.
Step 1 is to download a free copy of SQL Server Developer's Edition. It works on your desktop or laptop without having to install Windows Server and is the same as the Enterprise Edition but with special limited licensing.
Step 2 is to teach yourself how to correctly make a shedload of test data at the drop of a hat... any hat. The following articles can help there.
Step 3 is to learn about how to count without using loops. The articles in Step 2 above can help there.
Step 4 is as has already been suggested... start reading posts on this forum and then start working some of the problems. Read how some of the heavy hitters solve the problems. Unlike that what you might find in books, most of the problems are real life problems with real life solutions.
The more you repeat step 4, the more you'll learn because it's a huge subject with a never ending and changing supply of fascinating problems even if the questions are simple.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)