SQL Server 365

Replication Latency

• by Chris McGowan

• SQL Server 365

I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...

2013-01-25

1,459 reads

SQL Server 365 - Fantastic First Year In Numbers

• by Chris McGowan

• SQL Server 365

So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has...

2012-12-31

1,359 reads

Active Directory Group Membership and Powershell

• by Chris McGowan

• SQL Server 365

I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...

2012-12-19

791 reads

Tables without a Primary Key

• by Chris McGowan

• SQL Server 365

As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...

2012-12-06 (first published: 2012-11-30)

5,188 reads

Tables without a Clustered Index

• by Chris McGowan

• SQL Server 365

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

2012-11-29

1,517 reads

Unused Indexes

• by Chris McGowan

• SQL Server 365

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

2012-11-27

2,498 reads

Database Mirroring Performance Counters

• by Chris McGowan

• SQL Server 365

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

2012-11-21 (first published: 2012-11-14)

2,635 reads

Database Mirroring Error

• by Chris McGowan

• SQL Server 365

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

2012-10-26

591 reads

Create Database Script

• by Chris McGowan

• SQL Server 365

I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...

2012-09-21

856 reads

tablediff Utility

• by Chris McGowan

• SQL Server 365

I recently stumbled across a little gem of a utility called tablediff.  I have been working a lot with replication...

2012-09-20

6,268 reads