Email Alerts
-
Microsoft Visual Studio 2010 spotlight
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. IT SPOTLIGHT
-
.NET database object security
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. Tutorial
-
User-Defined Types
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. Tutorial
-
User-Defined Functions
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. Tutorial
-
Working with typed DataReader and SqlResultSet data
Get code samples to extract column values to native .NET data types. Book Excerpt
-
VB.NET timing out when backup changed to hourly
After changing transaction log backups from daily to hourly, one ITKnowledge Exchange member noticed that VB.NET was timing out. Find out what advice his peers have to offer. ITKnowledge Exchange Memb
-
SQL Server consolidation pros and cons
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. Checklist
-
Chapter 1: The case for SQL Server consolidation
This SearchSQLServer.com expert e-book, Consolidate SQL Servers for availability, scalability and cost savings by SQL Server MVP Hilary Cotter, will introduce you to the worlds of server and storage consolidation. In Chapter 1, Hilary will giv... Chapter Download
-
Face-off: Oracle vs. SQL Server
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. Article | 14 Sep 2005
-
.NET tools to be bundled in next SQL Server
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 of... Article | 09 Feb 2005
-
Eight ways that SQL Server developers hurt performance
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong. Tip
-
Creating Windows PowerShell scripts to manage SQL Server 2008 instances
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. Tip
-
Get status information for trace flag(s) currently turned on
The command DBCC TRACESTATUS can be used to get the status information for a particular trace flag currently turned on. Tip
-
Scalar functions for UNC file handling
Two quick little scalar functions that strip out the filename and filepath from a fully qualified UNC filename. Tip
-
Code to restore SQL Server databases in VB.NET
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert. Ask the Expert
-
Retrieve images from SQL Server and store in VB.Net
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. Ask the Expert
-
Connect to SQL Server database with Visual Basics
Find how to connect to a SQL Server database using Visual Basics 6.0. Ask the Expert
-
Encryption failures when upgrading to SQL Server 2005
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. Ask the Expert
-
Permissions error when connecting .NET
Greg Low helps troubleshoot an error message from trying to connect a project developed in .NET. Ask the Expert
-
Developing a table-like structure in Visual Basic
Expert Greg Low explains how to create table-like structures in Visual Basic, so they are not connected to any database. Ask the Expert
-
Using DISTINCT in a SQL query
Development expert Greg Low explains the purpose of DISTINCT and how to send a query to SQL Server from VBA. Ask the Expert
-
Changing date format of a flat file using VB.NET
Development expert Greg Low explains how to use VB.NET to format a flat file into the datetime SQL datatype format. Ask the Expert
-
Retrieving Excel data for an application
Development expert Greg Low offers an approach for querying an MS Excel database. Ask the Expert
-
Connecting Visual Basic to SQL Server
If you've had trouble connecting Visual Basic to SQL Server, let expert Andrew Novick offer some basic advice to get you started. Ask the Expert
- See more Expert Advice on .NET Development for SQL Server
-
Eight ways that SQL Server developers hurt performance
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong. Tip
-
Microsoft Visual Studio 2010 spotlight
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. IT SPOTLIGHT
-
Creating Windows PowerShell scripts to manage SQL Server 2008 instances
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. Tip
-
Code to restore SQL Server databases in VB.NET
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert. Ask the Expert
-
Retrieve images from SQL Server and store in VB.Net
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. Ask the Expert
-
Connect to SQL Server database with Visual Basics
Find how to connect to a SQL Server database using Visual Basics 6.0. Ask the Expert
-
.NET database object security
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. Tutorial
-
User-Defined Types
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. Tutorial
-
User-Defined Functions
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. Tutorial
-
Encryption failures when upgrading to SQL Server 2005
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. Ask the Expert
- See more All on .NET Development for SQL Server
About .NET Development for SQL Server
This is your guide to .NET development in SQL Server. .Net simplifies interoperability between languages and Microsoft Windows machines, especially for Web based services. .NET is comprised of many core components, including the .NET Framework. The .NET Framework addresses two areas: building and deploying Web services and making COM (Component Object Model) development easier and more productive for Windows developers. Learn about .Net's interoperability with the SQL Server platform.