Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Defining SQL Server constraints with TSQL
- Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects. All competent DBAs and developers should possess the ability to logically define constraints in the...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, server, SalesHistory, SQL Server Newsletter, Constraint, Column, Table, TSQL, OBJECT_ID, SaleID, SaleDate, SalePrice, Listing D, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-05-07
- Easily manage directories with .NET's Directory class
- Problem with Listing DListing D is written in 'C', and not VB although it is easy enough to understand and translate into VB.
- Tags: Microsoft development tools, Programming languages, gfiori@..., Listing D, Microsoft .NET
- Discussion threads 2007-05-04
- Working with .NET files via the Path class
- The .NET Path class, which allows you to work with file path values, uses string values to perform all of its operations. Learn how the class uses various properties and methods to perform operations. Developers often need to know certain aspects of a file such as the name,...
- Tags: Microsoft .NET, Middleware, Tony Patton, .NET, Microsoft development tools, Programming languages, Path class, .NET Newsletter, Microsoft .NET Framework, Class, Listing B, Path, Path String, Code Snippet, Listing D, Microsoft Windows, Application Servers, C#, Operating Systems, Software Development, Software/Web Development, Software, Enterprise Software
- Technical articles 2007-04-24
- Scaling out with distributed partitioned views in SQL Server 2005
- A distributed partitioned view joins data from one or more SQL Server databases. You can design these views in such a way that the query optimizer will know which table to pull data from in your query. I have examined the differences between scaling up and scaling out...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Servers, Databases, server, database, SQL Server Newsletter, Data, View, Table, SalesHistory, SaleID, Schema Validation, Listing D, Enterprise Software, Hardware, Software, Data Management
- Technical articles 2007-04-02
- Developing Bluetooth wireless applications in J2ME
- Peter Mikhalenko reviews the principles of Java development for Bluetooth on mobile devices and describes how to write a Java application for Bluetooth communications. A growing number of cellular phones support Java applications, but did you know that many devices can also run Java 2 Micro Edition...
- Tags: J2ME, Java, LocalDevice, RemoteDevice, Bluetooth, Wi-Fi, Peter V. Mikhalenko, Programming languages, JSR 82, JSR 82 specification, Java Bluetooth API, specification, Java Tips Newsletter, Device, Server, Wireless Application, Service, Peter Mikhalenko, Bluetooth API, DiscoveryAgent, Listing C, Service Discovery Service Discovery, Listing D, Wireless
- Technical articles 2007-03-28
- Easily manipulate data with the GridView control in ASP.NET 2.0
- Tony Patton recently introduced ASP.NET 2.0's GridView data control and covered the basics of using it. In part two of this series, he demonstrates how the GridView control makes it easy to view, edit, and delete data. Last week, I introduced ASP.NET 2.0's GridView data control and covered the...
- Tags: Microsoft ASP.NET, GridView, Middleware, Tony Patton, .NET, Microsoft development tools, ASP.NET 2.0, server control, HTML Text, TemplateField, .NET Newsletter, Data, Server, Microsoft ASP.NET 2.0, Listing B, SqlDataSource, SqlDataSource Element, Listing C, Listing D, Software Development, Software/Web Development, Enterprise Software, Software
- Technical articles 2007-03-06
- Post data to other Web pages with ASP.NET 2.0
- ASP.NET 2.0's PostBackUrl attribute allows you to designate where a Web form and its data is sent when submitted. Tony Patton explains how you can make use of this new Web solution. Standard HTML forms allow you to post or send data to another page or application via...
- Tags: Web, Microsoft ASP.NET, Middleware, Tony Patton, .NET, ASP.NET 2.0, .NET Newsletter, Page, Data, Property, Microsoft ASP.NET 2.0, Web Page, PreviousPage, Listing C, Listing D, Software Development, Software/Web Development, Enterprise Software, Software
- Technical articles 2007-01-30
- 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
- Dealing with ASP.NET's view state
- ASP.NET's view state feature allows you to save Web Form properties across different server requests. Tony Patton explains why it's important to use this feature with care. One of the more exciting features of ASP.NET is the view state concept. It allows you to save Web Form properties...
- Tags: Microsoft ASP.NET, Tony Patton, EnableViewState, Middleware, .NET, Microsoft development tools, Programming languages, view state, Page Class, .NET Newsletter, Page, Control, Feature, Listing B, Listing D, Software Development, Software/Web Development, Enterprise Software, Software
- Technical articles 2006-12-05
- Work with multiple data values with arrays
- Arrays are a basic feature of the .NET languages. They allow you to easily work with multiple data items in one container. Tony Patton tells you more about using arrays in your code. Arrays are a basic feature of most development languages. Arrays are mechanisms that allow you...
- Tags: C#, Tony Patton, .NET, Programming languages, Microsoft development tools, Microsoft Visual Basic.Net, .NET Newsletter, Microsoft .NET Framework, Array, Difference, Value, Listing B, Listing D, Listing F, Software Development, Software/Web Development, Development Tools
- Technical articles 2006-10-17
- Work with multiple data values with arrays
- Arrays are a basic feature of most development languages. Arraysare mechanisms that allow you to treat several items as a single collection andto easily work with multiple data values. The .NET Framework provides arraysupport in a variety of ways. In this article, I examine the basics of usingarrays to work...
- Tags: C#, Microsoft Visual Basic.Net, Tony Patton, Value at Risk
- Technical articles 2006-10-17
- Handle bulk binding exceptions in PL/SQL
- The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue. Bulk binding in PL/SQL is an important technique for efficient...
- Tags: Oracle Corp., PL/SQL, SQL%BULK_EXCEPTIONS, Listing C, Databases, Bob Watkins, Programming languages, FORALL, SAVE EXCEPTIONS, Oracle Tips Newsletter, Downside, UPDATE, Listing D, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-08-21
- Performing basic array operations in VB.NET
- VB.NET offers a simple way of grouping data into the array structures similarly to other languages. This article explores array declaration and usage. The ability to work with arrays is important in any programming language. VB.NET offers a simple way of grouping data into the array structures...
- Tags: Microsoft Visual Basic.Net, Irina Medvinskaya, Microsoft development tools, Programming languages, .NET, Visual Basic Tips Newsletter, Array, Listing B, Listing D, Development Tools, Software Development, Software/Web Development
- Technical articles 2006-07-27
- Control data caching in .NET with the Caching API
- Decreasing page load time is imperative when dealing with Web site performance. Tony Patton explains how you can make this happen by using the .NET Caching API. Caching frequently accessed or expensive data in memory boosts application performance by reducing the number of database calls to retrieve...
- Tags: Microsoft .NET, API, Control Data, Middleware, Tony Patton, .NET, Microsoft development tools, specific item, Caching API, .NET Newsletter, Cache, Method, Microsoft ASP.NET, Signature, Object, Listing B, Insert, Insert Method, Get Method, Listing D, Application Servers, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Development Tools
- Technical articles 2006-06-30
- Increase Web site performance with ASP.NET caching
- Caching frequently accessed Web page data is one way to positively impact a Web application's performance. Find out how ASP.NET makes it easy to cache data. While functionality is the number one goal of Web development, performance seems to be a close second. After all, a site that...
- Tags: Web, Microsoft ASP.NET, Middleware, Tony Patton, .NET, Performance management, Channel management, Microsoft development tools, Page Output, performance, .NET Newsletter, Parameter, Data, Web Site, Microsoft ASP.NET 2.0, Perception, Listing B, Listing D, Software Development, Software/Web Development, Enterprise Software, Software
- Technical articles 2006-06-27
- Look up values in SQL Server using range joins
- Arthur Fuller wants to shake up developers' assumptions that joins are always tests of equality. He explains that there are lots of ways to join, and demonstrates how you can use range joins to match a potentially large number of rows. It's a myth that joins are always tests...
- Tags: Microsoft SQL Server, Arthur Fuller, Databases, Network technology, server, join, SQL Server Newsletter, TechRepublic Inc., Row, Table, Listing D, Listing E, Listing F, Listing G, Listing H, Insurance, Financial Planning, Enterprise Software, Business Operations, Corporate Insurance, Finance, Software, Data Management, Networking
- Technical articles 2006-05-15
- Get real-world examples for applying network troubleshooting methodologies
- A few weeks ago, David Davis wrote an article about choosing a network troubleshooting methodology and introduced you to three approaches to network troubleshooting. This week, he revisits those approaches and offers up some real-world examples for applying them to your network. A few weeks ago, I wrote an...
- Tags: NETWORKING, Network technology, David Davis CCIE, MCSE+I, SCSA, Layer 1, bottom-up approach, Ethernet, network, Ethernet cable, OSI, Cisco Routers and Management Newsletter, DNS, PC, IP, IP Address, Subnet, Listing B, David Davis, Listing C, Default Gateway, Listing D
- Technical articles 2005-11-17
- Incorporate SQL Server UDFs in your .NET applications
- User Defined Functions UDFs are a powerful feature that every developer who works with SQL Server needs to know. Learn how to incorporate UDFs in your next .NET project. Database interaction is a standard feature of most .NET applications, with SQL Server as the popular choice for the...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft .NET, Microsoft SQL Server, Databases, Tony Patton, .NET, Middleware, Database interaction, User Defined Function, .NET Newsletter, Function, Method, Procedure, User-defined Function, Listing B, Scalar, Listing D, Enterprise Software, Software, Data Management
- Technical articles 2005-10-18
- Utilize XML to store configuration settings
- I was working with developers recently who are new to the.NET environment, and they were scratching their heads at the concept ofstoring configuration information. They were stuck on the older concept ofusing initialization ini or text files. I steeredthem away from this avenue toward a more appropriate .NET avenue via...
- Tags: XML, Tony Patton, Microsoft .NET, C#
- Technical articles 2005-09-27
- Utilize XML to store configuration settings
- The .NET Framework provides many ways to track application data, with its inherent XML support providing the perfect vehicle for maintaining this data. Take a closer look at storing application data in an XML file. I was working with developers recently who are new to the .NET environment,...
- Tags: Microsoft .NET, XML, C#, Tony Patton, .NET, Programming languages, Microsoft development tools, Middleware, .NET Newsletter, Microsoft .NET Framework, Microsoft Corp., Application Data, Microsoft Visual Basic.Net, Listing B, Listing C, Listing D, Software/Web Development, Web Development, Software Development
- Technical articles 2005-09-27
