measure twice, cut once.

G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...

2011-08-14

1,167 reads

Select from a table with no rows returned.

by data-marty

measure twice, cut once.

G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...

2011-07-04

5,004 reads

Meme Monday for June – there are no dumb questions

by data-marty

measure twice, cut once.

G’day,
Here’s my input into this months Meme Monday – there are no dumb questions.
It seems (at least to me), that – occasionally...

2011-06-06

1,693 reads

Free SQL Exam cram sessions from Microsoft.

by data-marty

measure twice, cut once.

G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...

2011-05-31

2,931 reads

A curious case of a missing configuration group.

by data-marty

measure twice, cut once.

G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...

2011-05-12

1,488 reads

Catalog view or compatibility view?

by data-marty

measure twice, cut once.

G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...

2011-05-08

3,003 reads

Certifications – and a survey.

by data-marty

measure twice, cut once.

G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...

2011-05-05

725 reads

How do you create or update stored procedures.

by data-marty

measure twice, cut once.

G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...

2011-05-04

17,940 reads

Meme Monday – “I got 99 problems but a disk ain’t one”

by data-marty

measure twice, cut once.

G’day,
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been...

2011-05-02

736 reads

Checkpoints and the Lazy writer

by data-marty

measure twice, cut once.

Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...

2011-05-02

20,311 reads

measure twice, cut once.

A second week at SQLskills – performance tuning

Select from a table with no rows returned.

Meme Monday for June – there are no dumb questions

Free SQL Exam cram sessions from Microsoft.

A curious case of a missing configuration group.

Catalog view or compatibility view?

Certifications – and a survey.

How do you create or update stored procedures.

Meme Monday – “I got 99 problems but a disk ain’t one”

Checkpoints and the Lazy writer

Blogs

Track SQL Server Configuration Changes Using the Error Log

Data Engineering Books Worth Having on Your Shelf (or your tablet)

SSMS Evaluation – future ready

Forums

Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887

Alamat kontak resmi BCA KCU BUKIT BARISAN Telp:0817866887

Alamat kontak resmi BCA KCU BUKITTINGGI Telp:0817866887

Question of the Day

Creating a JSON Document IV