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 - 969 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 - 553 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 - 1543 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 - 1025 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 - 3192 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 - 1357 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 - 3746 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 - 12828 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 - 5036 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 - 17331 views - 02/04/08 by Boyan Kostadinov in News