|
|
|
|
|
| | Total Hits: 1236 | Today: 0 | Author: Shyam Pather. | 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... |
| | Total Hits: 712 | Today: 0 | | 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.... |
| | Total Hits: 110 | Today: 0 | Author: Jerome Halmans | 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... |
| | Total Hits: 783 | Today: 0 | Author: Les Pinter. | 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.... |
| | Total Hits: 1019 | Today: 0 | Author: Chris Hembrow | 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.... |
| | Total Hits: 186 | Today: 0 | Author: Edgewood Solutions Engineers | 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.... |
| | Total Hits: 26 | Today: 0 | Author: Mitch Irsfeld | 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.... |
| | Total Hits: 76 | Today: 0 | Author: Guy Haim | 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.... |
| | Total Hits: 197 | Today: 0 | Author: Edgewood Solutions Engineers | 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 ... |
| | Total Hits: 233 | Today: 0 | Author: Edgewood Solutions Engineers | 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:... |
| | Total Hits: 227 | Today: 0 | Author: Kun Lee | 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 ... |
| | Total Hits: 219 | Today: 0 | Author: Edgewood Solutions Engineers | 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... |
|
|
|
|
|
|
|
|
|
|
|
|
|