measure twice, cut once.

Cluster failover – what’s the best way to get notified?

by Marty

measure twice, cut once.

G’day,
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check...

2011-03-27

2,828 reads

So you’re RAIDed, but are you protected?

by Marty

measure twice, cut once.

G’day,
Occasionally, I hear things that surprise me. And one of the statements that I’ve heard lately that fits into that category is...

2011-03-24

386 reads

Primary Keys – why accept the defaults.

by Marty

measure twice, cut once.

G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...

2011-03-19

1,747 reads

Disaster Recovery Exposure - Part Two

by Marty

measure twice, cut once.

In part one, I gave a general overview of some of the things that may affect IT services in the...

2011-03-15

526 reads

Disaster Recovery Exposure. - Part One

by Marty

measure twice, cut once.

G'day,

I've just readPaul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions...

2011-03-15

1,150 reads

In summary - SQLskills internals.

by Marty

measure twice, cut once.

Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...

2011-03-06

493 reads

What...you mean I won...and Thank You.

by Marty

measure twice, cut once.

Well, what a week it’s been. I started my winning blog post for the SQLskills blogging competition by stating that...

2011-01-30

2,097 reads

Internals and Performance class in Dallas

by Marty

measure twice, cut once.

At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...

2011-01-23

4,014 reads

Remember OBJECTPROPERTY(..) when investigating objects.

by Marty

measure twice, cut once.

The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...

2011-01-20

1,296 reads

Check that what you expected is actually what you got - DB's and SQLCMD

by Marty

measure twice, cut once.

I feel that it is wise move for a script to actually check itself that the database connection that is...

2011-01-16

1,390 reads

measure twice, cut once.

Cluster failover – what’s the best way to get notified?

So you’re RAIDed, but are you protected?

Primary Keys – why accept the defaults.

Disaster Recovery Exposure - Part Two

Disaster Recovery Exposure. - Part One

In summary - SQLskills internals.

What...you mean I won...and Thank You.

Internals and Performance class in Dallas

Remember OBJECTPROPERTY(..) when investigating objects.

Check that what you expected is actually what you got - DB's and SQLCMD

Blogs

The fundamental requirements of a reporting system

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

Check Power BI report interactions with Semantic Link Labs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

The Last Good DBCC Run

count the number of NULLs in a row

Question of the Day

The Last Good DBCC Run