Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- MSDN Webcast: T-SQL Enhancements in SQL Server 2005 - Level 200
- By now people have heard that one can write stored procedures in C# and VB .NET for SQL Server 2005. Does that mean TSQL is dead? NO! A lot has changed in the world of TSQL for SQL Server 2005. The attendee of this webcast will learn about the new...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Webcasts
- MSDN Webcast: Using Transact-SQL for Recursive Queries in SQL Server 2005 (Level 300)
- Microsoft SQL Server 2005 is the first version of SQL Server that supports recursive queries and implementing a standard recursive Common Table Expression CTE. This webcast explores recursive CTEs and demonstrates how to use them to answer common requests against graph structures. Using an employee organizational chart as an example...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Webcasts
- MSDN Webcast: SQL Server 2005 Masterclass: The New Features of T-SQL in SQL Server 2005 (Level 300)
- The demands on databases keep increasing-demands to use them in new ways, and demands to sort across new relationships. Wouldn't it be nice if something came along to make database development easier? Something has come along: Transact-SQL (T-SQL) in Microsoft SQL Server 2005.This webcast describes the new features of T-SQL...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Webcasts
- 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 (ObjectSearch)
- 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
- Microsoft is knocking on your door, Oracle.
- That's an OS issueYou mentioned Linux SQL Server will never be available for.All serious IT application service providers I've worked for are running AIX, Solaris, HP/UX, Tru64 and ... Linux for large scale applications some hundreds of terabytes of data The large scale application OS world is a UNIX world....
- Tags: Databases, Programming languages, Enterprise software, Operating systems, Microsoft SQL Server Transact-SQL, MS-Office, frank.schafer@..., Oracle Corp., PL/SQL, Microsoft SQL Server, Microsoft Corp., server, Linux, SQL
- Discussion threads 2007-10-24
- 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
- How to use constants to handle Jet and Transact SQL conflicts
- Many Access databases are upsized to SQL Server, and usually that means a lot of work because the two databases use different versions of SQL. A perfect example is wildcards, which often appear in WHERE clauses. Specifically, Jet uses the asterisk character (*) to match any string. T-SQL uses the...
- Tags: Microsoft SQL Server Transact-SQL, Database, Version, Susan Harkins
- Blog posts 2007-08-12
- 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: Databases, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, database administrator, database, hardware, GUI, mouse, server
- Image galleries 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
- Optimize database code to boost performance
- Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid. As .NET developers, we often find ourselves waist deep in SQL Server queries and stored procedures. A good example...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Databases, Tony Patton, Performance management, .NET, clause, Having Clause, database, performance, .NET Newsletter, Microsoft .NET, Query, Problem, Server, Creation, TOP Operator, Storage, Human Resources, Workforce Management, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2006-09-26
- Return resources to the system to improve .NET performance
- A common problem in the .NET platform is the consumption of system and database resources when developers fail to clean up after themselves when working with a database. Tony Patton notes that you can avoid such problems by releasing objects back to the system. The promise of .NET's garbage...
- Tags: Microsoft .NET, Storage, Databases, Tony Patton, .NET, Application servers, Middleware, performance, database, Microsoft SQL Server Transact-SQL, server, .NET Newsletter, Method, Problem, Connection, Exception, Database Connection, ADO.NET Connection Class, Hardware, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
- Technical articles 2006-08-15
- T-SQL querying multiple tables based on certain conditions
- Hi,I have a situation where i need to query multiple tables (12 tables) within a database for records containing values that are listed in another table and also based on a certain conidition.Specifically, i have a EMP table with a list of employee names, date of joining, office address etc....
- Tags: EMP, lavan_baloo@..., software, Microsoft SQL Server Transact-SQL
- Discussion threads 2007-02-12
- Handle errors in the data tier with SQL Server
- Handling exceptions in your .NET application code is a simple and straightforward process with try/catch code blocks, but you can monitor exceptions on the database tier as well. We examine error handling in your database code with SQL Server and T-SQL. Developers work hard to graciously handle exceptions so...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Databases, Tony Patton, .NET, server, RAISERROR statement, database, .NET Newsletter, Parameter, Microsoft .NET, Severity, Error, SQL Server Online Help, ROLLBACK TRANSACTION Statement, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2006-06-06
