Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Exploring the window functions in SQL Server 2005
- SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's how to use the OVER(…) clause to gather a collection of statistics. Window functions in SQL Server 2005 have nothing to do with Microsoft Windows; rather, they create data...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Construction, Databases, Arthur Fuller, SQL Server window, window, clause, Window Function, SQL Server Newsletter, TechRepublic Inc., Enterprise Software, Software, Data Management
- Technical articles 2007-03-19
Additional Resources
- SQL SERVER 2000 in WINDOWS SERVER 2003
- Hi,I had encountered the sql server error 10061 attempting to connect SQL server on WIN98. There is no error on Win XP Pro. Can anyone help?here are the settings:1. only one WINDOW SERVER 2003 in the network with Active Directory activated.2. only one WIN XP pro in the network3. only...
- Tags: alex@..., hardware, Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft Windows, Microsoft Windows 98, Microsoft Windows Server, Microsoft Windows Server 2003, network, server, sql, windows
- Discussion threads 2005-10-23
- How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
- This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management
- White papers 2001-07-19
- SQL: Window Functions
- Window functions enable the user to look at different levels of aggregation in the same result row. They make it easy to specify cumulative sum, moving average, share-of, and many other important calculations. Window functions are supported in Oracle where they are known as analytic functions and DB2 (where they...
- Tags: Function, Window, SQL, O'Reilly Media Inc., Construction, Data Mining, Databases, Enterprise Software, Software, Data Management
- Book chapters 2006-04-01
- Transferring SQL Server logins between servers or instances
- I recently 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. [poll=11] I...
- Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren
- Blog posts 2007-09-25
- Some resources on SQL Server 2005
- Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner
- Blog posts 2005-11-11
- Fast Track DBA
- I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...
- Tags: Programming languages, Databases, jabney@..., SQL, server
- Discussion threads 2005-06-14
- EMS SQL Manager 2008 for SQL Server (zip)
- EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...
- Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development
- Software downloads 2007-12-20
- Make the jump from SQL Server 2000/7 to SQL Server 2005 with these notes and tips
- There are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently released SQL Server 2005. Migrating from SQL Server 2000 or SQL Server 7 to SQL Server 2005 is not a project...
- Tags: Microsoft SQL Server, Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Download resources 2006-02-07
- Microsoft SQL Server Query Processor Internals and Architecture
- This article examines how Microsoft SQL Server queries are processed on the client, how the various clients interact with SQL Server, and what SQL Server does to process clients' requests. Hopefully, knowing how SQL Server processes your queries, and how and when it compiles them or recompiles them, will allow...
- Tags: Processor, Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
- White papers
- Best Practices for Upgrading to SQL Server 2005
- It is not difficult to move from SQL Server 7 or SQL Server 2000 to SQL Server 2005. The key to any successful upgrade is preparation and researching potential problems. Talk to stakeholders, level with them, and get their support, and the upgrade will be a success. SQL Server 2005...
- Tags: Microsoft SQL Server, Best Practice, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- White papers 2008-02-19
- Teratrax Performance Monitor (msi)
- Monitor SQL Server performance on all enterprise servers from a single interface. Analyze and chart real-time and historical execution of SQL code across users and applications. Isolate SQL Server hardware utilization and correlate it with SQL statements and SPs. Be the first to know about slow and failed SQL Server...
- Tags: Microsoft SQL Server, SQL, Databases, Enterprise Software, Software, Data Management
- Software downloads 2006-06-16
- EMS SQL Manager 2008 Lite for SQL Server (zip)
- EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...
- Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
- Software downloads 2007-12-20
- SQL 2000 server/ODBC
- Hello. I have installed SQL server 2000 personal edition on a desktop PC to establish a local SQL server for databases connecting via ODBC data source. When I attempt to SQL server verify authenticity of the databases login id, it tells me "connection failed"...SQL server error 11001...SQL...
- Tags: hardware, Microsoft SQL Server, ODBC, rcelentano@..., server, SQL
- Q&A 2005-04-26
- SQL Server 2005
- Can someone tell me what the best tools for creating, editing, and designing queries, functions and views for SQL Server 2005? I want to create some cool complex queries.The query window, a knowledge of SQL, database design and intellect.You should also be aware that unnecessarily complex queries are not cool.
- Tags: Databases, Enterprise software, willgates@..., Microsoft SQL Server 2005, Microsoft SQL Server
- Discussion threads 2007-04-26
- What's New in SQL Server Agent for Microsoft SQL Server 2005 Beta 2
- This paper provides an overview of new features for the SQL Server Agent job scheduling service for Microsoft SQL Server 2005 Beta 2. SQL Server Agent for SQL Server 2005 Beta 2 provides a more robust security design than earlier versions of SQL Server. This improved design gives system administrators...
- Tags: Agent, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Real Estate, Enterprise Software, Software, Data Management, Business Operations
- White papers 2004-09-02
- 5 SQL Scripts for Novice DBA
- If you are a new SQL Server database administrator DBA, a developer who has been recently given new DBA responsibilities for a SQL server, or an administrator who has to manage a SQL server as part of your network, then we have some free scripts that can help you. In...
- Tags: Microsoft SQL Server, server, SQL
- Blog posts 2006-01-04
- Infopath and SQL Connectivity Error
- Hi I am unable to connect to sql server from infopath. Under SQL Server Login providing the username and password I get the following error :-Connection failed:SQL State:'08001'SQL Server Error : 17[DBNETLIB][ConnectionOpen (connect).]SQl server dows not exist or access denied
- Tags: Databases, Programming languages, connecttreesh@..., SQL, Microsoft SQL Server, Microsoft InfoPath
- Discussion threads 2007-07-12
- MSDN Webcast: Introduction to Microsoft SQL Server 2005 Express Edition (Level 300)
- SQL Server Express is based on SQL Server 2005 technology and includes the unique Application XCopy feature. However, its networking and security features differ from other SQL Server 2005 editions. This webcast examines the differences between SQL Server 2005 Express Edition and the rest of the SQL Server 2005 family....
- Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, SQL Server Express, Databases, Enterprise Software, Software, Data Management
- Webcasts 2005-11-08
- How do I run code automatically when SQL Server starts?
- The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. Today, consultant Tim Chapman gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on...
- Tags: Stored Procedure, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, John Sheesley
- Blog posts 2008-11-10
- << Previous
- page 1 of 1
- Next >>
