MCITP Self-paced Training Kit: Maintaining a Microsoft SQL Server 2005 Database (Microsoft Offical Course, 2780B): 
Microsoft Official Course 2779A Implementing A Microsoft SQL Server 2005 Database Course (C90-04955, PArt Number... a
Windows Hosting - PEER 1
Low Cost Ultrafast Windows Hosting. Hi-Performance,Free Setup. Chat Now
SQL Database
Get the World's Fastest Database. 24/7 Support Available. Free Trial!
Embeddable SQL Database
Fast, Compact, Secure, Scalable SQL RDBMS. Try InterBase Free!
Power & Cooling with AMD
See how AMD delivers strong server performance without compromise.
New SQL Resource Kit
Easy SQL tools for non-programmers Download a Free 30-Day Trial.
I'm using Microsoft SQL Server Management Studio Express on my PC, I'm hoping there is a similar free tool I can get for my Mac.
By using a mac, you are going to lose all the functionality that is provided by the SSMS GUI. Can you still perform most of your job yes....( and btw, i prefer using my mac), however the GUI does provide some convenient features.
1. Solution
With the UAFS tool, users can automate the process of application compatibility testing to determine any issues that may arise from upgrading to SQL Server 2012 from SQL Server 2008. UAFS also helps verify that an SQL Server applications query results will remain the same once a database upgrade is complete. Previous versions of the tool covered upgrades from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008. Highlights of the 2012 version include improved replay accuracy and throughput thanks to its use of the SQL Server 2012 Distributed Replay Manager, as well as a more user-friendly results display from leveraging the power of SQL Server 2012 Reporting Services.
President and founder of Scalability Experts Raj Gill discussed some of the benefits of UAFS in the official press release: The Upgrade Assistant for SQL Server 2012 is a vital tool in helping SQL Server customers observe and compare their database applications on their current platforms as well as new versions of the Microsoft database platform. This new version of the upgrade assistant will expand support for all supported in place upgrade paths to SQL Server 2012. SE has partnered with Microsoft to help thousands of customers and partners upgrade to new releases of SQL Server with this tool.
Learn about expanded SQL Server 2005 database mirroring capabilities from EMC's Chad Sakac, senior practice manager for databases and ...
It could say "Native Client 2005", or "Native Client 2008" or "Native Client 2008 R2". RESOLUTION: If it's not present, you must install it. For SQL Server 2005, The file comes in two varieties: sqlncli. CHECK: If connecting to SQL Server 2005/2008, make sure the SQL Server Native Client is installed....
|
750 pages |
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts ... |
|
|
Microsoft® SQL ServerTM 2005: Database Essentials Step by Step Get the guidance you need to start designing databasesone step at a time. |
|
767 pages |
Microsoft SQL Server 2005 reporting services Generate and distribute comprehensive, integrated reports Transform disparate corporate data into business intelligence with help from this hands-on guide. |
|
704 pages |
Microsoft SQL Server 2005: A Beginner''s Guide The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, ... |
|
645 pages |
Microsoft SQL Server 2005, the complete reference The book goes on to cover the management and maintenance tools, the SQL Server support of the .NET Common Language Runtime, database integrity, transactions, ... |