Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Sunday, November 23, 2008

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Applications > SQL
Search:
What's New - What's Hot
Listings for Backup & Restore Backup & Restore (14)
Listings for Bug Tracking Bug Tracking (5)
Listings for Data Management Data Management (25)
Listings for Development Tools Development Tools (10)
Listings for DTS DTS (1)
Listings for Management Tools Management Tools (24)
Listings for Miscellaneous Miscellaneous (10)
Listings for Query Tools Query Tools (11)
Listings for Server Management Server Management (8)
Listings for SQL Server 2005 SQL Server 2005 (11)
Listings for Synchronization Synchronization (15)
 


Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1        
Total Hits: 15  |  Today: 0 Author: Narayana Vyas Kondreddi       Rating:  
Read Reviews | Write Review |   Your Rating: 

In a previous review, I looked at SwisSQL SQLOne Console from AdventNet, that converts SQL statements from one SQL dialect to another. That's a generic SQL Converter and supports conversion to and from Microsoft SQL Server, Sybase, Oracle, IBM DB2, Informix, MySQL, PostgreSQL and ANSI SQL. Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates th...

Use Data Caching Techniques to Boost Performance and Ensure Synchronization        
Total Hits: 30  |  Today: 0 Author: David Burgett       Rating:  
Read Reviews | Write Review |   Your Rating: 

Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment...

Thread Synchronization        
Total Hits: 26  |  Today: 0 Author: Ted Pattison       Rating:  
Read Reviews | Write Review |   Your Rating: 

My last three Basic Instincts columns have examined techniques for using asynchronous delegates and creating secondary threads. Those columns demonstrated how to introduce multithreaded behavior into your applications. In this month's column, I am going to discuss the need for thread synchronization and introduce the fundamentals of writing thread-safe code. After all, I've already shown how you can get into trouble by getting your code to run on multiple threads at once. Now, I feel obligated t...

An Introduction to Threads, Critical Sections, and Synchronization        
Total Hits: 35  |  Today: 1 Author: Spencer Ruport       Rating:  
Read Reviews | Write Review |   Your Rating: 

With the days of the single cored processor drawing to a close and users demanding more robust user interfaces by the day, knowledge of multi-threaded programming techniques is quickly becoming a requirement of any competitive application developer. The code compiles just fine, and depending on how lucky you are, it might even execute properly once or twice. But, keep pressing your luck and sooner or later you'll receive an error. Eventually a context switch will happen at just the wrong moment ...

An introduction to threads, critical sections, and synchronization        
Total Hits: 22  |  Today: 0 Author: Spencer Ruport       Rating:  
Read Reviews | Write Review |   Your Rating: 

With the days of the single cored processor drawing to a close and users demanding more robust user interfaces by the day, knowledge of multi-threaded programming techniques is quickly becoming a requirement of any competitive application developer. The code compiles just fine, and depending on how lucky you are it might even execute properly once or twice. But, keep pressing your luck and sooner or later you'll receive an error. Eventually a context switch will happen at just the wrong moment r...

Safe Thread Synchronization        
Total Hits: 28  |  Today: 0 Author: Jeffrey Richter       Rating:  
Read Reviews | Write Review |   Your Rating: 

By far, the most common use of thread synchronization is to ensure mutually exclusive access to a shared resource by multiple threads. In the Win32® API, the CRITICAL_SECTION structure and associated functions offers the fastest and most efficient way to synchronize threads for mutually exclusive access when the threads are all running in a single process. The Microsoft® .NET Framework doesn't expose a CRITICAL_SECTION structure, but it does offer a similar mechanism allowing mutually exclusive ...

Synchronization Primitives New To Windows Vista        
Total Hits: 29  |  Today: 0 Author: Robert Saccone and Alexander Taskov       Rating:  
Read Reviews | Write Review |   Your Rating: 

Windows Vista ships with a raft of new and exciting technologies for developers, including Windows® Presentation Foundation, Windows Communication Foundation, and Windows Workflow Foundation. In fact, Windows Vista™ has introduced so many new .NET-friendly technologies that it is easy to overlook all the new features and functionalities that native C/C++ developers can put to work in their apps.
In this article, we discuss some of the new capabilities in Windows Vista that impact native C/C++...

Performance-Conscious Thread Synchronization        
Total Hits: 31  |  Today: 0 Author: Jeffrey Richter       Rating:  
Read Reviews | Write Review |   Your Rating: 

In my career, I have architected and implemented many thread synchronization techniques. This has provided me with a lot of experience that has shaped the way I now think about thread synchronization problems. In this new column about concurrency, I will discuss my way of thinking on the subject and offer some code that I think you'll find useful when dealing with thread synchronization problems yourself. To really grasp the concepts in this column, you must have some understanding of thread syn...

Lock & Wait Synchronization in C++        
Total Hits: 65  |  Today: 0 Author: voidbent       Rating:  
Read Reviews | Write Review |   Your Rating: 

The Boost.Thread library provides portable wrappers under system threading primitives to create a concurrent environment and to apply synchronization on it. It is fully enough to have Boost.Thread library facilities to create full-fledged multithreaded programs with using of the lock & wait based synchronization there. But Boost.Thread library is just a first layer under system threading routines. Interface of the Boost.Thread is identical from functional point of view to the interface of the sy...

SQL Server Health and History Tool        
Total Hits: 55  |  Today: 0 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

I have heard about the SQL Server Health and History tool, but I have never used it. How long has this tool been around for? In your opinion is this a tool worth using? What sorts of functionality does the tool have to offer? What types of limitations does the tool have? Is this tool primarily intended for DBAs, Developers or Network Administrators? Where can I download a copy of the tool and what do I need to do to install it?...

Database Maintenance Plans and Backup File Management in SQL Server 2005        
Total Hits: 74  |  Today: 1 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

Database maintenance is vital to the health of an organization's data delivery infrastructure. In SQL Server 2005 Microsoft redesigned the method through which Database Maintenance Plans are created and managed. These plans can be created through a wizard in SQL Server Management Studio (SSMS). They are handled mainly through the Business Intelligence Studio (BIDS), and custom plans can be created in BIDS using SSIS. Although the process is comprehensive, the management of physical backup files ...

Why do my SQL Server database maintenance plan transaction log backups always fail        
Total Hits: 59  |  Today: 0 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

One nice feature of SQL Server is the ability to create maintenance plans for all different types of maintenance activities such as backups, index rebuilds, integrity checks etc... One part of the backup process is the ability to create transaction log backups. One thing you may have noticed is that when you set this up and the job runs it always fails. You check the backup files and the backup files are created, so why does this job always say it failed?...



DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net