Last Day to Catch Last Week’s Show > SelectViews: SQL Server Show: Getting Started with Reporting Services Power-Up Your SQL Server by Up To 500% By using some excellent technology to drive your SQL Server better, moving the TempDB file onto a RamDisk and running optimization software. At a fraction of the cost of new servers and peripherals, you can […]
Other News
Data Lineage: What You Don’t Know Can Hurt You
(Alex Gorelik) The term data lineage might bring to mind family trees and dry legal searches, however, for companies that are concerned about critical and sensitive data, the topic of data lineage has become increasingly important. Today’s environment of corporate regulation and stringent data gover
XML Data Binding
(Simon Sprott) XML Data Binding allows you to manipulate an XML document via a set of simple objects. The rules defining the ‘shape’ of the XML document are described in an XML schema. Typically, it is possible to read an XML document into an XML binding library and manipulate it programmatically vi
Three Patterns of Constructing an ASP.NET AJAX-based Applications
(Xianzhong Zhu) As one of the full-fledged AJAX frameworks, Microsoft ASP.NET AJAX holds many excellent features that deserve to be carefully explored. In this article, we will focus on one topic — how to use the Microsoft ASP.NET AJAX framework (“MS AJAX” for short later on) to develop web applica
Viewing HADR status through SQL
(Chris Eaton) Based on the number of questions and comments in my initial HADR posting I know that many of you are using HADR for high availability or disaster recovery. If you are using HADR, here is an administrative views that you can use to monitor your cluster via SQL.
Avoid the dangers of XPath injection
(Robi Sen) With the proliferation of simple XML APIs, Web services, and Rich Internet Applications (RIAs), more organizations have adopted XML as a data format for everything from configuration files to remote procedure calls. Some people have even used XML documents instead of more traditional flat
Building Object-Oriented Web Pages with Inheritance in PHP 5
(Alejandro Gervasio) You have probably used the principles of inheritance in any number of your object-oriented programming projects. Traditionally this means working with parent and child classes during the creation of a PHP application. In this two-part series, you’ll learn a simple way to use inh
Collections Best Practices
(Inbar Gazit) Most introductory textbooks on computer science and programming include a chapter about collections. They may be called arrays or data structures, but the concept remains the same. The ability to tie a set of elements to one another in a formal data object is essential to modern progra
[T-SQL] Getting distinct, current entries from tables with timestamp / datetime fields
(Jon Galloway) It’s relatively easy to store data with a time dimension, but querying it is another matter. If you select from a temporal tables (one which includes historical information indicated by a timestamp or datetime column) based on your ID, you’ll get a lot of duplicate records; only one o
Understanding Compression and Decompression in ASP.NET 2.0
(Sanjit Sil) System.IO.Compression namespace is a new addition in .NET 2.0 Framework. The System.IO.Compression namespace contains classes, namely DeflateStream and GZipStream, which provide basic compression and decompression services for streams. DeflateStream provides methods and properties for c
