Black Falcon Software Releases SQL Server Source Control 2.1.1

newlook_211

Black Falcon Software is proud to announce its release of SQL Server Source Control for Developers 2.1.1…

This release is a major upgrade to its current product, which was at version 1.0.3.  The reason for the large skip in version numbers is that an interim 1.1.1 release had been planned but it was thought better to combine all of the modifications and new features into a single release.

This latest version has a brand new interface style, which will bring it more in line with current expectations by users.

A new usage statistics form has been added that allows users to view the used space in their defined repositories.

An new email form has also been added that will allow users to contact Black Falcon Software directly from within the application.

A new utility has also been added that allows users to clear dangling data when a database connection has been deleted.  This dangling data was a result of the application not clearing all of the repositories with data associated with the deleted connection.  Since this “bug” was internalized by the fact that without the deleted database connection information, the associated data could never be viewed, it resulted merely in the data using up space than being any type of issue.  Running this utility once will rectify this issue without disrupting any data associated with existing, active data.

Many modifications have also been made to this product and are currently listed on the home-page of Black Falcon Software’s web-site.

If you are an employee, consultant, or freelancer who requires source control for your SQL Server database object scripts because your place of work does not have such a capacity or you just would like to have your own individualized form of such source control, which is similar in nature to the Mercurial private source control system, go to Black Falcon Software’s web-site at http://www.blackfalconsoftware.com and download a freely available 30-day trail version.  Licensing is very affordable and allows for installation on 5 different machines.

A tremendous amount of effort has gone into this latest release so it is hoped that everyone who tries it will enjoy working with it.

Database access has been tested up through SQL Server 2014 and should be compatible with all previous versions with this popular database engine.

In addition, this release has also been successfully tested against Windows 10.

The next expected release (2.1.2) will have the capability to access the newly released SQL Server 2016 database engine.

Steve Naidamast
Sr. Software Engineer
support@blackfalconsoftware.com
BFS_splash-screen-purple-sun_140x105

Best Database Managers for Developers

DatabaseManagers

The technical management of relational databases is a highly mature technology in the software development profession. Many of the high-end tools such as those offered from Toad and Embarcadero are superlative with their capabilities but completely beyond the affordability for most individual developers, unless of course they need such powerful tools for their businesses and clients (Toad does offer freeware versions but they are somewhat limited).

For most of us, we tend to work with databases through client tools provided on their workstations or we use the individual offerings from such vendors as Microsoft, MySQL, and PostgreSQL to name a few. However, as good as these tools are, to use them requires understanding the idiosyncrasies that comes with each as all of them are proprietary to the database. This is not a major undertaking since all such database managers operate in relatively the same fashion.

Nonetheless, if you work with a variety of databases constantly and you do not require the extensive capabilities that come with the high-end offerings, working with a single database manager for all your efforts more often than not makes such work a much smoother process.

There are two such database managers that fit this bill and are in fact quite popular with many professional developers; Database.NET and the products from EMS Database Management Solutions.

Read more of this post

Using Black Falcon Software’s SQL Server Source Control for Developers

SSSC_UsingBlackFalconSoftware's_SSSCProduct

Overview

Application source control is a veritable standard in all well-run Information Technology organizations.   However, it is surprising how many small organizations seem to believe that individual developers merely saving backups of their projects on a remote server is more than enough for source control processes.

It is even more surprising how many quality IT organizations that do not have formal database teams ignore database source control thinking that the backed-up databases housing the scripts are more than enough for such a vital development process.

To some degree the lack of such control on databases is understandable given that there are few products available for organizations to avail themselves of. In fact, the only substantial products available are for Microsoft’s SQL Server database, while many other database engines are involved in production processes throughout the international IT community.

For Microsoft’s SQL Server, both ApexSQL and Red-Gate offer excellent products for teams and as a result, are rather expensive for individual professionals to afford. However, Black Falcon Software now offers a far more affordable solution for professionals looking to incorporate database source control into their development processes that will allow them to avoid the pitfalls of having their database scripts deleted or modified by others accidentally while under development when source control is not available.

Such a situation can be a traumatic situation when one has developed quite a number of new tables, procedures, or other such objects in a test database only to have them suddenly disappear as a result of a colleague’s work on the same database. And this is a common occurrence since test databases in many instances tend to be regarded as reusable by those working with them.

To begin with, Black Falcon Software’s SQL Server Source Control for Developers is not designed for teams but instead for the individual professional who wants and\or needs to maintain ongoing versions of all the database object scripts that they are developing without the more elaborate requirements of a remote source control systems such as TFS or Subversion. Stored in local repositories on the desktop, developers can now implement easy-to-use database source control for SQL Server that are protected from accidental modifications by colleagues or worse, complete database refreshes when it is felt that such a refresh is required. Under either condition, recreating original scripts can be a taxing experience.

Black Falcon Software’s product has a very simple set of administrative source control processes.

Starting with the administration of the application, the developer is presented with the following options…

*** click on the images to enlarge them

Read more of this post

Best Embedded RDBMS Databases for .NET Developers

RDBMSEmbeddedDatabases

Black Falcon Software develops products for professional .NET developers and like any other MicroISV, the need for developer products to have embedded databases is often a necessary component for such work. The problem is that over the years this area of necessary database support has deteriorated to the point where few products are available any longer that are worthy of being used in commercial development.

For .NET developers the original database of choice was the Access MDB coming out of the transition from Classic VB. Though still available, this database has been long known for issues in the community and is now regarded as a non-starter for most professionals.

As the .NET environment grew in popularity, the database of choice for many was VistaDB, which was specifically designed for embedded database development. VistaDB came and went over the ensuing years but as the open-source database offerings became mainstream it finally went where it is now owned by Gibralter Software, which sells it at the hefty price of $1500.00 for a “site” license. However, if you qualify as a “MicroISV” with the company, they will offer a reduced price to help you with your business; though no estimate is provided.

VistaDB is offered as the .NET developer’s alternative to both SQLite and SQL Server CE but with both the latter available at no cost, this qualification is a non-starter unless VistaDB has an exact feature that is required for any developer’s work.

To this end, there are quite a number of what may be called 3rd-Tier database tools that can be used for embedded development, qualified simply is such from a lack of name recognition and corresponding probabilistic market-share. Many of these tools do not appear to have kept pace with the changing .NET Framework environments leaving them still supporting the 3.5 and 4.0 versions of the framework while integrations are correspondingly offered for Visual Studio 2005 and 2008. It is doubtful that any serious professional would want to take advantage of such tools. In this vein, “ScimoreDB” has appeared to be the most sophisticated of this group but it is stuck with its offering only supporting up to .NET Framework 4.0; at least at the last recent review of their business site.

Many other such tools look as if they are no longer supported or have been simply forgotten by time altogether.

Read more of this post

SQL Server Database – Localized Source Control

SourceControl

Every developer is familiar with the vital necessity of having quality Source Control tools in a development environment.  However, just as many developers through their careers have probably been very surprised to learn how many small and medium sized companies ignore this component in their development environments leaving it up to the individual technicians to implement their own methodologies to save their project work.  Such situations can usually be found to be a result of laziness, sloppiness, or sheer ignorance on the part of management or even the employed technical personnel.  And attempting to implement an organization-wide source-control system in such situations can and has been met with negative reactions.

Read more of this post

SQL Server CE “Identity” Keys

SQLServerCompact4 

 SQL Server CE is a terrific desktop database.

For developers that continue to use it in the development of desktop database applications the sad news has been known for a while that Microsoft has decided to no longer support such a venerable database engine.  Hopefully it will be opened sourced or maintained at some other level so that its use can be continued.

Read more of this post

%d bloggers like this: