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

SQL University Troubleshooting Week: Having a Plan for Every Situation

Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...

Search Active Directory (AD) from your desktop

Ever see a Windows group and want to know all the users in that group without having to ask your...

Re-blog – May 20-26

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

MCITP: 2 Down 2 to go

It’s time for the weekly update.  Much like last week, we had more issues with taking this exam today.  I scheduled exam 70-433 for first thing in the morning...