HOME | SIGN UP | ACCOUNT | SUBSCRIBE | STORE | WHAT'S NEW | TESTIMONIALS | TROUBLESHOOTING | SUPPORT AREA | SITE NEWS | LOGIN
Classes & methods · News · Jobs · Links · Downloads · Articles · Conferences · Magazines · Training · Consultants · Consulting · Blogs · FAQ
Books · Applications · Meetings · User groups · Speakers · User group leaders · Universal Thread Magazine · Coverages · Photos · Videos

DevCon Praha

DAQUAS and Microsoft Czech Republic will organize a conference for database professionals and developers who use Microsoft Visual FoxPro and Microsoft SQL Server. Out of 4 session tracks one will be dedicated to FoxPro speakers who will be presenting more than 10 topics in English. Two tracks will provide SQL Server content in Czech language and one track is reserved for local speakers to present Visual FoxPro topics and also some additional topics of general interest related to IT.

Date: 
Location: 

This conference has 92 pictures. We display 12 randomly selected pictures here. You may click here to view the album thumbnails.

Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...

Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...

Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...
Visual FoxPro DevCon, Praha...

Tuesday, June 23

Opening words

The twelfth DevCon has just begun! More than two days with more than 60 sessions, more than 30 speakers are waiting for the big show in Prague! Us the three reporters, are eager to see all of this in life, writing reports, taking photos and fully enjoying the “conference atmosphere”.

So, no matter if you are FoxPro, .NET or SQL, developer, manager or just fan, welcome to Prague and ejoy these two and half day conference!.

ADO.NET data services by Štepán Bechynský

In the first session Štepán, Developer evangelist from Microsoft, showed possibilities of data sharing between the client and server side,independent of platform used. As a “connection bridge” is used http connection, which provides us basic methods, such as GET, POST and PUT.

The whole session was covered b a useful demo based on Northwind database? Štepán used this database to display data from SQL to RSS (resp. Atom). Although it is a web application, all types of authentication are available. Due to the http service, if the request is incorrect, server answers by an error code, known from website developing – e.g. 401 as not authorized or 403 as forbidden. For client applications is extremely easy to parse RSS – it’s well known modification of XML. This ability brings this service to all platforms or developing languages. You can write client application in C#.NET, or for example javascript.

The only limitation of this service is that you need to transport whole object, not only a part of it. At the end of the session Štepán answered few questions. First one was about trasactions – how to cover data in one transaction. Štepán surely answered, that, if you use savechanges() method, it is as one transaction.

Datamining by Erik Caha & Zdenek Nosek

Zdenek and Erik started this session very unusually, with a small theatre performance, when Erik came into the hall with a mattox and started to “mine” the data, presented by a paper box. How a funny and elegant beginning!

But the datamining is not as hardwork as Erik showed! There are many solutions, which can us help. Another important information is that this session had two speakers. Erik Caha, as a representative of MS SQL SERVER 2008 part of datamining and Zdenek Nosek, as a representative of MS Office (esp. Excel 2007) part.

Why MS Excel 2007? Mainly: excel is great utility for displaying data and numbers – you can make charts, tables, etc. Version 2007 is necessary, because of new data system and some new abilities, which had been described by Zdenek. You have to install a special add-in, which will create a new tab in the Ribbon menu. There you can find multiple functions usable for datamining.

Both Zdenek and Erik reminded us, that all data mining or computing has to be based on well-formed data, so you have to modify it. Also for that you can find functions in datamining add-in in Excel 2007.

The session was partly theoretical and partly practical, so both Erik and Zdenek showed their examples on real data. Firstly it was some data of training center, secondly it was a database of poisonous mushrooms. In first case – if you predict some bad results, it will probably do nothing, but in the second case, if you predict the data, which mistakes edible mushrooms for poisonous, it could make more trouble than you think. So, not in every case is symmetrical algorithm needed, sometimes you have to make it asymmetrical.

Extended events and Event tracking for Windows by Erik Caha

A first after-lunch session by Erik was dedicated to events tracking on server. Erik showed us multiple ways of tracking, such as Extended events or Events tracking for windows. The session was more theoretical than previous ones, but Eri described everything as well as he could.

So what the Extended events stands for? It is framework, to be more specific, redundant framework, which helps us to catch, show and present events, and many other features. Some terms from this theme were described, for example package, event, action, predication, target, etc.

It is good to mention that these abilities are possible almost on every version of SQL server, by the way Erik showed thee examples on Express edition!

In the end of this useful session Erik warned, that this tracking is not so easy, so we have to know where, why, and how we will track.

Windows Powershell by Štepán Bechynský

This session was completely new stuff for me, but it surprised so much! Štepán, who can use powershell almost as well as his primary language, started by comparing PowerShell with cmd.exe (console available in Windows XP, etc.) and with WSH.

Powershell is natively in Windows 7 (RC available now) or Windows Server 2008 R2 edition. In older Windows (meant Windows XP SP2 or Windows Vista), you may install it in a special package downloadable from Microsoft website.

So, what is a basic build-stone of the PowerShell? It is a “commandlet”, a simple program called by PowerShell. It usually consists from 2 words – first one is a verb and second one is usually a noun (or collocation of nouns). E.g. Get Help.

The ability of using .NET objects, or COM objects makes PowerShell even more powerful than we thought. We rather do not forget to the variables, which are marked by $ at the beginning. It is possible to use conditions, operators, cycles, etc. By the way – PowerShell brings a really awesome operator –match, which is connected with regular expressions.

You can also launch scripts from external files, but remember as Štepán mentioned, that in default settings it is forbidden. PowerShell is powerful utility for personal computers, database stations but it will also be a great helper for web for web servers.

Regular expressions by Jürgen Wondzinski

Jürgen started his amazing session by describing his background, or let’s say expiriences with VFP. Then he moved into description of the term regular expressions as general. He described regular expressions as standardized pattern matching, which brings us very flexible text searching, or validating.

The theory is one thing, but practical using another, so Jürgen showed us an application in VFP, where the validation of e-mail address was used. These validation rules are not as easy as it seems – you have to verify whether the character “@” is used, whether there are any characters before and after it, etc. So the regular expression for this purpose seems as some weird code.

Because of that, Jürgen started to describe regular expressions again, from the beginning, on simple, but also useful examples written in VFP. In all these cases was quite obvious, that without regular expressions would be the code much more longer and messy.

Although the regular expressions syntax seems as some weird language, it is very useful in multiple developing languages.

Introduction to Windows 7 and benefits for administrators by Jan Horný

At the beginning Jan started with introduction himself. He continued with little history of Windows, beginning with Windows 3.0 and ending with Windows Vista. The Time has come and here it is - Windows 7.

Windows 7 are build on Windows Vista and Microsoft was listening to developers and users and collected a lot of information about what is good what is not about Vista and try to eliminate these bugs on Windows 7.

At first Jan advised us to install Windows 7 using USB Flash Disc. The reason is simple, using DVD installation last about 37 minutes. If we use USB Flash Disc it last about 8 minutes. Jan continued with introduction of Windows 7 editions for example Home (OEM), Professional (gave us more functions such as domens, PC BackUP, Mobility Center, Encrypted file system) and last one Enterprise-Ultimate (these are same version which gave us Multilanguage support, AppLocker, BitLocker, Direct Access and so on.).

After that Jan spoke about features. As he already sad Windows 7 are build on Windows Vista. The main changes are inside. For example is MicroKernel (MinWin), Core Parking (save energy, etc...), Windows Timer Coalescing. Then Jan focused on MicroKernel which is the main thing. It boots at first and then everything else. MicroKernel takes only 30MB on disc and 40MB of RAM.

Another new feature which Jan was talking about was Windows Background Services. It helps asynchronies start and it will start service only if it is needed. It will help to save PC sources as well. Windows PowerShell v2 is .net language which will help administrators to manage the system (GUI environment is one of the new feature, debugger and so on). Group Policy Preference is another new thing. User Account Control was next Jan’s topic. It helps to protect our PC before unwanted software. In Windows 7 we can change setting of UAC (in Vista it is impossible) and we can elevate the privileges for the software or services.

What about security? Jan didn’t miss anything and mentioned some news it this area such as UAC, BitLocker, AppLocker, DirectAccess. Jan mentioned little bit more about BitLocker To Go. This application allows secure data on USB Flash disc for example. It can be manage using Group Policy and in Windows 7 is very simple to configure.

After that we moved to different topic. What is new on the first sight? At first User Interface where we can find new Windows Taskbar, Jump Lists and at last Windows Aero Enhancements. Search is modified and it is everywhere such as Start Menu Search or Search Federation (searching not only on hard drives). HomeGroup which allows very simply set a network was improved as well.

There are a lot of others new things what Jan mentioned such as Windows Media Center, Biometry, Multitouch, Media Streaming and so on.

The session was full of news in Windows 7 and Jan made a great work and demonstrated all these things to us very simply. Thank you Jan.

Don’t be afraid and don’t steal by Darina Vodrážková and Jan Horný

This session was little bit different than usual. Darina and Jan who are working in Daquas Company and are concern with licenses held the session, because of session which didn’t take place. The session was mostly processed as question and answers. Here are some questions:

Is going to be free upgrade for Windows Vista to Windows 7? If we buy OEM version and we upgrade PC shall buy a new OEM? Can software police come to our company without notice? There were a lot of other question that were answered by Darina and Jan.

The session was perfect, especially for those who had some licenses problem or didn’t understand them in a propriety way. The session didn’t miss speakers good mood and humor.

Beyond Visual FoxPro 9.0 by Ken Levy

We know Ken Levy very well so there is no need to introduced him. Ken started with Agenda. He was speaking about Sedna, VFP X, XML Editor, VFP Tools, AppScan X and so on. At first Ken showed us Xiine web pages. There are online magazines which we can download for free.

After that Ken showed us where to download Sedna Add-on. After installation we can get My. Classlibrary, which can give us a great tool for improving development of software more easier and comfortable as well. We can also copy the code to our own application and use it, some of code is also using Windows API functions. Ken didn’t forget and showed us some demo of this classlibrary as well.

Ken then demonstrated us some other useful functions such as function which will showed us how much battery left on our notebook, which can be appreciate by users using notebooks.

VFP X was another Ken’s topic. On VFP X webpages we can find some good classes which can improve our software. Of course Ken’s demonstrated some of them on simple example. VFP X is simply very good improvement of Visual FoxPro.

XML Editor was another thing what was speaker talking about. He showed us this free editor how does it work and how to use it.

The session was also speaking about VFP Conversion. On the web page we can also find some free tools which can be used in Visual FoxPro. Another web page worth to go is CodeCast as well.

At the end of the session he exposed us some good tricks in Visual FoxPro. Ken had done a great work. He showed us how effectively improve our application using different classlibraries, tips and tricks and everything he showed us on a lot of simply demos.

Design of User Interfaces by Uwe Habermann and Venelina Jordanova

Hello everybody, we are here again after a long year to bring you coverage’s from our conference. One of the first sessions is about Design of User interfaces, but before we started Darina Vodrážková welcomed us to 12. Devcon. Darina mentioned some important information, number of session and their topics, but this is enough for introduction, let’s focus on Venelina and Uwe.At the beginning Venelina and Uwe introduced their self. They continued with agenda of the session.

Uwe pointed out that first view is crucial, because first impression plays very important role for users decision for choosing application. Our interface must satisfy the customer. In the past we tried to create friendly interface, but we were often limited with technical resources and ergonomics knowledge. From VFP 3.0 we started with object oriented programming, using many control types and so on. VFP 7.0 offers us XP themes and in VFP 9 we can create application like Office XP which seems to customer little bit old. So Uwe gave us simple question. What now? We can develop error free application or focus on data centric user interface which is represented with data models in forms. This model is very often used by developers. Typical view of customers is Task centric user interface, represented by business cases as they are in the real world. Developers should use task centric user interface as a interface but not as data model.

Venelina also mentioned that data entry should be mainly using keyboard then searching data, analyzing and editing data using mouse. Uwe continued with talking about business cases. He pointed out that business cases are more important than requirements, because requirements are often wrong but business cases are always correct. Important thing during developing our application is user participation and let user test our application. Venelina told us that user feedback is very important.

Uwe continued with quality criteria. The first one is Usability, second one is Usefulness and the last one likeability. Next topic Uwe and Venelina was talking about was time requirement. At first is discovery (searching for functionality), learn (find out how…), Efficiency and so on.

Another interesting thing what was Uwe talking about was Acceptance. We should keep in mind that our application should be compatible with Windows and Office as well. Application should have features such as splash screen, title, toolbar and so on. The only reason is that customers are familiar with them. User interface is designed well if it does exactly what the user expects. Our application should be stable which is expected as most.

Next thing we were talking about were Wizards, which are useful for users. Using Controls is very handy, such as Spinner, ComboBox, CheckBox, Grid and others. Uwe advised us that we have to be cautious using a long dialogs, because nobody read it.

The session gave us another thousand information what should we and what should we not do when we are developing our applications. Uwe and Venelina mentioned cardinal mistakes which makes our applications unfriendly for users and gave us some tips and tricks how effectively develop useful, friendly and reliable user interface. Well done Venelina and Uwe.

Wednesday, June 24

SQL server services by Štepán Bechynský

This session by Štepán was very interesting, because it showed us Reporting services, the service used to creating printing records. In the beginning of the session Štepán detailed few services of SQL server, such as Analysis (e.g. OLAP), Integration and Reporting services.

The session was combined with a demo of SQL server BI development studio.

Hitchhiker’s guide to ADO.NET and LINQ  by Milan Kosina

This session was second part of yesterday’s one. Firstly, Milan mentioned a literature for C# beginners/deve­lopers, and showed them on amazon.com shop. He did not forget to mention MONO project.

This session was mostly practical, so, let’s focus on demo apps. They’re based on same DLLs as yesterday’s web applications. Milan showed us on console application possibilities of data selecting, updating, and deleting data from database (in this case MS SQL), using ADO.NET. All presented as for beginners, who migrated from VFP to C#.NET.

Second part was dedicated to LINQ, especially to LINQ to SQL, which brings new, united (and we can say better) access to our data. Although the session lasted 75minuts only, Milan showed most of the features of data accessing in .NET framework.

Structured text files without any mysteries  by Vlastimil Subera

Another useful session! You would agree with me that everybody had used structured text files at least once! STF are surrounding us everywhere -in windows there are ini files, in websites are html files, and in many applications we can find xml files. These files could be used for data presentation, text presentation, data transfer, or simply as source codes of our applications. The advantage of text file is that you do not need any special software, in worst case – you can use Notepad. But this can be also a disadvantage – you have to set reading and writing rules.

Vlastimil continued on Steven’s Black session from 2007 Prague DevCon, and showed us his own application written in VFP, for analyzing text files. As an input file was chosen a file with Jan Neruda’s novel. With common VFP functions you may process these text files.

As we mentioned, one types of STF are INI files. Using simple functions strextract() and transform () we can easily read data.

So the result from this session is, that you can parse any txt file, you just need it to analyze to find returning parts, separators, such as commas, etc.

Questions and answers regarding VFP  by speaker’s forum

There were not many questions asked on the forum this year. Perhaps, as Igor Vít said, this is because Visual FoxPro is stable and in its latest version for some time around now and there were probably too many DevCons to keep anyone wondering about how something is done.

Apart from now usual topics along the theme “Is FoxPro dead, what now?” and jokes proving that VFP community can is a group of good spirited people who can make fun of anything, there were one that might catch interest of any VFP developer: “When making a transition from VFP centered development, is it better to reach out for C# or VB.NET?” To make an informed decision, it is necessary to take more facts into consideration. First, VB semantics is much similar to VFP style of coding, therefore easier to learn and some experience might already exist in the development team from using the old ASP with VBScript. On the other hand, when learning, you are more likely to find more examples in C# than in VB as well as it is much easier to find C# programmers or programmers more willing to learn C# than VB. Once you have the facts, the decision is now yours to make.

One could ask out why we missed Java in our discussions. As the audience later on agreed, this is because there is a general feeling that when we need to develop on Windows platform, we need to use .NET framework anyhow. If not for general development, then at least for some functions available through any kind of API calls for sure. Based on that if for example Linux development is not the main issue, it is reasonable enough to stick with .NET language group.

As we mentioned, one types of STF are INI files. Using simple functions strextract() and transform () we can easily read data.

So the result from this session is, that you can parse any txt file, you just need it to analyze to find returning parts, separators, such as commas, etc.

SQL Server Database Internal Storage Secrets Uncovered  by Miloslav Peterka

Sometimes, when the database performance needs to be at its best, to find-tune it, it is necessary to think about the internal storage and data processing that works behind the scenes. This session gave the basic insight to internals of the SQL Server database.

As far as the database files are concerned, it is best not to use Autogrow and Autoshrink features. You never have control over when the SQL Server decides to perform one of those and you can bet it will be right in the peak period. To overcome this, it is always best to set the size of the database to a reasonable value right at the beginning. Also, one should not forget to physically separate database files from the transaction log.

To make sure everyone followed, Miloslav continued with explaining the basic terms, such as a Filegroup, Data page, Extent, GAM, SGAM, etc., and always pointed out, how the SQL Server works with each of those.

Miloslav kept showing demos of what is happening behind the scenes of ordinary database operations with help of the SQL Internals Viewer, a must have tool for exploring and understanding how exactly everything works.

One of the things that influence the performance of the SQL Server is indexing. Even though this is a fairly large topic, easily able to fill up its own session, Miloslav made at last the most important summary of it.

There were also other topics talked about like transaction logging, recovery model and its settings, their differences, etc. All in all, it indeed was a complete session helping to understand the SQL Server internal storage secrets.

Transactions and locks  - what you should know  by Miloslav Peterka

We all know the theory. Transactions are used to make sure any change in a database is as ACID as possible. But how to make the best out of it in SQL server as well as what are the caveats and fats to think about – this is what the session was all about.

Miloslav started right from the beginning, explaining what is the default behavior of transactions in SQL server, what are the default settings, etc. Everything followed by pre-prepared examples. Apart from other things, there we could see the difference of a DML command being enclosed in an explicit transaction or in an implicit transaction if those are allowed.

When talking about transactions, locks always go hand in hand with it. Based on the current settings (optimistic or pessimistic), DML operations impose locks on all kinds of objects in the database or on the database itself, when needed. If one chooses to go the optimistic way, no locks are used and, if the transaction fails because of concurrency, the server simply does a rollback. It is only a question of which approach is better in which situation.

Another important point is the transaction isolation. When locks are set on an object, the transaction isolation setting define, whether we can read the old data from the locked object or the data being written and not yet committed or by default, wait until the record gets unlocked. Based on the settings used, there are also specific “illnesses” that need to be addressed. These are all well known and each of them even has its own name: lost updates, dirty reads, non-repeatable reads, phantom and duplicate data. Miloslav showed all of the mentioned problems on various examples, making it very easy for anyone to follow, understand and learn.

VFP.Net… You CAN teach an old fox new tricks  by Boudewijn Lutgerink

Need to go to .NET platform? Develop under .NET framework? But you still need to use VFP language, VFP forms, etc.? There is a way!

There is a new compiler being developed, allowing you to take your forms, compile them and have them run under .NET framework. This new VFP.Net application can also be combined with the original .NET language forms and together used to build a seamless application.

To build parts of the VFP.Net application one needs to use VFP itself to create individual parts of the application and then, the VFP developer studio for combining the parts into a compiled application. As the studio is actually built on top of the Visual Studio.Net shell, it also brings many of its useful features with it. One can take the advantage of its ability to create and use templates, work better with code in the project as a whole, etc.

Another interesting possibility is to create WinForms using VFP as the programming language. This brings another dimension to VFP and .NET teamwork. Boudewijn wrapped up his session with a lottery.

Database change management with Visual Studio Database Edition  by Michael Jurek

Michael started his session by explaining why Microsoft felt it was necessary to introduce a new team edition. It has always been difficult to maintain any reasonable system of database change management and people were asking for some help. Microsoft understood that and came out with an entire new edition.

Typically, there are several roles and people working with the database. It is a database architect, database developer and a database administrator. All of them make changes and need to share them.

Visual Studio Database Edition comes with a solution based on schema change management. The production database is master only for the real data it contains. The schema on the other hand is always re-generated right from the Visual Studio. This brings a perfect solution for change management and tracking the evolution of the database schema in time. Another clear advantage is that the schema can be versioned together with the application source code.

After this introduction Michael showed and talked about individual steps one goes through when using the new edition, such as how a new database project is created, what operations you need to do when developing, testing as well as deployment.

.NET with VFP and VFPConversion  by Ken Levy

VFPConversion is a project created specifically for VFP developers that are currently seeking new ways of continuing their work while learning how to convert to new technologies in the process.

The home for the project is located on http://www.vfpconversion.com/, where you can find many articles and other resources from well known persons in the VFP and .NET worlds.

One of the highlights of Ken’s session was an introduction to the ADS, which stands for Advantage Database Server. This product works like a wrapper around existing DBFs for providing a way to access its data from within .NET applications. The real advantage of ADS is then the fact, that the same DBF files can be accessed directly or through ADS. This allows keeping existing VFP applications intact while focusing on developing new parts and modules in .NET and still accessing the same data, of course. For more information about Sybase ADS with VFP, refer to http://sybase.com/foxpro.

Thursday, June 25

Security on SQL server  by Boris Mutina

Security is a really important thing in every system, so that’s why we found this session so interesting. Boris started this session by legal disclaimer. Then he continued with history of SQL servers with numbers of security holes. Boris recommended us to check which version of SQL server we have, by command SELECT @@version. Which patches we have and thus is our system safe? By the way – in SQL server 2008, there is still no security hole known.

But there are not only security holes made by creators of SQL servers – more mistakes are made by SQL administrators. For example – it really depends on which account SQL server runs.

This session was full of important advices. Really necessary is updating and patching. Try to use benchmark tool CIS, to reveal weak points. Part of advices was dedicated to SQL server on LAN (intranet), and part to SQL server as backend in web application. No matter how well you have your firewall configured; there is still universal firewall bypass protocol, also known as HTTP :).

So do not forget to protect your SQL server, if you do it better now, you will have less work in future!

Optimization queries practice  by Robert Haken

The first thing Robert recommends (according to the pyramid) is performance of the application. How big is the data flow? Does the caching help? Do not forget to use Database profiler to check all these things.

A main mistake in database construction is when you use more than one column for same thing, e.g. telephone1 and telephone2. Every time you seek the phone you have to check both cells. Robert also mentioned two possible types of keys – natural (real) and synthetic. Natural is related to the real value (personal id number, username…), synthetic is database own number. Robert’s company uses synthetic ones in int.

What are the main schema killers? For example, if you use varchar instead of datetime, you increase server loading. The best practice in query logical flow is to filter most data by WHERE clause, instead of HAVING clause.

Design and servicing of the database is very important for application developing, so do not forget on Robert’s advices, and keep your code clean!

Using VFP effectively - what’s happening behind the scenes by Pavel Celba

Pavel started his session with a brief overview of FoxPro history - right from the good all days of FoxPro, through the buyout by Microsoft up to a “Big Bang” time in 1995, when new Visual FoxPro for Windows was introduced.

As the session was mainly focused on using Visual FoxPro effectively, Pavel decided to start testing the audience and went on with a kind of a warming-up exercise. For example he took the situation, when you need to add a backslash to a path in order to combine it with, say, a file name. You are not sure, whether the backslash is not already there, so you have to check that first. In the oldest DOS versions this was done using quite a few commands. Later, when IIF function was introduced, the number of lines needed for this reduced significantly. It was when ADDBS function was added to Visual FoxPro, this became a one-line only operation. The funny thing though is that Pavel also compared the speed of each of the ways of doing the task. Not surprisingly, the oldest method was the fastest one and the ADDBS the slowest one. Even though ADDBS has its undisputable advantage in legibility in code by being a single command, in large cycles it might be a good idea to try one of the older methods.

In a similar fashion Pavel showed many other ways of doing one task differently and kept comparing the speed results. He also recommended using TEXT and ENDTEXT for putting together SQL SELECT commands to be used by SQLEXEC. It makes perfect sense and it makes it very well arranged with larger SQL commands, such as an extreme SELECT statement Pavel showed, counting about 20 pages.

Throughout his session Pavel also asked many questions for the audience to answer. Perhaps because they were too difficult or that this was almost the last session of the conference and everyone was a bit tired, no one answered any of the questions so Pavel sadly had to keep all the prizes he had prepared for giving out.

Pavel wrapped up his session by showing some of the internals of Visual FoxPro, such as viewing FXP files with a HEX editor. If one is to use VFP effectively, he has to know what is happening behind the scenes.

Questions and answers about SQL by speaker’s forum

Just as yesterday there was a questions and answers forum for Visual FoxPro, there was also one today for the SQL server topics. There were many questions asked, mostly very specific ones, where the speaker’s forum excellently showed their knowledge and experience by answering them from the top of their heads.

Pauses, when people were sorting their thoughts about what questions to ask next, were filled with various funny stories from the real life of an SQL administrator. One I personally liked very much is: Do you know what to use when you need to end a cycle in T-SQL procedure? Simply, just divide by zero. It is almost unbelievable to me that anyone would resort to this, putting it to a production SQL server stored procedure.

At the very end, every attendee who had asked a question was also rewarded with a SQL 2008 book.

Final words and acknowledgement

Another year of the traditional DevCon event in Prague has ended. The organizers repeated the success from the last year by carefully mixing the Visual FoxPro and SQL server sessions, making it again a great event for everyone.

Even though it was hardly noticeable on all of the crowded hallways, the attendance dropped a bit compared to the previous year. This is however nothing to be extremely worried about as that is a trend of this crisis year’s events anyway. Everyone is already looking forward to next year, when everything will again back again in its full strength.

Here, at the very end of the report, we, the reporters would like to express our gratitude to everyone who had helped making our reporting job as smooth as possible. Namely, we would like to thank especially:

Igor Vít, the main person behind organizing and putting the event together, for his vigor to keeping the event alive and as strong as possible. Thank you Igor!

Darina Vodrážková and all of the yellow and white t-shirt Daquas team for being everywhere, working almost like bees in a hive, where all the little details together make the perfection. Thank you!

Pavel Celba, for being our camera savior and providing many of the conference pictures which you can find either in the report itself or in its archive. Thank you Pavel!

Michel Fournier, the “father” of the UT reporting, for taking care of everything needed for delivering the report, as soon and as complete as possible to all of you, world-wide. Thank you Michel!

Feel free to share your experiences from the conference, any notes on the reporting, as well as your ideas of the UT coverage improvements on the UT forum. We are always happy to get the feedback from you!

See you next time!

Jan Vít, Vitsoft
 
Jan Vít is a student of the University Of Economics in Prague. Since 1993 he has been actively interested in programming as well as other areas of information technology. His computer experience started with PC 80386 with FoxPro 1.02, later followed by higher versions for the DOS platform and since 1999 he has been using the newest Visual FoxPro versions together with other programming languages and tools. Presently he spends most of his time with Visual FoxPro 9.0, MS SQL Server and C# in WinForms as well as WebForms development. He has been a regular speaker on the Czech Visual FoxPro DevCons since 2004 and is also the co-author of many DevCon conference reports from Prague and Germany. His work now mainly consists of developing software for pharmacies.

Karel Koliš
 
Karel Koliš is a student of University of economics in Prague. He works for VitSoft, s.r.o. company, which develops software for pharmacies. He is interested in .NET webforms and winforms programming, sometimes he uses PHP for easier web applications as well. His hobbies are IT, photographing and theatre.

Jan Kral
My name is Jan Kral and I am studying Third Faculty of Medicine, Charles University in Prague. I am interested in computer technology and medical science. In my free time I develop applications using Visual FoxPro 7,8 and nowadays I use VFP 9.0, all mostly for my personal use. I have been a co-author of several Czech VFP DevCons' UT reports. I also develop internet web pages using PHP, JavaScript, CSS and so on. Feel free contact me at my email.

SQL-Server & .NET DevCon 2008
DateContentDetail
06/09 16:31MeetingSQL Server Tools, Strate...
02/09 00:44NewsPEM Editor 6 has been re...
27/08 17:57NewsSouthwest Fox 2010 Early...
25/08 04:30NewsCryptoLicensing For .Net...
22/08 09:58NewsWindows Phone 7 Gold Rush
16/08 03:05NewsVisual WebGui reveals it...
11/08 17:54MeetingSo You Think You Want To...
10/08 16:41News.NET Training for VFP Pr...
09/08 18:33MeetingLINQ & SQL Server Reporting
03/08 08:15JobsSQL/VFP Developer for Ma...
29/07 10:59News.NET 4 for VFP Developer...
26/07 10:13JobsVFP Developer (Two Perma...
25/07 06:44NewsWith Visual WebGui 6.4 R...
24/07 11:00JobsQuality Assurance Softwa...
24/07 10:53JobsIntegrations and Web Dev...

Copyright © 1993 - 2010 Level Extreme Inc., All Rights Reserved · Telephone: 506-783-9007 Email: info@universalthread.com · Privacy & Security · Copyright · Terms & Conditions