Reading Time: 4 minutes Aggregate functions in SQL Server are usually fairly straightforward tools. We normally use them in a GROUP BY clause to present meaningful aggregate information about our data. I recently came across an interesting problem at work dealing with aggregate functions that I thought would make a great tutorial. I hope Continue Reading
Stored Procedure Output Parameters: A Guide for Beginners
Reading Time: 3 minutes Stored procedures are some of the most complex objects we have available to us in Microsoft SQL Server. There are many tips and tricks you need to know when creating and using them in your databases. In this very brief tutorial, we’ll talk about one of the more confusing things Continue Reading