(Dan Clark) With the release of Reporting Services, Microsoft has provided a truly enterprise-level reporting solution. Reporting Services provides support for the entire reporting life cycle including report authoring, report management, and report delivery.

(Allan Mitchell) Package configurations are now the prescribed way of being able to set values within your package from an outside source. One of the options for the source is Parent Package Variable. The name is perhaps a little misleading so this article is meant to guide you through this slight c

(Thiru Thangarathinam) The integration of the common language runtime (CLR) into Microsoft SQL Server2005 gives developers much more flexibility than ever before. This new feature lets you author stored procedures, triggers, and user defined functions and types using managed languages such as VB.NET

(Vinod Kumar) One of the key features introduced in SQL Server 2005 is the new DTS platform. With the new release of SQL Server Beta 2, you must be eager to get your hands dirty on this new amazing platform. This product does bring in a new perspective and new thinking the way we used to work with D

(CJ Kelly) What good is a firewall when you can crack more than 50% of the passwords on the network?

(William Pearson) In this lesson, we will introduce a function that can technically be classified as either a string or a numeric function, depending upon which of two choices we make in its syntax. Whichever of the two options we select, the IIF() function returns one of two possible values, based

(Rahul Sharma) Yukon is safe! Microsoft has addressed a lot of security concerns in its next release of SQL Server (code-named Yukon). Rahul Sharma counts the ways Microsoft enhancements ensure that you can run your business securely with no worries about security lapses.

(Tom Pullen) One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memo

(Mark Whitehorn) Whatever the reason for its popularity, we cannot afford to ignore XML, and neither can Microsoft. As Mark Whitehorn explains, the new version of SQL Server will have several ways of handling XML, some inherited from SQL Server 2000 and some entirely new.

(Dale Elizabeth Corey) Are you working in a large enterprise where your databases are of extreme value and security of that data is the utmost of importance? Are you looking for a real-time, active Microsoft SQL Server database intrusion protection system (Db-IPS) that directly monitors database