(Thiru Thangarathinam) With the release of.the NET Framework 2.0, Microsoft is enhancing the feature set by baking the ability to execute SQL commands asynchronously into the ADO.NET Class Library. Using this new feature, you can asynchronously execute commands against a SQL Server database without
Tag: sql server
An Alternative XML Solution
(Wayne Fillis) XML is a great tool for sharing and manipulating data. It is becoming (or is already!) a de facto standard in the Enterprise for the sharing of data in the form of XML documents, saved as .XML files (which can be opened and viewed in Internet Explorer) or imported directly into SQL Se
How do I track file growths on my data files?
(Mark Allison) Sadly, the current version of SQL Server (2000) does not have a table which logs data file growths. Performance monitor (perfmon.exe) does not allow you to monitor file growths either, however you can monitor transaction log file growths using performance monitor. If you would lik
An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server
(Surajit Chaudhuri and Vivek Narasayya) In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database. The tool takes as input a workload of SQL queries, and suggests a set of suit
Report-enable Your Web Apps with Microsoft Reporting Services
(Teo Lachev) Reporting is an integral part of almost all of today’s Web applications. However, while the tools to create such applications have matured, Web reporting often boils down to generating tabular reports in the form of HTML tables. Microsoft SQL Server 2000 Reporting Services fills in this
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Optimizing the CROSSJOIN() Function
(William E. Pearson, III) In this article, we will return to our intermittent examination of various MDX optimization techniques which we have intermingled with other MSAS optimization topics within this series. The function upon which we will focus will be CROSSJOIN(), whose mission it is to co
Harden MS Reporting Services Using Custom Extensions
(Teo Lachev) One of the most useful features of Microsoft Reporting Services is its extensibility model. Just about any aspect of Reporting Services can be custom-tailored to meet your specific requirements. Part one of this two-part series explains how to replace the default Windows-based secur
SQL Server 2005 Part 5 – High Availability and Scalability Enhancements
(Marcin Policht) In this article, we continue our discussion on high availability and scalability enhancements in SQL Server 2005 Beta 2 release. Features such as clustering, database mirroring, online indexing, fast recovery, database snapshots, and snapshot isolation transaction level have already
A Java proxy for MS SQL Server Reporting Services
(Christian Donner and Ilia Papas) A Java Web application often uses a SQL Server database. SQL Server now comes bundled with a reporting tool, Reporting Services. RS has generated a lot of attention among developers since it first came on the market about a year ago. It is a full-featured reporting
Review – Apex SQL Edit
(Brian Kelley) ApexSQL Edit is designed as an all-in-one Integrated Development Environment (IDE) for SQL Server. Including features like SourceSafe integration, Intellisense, data editing, and standard code formatting, along with Favorites (!), it is a significant upgrade from Microsoft’s provided
