Profile

Cover photo
Chris Mcgowan
Works at Appliances Online
Lives in Manchester
51 followers|18,583 views
AboutPostsPhotosYouTube+1's

Stream

Chris Mcgowan

Shared publicly  - 
 
Blogged: PASS SUMMIT needs you! 
Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee. Not know what PASS is? head over to the website and check it out. You can also get involved on twitter I love the bio "Connect, ...
1
Add a comment...

Chris Mcgowan

commented on a post on Blogger.
Shared publicly  - 
 
The problem is a space after each of the `

This is more than likely a crappy formatting issue on the blog (had a few issues with TSQL formatting) the below should work you can copy and paste it.

$scriptargs = [Microsoft.SqlServer.Replication.scriptoptions]::Creation `
-bor  [Microsoft.SqlServer.Replication.scriptoptions]::IncludeArticles `
-bor  [Microsoft.SqlServer.Replication.scriptoptions]::IncludePublisherSideSubscriptions `
-bor  [Microsoft.SqlServer.Replication.scriptoptions]::IncludeSubscriberSideSubscriptions

I use PowerGUI for all my PowerShell related stuff, you can get it here, it's free;

http://powergui.org/index.jspa

Cheers

Chris
I promised you some PowerShell scripts this year and this post is the first one.  I can see the value PowerShell can bring, but find it equally frustrating.  I don’t know the syntax very well or all the command lets and perso...
1
Add a comment...

Chris Mcgowan

Shared publicly  - 
 
Blogged:Tables Without a Primary Key.  Yet another one of my pet hates!
1
Add a comment...

Chris Mcgowan

Shared publicly  - 
 
Chris Mcgowan originally shared:
 
Blogged: Unused Indexes
1
Add a comment...
Have him in circles
51 people
John Sansom's profile photo
Marko Krstic's profile photo
Nick Harshbarger's profile photo
harsh mishra's profile photo

Chris Mcgowan

Shared publicly  - 
 
Blogged: 2013 - The Year of Community Speaking
So, the end of 2013 is upon us and what a year it has been. The SQL Server 365 blog saw the number of site hits double from last year, which I am thrilled with. The biggest personal achievement this year was popping my speaki...
1
Add a comment...

Chris Mcgowan

Shared publicly  - 
 
Blogged: Free Tools For The DBA
In this post we will look at 5 free tools that I use on a daily basis, I'll give a little bit of detail about them, why I find them useful and the links for you to download them. 1 - Maintenance Scripts - Ola Hallengren W...
1
Add a comment...

Chris Mcgowan

Shared publicly  - 
 
Blogged: Tables without a Clustered Index
1
Add a comment...
People
Have him in circles
51 people
John Sansom's profile photo
Marko Krstic's profile photo
Nick Harshbarger's profile photo
harsh mishra's profile photo
Work
Occupation
Database Administrator
Employment
  • Appliances Online
    Database Administrator, 2012 - present
Basic Information
Gender
Male
Story
Tagline
Comfortably Numb!
Introduction
I have been a SQL Server DBA for the last 5 years and have decided to give something back to the community which has given me so much over the years. I specialise in High Availability and preparing for disaster!
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Manchester
Previously
Manchester
Chris Mcgowan's +1's are the things they like, agree with, or want to recommend.
Volunteers Needed For PASS SUMMIT
sqlserver365.blogspot.com

Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee. Not know what PASS is? head over to the websi

2013 - The Year of Community Speaking
sqlserver365.blogspot.com

So, the end of 2013 is upon us and what a year it has been. The SQL Server 365 blog saw the number of site hits double from last year, which

PASS Summit
sqlserver365.blogspot.com

It's that time of year again, the annual PASS Summit is under way in Charlotte, NC! For those of you who don't know, PASS Summit is the worl

Free Tools For The DBA
sqlserver365.blogspot.com

In this post we will look at 5 free tools that I use on a daily basis, I'll give a little bit of detail about them, why I find them useful a

Windows Failover Cluster Monitor
sqlserver365.blogspot.com

Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as a DBA

Unused Indexes
sqlserver365.blogspot.com

A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can cause unnecessary reads

Index Tuning
sqlserver365.blogspot.com

This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using SQL Sent

Determining the uniquifier column ordinal for clustered and nonclustered...
improve.dk

Once you know what the uniquifier is, you may thirst for more details. This post outlines how to determine where the uniquifier is stored in

Stop Worrying About Exhausting Bigints
improve.dk

Should you worry about running out of bigint values? Probably not.

SQL Server 365: A Script A Day - Day 24 - Object Qualification
sqlserver365.blogspot.com

Today's script is one I use as an example to explain that there is method behind my standards that some people initially see as madness.

The Importance of Validating Backups - SQLServerCentral
www.sqlservercentral.com

Free Microsoft SQL Server articles, news, forums, scripts and FAQs.

SQL Server 365: Dropping a Database
sqlserver365.blogspot.com

Dropping a Database. I came across an issue on a server this morning where a drive had run out of free space. Now given I still haven't

SQL Server 365: A Script A Day - Day 21 - The HAVING Clause
sqlserver365.blogspot.com

Today's post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is typically used in a GR

SQL Server 365 - Fantastic First Year In Numbers
sqlserver365.blogspot.com

So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has been. I can honestly say that I have take

Tables without a Primary Key
sqlserver365.blogspot.com

As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script slightly to get all tab

Tables without a Clustered Index
sqlserver365.blogspot.com

Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the routine. In

Database Mirroring Performance Counters
sqlserver365.blogspot.com

This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t signed up to

Database Mirroring Error
sqlserver365.blogspot.com

I have been setting up multi instance database mirroring for the last couple of days along with some other DR related processes. I will do a

High Availability Lingo
sqlserver365.blogspot.com

You have got to love the way the SQL Server team change the lingo in all of their high availability (HA) / disaster recovery (DR) features.

Rebuilding System Databases
sqlserver365.blogspot.com

Today's post is something I thought I would share as there is an awful lot of incorrect commands I have seen (and some even tried) in the pa