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,826 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

385 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,741 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

525 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,148 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

489 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,096 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,010 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,292 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

Can I Change a Primary Key Value? #SQLNewBlogger

SQL Server Index Primer

Secure Azure SQL Server Backups Using Managed Identities

Forums

Update particular record in a table

Internationalisation

Size of DB on physical disk doesn't match Disk Usage by Table report

Question of the Day

Getting the TEXTSIZE