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,832 reads

So you’re RAIDed, but are you protected?

by data-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

400 reads

Primary Keys – why accept the defaults.

by data-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,758 reads

Disaster Recovery Exposure - Part Two

by data-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

535 reads

Disaster Recovery Exposure. - Part One

by data-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,165 reads

In summary - SQLskills internals.

by data-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

500 reads

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

by data-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,099 reads

Internals and Performance class in Dallas

by data-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,026 reads

Remember OBJECTPROPERTY(..) when investigating objects.

by data-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,302 reads

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

by data-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,398 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

A New Chapter: Why I Made the Move from Dayforce to ESO

Lean Six Sigma – Brief

T-SQL Tuesday #200: Bad Query signals

Forums

Using IFF within a WHERE clause

Reading Parquet using openrowset

Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019

Question of the Day

DBCC CHECKDB Limits II