TechRepublic : A ZDNet Tech Community

1 Resources for

sql server management

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

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...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, SQL Server Management Studio, Databases, Guest Contributor, Enterprise software, SQL Server Management, server, SQL Server Newsletter, Solution, Tool, SQL Server 2005 Management Studio, SQL Server Integration Services, Software, Data Management
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 --...
Tags: Databases, Enterprise software, Microsoft SQL Server, SQL Server 2005 Express Edition, SQL Server 2005 Express, Microsoft SQL Server 2005
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...
Tags: Microsoft Visual Studio, Sams Publishing, Microsoft SQL Server, Microsoft SQL Server Management Studio, Tool, Chapter Coverage, Databases, Enterprise Software, Software, Data Management
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...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, Scott Lowe, Databases, Enterprise Software, Software, Data Management
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,...
Tags: Microsoft Developer Network, Microsoft Visual Studio, Webcast, Mobile, Microsoft SQL Server, Microsoft Visual Studio 2005, Microsoft Corp., Mobile Application, Microsoft SQL Server Management Studio, Databases, Enterprise Software, Software, Data Management
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...
Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Database Management, Microsoft SQL Server Management Studio, Databases, Storage, Enterprise Software, Software, Data Management, Hardware
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.
Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server Management Studio, Databases, Productivity, Enterprise Software, Software, Data Management
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
Tags: programming, sql server, software, business@..., Microsoft SQL Server Management Studio, Microsoft SQL Server, DTS, server
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...
Tags: Recruitment & Selection, Databases, kornbit660@..., window, job, Microsoft SQL Server, server management
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...
Tags: SQL Server Management Studio Express, SQL Server Management, Microsoft SQL Server Management Studio, Microsoft SQL Server
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...
Tags: Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Guest Contributor, Enterprise software, SQL Server Newsletter, Business Intelligence, Microsoft SQL Server Transact-SQL, Microsoft SQL Server 2000, SQL Server 2005 Reporting Services, Software, Data Management
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. ...
Tags: Login, Microsoft SQL Server, Server, Script, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Steven Warren
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...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Scott Lowe MCSE, Upgrade Advisor
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...
Tags: common table expression, Microsoft SQL Server, Microsoft SQL Server 2005, Scott Robinson, server, Service Broker, SMO, XML-Data
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...
Tags: database, full-text search, Joshua Hoskins, Log Shipping, Microsoft Corp., Microsoft SQL Server
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...
Tags: Event, Microsoft SQL Server, Trace, Microsoft SQL Server 2005, Option, Execution Plan, SQL Server Management Studio, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
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...
Tags: Sql Server, sql backup, restore, databases, Data Recovery, Backup
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...
Tags: Database, Subscriber, Agent, Microsoft SQL Server, Data, Server, Replication, Microsoft SQL Server 2005, Publication, Joshua Hoskins
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...
Tags: Task, Database, Microsoft SQL Server, Goal, Backup, Index, Microsoft Corp., Microsoft SQL Server 2005, Maintenance Plan, User Database, SQL Server Profiler, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
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...
Tags: Microsoft Outlook, Microsoft SQL Server, Microsoft SQL Server 2000, Server, SQL, E-mail, SQL Mail, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2008-05-21
  • << Previous
  • page 1 of 1
  • Next >>


IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now
IT Professional's Guide to Policies and Procedures, Third Ed
Whether you're creating policies for management, training, personnel, support, privacy, Internet/e-mail usage, security, or inventory, you'll meet the needs of your entire enterprise with this one download!
Buy Now

Boost Business Productivity