Tag Archives: ms

Database Disk Usage Report with Microsoft SQL Management Studio

Microsoft SQL Server Management Studio can be used to generate Standard Reports for viewing system activity, statistics and performance. In this article I will give you a step by step guide on how …

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 2, ASP .NET 3.5, ASP .NET 4.0, MSSQL | Leave a comment

SQL Server NULLIF Function

If you are like me when it comes to developing SQL solutions, you will inevitably use ISNULL function but did you know about NULLIF function. This function is almost the opposite …

Tags: , , , , , , | Posted under Programming/Coding | Leave a comment

Finding Date Closest to Middle or Last Day of Month in SQL

If you have ever worked in SQL or other databases you know that dates can be very tricky. It is not always simple to capture differences and length of time …

Tags: , , , , , , , , , , , , , , | Posted under Programming/Coding | 1 Comment