Bro thank you so much. I am currently going through your PowerShell 7 Tutorials for Beginners series although. I'll only be using PowerShell for SQL Server mostly dbatools module. I even watch your videos on my tablet at the gym on the running machine. Really, really helpful Merry Christmas and Happy New Year.
Good instructions. Quick question, can I still use the dataset to look at the data even after the sql connection is closed? ....or do I need to throw that into a variable first? Thx
I noticed that the SqlAdpter.fill() method executes the whole SqlCommand you pass to it, no matter if it is just a SELECT or e.g. an UPDATE instruction. Sems odd - why not use it for every CRUD action?
Hi Manuel, it does indeed work for every CRUD operate but at the same time will fetch the data from the data causing unwanted data collection and usage or resources if large data sets are involved, but this being said using .fill for the execution would be totally acceptable. Hope that helps :)
![How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]](http://i.ytimg.com/vi/WgE8pVLgWGs/mqdefault.jpg)
Your PowerShell videos are very helpful. Learning a lot. Thank you!
Bro thank you so much. I am currently going through your PowerShell 7 Tutorials for Beginners series although. I'll only be using PowerShell for SQL Server mostly dbatools module. I even watch your videos on my tablet at the gym on the running machine. Really, really helpful Merry Christmas and Happy New Year.
Good instructions. Quick question, can I still use the dataset to look at the data even after the sql connection is closed? ....or do I need to throw that into a variable first? Thx
Could you please make a series on PowerShell PostgreSQL please?
I noticed that the SqlAdpter.fill() method executes the whole SqlCommand you pass to it, no matter if it is just a SELECT or e.g. an UPDATE instruction. Sems odd - why not use it for every CRUD action?
Hi Manuel, it does indeed work for every CRUD operate but at the same time will fetch the data from the data causing unwanted data collection and usage or resources if large data sets are involved, but this being said using .fill for the execution would be totally acceptable. Hope that helps :)
What’s your opinion on invoke-sqlcmd from the sql module?
It is a very good module!