Monthly Archives: April 2012

Split a string using a table Variable

Was just playing around with Table variables and thought of a practical problem lot of people approached to me with. Thought its worth documenting on how I do it so somebody can reuse the trick. Given a set of names … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks | Tagged , , | 1 Comment

Passed Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Passed Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008. This now takes my skillset to a new level on Dev aspects of sql server Microsoft Certified IT Professional (MCITP): Database Developer 2008 I could … Continue reading

Posted in MCITP, MCM, SQL Server | Tagged , | Leave a comment

Two main tables in a distribution database to facilitate replication

Somebody asked me this question: “What are the two main tables in a distribution database when you configure replication“ The two main tables in a distribution database to facilitate replication are those that contain the information on where to start … Continue reading

Posted in Replication, SQL Server, Tricks | Tagged | Leave a comment

Passed 70-433 TS: Microsoft SQL Server 2008, Database Development

Passed Exam 70-433 TS: Microsoft SQL Server 2008, Database Development This morning. The only book I referred in preperation for the exam was the: MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 – Database Development http://www.microsoft.com/learning/en/us/Book.aspx?ID=13159&locale=en-us The book … Continue reading

Posted in MCM, MCTS, SQL Server | Tagged , , | Leave a comment

Installing Full Text Search on SQL Server

Was just playing around with Full text search and was trying to enable full text search on one of my table on AdventureWorksDW2008 database. Noticed the full text search was greyed out and didnt remember if I ever installed full … Continue reading

Posted in Full-Text Search, SQL Server | Tagged , | 1 Comment