I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds
My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create…
Read More
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – Delete Duplicate Rows
I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate rows using CTE and ROW_NUMBER() feature of SQL Server 2005 and SQL Server 2008.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
A day before I wrote article SQL SERVER – sqlcmd vs osql – Basic Comparison. Today while I was displaying how sqlcmd can be used instead of osql to one of my companies team leader, I found another neat feature of SSMS Query Editor. sqlcmd can be used from Query Editor but it has to be enabled first.
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
In this blog post we are going to learn how to restore database backup using T-SQL script. We have already database which we will use to take a backup first and right after that we will use it to restore to the server. Taking backup is an easy thing, but I have seen many times when a user tries to restore the database, it throws an error.