measure twice, cut once.

G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...

2011-04-28

2,275 reads

Connection strings and application name

by data-marty

measure twice, cut once.

G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...

2011-04-27

14,894 reads

The developer / DBA relationship.

by data-marty

measure twice, cut once.

G’day,

A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as...

2011-04-27

2,663 reads

A small facet of information

by data-marty

measure twice, cut once.

G’day,
I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy...

2011-04-24

523 reads

PowerShell Tip – Custom windows for different tasks.

by data-marty

measure twice, cut once.

G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...

2011-04-22

738 reads

DBCC TraceOn – some processes are global.

by data-marty

measure twice, cut once.

Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...

2011-04-13

2,653 reads

So, what’s this heap thing?

by data-marty

measure twice, cut once.

G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...

2011-04-10

2,404 reads

This appears to be a system procedure..but it isn’t!

by data-marty

measure twice, cut once.

G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...

2011-04-05

2,040 reads

View system object definitions

by data-marty

measure twice, cut once.

G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...

2011-04-03

629 reads

If you fire that trigger, make sure you have the correct ID

by data-marty

measure twice, cut once.

G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...

2011-04-02

571 reads

measure twice, cut once.

DBA relationships – The data custodian

Connection strings and application name

The developer / DBA relationship.

A small facet of information

PowerShell Tip – Custom windows for different tasks.

DBCC TraceOn – some processes are global.

So, what’s this heap thing?

This appears to be a system procedure..but it isn’t!

View system object definitions

If you fire that trigger, make sure you have the correct ID

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