ASPNetFAQ.com: What is ASP.NET?

Technology posts on ASP.NET, IIS, Windows (+ a little Linux), Cloud Servers, Hosting, and more!
  • Blog Home
Search the site...

Indexes: An Overview and Maintenance for Performance

by Desiree Harris; originally posted November, 30 2004 on OrcsWeb.com Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database. However, while many people create indexes on their SQL Server tables, many people don’t maintain them properly to ensure queries run efficiently as possible. I’ll begin […]

Tweet
Share
0 Shares

Read More

Fill A DataGrid From Access Database

Originally posted October 2, 2001 on OrcsWeb.com The code below demonstrates how to connect to and query a Microsoft Access database then bind those results to an ASP.Net datagrid for display as an HTML table. <%@ Page language=”VB” Debug=”false” %> <%@ Import Namespace=”System.Data” %> <@ Import Namespace=”System.Data.OleDb” %> <script language=”VB” runat=”server”> Sub Page_Load(Sender as Object, […]

Tweet
Share
0 Shares

Read More

Exporting SSE Database Data to a Remote SQL Server

Originally posted April 15, 2006 on OrcsWeb.com When ASP.Net v2.0, Visual Studio 2005, and Visual Web Developer were released to manufacturing, ORCS Web began supporting those technologies making them immediately available to our clients. Visual Web Developer 2005 has a very cool feature that will allow you to dynamically create a SQL Server Express database for use when developing […]

Tweet
Share
0 Shares

Read More

SQL Server 2005 Export / Import Issues

We had a client run across some issues recently when they exported their SQL Server 2005 database from their old host and imported it into a new database at OrcsWeb. After spending quite a bit of time working with the client on why the application wouldn’t work, we tracked it down to a page on […]

Tweet
Share
0 Shares

Read More

How to Set All Databases to Simple Recover Model (Logging)

Below is a slight variant of some TSQL I borrowed from http://www.roelvanlisdonk.nl/?p=1703 It loops through all the databases on a server and changes the recovery model to Simple, which, if you aren’t aware, changes the amount of logging and how the logging is handled. You should make sure you aware of the impact of that change […]

Tweet
Share2
2 Shares

Read More

Proverbs 19:20

"Get all the advice and instruction you can, so you will be wise the rest of your life."

A Note On WordPress Hosting

Our main focus is of course .NET, but with a mix of Linux, virtualization, and other technologies. But if you're really looking for the best WordPress hosting specifically, read my WordPress host review to save yourself hassle AND money!




Recent Posts

  • What makes good web hosting?
  • jQuery Mobile C# ASP.NET and N5 Networks Software Repository
  • Open Source Bug Tracking Software and the Orchard Project
  • ASP.NET Development with Dreamweaver MX: Visual QuickPro Guide
  • Kendo UI Sample, ASP.NET Ajax Tutorial & More

Tags

ASP.NET Automation centos CMS css cytanium Development/Coding Email gmail Hosting htaccess http https IIS javascript Learning Linux logparser MySQL nginx openssl OrcsWeb performance PowerShell redirect RHEL security server SherWeb smtp SQL/Databases ssl System Administration telnet terminal tip Troubleshooting Ubuntu virtualization Visual Studio web farm web hosting Windows windows server Wordpress

Categories

  • ASP.net development
  • Development/Coding
  • Hosting
  • IIS (Internet Information Services)
  • SQL/Databases
  • System Administration
  • Virtualization
(c) ASPNETFAQ.com