(Jose A. Gonzalvo) This article presents a small command prompt utility to help you document your SQL Server/MSDE database.

(Dinesh Asanka) It has been around two months since I wrote the first partof this series, and I was waiting to get some comments on the previous article. Nevertheless, most of the people are still not using InfoPath 2003 as much as me!! Anyway, let me continue with my findings on this new tool. Toda

(Rudy Limeback) I have a table with the following info: Task Start Finish Sleep 01-oct-04 19:00 02-Oct-04 07:00 Awake 02-oct-04 07:00 02-Oct-04 20:00 Sleep 02-oct-04 20:00 03-Oct-04 02:00 Not a very exciting life really! If I were to report what I did in a 24 hour

Microsoft Office Access 2003 projects that connect to a Microsoft SQL Server 2000 database can be deployed by using the Package Wizard that is included with the Microsoft Office Access 2003 Developer Extensions. In an Access 2003 module, you can attach code that can automate the following required s

(Morris Lewis) Login security is the first step in securing a server. The basic premise is that an attacker cannot hurt what he cannot see; therefore, you will spend a lot of time ensuring unauthorized users never log into SQL Server successfully. It may seem as though authenticating logins should b

(Gunther Lenz, Francois Bronsard and Jean Hartmann) A common complaint of database administrators (DBAs) is that performance bottlenecks are not among those problems that one can fix “by just throwing hardware at it.” Thus, database servers must provide tools and techniques to help administrators ad

(G Vijayakumar) Last time, I wrote an article and focussed on Using SELECT, Views and Stored Procedures in SQL Server. I was quite glad to differentiate the three and its Pros & Cons. I was not even given much importance of Trigger not because of NO TIME. To be honest, I was just a beginner i

(Darren Green) When developing your own custom components for that more professional, and also practical, finish you may want to use your own icon rather than relying on the default system icon. You set this through the IconResource property of the appropriate component attribute; DtsTask for a cont

(William E. Pearson, III) In this article, we will continue the examination of distinct counts we began in our previous article, Considering DISTINCT COUNT. Having discussed why distinct counts are useful, and often required, within the design of robust analysis and reporting applications, we descri

SQL Server 2005 allows users to write managed code that runs on the server. Visual Studio 2005 makes it easy to build stored procedures, functions, triggers, data types and aggregates in managed code. Milind Lele shows how to create, deploy, and debug a user defined data type (UDT) in Visual Basic.