Tag Archives: powershell

Delete an Azure SQL Database from PowerShell

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Opening the PowerShell ISE from Explorer

This is a cool productivity trip, and one that I ran into by accident. I had heard that I could launch a command prompt by typing cmd in the address. That works, and it’s cool. It even works with ConEmu, … Continue reading

Posted in Blog | Tagged , | 2 Comments

Get Your SQL Server Product Key with Powershell #dbatools

There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL. Get-SqlServerKey is a command that will find your product keys. It’s not often you might need this, but it’s a pain to track them down … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Finding Sysadmins with dba tools–GetDbaRoleMember

I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing some PoSh skills. Recently I noticed there was a Get-DbaRoleMember cmdlet to use. Of course, when I tried to check … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Querying My Named Instance in PoSh–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking at some sample code the other day and it looked like this. cd sqlserver:\sql\localhost\default\databases This allows … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Installing dbatools on WS2012 R2

This is actually a simple, short post, but writing helps me remember things, and since I had to learn this, I decided to write something short. I have a number of Windows Server 2012 R2 VMs. I need to get … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The (Former) Complexity of PowerShell

When I first looked at PowerShell, it was v1.0, and I was in a TechEd presentation. The language seemed a mile past the VBScript I was using when T-SQL didn’t function well. The ability to access the .NET namespace, work … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Using Out-GridView To Pick Parameters–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article on PoSh and learned something cool. I can use Grid-View to surface an object … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is one of the most common questions posted on SQLServerCentral by newbies that are trying to manage their instances and ensure … Continue reading

Posted in Blog | Tagged , , , | 7 Comments

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s … Continue reading

Posted in Blog | Tagged , , | 3 Comments