SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

268 Results Found

ARTICLE

PowerShell Basics

My definition of what PowerShell is: Command Prompt after a few cups ... here to get an idea of how to start the PowerShell console. Windows 7 and Window Server 2008 R2 come with PowerShell already loaded for your exploration. If you ... two things with this article: 1) How is PowerShell useful and 2) What PowerShell can do. I will provide some ...

ARTICLE

Is PowerShell Intimidating?

... I have been doing some PowerShell learning and mentioned that. He replied that “PowerShell intimidates me”. Honest and courageous to say ... been slow to invest time in learning PowerShell? Why have I been so ... t pay much attention to the launch of PowerShell. It felt at the time like typical Microsoft ...

ARTICLE

Powershell for DBAs

... number of people talking about using Powershell (PoSH) with SQL Server. Laerte Junior ... notice more and more people are showing Powershell as a tool to accomplish repeatable tasks, run ... multiple servers. I've struggled to use Powershell much in my work, but I don't ...

ARTICLE

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

... have learned about installation and setup of the PowerShell environment. We have built a simple ... simple profile to prepare for SQL Server PowerShell and learned about Input and Output functions ... now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell. Everything in PowerShell is an object. Let’s start out ...

ARTICLE

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

What are PowerShell and SQL PowerShell and how do you use them ... might want to use this great tool. PowerShell is an environment that Microsoft developed to enable System ... automate routine tasks, as well as to use a scripting language to manage some of their administrative tasks ...

ARTICLE

Paging Doctor Powershell

... Treatment in 11 steps Enter Dr. Powershell, with its ability to read logs on the server ... information all into one easy to use script. This article will walk through a PowerShell script I have been modifying for quite ... return $counterArray; } ## Based on a Chad Miller script function Invoke-Sqlcmd3 { param( [string]$ServerInstance ...

ARTICLE

Day Zero with PowerShell

... I was ready to submit my first PowerShell article to SQLServerCentral when I got ... me that I should focus on explaining scripts to PowerShell beginners. However, beginners need PowerShell configured before they can follow along with any PowerShell article. I will be using SQLPSX in future ... configuration refresher is something that many experienced PowerShell users can benefit from as well ...

ARTICLE

Some Relevant PowerShell Books

... been reading quite a number of books on Powershell and SQL Server recently. Actually, I ... both topics together, though several PowerShell books are useful to the database professional.  The first ... SQL Server 2008 Administration with Windows PowerShell, by Ananthakumar Muthusamy (MAK)  and Yan Pan ...

ARTICLE

Pioneering with PowerShell

... America conference was that "there's a huge demand for good PowerShell basic training". Given Microsoft's strong ... been surprising to see radical languages such as PowerShell and F# appear, and gratifying to see so many IT professionals realise that in PowerShell, we have, at last, the fabled 'glue ... pioneering Database Developers have used PowerShell to automate the database deployment process; Exchange ...

ARTICLE

Automating Daily Checks with Powershell

... initial investment of a few hours tinkering with PowerShell. Using PowerShell, I produce a backup status report ... backup report looks like this: In the same script, I grab the past 72 hours ... going to assume you have zero PowerShell experience, like I did just ...