SSEUtil.exe is a tool that lets you easily interact with SQL Server. Among other things, it allows you to: • Connect to the main instance or user-instance of SQL Server. • Create, attach, detach, and list databases on the server. • Upgrade database files to match the version of the server. • E

(Baya Pavliashvili) After you have populated your dimensional database (as discussed in the previous article in this series), you’re ready to build Analysis Services cubes (Analysis Services is free when you purchase SQL Server 2000). The tool that lets you build and manage cubes with Analysis Servi

(scott) If you want to build your own UI front end to SQL Server Reporting Services, one web method you’ll need to become familiar with is GetReportParameters. GetReportParameters will return metadata about the parameters in a report, including names, types, and valid values.

(Brian Walker) This tip continues the system stored procedure series with a routine to list information about SQL Server connections or perform actions for selected connections. (R)

(Eric Hanson, Gail Erickson, Lubor Kollar and Jason Ward) This document describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.

(Vinod Kumar) Also called as RDB this is a new concept in SQL Server 2005 which I thought was worth taking a look at. In previous version of SQL Server 2000 whenever we had to upgrade a system defined object we had to drop and recreate. And rollback of the same was also something that we as DBA’s ha

(Paul Litwin) Normalization to 3rd normal form (or higher) is a good thing. For example, in the pubs database, in order to model the fact that a given author can write more than one book, and that a given book can have multiple authors, you have to model the many-to-many relationship between author

(Kevin Beaver) SQL injection is a security exploit in which the attacker adds SQL code to a Web form input box to gain access. Manual testing for SQL injection — as described in this tip and this paper — used to be the only way to determine if your database was vulnerable. Rooting through returned

(Adam Machanic) If you are preparing to upgrade your company’s precious mission-critical systems to SQL Server 2005, it’s hardly an exaggeration to say that you need all the help you can get. Be sure to proceed with caution, however, as an installation hiccup could cost your company thousands of dol

(Arthur Fuller) Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many of the proponents of the dynamic argument are web or Access developers, or developers of some other front end. Developers in the canned camp tend to be DBAs