Chrissy LeMaire
Today’s blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. intro dbatools has been around since 2014. At first, it started with one contributor and was solely dedicated to migrating SQL Server instances, but now it’s grown into an awesome open source DBA project with over 30 contributors.
Read moreChrissy LeMaire
Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work with GitHub. I love the command line, but with Git? I think it’s important to get the concepts down first and the Desktop version makes that a lot easier to contribute to projects like dbatools, dbareports and even PowerShell itself.
Read moreChrissy LeMaire
Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work with GitHub. I love the command line, but with Git? I think it’s important to get the concepts down first and the Desktop version makes that a lot easier to contribute to projects like dbatools, dbareports and even PowerShell itself.
Read moreChrissy LeMaire
In this release (two in one month, woo!), we gained 3 new contributors to the dbatools master repository for a grand total of of 29! Commands We fixed about 10 bugs, made two commands more efficient and added 5 new commands. Connect-DbaSqlServer Creates an SMO SQL Server object. Supports both Windows and SQL Authentication. I imagine mostly SMO programmers will like this one, but check it out anyway. It has a ton of useful parameters.
Read moreChrissy LeMaire
In this month’s release, we gained 6 new contributors to the dbatools master repository for a grand total of of 26! This was likely the result of moving the repository to the new organization on GitHub called the SQL Server Community Collaborative, which makes it easier to participate in the dbatools project. We also added a few pages to the dbatools GitHub Wiki including: Your First Pull Request, Style Guide and Testing and Q&A.
Read moreChrissy LeMaire
Hey, Chrissy here. Recently, I had great success with scheduling a database migration and wanted to let you know how I did it in case you have a similar requirement. My requirement comprised of copying two databases that were 30 GB in size, from one server to another, during a time that I wouldn’t be at the office. Remote work was not possible. The Script Here’s the scheduled-migration.ps1 script that ultimately worked for me.
Read moreChrissy LeMaire
dbatools is not only intended to be a great migration tool, but also a toolset to help DBAs follow best practices. Check out all the new commands in this batch, courtesy of Mike Fal, Constantine Kokkinos and Chrissy LeMaire. Best Practices Commands Ever read a really great article about how to do something properly but then kinda forgot and you have to revisit each time? Well, we’ve codified some of those practices for you, making them easy to both follow and remember.
Read moreChrissy LeMaire
When I first began working on dbatools, I was aware of the suggestion to use a distinct prefix in PowerShell, but chose to use Sql for its universal recognition. That will soon change. PowerShell Prefixes Prefixes are the things that start the noun. SQL Server uses Sql, Active Directory uses AD, SharePoint uses SP, PowerShell uses PS and Lync uses Cs. You can see, even with two letter prefixes, that there is no true case consistency.
Read moreChrissy LeMaire
When I first began working on dbatools, I was aware of the suggestion to use a distinct prefix in PowerShell, but chose to use Sql for its universal recognition. That will soon change. PowerShell Prefixes Prefixes are the things that start the noun. SQL Server uses Sql, Active Directory uses AD, SharePoint uses SP, PowerShell uses PS and Lync uses Cs. You can see, even with two letter prefixes, that there is no true case consistency.
Read moreChrissy LeMaire
So many SQL Server and PowerShell pros have joined the dbatools team and we’re producing well designed PowerShell commands like mad! dbatools is not only intended to be a great migration tool, but also a toolset to help DBAs follow best practices. We like to think of these commands as fully automated Wizards that are executed from the command line instead of the GUI. Best Practices Commands Ever read a really great article about how to do something properly but then kinda forgot and you have to revisit each time?
Read moreStart typing to search
Search across posts, pages, and commands
dbatools