SQL Server 2005 will soon be coming to market. In this episode we meet with James Hamilton and Tom Rizzo who outline some of the specific features and capabilities of SQL Server 2005 that will allow programmers as well as database developers to create better database-oriented solutions.

(Mike Gunderloy) If you’re a developer who works with SQL Server, you probably already know about SQL Profiler, the graphical tool that lets you capture and analyzer SQL Server events in real time. If you’re not familiar with this tool, check out my previous article, “Introduction to SQL Profiler”.

(Don Franke) As programmers, when building data-driven Web sites we typically focus our energies on defining what information needs to be accepted by the end user, and ensuring that this data is properly entered into some backend data store properly via a Web interface. After all, if a Web appli

(Margie Semilof) Improved security in SQL Server 2005 is the No. 1 reason database professionals will tell their senior managers why they need to start planning a move up to Microsoft’s newest database management platform when it becomes available later this year. (R)

(Julia Lerman) The Microsoft .NET Framework 2.0 delivers an updated ADO.NET that will streamline your data access development efforts. The ADO.NET team has worked with both the System.Xml team and the SQL Server team to provide a consistently rich developer experience, crossing technology bounda

(Lisa Vaas) SQL Server 2005 will likely be a dud at delivering high-performance computing, according to a new report from Forrester Research Inc.

(Muthusamy Anantha Kumar) When installing SQL Server, regardless of versions and editions, SQL Server database administrators tend to choose the default collation and sort-order, which is SQL_Latin1_General_CP1_CI_AS. Though case insensitiveness makes the life of the database developers and database

(John Fontana) Microsoft next month will finally ship the long-awaited 64-bit editions of its latest server and client operating systems–and the move is just the tip of a 64-bit iceberg.

The Log Shipping feature in Microsoft SQL Server 2000 Enterprise Edition is an automated process that sends transaction logs from one server to another. You can use Log Shipping to create a warm standby server for your production server.

(William Pearson) In this article, we will explore another tool that MSAS offers for the enhancement of cube processing, the Optimize Schema option. Optimize Schema attempts to identify unnecessary joins between our fact and dimension tables, and then to remove them. In many cases, the tool works ef