Better Writing from Hemingway

These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely...

SQL Query Run Time Estimation

A followup to a post about subqueries with an estimation for how long it would take for the query to...

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...