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

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

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

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

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

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

Endpoints Need Privileges Too

Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...

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