Select Page

Aggregate Functions MIN and MAX

I was tasked to develop a performance report using SQL Server Reporting Services 2005. One of the requirements for this report was to get the MAX and MIN date values and then perform a DATEDIFF to get the difference of days between the two values. One of the hurdles I...

Configuring Database Mail

SQL Server Database Mail plays a nice role in my administration. I have set up a few SQL Server Agent Jobs that calls upon stored procedures that I put together to help monitor issues that arise with the data. Sometimes its specific for tracking GIS Schema changes or...

MCTS: Final Decision

After some consideration I decided to pursue the 70-432 Exam: Microsoft SQL Server 2008, Implementation and Maintenance instead of the 2005 version. Though a large part of me thinks that getting certified in both versions is a good idea. As I mentioned before I am...