Category Archives: Developer

Full-Text Search – A Beginner’s Guide

In my experience, many DBA’s and developers seem to shy away from Full-Text Search (http://technet.microsoft.com/en-us/library/ms142571.aspx).  But, it is not as complicated as you may think.  In this post, I am going to attempt to make it as easy as possible … Continue reading

Posted in DBA, Developer, TSQL | Tagged | Leave a comment

Undocumented Stored Procedures … Do NOT Rely on Them in Production!

“Just because you can, does NOT mean you should.”  This is one of my favorite sayings that I like to apply in many aspects of my life, including when I am dealing with SQL Server. For example, there are a … Continue reading

Posted in DBA, Developer, TSQL | Tagged | Leave a comment

SQL Skills Training Class

On almost every survey of the best places to work, employee training is listed as one of the factors that will boost an employee’s satisfaction with a company.  And I have found that to be definitely true in my case.  … Continue reading

Posted in Business Intelligence, Developer, Professional Networking, Training | Tagged , , | Leave a comment

Database Administrators or Developers … Who is Responsible for Indexing?

To answer that question, I am going with “it depends” and “both”! The reason I answer that way, is that anyone designing, building, querying, or maintaining database objects needs to have a grasp of indexing and how it will affect … Continue reading

Posted in DBA, Developer, TSQL | Tagged , , , | Leave a comment

“Do It All at Once” Philosophy … A Set Based Approach Using a Tally or Numbers Table

When it comes to database programming, two of the key principles are that the code should run quickly and be scalable.  And this is really where a lot of people coming from traditional programming backgrounds get into the most trouble … Continue reading

Posted in Developer, TSQL | Tagged , , | Leave a comment

Find Data Quickly … By Using Indexes

Frequently, when a person is interviewing for a database job (i.e. developer or administrator), someone asks them … What is an index?  Or they may ask, what is the difference between a clustered and non-clustered index?  Now, while I do … Continue reading

Posted in DBA, Developer | Tagged , , | 2 Comments

Attack It in Small Bits or Chunks

A friend of mine, with an interesting sense of humor, once asked me, “Do you know how you can eat a whole cow?”  I knew there was going to be some “smart” type of answer, but I didn’t come up … Continue reading

Posted in DBA, Developer, TSQL | Tagged , | 1 Comment