|
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
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...
|
|
|
|
Total Hits: 30 | Today: 0
|
Author: David Burgett
|
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...
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: Ted Pattison
|
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...
|
|
|
|
Total Hits: 35 | Today: 1
|
Author: Spencer Ruport
|
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 ...
|
|
|
|
Total Hits: 22 | Today: 0
|
Author: Spencer Ruport
|
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...
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: Jeffrey Richter
|
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 ...
|
|
|
|
Total Hits: 29 | Today: 0
|
Author: Robert Saccone and Alexander Taskov
|
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++...
|
|
|
|
Total Hits: 31 | Today: 0
|
Author: Jeffrey Richter
|
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...
|
|
|
|
Total Hits: 65 | Today: 0
|
Author: voidbent
|
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...
|
|
|
|
Total Hits: 55 | Today: 0
|
Author: Edgewood Solutions Engineers
|
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?...
|
|
|
|
Total Hits: 74 | Today: 1
|
Author: Edgewood Solutions Engineers
|
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 ...
|
|
|
|
Total Hits: 59 | Today: 0
|
Author: Edgewood Solutions Engineers
|
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?...
|
|
|
|
|
|