Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

2013 North American PowerShell Summit

The date has been set for the next North American PowerShell Summit.  It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond, Washington.  I’m already secured my spot and if you want to be there you better act fast!  As of… Read more

0 comments, 449 reads

Posted in SQLvariant on 25 September 2012

Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012

Atlanta MDF presents:

SQL Saturday #111 Pre-Conference Sessions

SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions for the Friday before (April 13). They will cover a broad spectrum of topics: Performance Tuning, SSIS, and SSRS. Registration is… Read more

0 comments, 666 reads

Posted in SQLvariant on 1 February 2012

PowerShell takes the Pole at SQLRally!

PowerShell takes the Pole at SQLRally!

PowerShell has taken the Pole for the DBA division at SQLRally!  Come see why the organizers have chosen this session to lead the pack to the Green Flag.

We will be covering new ground, not rehashing last year’s PASS Summit presentation.  I have… Read more

0 comments, 225 reads

Posted in SQLvariant on 10 May 2011

Late April Free Training from PASS VCs

PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT -4)
Marco Shaw

Marco provides an overview of using sysprep for Windows Server 2008R2, and SQL Server 2008R2, which also now supports this feature. This… Read more

1 comments, 304 reads

Posted in SQLvariant on 15 April 2011

Help Promote SQLRally!

In case you’re in need of some images to help us promote the largest PASS event on the East Coast this year, I’ve gathered some together for you For all you chapter leaders I’ve also included a flyer that you can print out and hand out at your user group… Read more

2 comments, 550 reads

Posted in SQLvariant on 25 February 2011

Emailing tempdb Query Results to Paul Randal with PowerShell

I was referred to someone on twitter today who wants to email query results without setting up database mail.  I explained this in Post 6 of PowerShell Week at SQL University but that example was somewhat complicated. Instead, I thought I’d whip up a new example using Paul’s latest survey Read more

0 comments, 1,046 reads

Posted in SQLvariant on 23 February 2011

PowerShell Interfaces with Other Hammers

This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or with PowerShell or a mix of both. Give us your best tips/tricks and… Read more

0 comments, 275 reads

Posted in SQLvariant on 9 February 2011

PowerShell Week at SQL University – Post 6

Yesterday we went over some loop constructs to get information out of SQL Server.  While getting the information out is great, as Data Professionals our very next concern is going to be: “ok, where do I put this so that I can refer to it later?”

Today we’re going to… Read more

0 comments, 759 reads

Posted in SQLvariant on 21 January 2011

PowerShell Week at SQL University – Post 5

In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca.  There are quite a few more language constructs that we need to cover but we have enough info to start recouping… Read more

0 comments, 645 reads

Posted in SQLvariant on 20 January 2011

PowerShell Week at SQL University – Post 4

Recap

So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what providers are and how to work with methods & properties.

Profiles

Today we focus on load things… Read more

0 comments, 649 reads

Posted in SQLvariant on 18 January 2011

PowerShell Week at SQL University – Post 3

Providers

What are Providers?  Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive.  Why do you need them?  Well you quite possibly may not ‘need’ them per-say but they sure do make… Read more

0 comments, 269 reads

Posted in SQLvariant on 20 May 2010

PowerShell Week at SQL University – Post 3: Providers, PSDrive

Providers

What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive. Why do you need them? Well you quite possibly may not ‘need’ them per-say but they sure do make… Read more

0 comments, 627 reads

Posted in SQLvariant on 20 May 2010

PowerShell Week at SQL University – Post 2

Cmdlets, Functions and Snapins

So far we’ve learned how to open up PowerShell and add on to it with some modules; then we learned how to create a variable and populate it with anything from some numbers to an entire table.  Today we’re going to quickly look at another… Read more

0 comments, 516 reads

Posted in SQLvariant on 19 May 2010

PowerShell Week at SQL University – Post 1

Getting Started With PowerShell Variables

Yesterday we laid the ground work for PowerShell Week.  Today we will learn about Variables in PowerShell. You will notice that PowerShell variables work very differently from SQL Server variables.

The evolution of variables in SQL Server is pretty straight forward. In SQL Server 2000… Read more

0 comments, 501 reads

Posted in SQLvariant on 18 May 2010

PowerShell Week at SQL University – Post 0

Welcome to PowerShell Week at SQL University.  For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get industry experts together to create learning courses around SQL Server.  These learning courses are in one week segments that focus on a specific area. 

When I began blogging about… Read more

0 comments, 486 reads

Posted in SQLvariant on 17 May 2010

Basic SQL Querying From PowerShell

I promise to make this worth your time.  (Oops, I better make this quick.)

Alright so with PowerShell if you open it up and just run this code you’ll be able to query your database right from the start.  Anyone who has worked with data systems for a while will…

Read more

0 comments, 394 reads

Posted in SQLvariant on 22 February 2010