September 27, 2016 at 2:40 am
Hi All,
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.
Thanks
September 27, 2016 at 5:20 am
Find out how to bring the latest state of the art hardware to its knees, what type of code is needed to make a mockery of the most awesome servers.
Basically, if you can come up with a set of worst TSQL or DB practices, then you are much better than most of us already.
Just doing the investigation will be a wealthy experience cos you will know what to avoid and in the process, you may accidentally learn the good stuff.
September 27, 2016 at 5:45 am
Try to solve the various T-SQL problems that other people post here ... and compare your solutions with those written by others. You'll learn a lot if you take the time to understand how and why they did it the way they did.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 27, 2016 at 6:05 am
Phil Parkin (9/27/2016)
Try to solve the various T-SQL problems that other people post here ... and compare your solutions with those written by others. You'll learn a lot if you take the time to understand how and why they did it the way they did.
Very much this. The best way to get better at writing T-SQL is to write a lot of T-SQL. You may not have much opportunity at work, so you have to find other places. Any time I'm learning new tech or expanding my skill set, I try really hard to find the questions related to that on the forums and attempt to provide answers. It's a great way to get better & learn.
Another thing to help you learn more is to teach. Set up a class at work where you're going to do a 15-20 minute lunch & learn. You can have a single topic or just two topics each day where you're going to share a little of what you're working on with your co-workers. They can also bring stuff to the table.
"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
September 27, 2016 at 7:19 am
To reiterate what Phil & Grant said... Answering questions here on this forum...
I can't speak for anyone else but I've learned an incredible amount here on this forum... Answering other peoples questions in a forum setting, allows you to focus on a single puzzle like problem (that doesn't happen to be your problem). More importantly, your answers will be joined by and compared to other peoples answers... Yes it can be a little disheartening when your solution gets blown out of the water by another solution but that's opportunity not only to learn, but learn what works the best. Some of the best T-SQL writers I ever encountered are regular posters on this forum and putting my solutions up against theirs has forced me to step up my game.
Just my 2 cents...
September 27, 2016 at 11:23 am
Talib123 (9/27/2016)
I'm a production DBA
... how do I get my T-sql skills to a developer\Report writer level.
So you want to go from DBA-level SQL to developer-level SQL:
Destroy half your brain :-D:-P. That's a JOKE people!
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
September 27, 2016 at 12:07 pm
ScottPletcher (9/27/2016)
Talib123 (9/27/2016)
I'm a production DBA
... how do I get my T-sql skills to a developer\Report writer level.
So you want to go from DBA-level SQL to developer-level SQL:
Destroy half your brain :-D:-P. That's a JOKE people!
"crickets"
Hmm, may want to try again.
September 27, 2016 at 2:01 pm
Lynn Pettis (9/27/2016)
ScottPletcher (9/27/2016)
Talib123 (9/27/2016)
I'm a production DBA
... how do I get my T-sql skills to a developer\Report writer level.
So you want to go from DBA-level SQL to developer-level SQL:
Destroy half your brain :-D:-P. That's a JOKE people!
"crickets"
Hmm, may want to try again.
I should have put a q mark: So you want to go from DBA-level SQL to developer-level SQL?
But, at any rate, I'm a DBA; I write SQL. To drop my SQL skill level down to a developer's level, I would have to destroy half my brain.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
September 27, 2016 at 2:49 pm
ScottPletcher (9/27/2016)
Lynn Pettis (9/27/2016)
ScottPletcher (9/27/2016)
Talib123 (9/27/2016)
I'm a production DBA
... how do I get my T-sql skills to a developer\Report writer level.
So you want to go from DBA-level SQL to developer-level SQL:
Destroy half your brain :-D:-P. That's a JOKE people!
"crickets"
Hmm, may want to try again.
I should have put a q mark: So you want to go from DBA-level SQL to developer-level SQL?
But, at any rate, I'm a DBA; I write SQL. To drop my SQL skill level down to a developer's level, I would have to destroy half my brain.
I do both. And anyone who develops SQL should work harder to improve their skills, whether a developer or administrator.
September 27, 2016 at 2:53 pm
Talib123 (9/27/2016)
Hi All,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.
Thanks
The vast majority of good T-SQL learning material will be in the from reading (books, blogs, and forums) and also practicing. However, since you're specifically asking for good video related material, I'd say search YouTube for:
T-SQL AND ("Kevin Kline" OR "Itzik Ben-Gan" OR "Grant Fritchey" OR "Adam Mechanic" OR "Brent Ozar")
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 3:30 pm
You mean destroy the RBAR side, the side that's good at writing cursors and such?
September 27, 2016 at 4:57 pm
Lynn Pettis (9/27/2016)
ScottPletcher (9/27/2016)
Lynn Pettis (9/27/2016)
ScottPletcher (9/27/2016)
Talib123 (9/27/2016)
I'm a production DBA
... how do I get my T-sql skills to a developer\Report writer level.
So you want to go from DBA-level SQL to developer-level SQL:
Destroy half your brain :-D:-P. That's a JOKE people!
"crickets"
Hmm, may want to try again.
I should have put a q mark: So you want to go from DBA-level SQL to developer-level SQL?
But, at any rate, I'm a DBA; I write SQL. To drop my SQL skill level down to a developer's level, I would have to destroy half my brain.
I do both. And anyone who develops SQL should work harder to improve their skills, whether a developer or administrator.
Harder than what? Harder than they are already doing? What if they are already working hard to improve their skills? I think your comment needs a WHERE clause 🙂
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 27, 2016 at 6:28 pm
A lot of good advice here, especially
The best way to get better at writing T-SQL is to write a lot of T-SQL.
Over the years I have created dozens of little "one-off" personal databases. A homework db, a goals db, a DB to organize my comic book collection, etc. More recently I have been doing more SQL puzzles such as this. Answering forum questions has been very helpful too even when your answer is wrong or much less efficient.
-- Itzik Ben-Gan 2001
September 27, 2016 at 8:54 pm
Eric M Russell (9/27/2016)
Talib123 (9/27/2016)
Hi All,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.
Thanks
The vast majority of good T-SQL learning material will be in the from reading (books, blogs, and forums) and also practicing. However, since you're specifically asking for good video related material, I'd say search YouTube for:
T-SQL AND ("Kevin Kline" OR "Itzik Ben-Gan" OR "Grant Fritchey" OR "Adam Mechanic" OR "Brent Ozar")
ooh, not me. I don't write T-SQL like those other people. I teach mechanisms & processes and some internals. That hard core coding stuff, I leave that to the smart people.
"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
September 28, 2016 at 7:51 am
I can query, join filters but how do I get my T-sql skills to a developer\Report writer level.
Solve the actual problems in your company. In a few years, if you're still learning, you'll learn how you could have written them better. But as long as it works and produces the correct data in an acceptable time frame, you'll be learning. Reading is a good place to start, but doing is the essence of learning for most adults.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply