More Bloopers for Memorial Day

It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in...

How to become an expert in your field

I have been compiling a list of what things a person can do to become an expert, or guru, in...

Optimizer Timeouts with XQuery

I was looking at performance of a database and I noticed a few of the plans were very large and...

Can Scrum work for the DBA?

Agile! Scrum! Development methodologies! Sprint!

If you have a manager who reads any web page about being a manager, then you...

SqlHerts–26th May 2011

Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay.  Its a true pleasure to...

ACID Rules in Sql Server

ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity  states the principle of  All...

DML, DDL, DCL, TCL in SQL Server

Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...

Restoring a database from higher version to lower version SQL server

AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...

Accidentally Dropped the Distribution Database

Have you made the mistake of dropping your distribution database like this?

If so, remember not to do this ever again. ...

Using Views for Faster SQL Query Development

A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...