Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 10 things you should know about SQL Server 2005 Management Studio
- SQL Server 2005 Management Studio is a phenomenal advance over the tools provided with SQL Server 2000. Check out the improvements in SQL Server Management Studio, which makes it easier to locate errors in your code and allows you to keep tabs on your reports. By Arthur Fuller and...
- Technical articles 2006-02-03
Additional Resources
- How do I? Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?
- With the release of SQL Server 2005 Express Edition and the SQL Server ManagementStudio Express, Microsoft has entered the small, free database market with a splashtrumping even their own Microsoft SQL Desktop Edition. SQL Server Management StudioExpress -- a full-featured management tool comparable to the legacy SQL Server EnterpriseManager --...
- Technical articles 2006-08-04
- Unleash the power of SQL Server Management Studio, Query Analyzer, and Visual Studio with these essential tools
- Master SQL Server Management Studio, Query Analyzer, and Visual Studio tools in this chapter download from Microsoft SQL Server 2005 Compact Edition. First, learn how to use SQL Server Management Studio and Query Analyzer to manage and manipulate the SQL Server database. Familiarize yourself with the Visual Studio...
- Book chapters 2007-09-10
- How do I... Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?
- With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. SQL Server Management Studio Express -- a full-featured management tool comparable to the...
- Download resources 2006-08-04
- MSDN Webcast: Using SQL Server Management Studio and Visual Studio 2005 to Build Rich Mobile Applications (Level 200)
- There are more Microsoft SQL Server 2005 Mobile Edition data management and data-oriented development tools than ever before. This webcast shows how to combine the power of SQL Server Management Studio and Microsoft Visual Studio 2005 to simplify development of SQL Server Mobile applications. The presenter explains data form generations,...
- Webcasts 2006-09-20
- MSDN Webcast: Overview of SQL Server Management Studio Express (Level 100)
- This webcast describes how to manage the Microsoft SQL Server 2005 Express Edition database using SQL Server Management Studio Express, a graphic and intuitive database management tool. The webcast shows how to use the wizards, manage the database, view the data structures, and use built-in tools like the query optimizer...
- Webcasts
- MSDN Webcast: Introducing the New SQL Server Management Studio - Level 100
- Get an overview of the new tools in SQL Server 2005, including SQL Server Management Studio, Database Tuning Advisor and SQLCMD. Also see the enhancements that have been made to existing tools such as Profiler and SQL Agent.
- Webcasts
- SQL Server Management Studio Express and Backwards Compatibility
- I downloaded the SQLServer2005_DTS.msi install and ran it on a workstation that has Microsoft SQL Server Management Studio v.9.00.1399.00installed and I was able to see the legacy Sql Server 2000 packages on another server. Works Great! My Issue is w
- Discussion threads 2006-11-30
- Can we window batch to run job in SQL server management
- I have 1 job to be run after checking txt file was generate so I wanna create batch file to check the txt file first if it was created then I will run job in SQL to load all data into DB.Can I create the batch file to do like...
- Discussion threads 2007-09-20
- Error 29506 while installing SQL Server Management Studio Express
- I'm trying to install SQL Server Management Studio Express on my PC running Windows XP Professional (SP2). Every time I try running it fails with an error at the very end of the installation.It ends with an error "The installer has encountered an unexpected error installing this package.This may indicate...
- Discussion threads 2008-02-26
- 10 things that will convince you to upgrade to SQL Server 2005
- Find out the 10 most compelling reasons why you should upgrade to SQL Server 2005. Several enhancements to the latest edition of SQL Server include Management Studio, SSIS, and built-in business intelligence. By Arthur Fuller and Stephen Giles Most IT pros are working in SQL...
- Technical articles 2006-03-13
- How do I... Transfer logins from one SQL Server 2005 instance to another?
- In my last How do I..., I discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. ...
- Blog posts 2007-09-25
- Make the jump to SQL Server 2005 with these notes and tips
- SQL Server isn't aproduct that Microsoft updates very often, so when they do release an upgrade,it has the potential to be significant. As such, there are a number of changesyou should understand before you begin planning the leap from SQL Server 2000 orSQL Server 7 to the recently released SQL...
- Technical articles 2006-02-07
- 10 things you should know about SQL Server 2005 features
- The fanfarefrom TechEd 2005 this past June wasvintage Microsoft: lots of happy noise about miraculous products withtongue-in-cheek delivery dates, as many of us suppressed a yawn. But let's givecredit where it's due; we've waited a long time for a new SQLServer, and the features Microsoft is delivering with its upgraded...
- Technical articles 2005-08-08
- A free fully functional database is yours with Microsoft's SQL Server Express
- With the release of SQL Server 2005 Express Edition and the Community TechnicalPreview release of SQLServer Management Studio Express, Microsoft has released a fully functionaldatabase system free of charge. There are, of course, limitations to both of these systems, but they offer a perfect jumping-on point for either those wishingto...
- Technical articles 2006-02-23
- Capture execution plans with SQL Server 2005 Profiler
- Execution plans are one of the best tools for diagnosing problem queries and for performance tuning queries on your SQL Server. Prior to SQL Server 2005, the only options for query executions were text plans or graphical execution plans for queries run by hand. In SQL Server 2005, you can...
- Blog posts 2008-01-14
- How Do I... Restore a SQL Server database to a new server?
- This blog entry is also available as a TechRepublic gallery and as a TechRepublic download.As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to...
- Blog posts 2007-06-20
- How do I... Configure transactional replication between two SQL Server 2005 systems?
- This blog post is also available as a TechRepublic gallery and TechRepublic download. Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical administrative tasks. This How do I... shows you...
- Blog posts 2007-08-29
- Create database maintenance plans in SQL Server 2005 using SSIS
- In SQL Server 2005, database maintenance plans are almost entirely created using SQL Server 2005 Integration Services SSIS. Microsoft provides a useful wizard to guide you through the creation process, but you are not required to use the wizard. This article shows you how to create a...
- Blog posts 2007-12-03
- How do I configure SQL mail in SQL Server 2000?
- As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that...
- Blog posts 2008-05-21
- << Previous
- page 1 of 1
- Next >>
