Problem solve

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. Continue Reading

• 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. Continue Reading

• What is the code to restore SQL Server databases in VB?

  Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert. Continue Reading

• 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. Continue Reading

• Connect to SQL Server database with Visual Basics

  Find how to connect to a SQL Server database using Visual Basics 6.0. Continue Reading

• 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.Continue Reading

• Permissions error when connecting .NET

  Greg Low helps troubleshoot an error message from trying to connect a project developed in .NET.Continue Reading

• 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.Continue Reading

• 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.Continue Reading

• 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.Continue Reading

• Retrieving Excel data for an application

  Development expert Greg Low offers an approach for querying an MS Excel database.Continue Reading

• 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.Continue Reading

• 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.Continue Reading

• COUNT DISTINCT in VB and Access

  Continue Reading

• Scalar functions for UNC file handling

  Two quick little scalar functions that strip out the filename and filepath from a fully qualified UNC filename.Continue Reading