Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Configure IT Quick: Use SQL Profiler to diagnose SQL Server performance issues
- Use Profiler templates, event traces, and other monitoring tools to fix problems with your SQL server.SQL Profiler can help you diagnose SQL Server performance issues quickly and easily. This graphical tool lets you monitor SQL Server events based on criteria you choose. You can use it to trace events and...
- Tags: Programming languages, Databases, performance, Steven Warren MCSE, MCDBA, information technology, SQL Profiler, TSQL Statements, SQL, Microsoft SQL Server, SPID
- Technical articles 2002-09-19
Additional Resources
- Script Table definitions using TSQL
- Generating scripts in SQL Server using TSQL has never been easy. In today's SQL Server tip, I will show you how you can use TSQL in SQL Server 2005 code to script a table's definition. by Tim Chapman
- Tags: Microsoft SQL Server, Server, TSQL, @TableName, CAST, CASE, @Definition, OBJECT_NAME, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-08-18
- 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
- Fashion Statements (zip)
- Fashion Statements is designed to deliver the latest in high quality fashion and political/artistic apparel. All fashion statements come in three colors and can be printed for transfer to t-shirts, coats, and other apparel. Fashion Statements can also be used as posters or wall hangings. Make a fashion statement with...
- Tags: Apparel, Statement, Wall, Fashion Statements, Construction
- Software downloads 2006-05-23
- Using IntelliSense in SQL Server 2008
- Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, IntelliSense, SalesHistory, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-15
- VistaDB 3 (exe)
- VistaDB is a fully managed and typesafe embedded SQL Server alternative database engine developed in C# for .NET. ASP.NET, Mono and WinForms support for building desktop, mobile and server apps, SQL Server 2005 compatible data types, T-SQL syntax, TSQL Procs, Unicode support, Blowfish encryption, Visual Studio 2005 / 2008 integration,...
- Tags: Microsoft Visual Studio, Microsoft SQL Server, Microsoft Visual Studio 2005, Server, Microsoft SQL Server 2005, VistaDB Software, VistaDB, Microsoft Development Tools, Databases, Enterprise Software, Development Tools, Software Development, Software/Web Development, Software, Data Management
- Software downloads 2008-10-28
- Fashion Statements for Women (zip)
- Fashion Statements for Women is designed to deliver the latest in high quality fashion and political/artistic apparel. All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coats and other apparel. Fashion Statements for Women can also be used as posters or wall hangings. Make...
- Tags: Apparel, Women, Gender And Diversity, Human Resources
- Software downloads 2006-05-24
- Fashion Statements for Men (zip)
- Fashion Statements for Men is designed to deliver the latest in high quality fashion and political/artistic apparel. All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coats and other apparel. Fashion Statements for Men can also be used as posters or wall hangings. Make...
- Tags: Apparel, Wall, Construction
- Software downloads 2006-05-25
- Mission Statements are a waste of time
- Great Mission StatementsMy favourite story about mission statements was told to me by British Motivational Speaker, "Business Hypnotist" and Coach Gary Outrageous. As a "feel good" piece in his talks, he gets people singing "Bring Me Sunshine",
- Tags: ProjectCoach, mission statement, Mission Statement, Bring
- Discussion threads 2006-11-13
- Assess a SQL Server database developer applicant's skills with this TSQL test
- If a SQL Server database developer aces the verbal portion of the interview, a TSQL test is the perfect way to ascertain the true level of their programming skills. Tim Chapman presents 10 questions that will thoroughly test an applicant's TSQL expertise. Last week, I presented a list of...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, server, Sale Price, applicant, database, SQL Server Newsletter, Programming, TSQL, Enterprise Software, Software, Data Management
- Technical articles 2006-10-23
- Better Workload, Better Testing
- One of the most important processes for testing the impact of system changes - both hardware and software - on a database is setting up a test environment that faithfully represents the database's actual workload. Although it's possible to write SQL statements that reflect business functionality, it's a task that...
- Tags: Statement, SQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware
- White papers 2008-01-01
- Write PIVOT queries in SQL Server 2005
- SQL Server 2005's PIVOT operator allows you to rotate row level data into tabular data without the use of the CASE statement. Tim Chapman describes why this new operator has a place in the TSQL developers' toolbelt. New to SQL Server 2005 is the PIVOT operator, which gives...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Tim Chapman, CASE statement, PIVOT operator, statement query, CASE statement query, SQL Server Newsletter, Problem, Data, Statement, Operator, Difference, Listing B, PIVOT, CASE, Listing C, PIVOT Clause, Listing D, Enterprise Software, Software, Data Management
- Technical articles 2006-12-18
- SQL Server Yukon: Advantages of the new PIVOT operators
- Yeah,a great leap forward!:).You must know your pivot columns ahead of time!Where as in Access they are created dynamically if desired.For a true replacement of the Access crosstab dynamic pivot functionality on sql server check out the RAC utility at www.rac4sql.net.Like Access but much more powerful with many features/options.And RAC...
- Tags: CLR, Microsoft Access, Microsoft SQL Server, new PIVOT operator, PIVOT, PIVOT operator, rog11228@..., SQL Server Yukon, TSQL
- Discussion threads 2004-10-14
- General SQL Parser .NET version (zip)
- General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete...
- Tags: Microsoft .NET, Statement, SQL, General SQL Parser, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-12-07
- Easy code archiving in SQL Server 2005
- DBA Tim Chapman extols one of the virtues of SQL Server 2005 is the ability to return the entire code of an object from a system function. He notes that this function will make it much easier to archive your procedure code. As a database administrator, I always try...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Backups, archiving, database, procedure code, backup, SQL Server Newsletter, Function, Procedure, Code, System Function, OBJECT_DEFINITION, Enterprise Software, Software, Data Management
- Technical articles 2007-01-12
- Network statements
- I was under the impression that the network statements in EIGRP didn't need any mask information, that they were the same as for RIP and IGRP ie #network 10.0.0.0. The article indicates that a wildcard mask is needed just like in OSPF
- Tags: jusdownunder, eigrp, networking, network
- Discussion threads 2005-10-07
- Fine-Grained Auditing for Real-World Problems
- Traditional Oracle Database auditing options lets track the actions users perform on objects at the macro level - for example, if one audits for SELECT statements on a table, he or she can track who selected data from the table. However, people don't know what they selected. With data-manipulating statements...
- Tags: Oracle Corp., Statement, Trigger, Databases, Productivity, Enterprise Software, Software, Data Management
- White papers
- Indexing XML Documents With DB2 9 pureXML
- Just like relational indexes, XML indexes on DB2 9 pureXML are used to improve the performance of queries. The user should always create indexes over frequently accessed data, resulting in significant performance gains for the select statements executed over the indexed data. Although indexes usually present very positive performance gains...
- Tags: Performance, XML Document, Statement, Index, IBM DB2, Performance Management, XML, Databases, Enterprise Software, Human Resources, Workforce Management, Software/Web Development, Web Development, Software, Data Management
- White papers 2006-05-01
- Microsoft JDBC Type - 4 drivers
- We are converting our legacy application to run on Java. We use ODBC drivers shipped with SQL Server 2000 to connect to the database. On the java side we began to use JDBC type 4 drivers. WE noticed that the sql statements being sent over to the database via jdbc...
- Tags: database, JDBC, Microsoft Corp., ORASU, software, SQL
- Discussion threads 2004-12-14
- SQL Tools Make Fast Work
- The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...
- Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2006-01-01
- << Previous
- page 1 of 1
- Next >>
