Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Applications > SQL > Miscellaneous


Search:
What's New - What's Hot
Building a SQL Server 2005 Updatable Subscription Replication Topology     
Total Hits: 243  |  Today: 0Author: Kun Lee      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 has introduced a new replication method called "Updateable Subscription Replication" which allows data modification at both the publisher and the subscriber(s). An option is also available to queue the data from the subscriber so the subscriber does not have to be on the network all of the time. The overall setup is not difficult, but there are a few tricky areas you should be aware of during the setup and configuration. Let's outline setup process in a step by step manner to ...

Getting operating system content into SQL Server     
Total Hits: 235  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Every once in awhile you may have the need to access some data from the Windows operating system or from the contents of a file. The need may be to find out what files exist in a directory, to read the contents of a log file into SQL Server or for some other purpose. Whatever the need, what is a simple way of pulling this data into SQL Server? One way of handling this is to use the xp_cmdshell extended stored procedure to access the file system and bring the contents into SQL Server. By using...

Migrating a SQL Server Instance     
Total Hits: 249  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I need to migrate an instance of SQL Server 2000 due to a hardware issue that I am having. What are the steps that I should take before, during and after the process? What pit falls should I watch out for? Let's walk through the general steps to migrate a SQL Server 2000 instance. Based on your environment and the specific circumstances, a different set of steps or additional steps may be needed, but below outlines the general steps that are needed:...

SQL Server 2005 Database Mail Install Hangs     
Total Hits: 202  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2005, Microsoft introduced Database Mail the replacement for SQL Mail. When setting up Database Mail a few options need to be set including enabling Database Mail, setting up profiles and also making sure that Service Broker is enabled. Most of these options can be configured on the fly by just selecting "Configure Database Mail", but when running the install and selecting "Yes" to activate Service Broker for "msdb" the installation just hangs and the install never completes....

Deployments and Tests in an iSCSI SAN     
Total Hits: 127  |  Today: 0Author: Jerome Halmans      Rating:  
Read Reviews | Write Review |  Your Rating: 

iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management and scaling benefits for datacenters. iSCSI support in Windows Server 2003 makes connecting servers to an iSCSI SAN easy and affordable. This paper describes the deployment and testing results of SQL Server 2005 using the Microsoft iSCSI Initiator with an EqualLogic iSCSI SAN. It helps you understand best practices and the benefits of using an iSCSI SAN with SQL Server 200...

Building a Visual FoxPro Application for SQL Server     
Total Hits: 802  |  Today: 0Author: Les Pinter.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn how to build a data access layer to communicate with either DBFs or SQL Server. Even cooler, you'll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you. Find out how to use a data access layer in FoxPro, which gives you the ability to use DBFs, SQL Server, a WebConnection XML server, or XML Web services....

The Simplest SQL Notification Application: Stock Quotes     
Total Hits: 1348  |  Today: 0Author: Shyam Pather.      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this chapter, you'll see your first SQL-NS application. Think of this chapter as a tour: My intent is simply to show you around the various facilities that the platform offers so that you get a feel for the application model and the process of coding to it. We will look at code in this chapter, but simply for the purpose of understanding the concepts behind the application. A line-by-line explanation of the code at this stage would drown out the simpler picture that I'm trying to show. That s...

SQLWebReports Web Based Data Reporting  Version: 3.3     Price: $399.00 / Free Trial  
Total Hits: 727  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLWebReports is a data driven, web reporting solution for Microsoft® SQL Server© 7 or 2000. Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of web based, HTML reports in a few minutes rather than months....

MS SQLServer Query Analyser     
Total Hits: 1050  |  Today: 0Author: Chris Hembrow      Rating:  
Read Reviews | Write Review |  Your Rating: 

An online Query Analyser for Microsoft SQL Server. Has the same basic functionality as the Query Analyser, allowing you to create/edit stored procedures, execute commands and retrieve data....

Sql180 Developer  Version: 0.00     Price: $0.00  
Total Hits: 86  |  Today: 0Author: Guy Haim      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article will introduce you to a graphic tool called "Sql180 Developer", which is intended to be used by Oracle developers and Oracle DBAs. If you are an Oracle developer, you can easily write and compile PL/SQL code with this code or just work and develop in an Oracle environment. If you are a DBA or an Oracle security specialist, you can manage the DB, monitor it and its performance and also check security issues and problems about your Oracle Database....

Building SQL Server Indexes in Ascending vs Descending Order     
Total Hits: 212  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When building indexes often the default options are used to create an index which creates the index in ascending order. This is usually the most logical way of creating an index, so the newest data or smallest value is at the top and the oldest or biggest value is at the end. Although searching an index works great by creating an index this way, but have you ever thought about the need to always return the most recent data first and ways you can create an index in descending order so the most ...

Imagine Cup 2008: Competing for Change  Version: 0.00     Price: $0.00  
Total Hits: 46  |  Today: 0Author: Mitch Irsfeld      Rating:  
Read Reviews | Write Review |  Your Rating: 

Finalists in the 2008 U.S. Imagine Cup met in Los Angeles on April 20 through April 22 to present their solutions for changing the world by enabling a sustainable environment. Their passion and creativity was tempered only by the discipline of envisioning real-world business models. The result: a fresh blend of established technology and unconventional thinking that attacked the world's environmental problems on several fronts....



Disclaimer - Privacy
© 2002-2017 DevASP.net