Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of full-text search.

What is a Stoplist?

A stoplist is a… Read more

Last year, I did a wrap up post of the year to see where I landed from where I wanted to be.  At the end of that post, I came up with a number of goals for the year.  Now’s the time to see how I did with those goals. Read more

Year 2012 was super special for me in many ways. Made lot of new friends, Attended SQLPASS Summit 2012 and had the privilege to meet and greet #SQLfamily members, New learnings, Multiple SQL2012 deployments, Lot of writing and Loads of fun !!!

All about resolutions -

One of the major… Read more

2012 was, simply stated, a year that kicked my butt.  When I wasn’t struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are… Read more

Read more

Read more

Read more

Read more

Looking back at 2012 I feel like I’ve written less than I planned to, and in some ways done less than I had planned, yet it was a year of tremendous growth for me and not a lost year by any measure. Less travel has been good, if hard to… Read more

Last year I purchased two Kindle Fires for the family to use. The UI could be just a little bit/slow twitchy at times, but never so much to make you put the device down.  Looking at the usage over a year it was mostly games mostly played by kids followed… Read more

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

1. On Being A Senior Engineer…

Read more

Read more

I’m not working too hard today, so this is just a short post to wish all my readers a very happy and prosperous New Year

---

Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL…

Read more

Read more

So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has been.  I can honestly say that I have taken a great deal away from this experience which has been so rewarding, the  only disappointment I have is that I didn't start blogging earlier.

I…

Read more

In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files in a folder.  The previous posting mostly talked about how the stored procedure worked and the output it generated.  For this posting, I have expanded upon the script…

Read more

New Year begins,
Let us pray that it will be a year with new peace, new happiness and abundance of new friends. May the year brings the true example of Humanity.

Let us pray to get the courage to feel the difference of Right and Wrong.
Let us pray for… Read more

It is Monday today but its no ordinary Monday. Today is New Years Eve, its the end of December and its the last day of the year. This post is looking back at the top 4 popular posts on the blog for December 2012

1. SP_Change_Users_login
2. Bulk Insert Permissions
3. DB_Executor Role

Read more

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 400,000 times in 2012. If it were Liechtenstein, it would take about 7 years for that many people to see it. Your…

Read more

I just discovered a few posts calling out a bug in the vSphere 5.1 vCenter performance statistic rollup procedure for performance statistics. Any performance statistics greater than 30 days are lost. VMware does not currently have a resolution, but I am sure they are working on this.

I consider this… Read more