SQL Server Tutorials & Articles
-
Encapsulating ODBC in ASP .NET
by Jason G. WilliscroftHotQuant, LLC, builds on their previous ODBC article by demonstrating how to use encapsulation to isolate an application's data access layer and significantly streamline the code.
-
Using Triggers to track database action history
by Super TalTal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables.
-
Building XML Web Services Using C# and ASP.NET
by James YangThe term web service has been used quite frequently lately: you hear people saying how good web services are and how they will dominate the future of software development, but what exactly are web services and how can we create them? In this article James shows us how to build two web services and also unravels all of the lingo surrounding web services.
-
Remote Scripting With JavaScript and ASP
by Mitchell HarperRemote scripting is an extremely powerful feature available in both Netscape Navigator and Internet Explorer. It allows us to use a combination of scripting languages to call server side ASP code from the client using JavaScript. In this article Mitchell shows us how to install remote scripting as well as two examples of using it to interact with ASP scripts using client-side JavaScript code.
-
Beginning Active Server Pages
by James CrowleyExpand your VB skills to the web - learn how to create Active Server Pages in this extensive tutorial
-
Using SQL-DMO To Backup and Verify a Database
by Carvin WilsonThe SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. This article shows you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
-
Market Information
by TheSkillsMarketFind out what skills, whether database, web, middleware or development are in demand, and the average rate for that skill!
-
SQL Distributed Management Objects Part 2
by S.S. AhmedLearn how to administer SQL Server remotely.
-
Securing ASP Data Access
by Thomas C. CarpeSecuring ASP Data Access Credentials Using the IIS Metabase
-
SQL Distributed Management Objects
by Carvin WilsonHow to use the SQL Distributed Management Objects from ASP
-
String Concatenation Component
by Michael BalloniAn efficient string concatenation component to replace VBScript's poor performance.
-
Interview with Ken Slovak
by James CrowleyAn interview with Ken Slovak, joint author of Beginning Visual Basic 6 Application Development.
-
Oracle8 and Oracle8i
by Wrox PressHow to access Oracle 8 and Oracle8i databases... A sample chapter from the book 'ASP Data Access'
-
ADO+
by MicrosoftA preview of ADO+, part of the Microsoft .NET innovations
-
Building Your First Data Cube
by Dan MaharryIn this extract from Beginning Microsoft SQL Server 2012 Programming, the authors demonstrate how to create a 'simple' OLAP cube using the AdventureWorks database as the data source
-
To The Cloud: Moving Red Gate Tools to SQL Azure
by Roger HartRoger Hart looks back at Red Gate's inclusion of SQL Azure into its database applications, the issues they encountered and the solutions they created
-
Using SqlBulkCopy for high performance inserts
by Mike GoatlyIn the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get 'close to the metal' when it comes to persisting data. However, when you need to squeeze the last ounce of performance out of your app - it can make sense to go under the covers.
-
Integrating Active Directory Into Azure
by Steve PlankThe most common giveaway a user experiences when an enterprise application has been moved to the cloud is the sudden appearance of a username/password dialogue box.
-
Introduction to Windows Azure - What you should know
by Neil MackenzieNeil Mackenzie looks at where Windows Azure fits among the various cloud computing offerings in the wild today, and also at the four key areas of Azure that new developers will need to be aware of when they start their first project.
-
Interview with Rob Vieira
by James CrowleyAn Interview with Rob Vieira author of Professional SQL Server 2000