Using new location-aware data types in SQL Server 2008
Learn how leverage location based data using Microsoft SQL Server 2008 from C# applications and combine them with interactive maps.
Learn how leverage location based data using Microsoft SQL Server 2008 from C# applications and combine them with interactive maps.
The results you get out of any performance prediction exercise are bound to be wrong. The goal is to make them as least wrong as possible. Rob Bogue will help you understand how to avoid getting them too wrong.
In many business applications, it is crucial to know how data has changed over time. For developers, this is not a new problem; many different solutions have been created to log changes. But creating a log is time-consuming. Read on to learn how SQL Server 2008 can help you save time and work more effectively.
Learn to build a text DSL in MGrammar.
Old school programming, whereby the programmer reads control values and writes inline SQL, still works, but it's so 90s. If you are new to WinForms or Web programming but experienced, peruse the article and then master LINQ.
Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.
Learn modeling and M development with the Oslo CTP SDK.
Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.
Learn to how to make SQL Server Integration Services a part of Windows Workflow Foundation.
Discover how to use nullable types when retrieving data from your database.
Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.
Discover how to use the XamlReader to dynamically create a Datatemplate. Then, see how you can bind to a Dataset and display the data in a ListView control (via a sample application pointing to the Northwind database).
Discover how you can utilize SQL Server transactions when nesting calls to stored procedures.
Expose your SQL Server data directly over the web. Learn to create SOAP-based native web services in SQL Server 2005/2008 that can be consumed from client applications over HTTP.
William Vaughn clarifies a misunderstanding regarding the ReportViewer Control.
Many WPF demos focus on slick graphics and designer user interfaces. While this is all good, those regular business database applications will eventually make the transition from WinForms to WPF. Learn how to get started accessing business data in your WPF applications.
LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.
Pulling your hair out trying to get the SQL Server 2008 Sample AdventureWorks databases installed? If so, you've come to the right place; this article makes it easy(ier).
Enterprise data is the lifeblood of a corporation, but it's useless if it's left to languish in data silos. Data warehousing and mining provide the tools to bring data out of the silos and put it to use.
Developers working at all levels of experience can take advantage of this technique. Discover how to invoke a stored procedure with parameters using the AddWithValue method of the SqlParameterCollection to define SQL parameters in one step.
Learn how to build Unit tests and generate sample data for your database development projects.
Need a fast database that won't bloat your application? Try this fast b+tree record manager with a small footprint, especially good for embedded device environments.
Store XML data directly in SQL Server. Use the power of the XML data type to store and manipulate XML data efficiently and easily.
ADO.NET 3.0 and the ADO.NET Entity Framework are designed to let you spend less time writing SQL and database plumbing code and more time working in the space of the problem you are trying to solve.
Discover how reporting applications can adapt to changing reports by shifting its report-related information into a database.