(Leo Peysakhovich) As usually, most of my articles started with a specific task for my company. I am not looking for the article but the articles are finding me. Ones upon a time (starts like all those magic stories) I placed a question to myself – “How many columns in the corporate database are not
Other News
A SQL Server cluster resource goes to a ‘failed’ state when you try to bring the resource online in SQL Server 2000
When you try to bring a SQL Server cluster resource online for a virtual instance of Microsoft SQL Server 2000, you may notice the following behavior: • The SQL Server cluster resource goes to a ‘failed’ state and does not come online. • You receive a combination of the following error messa
Comparing HTML Reporting and MS SQL Server Reporting Services
(Terry Voss) I thought I had it made, using my own HTML reporting methods for Web appliactions and Crystal Reports foe Windows applications, but a new tool is now of interest. With MS SQL Server Reporting Services I now have one solution for reports for Web and Windows forms applications.
Code Access Security and .NET
Just about everything has changed in one way or another in .NET, and security is no different. Before I worked at my current job, I had done a fair amount of .NET work but most of our stuff was done the old school way. We deployed to external customers exclusively, and used traditional install scr
Backing up a database with split mirroring
(Roger Sanders) A split mirror is an “instantaneous” copy of a database that is made by mirroring the disk(s) that contain the database’s data, and splitting the mirror when a backup copy of the database is required. Mirroring is the process of writing all database data to two separate disks (or
Learn to Write XAML Applications Today with Xamlon
(Alex Hildyard) XAML is an XML-based markup language that describes UI content and behavior. The concept is similar to the combination of HTML and JavaScript used in Web applications today, but far more ambitious. “Avalon” is the codename for the runtime that interprets XAML documents and turns them
Clustering for Indexes
(James Koopmann) There is nothing spectacular about using indexes per say. However, on many occasions I have come across a variety of SQL coders that never consider validating that the index they think they are using is efficient or even being used at all. We can all put indexes on the columns that
10 Steps to a Successful Versioning and Deployment Strategy for .NET
(Michele Leroux Bustamante) A well rounded versioning and deployment strategy considers several overlapping and interdependent .NET Framework concepts. The development process must include a strategy around strongly named assemblies. Code access security and runtime security policy must be evaluated
Checksum Transformation
(Darren Green) The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services
Workload Management for DB2 Data Warehouse
(C. Nin Lei) This IBM Redpaper addresses the workload management issues encountered in a data warehouse environment. It delivers a set of guidelines for overcoming these obstacles by utilizing the z/OS Workload Manager. It also provides tips and techniques for properly implementing a Workload Manage