(Steven Warren) Do you not have a full-time DBA to keep Microsoft SQL Server databases running according to industry standards and best practices? Sometimes even DBAs want to test their SQL Servers against various best practices. In the past, you would have to tweak your SQL Server settings manually
Other News
Use Oracle 10g Single-Sign-On with .NET applications
(Sanjeev Malik) Today’s enterprise-wide systems are becoming increasingly sophisticated with a variety of operating systems and software development platforms. This presents the constant challenge of integration, which requires creative ways of configuring products from multiple vendors to work in t
Use XSLT to prepare XML for import into OpenOffice Calc
(Uche Ogbuji) The popular open source office suite OpenOffice.org is XML-savvy at its core. It uses XML in its file formats and offers several XML-processing plug-ins, so you might expect it to have nice tools built in for importing XML data. Unfortunately, things are not so simple, and a bit of
Auditing Through Triggers
(Robert Marda) In this article I will give code examples for a few triggers. For an excellent explanation about triggers in general and how they work in SQL Server 7.0 and SQL Server 2000 please see the following articles written by Brian Kelley: Triggers in SQL Server 7.0 and 2000 – The Common Grou
FIX: Section names are truncated to a total length of 254 characters when you use Data Transformation Services to create a Dynamic Properties task and you add an .ini file in SQL Server 2000
In Microsoft SQL Server 2000, when you use Data Transformation Services (DTS) to create a Dynamic Properties task and you add an .ini file that contains more than 254 characters in section names, the section names are truncated to a total length of 254 characters. Therefore, one of the section names
Multiple Columns DropDown for ASP.NET
(Jayarajan S Kulaindevelu) There are many dropdown controls out there for the web, but I have not seen any dropdown controls which can show multiple columns like in VB or MS Access, so I thought of building my own control, which will display the columns based on the selection made in a SQL statement
Obtain Different Portions of a SQL Datetime Field
(Hani Greiss) SQL has the habit of displaying date fields as: yyyy-mm-dd 00:00:00.000. But sometimes, you need to display just the Date or just the Time from a date field.
Custom Events in VB.NET 2005
(Bill Horst) This article provides an introduction to Custom Events, a new language feature in VB.NET 2005. Custom Events allow the user to specify what to do when AddHandler, RemoveHandler, and RaiseEvent are called for an event.
Automatic SQL Tuning using SQL Tuning Advisor
(Sreeram Surapaneni) SQL tuning is one of the challenging tasks faced by Database Administrators. It is an interesting and creative, but at the same time, daunting task. Manual tuning of SQL statements requires through knowledge of how the statements are executed in the background and experience to
Create ActiveX servers for PL/SQL packages
(Scott Stephens) When you’re tuning database applications, your first impulse may be to follow the manuals’ examples and start coding database logic directly into your code. Find out why a better approach is to treat the database server as a real server. (R)