Do you ever get so engrossed in solving problems that you lose all track of time? That is how it works out for me many times. I get so focused on completing the current problem that I lose all track of time. It’s nice to be able to concentrate like that, but it can sure get me into trouble. In […]

Today is Day 2 of the Free SSWUG.ORG Virtual Conference Yesterday we talked a bit about trust and specifically TRUST in the information and data systems we manage… Day 2 brings more sessions, more tips and, well, more. It’s easy to join in and check out the free online event – Just head to the site and register or head […]

Many years ago I worked on a project converting a Windows application into a web site. One of the interesting things about the project was the aspect of reporting. The original windows application used Crystal Reports for reporting. It was bundled with Visual Studio, and freely distributed. We used Chrystal Reports in our Proof of Concept web site, and found […]

Free SSWUG.ORG Virtual Conference Starts Today We have some excellent presentations on tap for you in the two-day, free SSWUG.org Virtual Conference. It’s getting underway today at 11:00am EST and runs today and tomorrow. If you’re not yet registered, there is still time to do so, just head to: http://www.sswugvc.com You’ll be able to register for the event and you’ll […]

Where would we be without ODBC and JDBC? I can guarantee you that life would be much harder today without them. I really liked the idea of ODBC when it was first introduced by Microsoft. It was based on the old COM technology, and was one of the first frameworks that wrapped a standardized SQL syntax around many different data […]

As a follow on editorial for database security, I was reminded that the needs of ORM tools may be a little bit different than database access you control yourself. One of the comments addressed Entity Framework (EF) specifically because it assures your database schema is synchronized with the code being executed. When software using EF first connects to a database […]

What’s the first thing you should do when you create a new database for a corporate environment? Remove all accounts from the DBA Schema, and create an Application account pointing to another schema. There may be other databases other than those hosted in a corporate environment, depending on the required security and authentication mechanism. That’s a pretty strong statement. So […]

I’m spoiled when it comes to working with SQL relational databases. I say spoiled because it is quite amazing how transportable the SQL language is. When you have learned the basics of the SQL Language you can apply it to just about any implementation of an SQL Engine due to the tendency to adopt ANSI standards in the implementation of […]

Only Days Left to Register… For a Free Online Conference! There are only a few days left – the event is next week – we’re bringing you great content, incredible presenters. What we’re not bringing you is the time out of the office. Or travel. Or really boring lunches. Take a look at the site – check out the sessions. […]

Making your own code follow the concepts of an ACID transaction is not all that fun. I’ve been playing with an in memory engine where portions of the data in the memory is modified frequently throughout the data. It takes quite a while to startup a new instance of the engine if you read the objects from source application. So, […]