Happy New Year 2013

Happy New Year 2013 !

New Year begins,

Let us pray that it will be a year with new peace, new happiness and abundance of new...

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