It seems that there is both excitement and confusion surrounding Master Pages and Themes. A big part of the problem is that they always seem to be mentioned in the same breath – like I just did. The reality is that they are two separate but equally important technologies. Each has its own function in ASP.NET but when you use these two technologies together, you get a site design that is amazingly versatile, easy-to-use, and easy-to-adapt. ASP.NET 2.0 provides a whole host of improvements to your web development experience but, in my opinion, these two technologies represent the single biggest reason to migrate your sites to this new platform. Let's take a look at each of these technologies in turn.

Implementing Data Security in a Report Model

by Additional Articles

SQLServerCentral

Administration

The report models introduced in SQL Server 2005 feature a number of ways to customize the data visible to different users and groups: perspectives, model item security, security filters, and opaque expressions. This article describes when and how to use each of these features.

Script Database Objects with SMO

by Vasant Raj

SQLServerCentral.com

One of the big changes with SQL Server 2005 is the evolution of SQL-DMO to the new SMO managed code assemblies. Author Raj Vasant brings us quite a bit of code to show how this can be used to script your objects.

Dual Processor vs Dual Core

by Additional Articles

Other

Miscellaneous

Will multiple processors or a dual core processor be beneficial to you, and what are the differences between them? These are the questions this article will attempt to lay to rest.

Finding Gaps in a Sequential Number Sequence

by Stephen Lasham

SQLServerCentral.com

SQL Puzzles

Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.

Securing Your WCF Service

by Additional Articles

Other

Miscellaneous

In this article I will show you how you can implement security on a WCF service. There are many options and extensibility points for implementing security in WCF. You can also use specific products, such as the Windows 2003 Server Authorization Manager, together with WCF to implement the authorization requirements of a solution. Out of the box, WCF supports Windows credentials, Username Tokens and X.509 Digital Certificates as security credentials.

Stored Procedure vs Triggers

by Gulappa Vijaya Kumar

SQLServerCentral.com

Performance Tuning

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.

SSIS: Using InfoPath XML Files in SSIS XMLSource Adapter

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This article describes how to work around these potential problems. The issues mentioned in this article is not only specific to InfoPath files, it can also be referenced in other similar situations as well.

Picking Service Accounts

by Steve Jones

SQLServerCentral.com

Administration

It is something you do rarely, but with SQL Server 2005 and ten services, there are more decisions to make. Steve Jones gives some advice on which service accounts to choose and some common problems with others.

Red Gate Photo Competition!

by Additional Articles

Redgate

Product News, Releases, and Upgrades

Most of the time, it's the simplest tools that have the biggest impact on our lives. If you have a camera and believe, like Leonardo DaVinci, that simplicity is the ultimate sophistication, then why not enter Red Gate's Ingeniously Simple Tools photo competition...
To enter is simple. All you need to do is send us a photo of your favorite, simple tool.

Getting Started with Master Pages and Themes

Implementing Data Security in a Report Model

Script Database Objects with SMO

Dual Processor vs Dual Core

Finding Gaps in a Sequential Number Sequence

Securing Your WCF Service

Stored Procedure vs Triggers

SSIS: Using InfoPath XML Files in SSIS XMLSource Adapter

Picking Service Accounts

Red Gate Photo Competition!

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

When the Token Meter is Zero

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Question of the Day

The Data API Builder MCP Server Tools