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

Archives: February 2013

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

During… Read more

0 comments, 709 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2013

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

One of the tasks that… Read more

1 comments, 1,917 reads

Posted in A Discussion of SQL Server-Related Topics on 27 February 2013

A Month of PowerShell – Day 26 (Changing Login Passwords)

Welcome to Day 26 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

If you utilize the sa… Read more

0 comments, 644 reads

Posted in A Discussion of SQL Server-Related Topics on 26 February 2013

A Month of PowerShell – Day 25 (Integrity Checks)

Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

We all know that we… Read more

2 comments, 1,402 reads

Posted in A Discussion of SQL Server-Related Topics on 25 February 2013

A Month of PowerShell – Day 24 (JobServer: Jobs)

Welcome to Day 24 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

One of the best practices… Read more

0 comments, 770 reads

Posted in A Discussion of SQL Server-Related Topics on 24 February 2013

A Month of PowerShell – Day 23 (JobServer: Alerts)

Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Today, we’re going to look… Read more

0 comments, 782 reads

Posted in A Discussion of SQL Server-Related Topics on 23 February 2013

A Month of PowerShell – Day 22 (Restores)

Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Yesterday we backed up all… Read more

0 comments, 1,698 reads

Posted in A Discussion of SQL Server-Related Topics on 22 February 2013

A Month of PowerShell – Day 21 (Backups)

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

If you don’t have a… Read more

0 comments, 1,558 reads

Posted in A Discussion of SQL Server-Related Topics on 21 February 2013

A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)

Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Finishing up the mini-series of… Read more

0 comments, 1,761 reads

Posted in A Discussion of SQL Server-Related Topics on 20 February 2013

T-SQL Tuesday #39 – Wrapup

Last week, I hosted the T-SQL Tuesday blogging party event, and the topic was on how do you use PowerShell with SQL. We had a pretty good turnout with 22 blog posts, and here is the recap of our party (if I missed you, please post a comment and… Read more

2 comments, 448 reads

Posted in A Discussion of SQL Server-Related Topics on 19 February 2013

A Month of PowerShell – Day 19 (Databases: Scalar Functions)

Welcome to Day 19 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Continuing the mini-series of objects… Read more

0 comments, 402 reads

Posted in A Discussion of SQL Server-Related Topics on 19 February 2013

A Month of PowerShell – Day 18 (Databases: Stored Procedures)

Welcome to Day 18 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Continuing the mini-series of objects… Read more

0 comments, 455 reads

Posted in A Discussion of SQL Server-Related Topics on 18 February 2013

A Month of PowerShell – Day 17 (Databases: Views)

Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

We’ve spent several days working… Read more

0 comments, 375 reads

Posted in A Discussion of SQL Server-Related Topics on 17 February 2013

A Month of PowerShell – Day 16 (Databases: Triggers)

Welcome to Day 16 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

The last several days we’ve… Read more

0 comments, 455 reads

Posted in A Discussion of SQL Server-Related Topics on 16 February 2013

A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)

Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Adding a foreign key constraint…

Read more

0 comments, 417 reads

Posted in A Discussion of SQL Server-Related Topics on 15 February 2013

A Month of PowerShell – Day 14 (Databases: Altering Tables)

Welcome to Day 14 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Adding columns and unique/default constraints

Read more

0 comments, 783 reads

Posted in A Discussion of SQL Server-Related Topics on 14 February 2013

A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)

Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

We have created a database… Read more

0 comments, 1,995 reads

Posted in A Discussion of SQL Server-Related Topics on 13 February 2013

A Month of PowerShell – Day 12 (Logins, Users and Roles)

Welcome to Day 12 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Creating Logins

One of the… Read more

1 comments, 514 reads

Posted in A Discussion of SQL Server-Related Topics on 12 February 2013

A Month of PowerShell – Day 11 (SMO: Databases)

Welcome to Day 11 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Yesterday we took a look… Read more

0 comments, 1,330 reads

Posted in A Discussion of SQL Server-Related Topics on 11 February 2013

A Month of PowerShell – Day 10 (Navigating SMO collections)

Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

Yesterday, a couple of different… Read more

0 comments, 1,745 reads

Posted in A Discussion of SQL Server-Related Topics on 10 February 2013

Older posts