Recently, PASS announced their first round of speakers for Summit 2017 speakers and I’m on the list! I’m particularly excited because Summit is the largest SQL Server event in the world and it’s looking like PowerShell will be getting some…
netnerds.net
information is power
Author: Chrissy LeMaire
Chrissy is a Cloud and Datacenter Management MVP who has worked in IT for over 20 years. She is the creator of the popular SQL PowerShell module dbatools, and holds a number of certifications, including those relating to SQL Server, Linux, SharePoint and network security. You can follow her on Twitter at @cl.
PowerShell Gallery Metapackages
Recently, I was approached by supa-famous Joey Aiello of the PowerShell team at my favorite conference ever, PSConf.eu. So Joey comes up and says “Chrissy, Aaron Nelson has pretty much required me to talk to you. The SQL Community has…
SSMS Complains of “Inconsistent Line Endings” with PowerShell Output
If you’ve used Out-File, Set-Content or Add-Content to create a SQL file, you may notice that SQL Server Management Studio complains about normalizing the line breaks. If you see this, simply using -Encoding UTF8 for your output instead of ASCII,…
Posted in PowerShell, SQL Server
T-SQL Tuesday: The Cloud, Globalization and Automation
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. This month’s T-SQL Tuesday, hosted by…
Posted in PowerShell, SQL Server
A Suggested Fix for Thunderbolt Display Buzzing
About a month ago, my beloved Thunderbolt display began buzzing. After some research, it seemed that there could be all sorts of solutions. The one that seemed to almost always work was sending off the monitor to get the power…
Posted in OS X & iPhone
Loading SMO in Your SQL Server-centric PowerShell Modules
In a recent version of PowerShell, Publish-Module, which publishes modules to the Gallery began requiring fully qualified Assembly names such as “Microsoft.SqlServer.Smo, Version=$smoversion, Culture=neutral, PublicKeyToken=89845dcd8080cc91”. Previously, it was sufficient just to use short names such as Microsoft.SqlServer.Smo. This had similar…
Posted in PowerShell, SQL Server
Find Every Parameter for Every Command in a PowerShell Module
We’re currently working on standardizing our documentation for dbatools and I needed a list of all of the parameters we use. Here’s how I did it (well, I did it an uglier way then Aaron made it prettier ;)) Get-Command…
Posted in PowerShell
dbatools to the backup/restore rescue
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…
Posted in PowerShell, SQL Server
dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.
Available from dbatools.io and github
dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI 📊
Available from dbachecks.io and github
Chrissy LeMaire
Tweet to @cl
Brandon Abshire
Chrissy has been awarded the Microsoft MVP for her work in the PowerShell community.
Belgian PowerShell User Group
Help persuade Microsoft to open source SQL Server's PowerShell module, SqlServer.
Upvote now on Microsoft Connect
Upvote now on Microsoft Connect
Recent Comments