New & Notable
.NET Development for SQL Server News
September 25, 2018
A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
June 11, 2018
The looming Microsoft-GitHub pairing confirms the company's rebirth as an open source friend. Data tools on the Azure cloud are part of the motivation.
March 21, 2018
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
November 21, 2017
Microsoft Connect(); 2017 saw the addition of MariaDB and Cassandra to the Azure cloud database lineup. Also discussed: A set of Spark-based analytics services called Azure Databricks.
.NET Development for SQL Server Get Started
Bring yourself up to speed with our introductory content
Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine. 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
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 ... Continue Reading
Manage .NET Development for SQL Server
Learn to apply best practices and optimize your operations.
Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. Continue Reading
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
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