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

T-SQL Tuesday #43 – Plan Operators

This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!). As this month’s host, Rob has selected the topic of this month’s world-wide T-SQL Tuesday blogging party to be about Plan Operators. Specifically, one or more Plan… Read more

2 comments, 1,087 reads

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

Getting the lowdown on 18456 errors

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will get an 18456 error. This error is deliberately obfuscated in SQL Server so that the user can’t tell why the error failed (and thus try to crack into the server).… Read more

1 comments, 1,341 reads

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

The Bucket List – Item #1 is (finally) finished

We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the bucket. Perhaps you want to ski the Swiss Alps. Learn a foreign language. Learn to play a musical instrument. Surf the Hawaiian swells. Visit far-away places. Get romanced by… Read more

10 comments, 340 reads

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

T-SQL Tuesday #41 – Presenting and Loving it!

It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation by selecting the topic, and he would like to know how we came to love presenting. Being the inquisitive type, Bob would like to know things like what was the… Read more

1 comments, 305 reads

Posted in A Discussion of SQL Server-Related Topics on 9 April 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, 684 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,897 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, 627 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,389 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, 747 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, 753 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,657 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,538 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,726 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, 437 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, 396 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, 445 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, 366 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, 442 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, 406 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, 761 reads

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

Newer posts

Older posts