.NET Development for SQL Server News
September 14, 2005
Two site editors square off on the topic of SQL Server versus Oracle, a debate with equally loud fans on either side of the issue.
February 09, 2005
After two decades with the same underlying technology, SQL Server is in need of a facelift, Microsoft says. At the Professional Developers Conference, Microsoft vice president Gordon Mangione revealed some early features of Yukon, the next version ...
.NET Development for SQL Server Get Started
Bring yourself up to speed with our introductory content
Another important new feature in SQL Server 2005 that is enabled by the integration of the .NET CLR is the ability to create true user-defined types (UDTs). Learn the best ways to utilize them in this chapter excerpt. Continue Reading
Creating .NET-based user-defined functions (UDFs) is another new feature that's enabled by the integration of the .NET CLR. Learn more about them in this chapter excerpt. Continue Reading
No discussion of the new CLR features would be complete without a description of the security issues associated with using .NET assemblies and the SQL Server CLR. Find out how you can improve your CLR security. Continue Reading
Evaluate .NET Development for SQL Server Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here. Continue Reading
See if SQL server consolidation is right for you with this checklist, taken from Chapter 1 of our e-book, Consolidate SQL Servers for availability, scalability and cost savings. Continue Reading
Manage .NET Development for SQL Server
Learn to apply best practices and optimize your operations.
Creating Windows PowerShell scripts helps manage SQL Server 2008 objects, databases and other instances. This tip covers two PowerShell snap-ins that aid the navigation of the SQL Server component hierarchy. Continue Reading
There are several criteria required for certificates to be properly loaded by SQL Server 2005, when upgrading. SQL Server 2005 expert Adam Machanic addresses concerns. Continue Reading
Get code samples to extract column values to native .NET data types. Continue Reading
Problem Solve .NET Development for SQL Server Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong. Continue Reading
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert. Continue Reading
Having difficulty retrieving images from a SQL Serve database to a VB.Net application? Get best practices to retrieve, store and manage SQL Server images. Continue Reading