dbatools commands used: Get-DbaDatabase Get-DbaDbFile Get-DbaDbSpace Get-DbaDbState Get-DbaAgentJob Get-DbaAgentJobStep Get-DbaLogin Get-DbaDbUser Get-DbaServerRole Get-DbaServerRoleMember Get-DbaDbRole Get-DbaDbRoleMember See the databases When I want to quickly check the databases in the SSMS I would use this: SSMS With dbatools I can run the following command: dbatools: Get-DbaDatabase In a comparable way we can see details of a single…Read More dbatools.io = command-line SQL Server Management Studio: Let me see
dbatools commands used in this post: Connect-DbaInstance Invoke-DbaQuery Write-DbaDbTableData Connect to the Database Engine It is possible in dbatools to create a server object and reuse it without providing the credentials and connecting to the instance again and again. SSMS dbatools: Connect-DbaInstance Execute a simple query Once the connection is established you can run the…Read More dbatools.io = command-line SQL Server Management Studio: Connect, Query and Save
I am using dbatools.io in day-to-day work. That amazing set of tools helped me a lot. I have also met people who have some reservations or do not know where to start. I have heard: I will not learn new language, for example PowerShell SQL Server Management Studio is all I need We already have…Read More dbatools.io = command-line SQL Server Management Studio
Table of contents for the dbatools.io = command-line SQL Server Management Studio series. An overview of how to start using dbatools to run queries against your SQL Server instance.dbatools: Connect, Query and Save If you want to look at your SQL instance and see your objects here is how you can do it.dbatools: Let me…Read More dbatools.io = command-line SQL Server Management Studio: Table of contents
Last month I have demonstrated how to contribute to the dbatools.io without touching PowerShell editor. This time let’s see how to do some PowerShell, shall we? So exciting! However, you might find here why some stuff did not work quite well, as I found the hard way. You’ve been warned. Invite dbatools for dinner (or…Read More dbatools.io – blind-date: why don’t I see my changes?
What dbatools.io is? That’s what you can find on their website. dbatools is a free PowerShell module with over 500 SQL Server best practice, administration, development and migration commands included. Currently, other components of SQL Server such as SSIS, SSRS and SSAS are not supported, but they are part of the overall goal. The high…Read More dbatools.io – how to contribute?