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
All Articles document-error-flat

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
All Articles devt17

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
All Articles devt7

Developer Training – Employee Morals and Ethics – Part 2

If you have been reading this series of posts about Developer Training, you can probably determine where my mind lies in the matter – firmly “pro.” There are many reasons to think that training is an excellent idea for the company. In the end, it may seem like the company gets all the benefits and the employee has just wasted a few hours in a dark, stuffy room. However, don’t let yourself be fooled, this is not the case!

Read More
All Articles devt4-321x400

Developer Training – Importance and Significance – Part 1

Can anyone remember their final day of schooling? This is probably a silly question because – of course you can! Many people mark this as the most exciting, happiest day of their life. It marks the end of testing, the end of following rules set by teachers, and the beginning of finally being able to earn money and work in your chosen field. Let us read more about Developer Training Importance and Significance.

Read More