Sponsored White Papers, Webcasts, and Downloads
ZDNet Resources
- MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)
- This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, including the hierarchy ID data type, the FileStream object, table-valued parameters, and large user-defined types.
- Tags: microsoft sql server transact-sql, microsoft developer network, microsoft sql server 2008, webcast, microsoft sql server, databases, enterprise software, software, data management
- Webcasts 2008-06-04
- SQL Server 2005 T-SQL with Advanced Topics
- Instantly save $500 off the standard course price when you register on TechRepublic or ZDNet! Offer ends April 30, 2008.View Available Dates and LocationsIn this course, you'll start by learning about the basic features available in SQL Server, including how to design and create a database and...
- Tags: microsoft sql server transact-sql, microsoft sql server, microsoft sql server 2005, databases, enterprise software, software, data management
- Training 2008-04-01
- xSQL Object Search (exe)
- Search on one or all databases choose to find the objects that meet the search criteria on one database or on all databases in the selected SQL Server. Support all types of database objects from tables and views to CLR objects and Xml Schema Collections, you can search all database...
- Tags: microsoft sql server transact-sql, object, storage, databases, hardware, enterprise software, software, data management
- Software downloads 2008-02-14
- MSDN Webcast: New T-SQL and Engine Features, New Data Types for SQL Server Programmability (Level 200)
- With Microsoft SQL Server Compact 3.5 and Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile devices to their full desktop client computers, benefiting from the power of SQL...
- Tags: microsoft sql server transact-sql, microsoft developer network, webcast, microsoft sql server, server, microsoft corp., databases, enterprise software, software, data management
- Webcasts 2008-01-30
- Ubitsoft SQL Enlight (zip)
- Ubitsoft SQL Enlight is a software development tool targeted to database professionals who need to write, read and analyze Transact-SQL scripts. Ubitsoft SQL Enlight integrates with MS SQL Server 2005 Management Studio and MS Visual Studio 2005.Key features:reformat T-SQL code with set of customizable rules; summarize T-SQL script;T-SQL statements outlining;validate...
- Tags: microsoft sql server transact-sql, ubitsoft sql enlight, databases, enterprise software, software, data management
- Software downloads 2007-12-21
- MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300)
- This webcast on new T-SQL programmability features in Microsoft SQL Server 2008. It covers exciting new features such as new data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns), dependency management for database objects, procedure programming (i.e. table value parameter), data warehousing enhancements (i.e. Merge data manipulation language DML...
- Tags: microsoft sql server transact-sql, microsoft developer network, microsoft sql server 2008, data warehouse, webcast, microsoft sql server, microsoft corp., databases, business intelligence, storage, enterprise software, software, data management, hardware
- Webcasts 2007-12-04
- MSDN geekSpeak: Advanced T-SQL Techniques With Tobias Thernstrom
- The presenter of this webcast shares his knowledge and experience around a particular developer technology. The attendee of this webcast will hear about industry trends, new technology, real-world experiences and more. The presenter of this webcast shows some advanced T-SQL query techniques.
- Tags: microsoft sql server transact-sql, microsoft developer network, webcast, digital media, databases, consumer electronics, personal technology, enterprise software, software, data management
- Webcasts 2007-09-26
- Code Visual to Flowchart (exe)
- Code Visual to Flowchart is an automatic flow chart generator software. It can reverse engineering a program, create programming flowchart from code, mostly used on flowcharting a program and documenting source code. It can generate Bmp, PNG, Visio, Word, Excel and PowerPoint flowcharts document, help programmers to document, visualize and...
- Tags: microsoft sql server transact-sql, flowchart, fortran, microsoft visual basic, c, programming, programming languages, microsoft development tools, c/c++, scripting languages, development tools, .net, databases, software development, software/web development, web development, enterprise software, software, data management
- Software downloads 2007-07-11
- How Do I... Restore a SQL Server database to a new server?
- 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 carry out this task: SQL Server Management Studio GUI or T-SQL Command line. The...
- Tags: microsoft sql server transact-sql, techrepublic inc., microsoft sql server, server, databases, enterprise software, software, data management
- Download resources 2007-06-20
- Use cursors wisely in your T-SQL Programming
- T-SQL database developers and administrators with solid knowledge of the various cursor types and the syntax for declaring and using them will deepen their understanding of when and how to use cursors appropriately in this sample chapter from Inside Microsoft SQL Server 2005: T-SQL Programming . Closely examine multiple...
- Tags: microsoft sql server transact-sql, microsoft press, cursor, microsoft sql server 2005, databases, enterprise software, software, data management
- Book chapters 2006-10-04
- Exploit advanced T-SQL querying techniques: Aggregating and pivoting data in SQL Server 2005
- Take a detailed look at the internal architecture of T-SQL and unveil the power of set-based querying. Best practices, sample databases, and sample code in Inside Microsoft SQL Server 2005: T-SQL Querying help database developers and administrators master the intricacies of the programming language. Focus your investigation on data-aggregation techniques...
- Tags: technique, microsoft sql server transact-sql, microsoft sql server, microsoft press, microsoft sql server 2005, databases, productivity, enterprise software, software, data management
- Book chapters 2006-08-08
- Ruby on Rails chases simplicity in programming
- Ruby on Rails chases simplicity in programmingI brought this upat the last PAPPL meeting - but the idea was shot down by acclimation. It was agreed that this is but another Thesauraus-job on existing languages and worthy of being shot down by the People Against the Proliferation of Programming Languages.Agree...
- Tags: scripting languages, development tools, databases, ruby, programming, microsoft sql server transact-sql, stored procedure, ruby on rails
- Discussion threads 2005-10-31
- SwisSQL--SQL Server to Oracle Edition (exe)
- SwisSQL--SQL Server to Oracle Migration tool is an automated migration tool to convert stored procedures implemented in Microsoft SQL Server Transact SQL (T-SQL) into equivalent Oracle PL/SQL code. It automates more than 90% of T-SQL code conversion into PL/SQL. It provides productivity benefits by eliminating error prone manual effort. SwisSQL...
- Tags: microsoft sql server transact-sql, oracle corp., microsoft sql server, server, tool, databases, enterprise software, software, data management
- Software downloads 2005-03-25
- SQL Server Survival Guide for Network Administrators
- Microsoft's SQL Server can be a scary place, especially if you don't have much database experience. So we put together this resource to help guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon...
- Tags: microsoft sql server transact-sql, techrepublic inc., microsoft sql server, server, databases, enterprise software, software, data management
- Download resources 2005-01-05
- Microsoft T-SQL Performance Tuning Part 2: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using Indexing Strategies
- This paper describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer to achieve the same or similar results to those...
- Tags: microsoft sql server transact-sql, performance, microsoft sql server, server, microsoft corp., quest software inc., performance management, databases, human resources, workforce management, enterprise software, software, data management
- White papers 2005-01-01
- Microsoft T-SQL Performance Tuning Part 4: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using SHOWPLAN Output and Analysis
- This paper will teach you the basic techniques used to tune SELECT statements on Micosoft's SQL Server 2000 relational database management system. The paper will also teach you the techniques available using Microsoft's graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer, as well as...
- Tags: microsoft sql server transact-sql, performance, microsoft sql server, server, microsoft corp., analysis, quest software inc., productivity, databases, performance management, enterprise software, software, data management, human resources, workforce management
- White papers 2005-01-01
- SQL Server Survival Guide for Net Admins PDF
- This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL Reference introduces the fundamentals of T-SQL code and query building to help you find information in your database....
- Tags: microsoft sql server transact-sql, administrator, adobe pdf, microsoft sql server, server, databases, enterprise software, software, data management
- Download resources 2004-10-07
- Editing Transact-SQL Code in SQL Server 2005 Beta 2
- Management Studio is the primary tool for developing Transact-SQL queries in Microsoft SQL Server 2005 Beta 2. This paper introduces you to the Management Studio Transact-SQL editing facilities, highlighting some of its more interesting and compelling new features for Transact-SQL development. This paper explains how Management Studio differs from, and...
- Tags: microsoft sql server transact-sql, microsoft sql server, microsoft sql server 2005, management studio, databases, enterprise software, software, data management
- White papers 2004-10-01
- Translating Procedural Statements Between Oracle and SQL Server
- This white paper is intended to give a QUICK but thorough overview of the issues database users may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle's PL/SQL and Microsoft SQL Server's Transact-SQL procedural extensions to the ANSI SQL standard. The document should be equally...
- Tags: microsoft sql server transact-sql, database administrator, oracle corp., microsoft sql server, pl/sql, server, quest software inc., databases, programming languages, enterprise software, software, data management, software development, software/web development
- White papers 2003-02-12
- Transact-SQL Cookbook: Statistics in SQL
- In spite of the fact that the user can use SQL to generate statistics, it is not the papers intention to promote SQL as the best language for that purpose. As in any other situation, a strong dose of common sense is necessary. If the user needs a fast, easy-to-use...
- Tags: microsoft sql server transact-sql, statistics, sql, o'reilly media inc., programming languages, databases, software development, software/web development, enterprise software, software, data management
- Book chapters 2002-03-01
White Papers and Webcasts