SQL Server

Export Excel reports in Microsoft SQL Server 2000, 2005 & 2008

What’s new in this release? Aspose.Cells for Reporting Services is already providing comprehensive supports for SQL Server 2005 Reporting Services but this...

0 replies - 1101 views - 05/14/09 by Usman in Announcements

Aspose.Total for Reporting Services Q1 2009 Released

What’s new in Aspose.Total for Reporting Services Q1 2009? Aspose.Total for Reporting Services Q1 2009 has just released. This quarter release includes many...

0 replies - 649 views - 04/23/09 by Usman in Announcements

SQL Server Advisor: my blog

Expertise, advice, tool fro performance and all things interesting accumulated over the years to optimize Microsoft SQL Server and to make it -close to- zero /...

1 replies - 1643 views - 03/14/09 by SQLServerAdvisor in Tips and Tricks

Aspose.Slides for Reporting Services supports SQL Server 2008

What’s new in this release? This major release of Aspose.Slides for Reporting Services announces full support of Microsoft SQL Server 2008 Reporting...

0 replies - 1116 views - 02/10/09 by Usman in Announcements

SQL Server Scheduled Backups with NAnt

When installing and using production web applications, backup is always a must. I have written about SQL Server Backup before and this post would expend on...

0 replies - 3243 views - 11/07/08 by Boyan Kostadinov in News

Aspose.Total for Reporting Services Q3 2008 Released

Aspose.Total for Reporting Services Q3 2008 release includes many new and improved features in this suite of Microsoft SQL Server Reporting Services Rendering...

0 replies - 1430 views - 10/14/08 by Usman in Announcements

Querying the File System - From ColdFusion to SQL Server

While looking for a solution of a different problem, I realized that SQL Server has a feature called extended stored procedures. Extended stored procedures, at...

0 replies - 3837 views - 03/17/08 by Boyan Kostadinov in News

Querying Active Directory Through SQL Server

Integrating your application with Active Directory (or another LDAP based directory) is a common requirement in many business applications. Almost every...

3 replies - 13163 views - 02/11/08 by Boyan Kostadinov in News

Get Business Days and Working Hours in a Month

In business applications, there often is a need to know the number of business days and/or hours in a month/year. There is a dozen ways to do this depending on...

0 replies - 5144 views - 02/07/08 by Boyan Kostadinov in News

Custom Date Formatting in SQL Server

Most people that use SQL Server are familiar with formatting dates inside SQL Server. The common approach is: convert(varchar, getdate(), 106) -- Displays a...

2 replies - 17750 views - 02/04/08 by Boyan Kostadinov in News