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,836 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,761 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

539 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,167 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

504 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,100 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,037 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,304 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,400 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

Local Models Using GPUs with Ollama

Don’t Fear the Technology

Creating a Custom SQL Server Security Checklist Using the DoD STIG

Forums

RegEx Functions III

Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix

Finely Tuned Models

Question of the Day

RegEx Functions III