Solved Starting to use dbatools utility

mmcconaghy October 12, 2018 at 15:04:45

Have you looked here: https://dbatools.io/start/ Near the bottom of the page. MIKE http://www.skeptic.com/ message edited by mmcconaghy

Hi. Yes. I checked that link. It’s not what I am looking. I am interested in 'basic ' sanity type of tutorial or demo or instructions for the beginners Thanks anyway

Razor2.3 October 12, 2018 at 16:32:05

So you're asking for a tutorial on the Get-Module command? How To Ask Questions The Smart Way

No. I am asking for tutorial or instructions or demo how to verify that dbtools is installed properly and how to use dbtools. Like some simple example because I want just have a feeling of this module

Razor2.3 October 12, 2018 at 17:27:18

✔ Best Answer

In that case, I'm not entirely sure what you're asking for. - Get-Module will tell you if PS knows it's there. (I.e. if it's installed correctly.) - Getting started topics are at the bottom of mmcconaghy's linked page. (I.e. how to use it.) That seems to cover your request? Unless you need it in video format? In which case, YouTube has a search function. How To Ask Questions The Smart Way

well ... by link you meant this one? http://www.skeptic.com/ ?? I've run Get-Module and it returned me 3 rows with Manifest. What it means? That PS is working or dbatools is working

mmcconaghy October 12, 2018 at 21:02:57

by link you meant this one? http://www.skeptic.com/ ?? No, this one: https://dbatools.io/start/ MIKE http://www.skeptic.com/ message edited by mmcconaghy

Razor2.3 October 12, 2018 at 21:06:19

susja: by link you meant this one? http://www.skeptic.com/ ?? No, that's the signature block. The link was https://dbatools.io/start/ susja: I've run Get-Module and it returned me 3 rows with Manifest. By itself, the command only lists currently loaded modules. Modules are loaded on demand. You need to use the -ListAvailable switch to see the list of known modules. Check Get-Module's documentation for more details. How To Ask Questions The Smart Way

Well ... I ran Get-DbaDbTable <instance-name> and get a whole list of data of all tables in the instance. This tells me that dbtools is installed and functioning, correct? I also ran -ListAvailable and it showed that dbtools was installed. Hence..no problem with dbtools. Thanks for that. Now my question more generic :) I'm using SSMS and run various queries when needed and etc. I expected that dbtools will help to get some data in different or easier way especially when I don't know some stuff. Also likely I'll get it in form of text file, I could use some text parsing utility ... like grep, awk or etc. But that's not the major goal. My major goal is get data easier than compiling myself sql query. E.g. when I ran Get-DbaDbTable I've got data for all tables but let say I need only from one table from the instance and etc. Could you advice how to 'navigate' for more specific task. Thanks again for your help. Appreciate it. Regards

Razor2.3 October 13, 2018 at 23:21:47

Look, I work in industries that don't let me readily use third party code, and I don't intend to spin up an SQL Server at home just to play around with this library. When I want to interact with a DB in PS, I have to use the .NET objects directly. That said, I notice Get-DbaDbTable has a -Table param. How To Ask Questions The Smart Way

- Razor2.3 I did not get your last comment My industry is also against using third party tool. Hence results of using dbtools will be my responsibility. I only thought that if I could use any tool that improves my performance it will benefit industry Not sure what’s wrong instead of writing some complex sql query to accomplish some task I could spend less time and get the same results by using dbtools. Welll in general I agree with you and always try to comply with companies rules and regulations but sometimes just want to explore something more I do appreciate your advice and help Thanks

Razor2.3 October 14, 2018 at 07:16:40

I'm saying I'm not an expert on the library, and there's no reason to believe I'll become one. How To Ask Questions The Smart Way message edited by Razor2.3

Thanks You helped me a lot