Monthly Archives: February 2012

Similarities between Access Databases and Projects

Similarities between Access Databases and Projects About indexes Article About indexing fields and records in an Access database (MDB) About indexes (ADP) About keys Article About primary keys (MDB) About keys (ADP) About queries Article About types of queries (MDB) … Continue reading

Posted in SQL Server | Tagged | Comments Off on Similarities between Access Databases and Projects

Microsoft Access 2012 Wish-List

I ran into this on the internet.. I think that it’s funny.. because I think that Access Data Projects include all 5 of these features already: Q: New Feature 1 – Recording Macros A: I use SQL Profiler for this!!! … Continue reading

Posted in Access, SQL Server, Visual Basic | Tagged | 1 Comment

Sun is Setting on MVC?

I am so glad that I don’t waste my time learning the latest and greatest client-side BULLSHIT. I still think that most logic deserves to reside on the server-side. Sorry, but I’ll always feel that way. Sun is Setting on … Continue reading

Posted in SQL Server | Tagged | Comments Off on Sun is Setting on MVC?

Don't Distract New Programmers with OOP

Wow.. I finally found someone who makes some sense. I think that OOP is an example of over-engineering.. I use OOP on the database side ALL THE TIME. Stored procedure inherits from a couple of views.. THAT is practical OOP. … Continue reading

Posted in SQL Server | Tagged | Comments Off on Don't Distract New Programmers with OOP

How can Microsoft fix their problem with mainstream developers?

Resuming Classic VB as a mainstream product would also mean best PR for them, too. The years ago, there were 6 million “professional” VB6 programmers. All of us, no matter what additional tools,languages and platforms are we using today, still … Continue reading

Posted in SQL Server | Tagged | Comments Off on How can Microsoft fix their problem with mainstream developers?

Perl Data Language gets auto-parallelisation

http://m.h-online.com/open/news/item/Perl-Data-Language-gets-auto-parallelisation-1430053.html?mrw_channel=open;mrw_channel=open;from-classic=1

Posted in SQL Server | Tagged | Comments Off on Perl Data Language gets auto-parallelisation

Don't rewrite old code 'just becase it's old'

http://www.joelonsoftware.com/articles/fog0000000069.html             Joel on Software Things You Should Never Do, Part I by Joel Spolsky Thursday, April 06, 2000 Netscape 6.0 is finally going into its first public beta. There never was a version 5.0. The last major release, version … Continue reading

Posted in Access, Internet Explorer, SQL Server | Tagged | Comments Off on Don't rewrite old code 'just becase it's old'

Area Codes – wish everyone used HTML tables for data.

I still love HTML tables.. I just wish that more people would just provide data like this.. IN A SIMPLE FORMAT. Long live HTML tables, I still think that Div tags are for idiots, sorry if I offend anyone when … Continue reading

Posted in SQL Server | Tagged | 1 Comment

how to import all the spreadsheets in a folder

I love Access / Visual Basic for importing files.. I just laugh when I talk about doing this same thing in SSIS, it takes MUCH less time to write a simple loop in script than to do it in GUI … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on how to import all the spreadsheets in a folder

how to remove spaces in column names

I use this method for EVERYTHING.. I learned this method from a book called ‘SQL Server 7.0 Secrets’ -Aaron select ‘exec sp_rename ‘ + char(39) + so.name + ‘.[‘ + sc.name + + ‘]’ + CHAR(39) + ‘, ‘ + … Continue reading

Posted in SQL Server | Tagged | Comments Off on how to remove spaces in column names