(Itzik Ben-Gan) SQL Server 2005, formerly code-named Yukon, introduces a wealth of new T-SQL features and enhancements, which I briefly highlighted in my November 2003 article, “What’s New in Yukon T-SQL,” InstantDoc ID 40206. But in my opinion, common table expressions (CTEs) are by far the most im
Other News
Setup Row Level Security or Virtual Private Database
(Shahid Hafeez) This functionality to support fine-grained access control is based on dynamic predicates, where security rules are not embedded in views, but are acquired at the statement parse time, when the base table or view is referenced in a DML statement. A dynamic predicate for a table or
The Need For Speed – Upgrading Your Servers
(Steve Jones) My server isn’t fast enough. Actually it’s neither fast enough, nor big enough. Well, let’s be totally open here. My server is a smoking, high end, rather expensive piece of hardware that I admire. However my users, have a different opinion. (R)
Creating an Identity Column
(Graz) In it’s simplest form an identity column creates a numeric sequence for you. You can specify a column as an identity in the CREATE TABLE statement: CREATE TABLE Yaks ( YakID smallint identity(7,2), YakName char(20) ) Find out more about Identity columns in this article.
Manipulating Microsoft SQL Server Using SQL Injection
(Cesar Cerrudo) This paper will not cover basic SQL syntax or SQL Injection. It is assumed that the reader has a strong understanding of these topics already. This paper will focus on advanced techniques that can be used in an attack on a (web) application utilizing Microsoft SQL Server as a bac
Go Global: Localizing Dynamic Web Apps with IIS 5.0 and SQL Server
(Jeremy Bostron and Doug Rothaus) The success of a database-driven international Web site depends on how well the code and localized content work together with the software on the client and server. Localizing a dynamic Web site is more complicated than localizing a static one. The use of HTML a
SQL Server 2000 Reporting Services
This two-day seminar provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Attendees leave the seminar with a good understanding of how to apply reporting services to problems within a business context. Optionally, bring your lapto
Oracle users show interest in 10g’s platform features
(Marc L. Songini) A number of Oracle Corp. users are showing interest in the recently shipped 10g database, citing the software’s new manageability, usability and self-tuning features. In addition, because prices were recently slashed, some are suggesting that 10g could rival Microsoft Corp.’s SQL S
Using XML and XSLT to Personalize a Web Site Part 2: XSL Transformation Stylesheet Basics—Creating XHTML from XML
(Nicholas Chase) XSL Transformations provide a handy means for converting XML data to HTML pages, allowing you to store your content in its most flexible form and still have complete control over its display in the user’s browser. This article, which is the second in a series on Web site personaliza
Load and Save objects to XML using serialization
(CodeZX) This C# program demonstrates loading and saving an object (including a Bitmap) to an XML file using .NET XML serialization encapsulated within a ‘wrapper’ class. XML Serialization enables an object’s public fields and properties to be saved and loaded to/from an XML file.