
	Where results make sense

Topic: SQL Server

	Microsoft SQL Server 2005: SQL Server 2005 Overview
		SQL Server 2005 delivers powerful, familiar tools to IT professionals as well as to information workers, reducing the complexity of creating, deploying, managing, and using enterprise data and analytical applications on platforms ranging from mobile devices to enterprise data systems.
		SQL Server offers integrated development tools for the database engine, data extraction, transformation, and loading, data mining, OLAP, and reporting that are tightly integrated with Microsoft Visual Studio to provide end-to-end application development capabilities.
		SQL Server 2005 simplifies the development, deployment, and management of line-of-business and analytical applications by providing a flexible development environment for developers and integrated, automated management tools for database administrators.
	www.microsoft.com /sql/prodinfo/overview/default.mspx (927 words)

	A Secure SQL Server
		The SQL server administrator is authorized to run any code chosen by himself inside the SQLSERVR.EXE with the use of the xp_cmdshell, the xp_regwrite or self-created procedures.
		If the ordinary users of the SQL server service are to be allowed to run the commands of the operating system, then the xp_cmdshell extended procedure has to change the security token for one which is less privileged than the one inherited from the SQLSERVR.EXE service's process.
		The SQL Server service should not be allowed to modify the data in the directory in which the data used for running the service is stored, i.e.
	www.windowsecurity.com /articles/Secure_SQL_Server.html (4226 words)

	Microsoft SQL Server - Wikipedia, the free encyclopedia
		SQL Server is commonly used by businesses for small- to medium-sized databases, but the past five years have seen greater adoption of the product for larger enterprise databases.
		SQL Server 7.0 was the first true GUI based database server and was a rewrite away from the legacy Sybase code.
		As a result, the relative strength and viability of SQL Server is directly affected by the relative strengths and weaknesses of the Microsoft platform, unlike Oracle and DB2 which both run on numerous platforms, including Windows and Linux.
	en.wikipedia.org /wiki/Microsoft_SQL_Server (1157 words)

	Download
		SQL Server Express is free to redistribute and can be seamlessly upgraded to more sophisticated versions of SQL Server.
		SQL Server Management Studio Express is installed by running the setup program for either SQL Server Express with Advanced Services or SQL Server Express Toolkit.
		SQL Server Express Forums for troubleshooting tips and answers to common questions.
	msdn.microsoft.com /vstudio/express/sql/download (837 words)

	SQL Server Express WebLog
		Use of SQL Express provisioning mechanism or the provisioning tool is targeted at installing SQL Express for use in an administrative environment, in fact, both SQL Setup and the provisioning tool require the user to have administrative privileges on the computer.
		Having SQL Express on Microsoft Update is a continuation of the work we started by making Service Pack 1 of the other Editions of SQL Server 2005 available on Microsoft Update.
		SQL Express will be detected when you scan your computer, right along with other Microsoft applications, and you will have the ability to select the update and have it applied to your computer.
	blogs.msdn.com /sqlexpress (8233 words)

	SQL Server Database Performance Tuning And Other Articles
		The ability to ask your questions in the SQL Server forum.
		Access to white papers, SQL Server jobs, free magazines, and more.
		While our main focus is on SQL Server performance, we also cover many other topics, including SQL Server clustering.
	www.sql-server-performance.com (197 words)

	SQLSecurity.com > Home (Site not responding. Last check: 2007-10-19)
		SQL 2005 Service Pack 2 is supposed to address this but it is still in beta.
		Wait for SQL 2005 SP2 before you make a move to Vista on any machines running SQL Server desktop editions.
		Since I've been relatively satisfied with SQL 2005 to date I addressed what I see as some annoyances as well as the ongoing issue of there still being way too many extended stored procedures available to the public role.
	www.sqlsecurity.com (897 words)

	SQL Database Application Development software tools provided by Quest Software
		Toad™ for SQL Server is a database development and administration tool that increases productivity and ensures optimal code quality for your SQL Server environment.
		The Debugger for Toad for SQL Server lets you code and debug the way you work, line-by-line and statement-by-statement, without having to change normal application execution or use cumbersome workarounds.
		With Toad for SQL Server’s Debugger, you can step through code one line at a time as it executes on the server, set conditional breakpoints, watch and modify variables, and view the execution stack.
	www.quest.com /toad_for_sql_server (866 words)

	O'Reilly Store -- SQL Server
		This book is designed for the system or database administrator, IT manager, and IT professional working with SQL Server because it covers four main topic areas: technologies and architecture; planning;… Read more.
		The SQL Server 2000 Black Book is an insightful guide to utilizing the power and flexibility of SQL Server 2000.
		A major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share… Read more.
	www.oreilly.com /pub/topic/sqlserver (343 words)

	SQL Server Forums at SQLTeam.com
		This forum is specifically for people that are working with SQL Server for the first time.
		This is for SQL Server topics that don't seem to fall into any of the other categories.
		This forum is for SQL Server data corruption issues and problems related to DBCC CHECKDB.
	www.sqlteam.com /forums (461 words)

	SQL Server database tools and management software from Quest Software
		Toad™ for SQL Server leverages the knowledge gained from our past experience with database development tools and empowers SQL Server developers and administrators of varying skill levels to rapidly create and execute queries, automate database object management and write, debug, and tune T-SQL code more efficiently.
		SQL Turbo is a revolutionary search tool which dramatically increases the speed of SQL Server’s free text retrieval while significantly enhancing the performance and data processing range of SQL Server Search applications.
		SQL Watch detects changes to the metadata of a SQL Server database notifying an administrator with the exact details of the changes with an emailed report.
	www.quest.com /sql_server (745 words)

	Microsoft SQL Server 2000
		SQL Server 2000 and MSDE will not be supported on Windows Vista
		In the SQL Server sysprocesses table output, the SQL Server process ID number (SPID) is less than 50 and shows a self...
		You cannot connect to a named instance of SQL Server 2000 by using the shared memory protocol after you remove the default instance
	support.microsoft.com /default.aspx?scid=fh;EN-US;sql (494 words)

	PHP: Microsoft SQL Server Functions - Manual
		DBLIB was developed for SQL Server 6.x where the max identifier length is 30.
		Installing the SQL Server client tools and using the Client Network Utility to change my settings to use named pipes resolved this issue.
		Well, ntwdblib.dll is not distributed with SQL Native Client 2005 versions anymore, but it is what you need to use the mssql family functions with php.
	www.php.net /manual/en/ref.mssql.php (2834 words)

	[No title]
		SQL Server 2005 provides all sorts of XML components, including utilities and APIs for simplifying working with relational and XML data such as XML Schema annotations for bi-directional mapping between relational databases and XML.
		SQL Server 2005's new XML data type is based on this standard.
		The SQL Standardization Committee — We're looking into mechanisms to leverage the work of the XQuery working group into existing SQL standard technologies, including mechanisms to query into SQL data types using XQuery, a subject I discussed at a recent talk at XML 2004.
	www.stylusstudio.com /michael_rys.html (2349 words)

	SQL Server Reference Guide (Site not responding. Last check: 2007-10-19)
		Microsoft provides a lot of free tools for SQL Server, and this week I'll show you another: The Best Practices Analyzer for SQL Server.
		SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters.
		The question on most SQL Server Data Transformation Services (DTS) users' minds is how Integration Services (IS) will affect their current packages.
	www.informit.com /guides/guide.asp?g=sqlserver (451 words)

	SQL Server Training - Online (Site not responding. Last check: 2007-10-19)
		This is designed to be a hands on class in developing with SQL Server 2000 Enterprise Edition.
		Software and System Requirements: These are the minimum system requirements for installing SQL Server 2000 Enterprise Edition.
		An evaluation version of SQL Server is available if the student does not have access to a database server running SQL Server.
	www.hwg.org /services/classes/sqlservertraining.html (575 words)

	DBAzine.com: SQL Server
		SQL Server 2005 and Express Installation Tips and Tricks
		In this article, author John Cook shows how to install SQL Server 2005, to minimize the number of steps.
		This week, a new concept from author and SQL Server expert Eric Charran, in his DBAzine “Creating and Deploying a Smart Client with Plug-Ins” series.
	www.dbazine.com /sql (247 words)

	SQL Server Developer Center
		SQL Server 2005 business intelligence technologies enable you to analyze data, explore patterns, integrate disparate data sources, and build reports that give you the power to make better business decisions.
		SQL Server 2005 includes a lot of changes to help make moving from Oracle to SQL Server easier, these include; - User Schema separation - Multiple Active Result Sets (MARS) - Synonyms - Recursive Queries(CTEs) and some other smaller issues.
		Hi, though i've been using sql server 2000 developer edition for awhile, I guess i overlooked the fact that the full-text search tool was never installed and i never needed it until now.
	msdn2.microsoft.com /en-us/sql/default.aspx (692 words)

	SQL Server vs Oracle
		One of the main Microsoft SQL Server 2000 advantage in comparison with Oracle 9i Database is that SQL Server is cheaper.
		SQL Server 2000 is generally accepted as easier to install, use and manage.
		Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.
	www.mssqlcity.com /Articles/Compare/sql_server_vs_oracle.htm (1052 words)

	SQL Server: Covering today's SQL Server topics
		Learn how to install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles.
		SQL Server Administration (General), SQL Server availability, SQL Server backup and recovery, SQL Server Security, SQL Server performance and tuning, SQL Server clustering, SQL Server DW/BI, SQL Server replication...
		SQL Server performance tuning A to Z: From testing and monitoring to tuning and troubleshooting, you're sure to find a tip or tool to help you resolve your SQL Server performance dile...
	searchsqlserver.techtarget.com (434 words)

	SQL Server Frequently Asked Questions (Site not responding. Last check: 2007-10-19)
		How can I find what is default on my SQL Server for sort order and character set.
		I frequently use SQL Agent and I notice jobs are put on hold while others run.
		I have examined the memory usage of my SQL Server and find sqlservr.exe is using most of the server memory even then the server has no connections.
	www.sqlservercentral.com /faq/listfaq.asp?categoryid=2 (3169 words)

	SQL Server Magazine - The Smart Guide to Building World-Class Applications
		SQL Server 2005 Compact Edition is similar to its predecessors, but the new name isn't the only change in this latest release.
		SQL Server logs can make troubleshooting problems simplerâ”if you know where to look.
		Here are 5 SQL Server 2005 log files that might come in handy.
	www.sqlmag.com (628 words)

	SQL Server Training - Online
		Students will be introduced to the basics of using SQL Server on the Web.
		MS SQL Server installed on a Windows computer.
		He has the honor of being a member of the first Compaq Computer/Microsoft Corporation Designated Master Accredited Systems Engineer SQL Server team to achieve this distinct certification in the United States.
	www.hwg.org /services/classes/sqlserver.html (490 words)

	FTPOnline - SQL Server (Site not responding. Last check: 2007-10-19)
		Check out these essential articles on SQL Server to help with your programming and administration needs, from Visual Studio Magazine's and Windows Server System Magazine's database experts.
		You'll learn to speed up queries and improve performance, understand how SQL Server fits in with Microsoft's platform strategy, and more.
		Use one of SQL Server 2000's newer features to write efficient and.
	www.fawcette.com /resources/spcollections/sql/default.asp (728 words)

	Database Journal: Microsoft Sql Server Administration News, Articles, Scripts, Tutorials, Forums, And Resources for the ...
		This study from The Edison Group proves that Oracle Database 10g is easier to manage than Microsoft SQL Server 2005.
		This article explores the benefits and various methods of using Microsoft SQL Server to analyze IIS Web Server log files.
		Part 37 of this series presents Derived Column transformation, which, while serving primarily an auxiliary role, should not be ignored, since it offers significant flexibility in the areas of logical and math operations, string processing, and data conversion.
	www.databasejournal.com /features/mssql (841 words)

	What is SQL Server? - A Word Definition From the Webopedia Computer Dictionary (Site not responding. Last check: 2007-10-19)
		SQL Server Info - Get Info on SQL Server from 14 Search Engines in 1.
		This article details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).
		Hands On Technology Transfer: Microsoft SQL Server Training - Instructor-led SQL Programming and SQL Server Administration courses, 75 cities in the US, Canada, and UK.
	www.webopedia.com /quick_ref/SQL_Server.html (399 words)

	SQL Server Express - Easy to Use
		SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005.
		Free to download, free to redistribute, free to embed, and easy for new developers to use immediately, SQL Server Express includes powerful features such as SQL Server Management Studio Express, for easily managing a database.
		Easily move or copy your SQL Server Express databases to another computer or hosted server using XCopy and ClickOnce deployment.
	msdn.microsoft.com /vstudio/express/sql (202 words)

	SQL Server Central - Microsoft SQL Server community with 391,919 Microsoft SQL Server users
		While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS.
		SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.
		SQL Server 2000 has table valued functions that are very useful in many ways.
	www.sqlservercentral.com (806 words)

	SQL Server - FunctionX
		Microsoft SQL Server is a product used to create computer databases on a Microsoft Windows operating system.
		This is an attempt to create a semi-complete SQL Server for a bank.
		The DataGrid control of the.NET Framework provides an easy means of displaying data from a table or a view of a SQL Server database to the control through a DataSet object.
	www.functionx.com /sqlserver (313 words)

	SQL Server Help, SQL Server Tutorials, SQL Server Programming, SQL Server Code
		SQL Server is a relational DMBS written for the Windows platform by Microsoft.
		SQL Server is a high-end and high-performance solution, for applications that interact with a database.
		SQL Sever: Storing Code in Binary or Text Files Rather than Stored Procedures
	www.devarticles.com /c/b/SQL-Server (815 words)

Try your search on: Qwika (all wikis)