So you think you know SQL…Concurrency and Locking

The first in hopefully a fairly long series of posts on interview type questions/scenarios/etc., this one will cover Concurrency and Locking related Q/A (simple Q/A only at this point).  The questions are separated into easy, moderate, and difficult groups.  If you have any comments, by all means please post and lets discuss! Typically, answers and…

0

So you think you know SQL…

I’m frequently asked about questions that are asked when interviewing candidates for Sql Server related positions, what topics should be covered, what types of questions should be asked, etc. In spirit of trying to address this as well as a range of basic, intermediate, and advanced level topics, I’m going to begin a series of…

0

Presenting Service Broker at Capital Area Microsot Integration and Connected Systems – MICSUG – Reston, VA

If you’re in the DC/Nova/Baltimore area and are interested in a presentation covering Service Broker scenarios with Sql Server 2005, I’ll be presenting at the Capital Area Microsot Integration and Connected Systems user group (MICSUG) at the Microsoft office in Reston, VA this coming Thursday, May 24th. For more information on the group, check out their site…

1

Large log backups with bulk operations and read-only databases

So, here’s an interesting scenario I ran into a few weeks back. A customer had a situation in which they were using a read-only database (to serve reports/ad-hoc queries during production hours) that was loaded nightly with differential data from a variety of systems. This data was imported to the system nightly from flat-files (variety…

0

Paul Randal presenting at NovaSql user group

After a nice vacation (to Italy for a friend’s wedding…very nice country…) I’m back and hopefully will be posting a couple of technical topics in the next few days to get caught-up on my absense. In the meantime, if any of you are in the DC area next Monday, May 21st, Paul Randal will be…

0