Tags » Tips And Techniques

Sql Server Kill a SPID (session or Process)

Quick one today:

Sometimes, but not too often (thank fully), we end up in situations where we need to KILL some processes (SPIDs). There are several reasons for this. 124 more words

DBA

Six Questions for Agent Lauren Clark

by Carolee Noury

Writers know it’s a good idea to get to know an agent before pitching to and/or querying her. In that spirit, here’s an opportunity to meet… 331 more words

General Interest

Sql Server: How to remove existing data files

Quick one today:

In the last few weeks, there have been multiple incidents where there was a need to remove/add/modify data files on a Sql Server databaes. 170 more words

DBA

Convert PerfMon blg files into csv

Quick one today:

A few days ago, one of your customers, upon request, sent us their Perfmon files from their database server. We have a template to capture all pertinent Sql Server metrics from PerfMon that we provide to all our customers. 115 more words

DBA

How do you talk to nature?

I am taking three circles this year on my new path of discovery about myself, and each one is very enlightening in its own way. Every month we have what we call ‘at homework’ and each circle seems related with what work we are to do. 691 more words

Akashic Records

Sql Server: Some differences between Temp tables and Table variables

Quick one today:

Temporary tables and table variables are a great addition in Sql Server. Pretty much every database code take advantage of this feature, for right reasons. 193 more words

DBA

A Lesson on Blinkies

Above you see a photo of a Johnstone’s Whistling Frog that I created in Port Antonio, Jamaica. This was the first image that I created of these lovely little frogs during my stay in Jamaica. 284 more words

Photography