Hi, so I’m still fairly new in my career. So far I know the basics of using SQL Server’s SSMS, IS, and RS. Other than going more in depth with these few things, what else should I know if I want to be an expert Database dev/ BI pro?
…where to start
This is a very expansive subject the more you learn the more you will understand you will never know everything regarding database design, BI, and SQL Server. You will likely end up becoming stronger in certain areas through necessity.
The SQL Server community is large, and helpful so you never need to worry about not finding an answer. You can also always find something connected to SQL Server or data/databases in general that has nothing to do with any existing projects to learn about.
For now if you are a dev start learning about good coding practices and how to optimise T-SQL and database design. You can nearly always find a different way to do something e.g. Temp Tables vs. Table Variables.
Also, don’t ignore the basics - learn how to use BCP, SQLCMD and some PowerShell, you won’t always be able to use SSMS/SSIS or the data import wizard etc.
I wish these books/web-guides had been available when I first started working with SQL Server many years ago;