SQL

dbatools = command-line SSMS dbatools = command-line SSMS

dbatools commands used in this post: Remove-DbaDatabase Remove-DbaLogin Remove-DbaDbUser Remove-DbaDbRoleMember Remove-DbaDbRole Remove-DbaServerRole Remove-DbaAgentJobStep Remove-DbaAgentJob One note before we start dropping objects on the SQL Server. The dbatools commands support a -WhatIf switch (more about that here). I would encourage you to test it out, especially with commands that are removing things. Drop database Who does…

Read More dbatools.io = command-line SQL Server Management Studio: Drop it

dbatools = command-line SSMS dbatools = command-line SSMS

dbatools commands used in this post: New-DbaDatabase New-DbaLogin New-DbaDbRole New-DbaDbUser New-DbaAgentJob New-DbaAgentJobStep New-DbaAgentSchedule New-DbaDbMailAccount New-DbaDbMailProfile New database Request for a new database is a pretty standard and repeatable task. It can be either a simple database based on the model database or more complex with multiple data files and filegroups. SSMS dbatools: New-DbaDatabase New login/user/role…

Read More dbatools.io = command-line SQL Server Management Studio: Something new

dbatools = command-line SSMS dbatools = command-line SSMS

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 = command-line SSMS dbatools = command-line SSMS

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

dbatools = command-line SSMS dbatools = command-line SSMS

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

dbatools = command-line SSMS dbatools = command-line SSMS

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

Blind date: PowerShell & dbatools Blind date: PowerShell & dbatools

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?

dbatools.io – how to contribute? dbatools.io – how to contribute?

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?

AzureAdventCalendar.com AzureAdventCalendar.com

Azure Advent Calendar About three months ago @Pixel_Robots and @gregor_suttie has invited the community to participate in Azure Advent Calendar. Working with Azure? Join the 2019 Azure Advent Calendar and showcase your knowledge where others can benefit, help the Azure Community and help each other.#azurefamily #azureadventcalendar https://t.co/s0U6SFh97zplease retweet pic.twitter.com/nTUcD3rIzG — Gregor Suttie – in Prague (@gregor_suttie)…

Read More Azure Advent Calendar 2019: Azure Data Studio

Girl feeding pigeons Girl feeding pigeons

Following the Data:Scotland conference I have uploaded my presentation to GitHub as well as official Data:Scotland repository. If you missed that session, here are some happy faces!

Read More Data:Scotland – Multi-server agent jobs administration with happy faces and pigeons