(Ged Mead) Quite often as I browse through the VB.NET Forums on vbCity I see questions about tasks that can be quite difficult in WinForms, but would be much easier to deal with using WPF. One recent question that fits this description is the following one: “I am wondering how I can change a spe
Other News
Extend WebSphere Portal with OmniFind Enterprise Edition search solution
(Ajay Wanchoo) Learn how to implement IBM OmniFind Enterprise Edition as a search engine with IBM WebSphere Portal. This tutorial introduces the two products, describes the advantages of using them together, and details how to integrate them. You’ll examine the architecture, see how to install the p
Password Management Enhancements in Oracle 11g
Starting with Oracle 11g, passwords have become case sensitive, provided you choose to upgrade to “new security standards” during the database creation. Before 11g, database passwords were case insensitive. One can connect to user using password in upper case, lower case or mixed case no matter how
Adding simple trigger-based auditing to your SQL Server database
(John Galloway) How do you track changes to data in your database? There are a variety of supported auditing methods for SQL Server, including comprehensive C2 security auditing, but what do you do if you’re solving a business rather than a security problem, and you’re interested in tracking the fol
Compression Strategies
(Sunil Agarwal) In the previous blogs, I had described the data compression in SQL Server 2008 and its implications on CPU and IO. One of the question that keeps coming up is ‘Should I compress my database? Or Why SQL Server does not provide an option to compress the whole database’. I am not sugges
Indexing NULLs: (Empty Spaces)
(Richard Foote) There have always been issues with NULLs and indexes. The main issue being of course if the indexed columns are all null then the associated row is not indexed.
Implementing Custom Logging in SQL Server Integration Services (SSIS) Packages
(Ray Barley) We have quite a few SSIS packages that we run on a regular basis to extract data from our OLTP systems and transform/load into our data warehouse. We would like to capture some basic information about these SSIS packages such as what packages were run, when, how long did they take to r
SQL Server 2008… Some Possibilities
Featured Article(s) Upload employee picture into a table (Vadivel Mohanakrishnan) This article explains one of the ways to upload an image into a table. The target audience of this article are ‘beginners to intermediate’ level of readers. SQL Server, The OS, Counters… It All Matters Keep track of the different key vital signs for your SQL Servers, from the various […]
SQL Server Version Treadmill
Featured Article(s) Understanding Authentication, Authorization and Impersonation in ASP.NET (Part II) In the earlier part in this series we had a look at what Authentication is and how it is used. We also discussed the types of authentication supported by ASP.NET and we learnt how we can implement Forms Authentication in ASP.NET. In this and the concluding part of this […]
XML Template Engine/Code Generator in .NET
(Tomislav Stare) This article presents one way you could build an XML Template Engine that processes or parses XML templates and generates code. The engine can be used as an alternative to XML/XSLT template engines available out there. Compared to them, the template transformation or code generation