Speaking on Standardize SQL Server Implementations (Dev to Prod)

Summit and something new…

Let me just say, I’m excited.
 
First of all, can you believe that the PASS Summit is next week?  Next. Week.
Are...

Tales from the Query Processor III

https://www.flickr.com/photos/socal_jim/2070088596/Hello Dear Reader!  It’s that time of year again.  The leaves are turning, temperatures are changing, and Halloween is once...

Writing Fair and Useful Editorial Reviews Is Hard Work

One of my original goals was to be more reporter than editorial writer, but I’ve found that the editorial part...

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...

How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013

Hello Friends,
I was getting lot of responses on blogs and mails. It will be difficult to cover all at once...

How to take Transaction Log backup ? TIP# 68

 
As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...

PASS Summit: Things to Do, People to See

PASS Summit is nearly upon us. I’m excited to be attending my second Summit in Seattle and cannot wait to get there to see everyone. With one Summit and...

Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects...