How to Use xp_dirtree to List All Files in a Folder - Part 2

In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...

Last Weeks Top 10 “Reading” Links #13

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

Log Shipping in SQL Server

Log Shipping:- Log Shipping is a process of keeping the latest copy of the database of the primary database server...

Phones, Tablets, and Even Windows 8

Last year I purchased two Kindle Fires for the family to use. The UI could be just a little bit/slow...

Rebuild And Reorganization of Indexes

Rebuild and  Reorganization of Indexes:- SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,...

Replication in SQL Server

Replication  is a way of distribution of database and their objects from one master database to one or more recipient databases...

SQL Server 365 - Fantastic First Year In Numbers

So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has...

SQLBits XI Dates Announced

SQLBits XI has been announced for the 2-4th of May 2013. Having taken place in London this year, it is moving back North to the Midlands at the East...

vSphere 5.1 Performance Statistic History Bug

I just discovered a few posts calling out a bug in the vSphere 5.1 vCenter performance statistic rollup procedure for...

Welcome 2013

HappyNewYear2013

May this new year bring lots of Happiness in all of your life. Let  welcome 2013 together with lots of...