=================================
Our email address has changed! To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.
=================================
1. Commentary - Where Do I Find It in SQL Server 2005?
2. News - PDF Version of SQL Server 2005 System Table Map Poster
1. ==== Commentary ==== Where Do I Find It in SQL Server 2005? by Michael Otey, mikeo@windowsitpro.com
If you're used to SQL Server 2000 and have just upgraded to SQL Server 2005, you might find yourself lost in the maze of new features and interfaces, and many tools have either changed or moved. Here's how to find some of your favorite tools in SQL Server 2005.
The SQL Server Service Manager When you upgrade to SQL Server 2005, you might wonder whether the upgrade actually worked because the SQL Server Service Manager icon is gone. Fortunately, that's normal. You can access the tool's replacement, the SQL Server Configuration Manger, in two ways. From the Start menu, select All Programs, SQL Server 2005, Configuration Tools, SQL Server Configuration Manager. Or you can right-click My Computer, select Manage, and open the Services and Applications Node.
Enterprise Manager Next, you'll see that Enterprise Manager has been replaced by the SQL Server Management Studio, which does all the things Enterprise Manager did and more. Management Studio is faster when you're working with a large number of objects and servers. Plus, most of its dialog boxes are non-modal, which means you can more easily work on multiple tasks simultaneously.
Query Analyzer Query Analyzer, the developer and DBA mainstay, has been replaced by Query Editor. Start this new tool by using the New Query button in Management Studio. Query Editor still lets you write and run T-SQL queries,and you can also integrate it with Visual SourceSafe version control. However, Query Editor lacks Query Analyzer's T-SQL debugging capability. You need to use a Visual Studio 2005 Database project to debug T-SQL scripts.
Analysis Services Manager Microsoft has radically changed the management and development profiles for SQL Server 2005 Analysis Services. Analysis Services Manager is replaced by a combination of Management Studio and the Business Intelligence Development Studio (BIDS). Management Studio lets you manage Analysis Services and perform backups. BIDS handles creating and deploying cubes.
DTS Designer The DTS Designer is replaced by the new SQL Server Integration Services (SSIS) Designer. Unlike the DTS Designer, which you start by using Enterprise Manager, the SSIS Designer starts through BIDS. Open BIDS and select File, New, Project, Business Intelligence Projects, Integration Services project.
Import Export Wizard Probably the most vexing change in SQL Server 2005 is the apparent disappearance of the Import Export Wizard. Instead of starting the wizard from the Start menu, you must first open BIDS, open an SSIS project, then right-click the SSIS Packages node in the Solution Explorer?not exactly an intuitive process. Alternatively, you can start the Import Export Wizard by typing dtswizard.exe (yes, it's still dtswizard) at the command prompt.
2. ==== News ==== PDF Version of SQL Server 2005 System Table Map Poster http://lists.sqlmag.com/t?ctl=255CC:610454
A PDF version of the popular SQL Server 2005 system table map poster is now available for download to all SQL Server Magazine UPDATE readers. The poster download, sponsored by ProClarity, provides unique, indepth information about one of the most fundamental changes in the new release. The new system tables give you access to internal SQL Server 2005 system information that has never before been available and is not documented anywhere else.
Microsoft partnered with SQL Server Magazine to create this visual representation of the most important views and relationships to help SQL Server pros understand the logical layer that Microsoft created between the DBA and the underlying physical system tables from the perspective of performance, activity, and maintenance. The print version of the poster was inserted into the December 2005 issue of SQL Server Magazine, and is available to new magazine subscribers through a special subscription offer.
To download the PDF version, click here http://lists.sqlmag.com/t?ctl=255CC:610454
------------------- Manage Your Account You are subscribed as news-and-stuff@arconati.us. To unsubscribe from this email newsletter, click here http://lists.sqlmag.com/u?id=28351AE7DCFB1F6CFEAB1EF4F8C0667E
To manage your email account, simply log on to our Email Preference Center. http://lists.sqlmag.com/t?ctl=255CE:610454
View the SQL Server Magazine Privacy Policy. http://lists.sqlmag.com/t?ctl=255CD:610454
SQL Server Magazine is a division of Penton Media, Inc., 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department
Copyright 2006, Penton Media, Inc. All Rights Reserved.
No comments:
Post a Comment
Keep a civil tongue.