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

Home >Search > Applications > SQL > SQL Server 2005

What's New - What's Hot
Importing Excel data with SQL Server Integration Services and dealing with unicode and non-unicode data issues     
Total Hits: 331  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

One task that most people are faced with at some point in time is the need to import data into SQL Server from an Excel spreadsheet. We have talked about different approaches to doing this in previous tips using OPENROWSET, OPENQUERY, Link Servers, etc... These options are great, but they may not necessarily give you as much control as you may need during the import process. Another approach to doing this is using SQL Server Integration Services (SSIS). With SSIS you can import different types...

Listing SQL Server Object Dependencies     
Total Hits: 220  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When developing components for SQL Server one change may affect another database object. Finding these dependent objects should be straightforward, but in most cases it is not as easy as you would think. So what is the best way to find dependency information in SQL Server? There are several methods of getting this information. The first approach would be to use the SQL Server Management tools. For SQL Server 2005, right click on the table name and select "View Dependencies" as shown below we...

Accessing the Windows File System from SQL Server     
Total Hits: 451  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Within my SQL Server T-SQL stored procedures and scripts I need to find out the files in a specific directory. What are some approaches to do so? I need some flexibility to capture the file names and general information for subsequent processing. What are the native SQL Server options as well as the custom options that are available?...

A Tutorial for Constructing a Plug-in Viewer     
Total Hits: 110  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft Analysis Services Data Mining Viewer Plug-in Framework defines the necessary interfaces and registry information that third parties can implement, so that their algorithm viewers will be seamlessly integrated in the SQL Server Business Intelligence Development Studio Designer. DM Algorithm Viewer Plug-in Framework is to allow third party algorithm providers to use their own viewers displaying the discovered patterns. Viewers are .NET WinForms UserControls which display patterns of the ...

Want to Search with ASP and SQL?     
Total Hits: 372  |  Today: 0Author: aspalliance      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here is the download file that you will need to get the most out of this tutorial. It is a simple search utility designed to show you the basics behind doing a simple database search using ASP. If you just want to download it, change the data in the Access database, make a DSN called "Employees," and use it....go for it!

There are three files in the "" file that make this work: The database (employees.mdb); The HTML file that posts to the ASP file (ASPSearch.htm); The ASP f...

Date/Time Conversions Using SQL Server     
Total Hits: 234  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you....

Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies     
Total Hits: 75  |  Today: 0Author: Anthony T. Mann      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 SP2 introduces tight integration between Reporting Services and Microsoft SharePoint Products and Technologies to enable a single user environment with which to manage and execute reports. This white paper shows how to administer the integration between Reporting Services and SharePoint Products and Technologies and provides troubleshooting tips in the event that problems arise....

Multi-User Considerations in Data Synchronization for SQL Server 2005 Mobile Edition 3.0     
Total Hits: 200  |  Today: 0Author: Gil Lapid Shafriri,Debra Dove      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server Mobile Edition allows multiple users to concurrently access the same database. Multi-user access means that multiple threads or processes may be accessing a database while one thread is synchronizing that database with SQL Server. This functionality enables background synchronization, so a user can continue to work on a database while the database is synchronizing with the Publisher. However, this creates interesting complications that you will need to address as you build y...

Regular Expressions Make Pattern Matching And Data Extraction Easier     
Total Hits: 227  |  Today: 0Author: David Banister      Rating:  
Read Reviews | Write Review |  Your Rating: 

Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. Is there a better way?

In fact, regular expressions provide a much more efficient and elegant solution. It is easy to see how they would be helpful for comparing text to identif...

Row Level Security for SQL Server 2005 - Technical Media  Version: 1.0     Price: $100.00 / Free Trial  
Total Hits: 438  |  Today: 0Author: Mike Graham      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data Nomad® is an affordable set of developer tools that extend the Microsoft SQL Server 2005 platform to provide row-level security and remote access features allowing developers to accurately and efficiently create and manage powerful distributed applications that insure access to information is protected. Developers of .NET 1.1 and .NET 2.0 smart client and web applications can now easily add row-level security to database applications through the Data Nomad® developer tools. Existing databa...

Securing Your SQL Server 2005 Express Edition Server     
Total Hits: 115  |  Today: 0Author: William Vaughn      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server 2005 Express edition is the replacement for the Microsoft Desktop Engine (MSDE) edition of Microsoft SQL Server. Its architecture has been completely redesigned to enable you to install and use it as you would Microsoft Access/JET databases—but without the problems associated with that approach. SQL Server 2005 Express Edition goes a long way toward building a better solution for applications that need:
* A replacement for JET databases. That is, a DBMS that can be taken over b...

Disclaimer - Privacy
© 2002-2017