SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video

You might have heard many times that one should not use SELECT * as there are many disadvantages to the usage of the SELECT *. I also believe that there are always rare occasion when we need every single column of the query. In most of the cases, we only…
Read More

SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier

If you have not read my SQL SERVER – Simple Example to Configure Resource Governor – Introduction to Resource Governor yesterday’s detailed primer on Resource Governor, I suggest you go ahead and read it before continuing this article. After reading the article the very first email I received was as follows: “Pinal,…
Read More

SQL SERVER – Fix: Error 147 An aggregate may not appear in the WHERE clause

Everybody was a beginner once and I always like to get involved in the questions from beginners. There is a big difference between the question for beginner and question from advanced user. I have noticed that if an advanced user gets an error, they usually need just a small hint to resolve the problem. Let us learn about how to fix Error 147 in this blog post.

Read More

Developer Training – A Conclusive Summary- Part 5

We have now reached the end of our series about developer training. I hope you have come away thinking that training is the best way to advance in your company and that you are looking for training opportunities right now. If you’re still not convinced here are a few things to keep in mind:

Training benefits the employer and the employee.
A well trained employee is a happy employee, and a happy employee is more efficient and productive.
Training an employee might be expensive, but it is less expensive than hiring a new person.

Read More