smithvoice.com
Pages by tag

19 pages are tagged with Database


To check more tags, click here  click to open


ASP.Net Membership mdf setup without ASPNETDB.mdf


Summary:

Microsoft's ASP.Net Membership system isn't world-class bulletproof and has quite a few limitations so you'd not want to use it as-is for projects where money is involved, but for a lot of projects it fits the bill fine.

The only problem is that most of us get it into a project by banging on it and swearing a lot... then we forget about the pain till the next time.

This last time when my brain started saying 'next time I won't have to use this thing'... I figured I'd be smarter and write it down.  Also, because I am getting sick and tired of simple yes/no questions being answered by showing a YouTube video, I decided that I won't even show a single darned image in these steps.

[more]



The last remaining issue of long duration space life


Summary:

Had another request to add demo SQL to the old Magic Datepart page. Done.

Hey... yesterday two background voices came together in a flash.

First, while waiting for my tires to be replaced I caught a guy lamenting 'kids these days' not being able to look up from their Gameboys [sic] and AppPhones to save their souls.  Later I had Methuselah's Children playing at the house and along came that always-sad Heinleinism that the only long duration space travel issue truly unfixable by dedicated science and engineering (aka Just Doing It) is the deadliness of boredom.

Hmm.  Hmmmm.  Perhaps the rise of video games is the pink pill RAH didn't foresee?



Persisted Coalescence


Summary:

I knew PERSISTED.  I knew COALESCE.  Dang though, I hadn't thought to put them together!

ALTER TABLE myPersonTable
    ADD FullName AS  (
REPLACE(RTrim(Coalesce(Title + ' ','') 
+ Coalesce(FirstName + ' ','') 
+ Coalesce(MiddleName + ' ', '')
+ Coalesce(LastName + ' ', '')
+ Coalesce(Suffix, '')
+ Coalesce(NULL, '')), '  ', ' ') ) PERSISTED



WROX Professional ASP.Net MVC3 review


Summary:

Wow.  If this is what a "Professional" is now expected to know, I'm sad for .Net.

[more]



The magic datepart technique


Summary:

"Hi Smith! Remember the project that needed to allow entry of date values but the users couldn't be forced to any specific precision?  I have the same requirement and can't remember how you did the precision metadata, we're on SQL Server, not Oracle, was it a PLSQL ability?"

:)  Uh... you're thinkin' too hard, budd.  All I did was add a sibling column to the DATE field and packed it with the id/enumval of the desired datepart precision.  

I gotta laugh about my saying that you're thinking too hard, it's ironic...

[more]



Country Code Table


Summary:

"Hey Smith!  Got that country code table SQL?"

Yeah, right here.



MONO/Ubuntu part 20 - Connecting Mono to Oracle


Summary:

Now that your Oracle XE server is installed and running, you might like to hit it with a web page or two. You'll need to get a couple of extras for that, the System.Data.Oracle dll that's part of the MS.Net installation but not the Mono core and also a bit of middleware that will route your application calls through that dll to the Oracle server.

Like most things, this is all really easy once you've done it wrong a few times. Lucky for you, I've made all the mistakes already so all you have to do is just follow the bouncing ball.

Get and install the Mono System.Data.OracleClient - Get and install the Oracle Instant Client "middleware"



MONO/Ubuntu part 19 - Installing Oracle 10g XE Server


Summary:

Databases, databases, which one to pick. A religious issue with battles bigger than Islam vs Judaism and almost as bloody as the computer language wars.

But let's be practical.

If you're on Windows with a clean slate your first reach is for SQLServer, even the free single-core, 4gb maxed "Express" versions are right up to date with the latest and greatest full-on paid product. MS does the product very well. And if you have SQLServers running you're all set connecting to SQLS2000, 2005 and 2008 via Mono with all of your standard ADO.Net code.



DBMaker.net


Summary:

featured in Mike Gunderloy's Sybex Press book ADO AND ADO.NET Programming"

If you're a big iron RDBMS coder, consider that dynamically created Jet files as middleware have come in very handy for lots of folks using Oracle and SQLServer in the enterprise, so this is not just a power for those using Jet as a core source.

Years ago we noticed that we were spending more time writing DAO object code than working with data. So we took an afternoon and wrote the first SmithVoice.com DBCodeCreator. It saved us lot of time and other devs seemed to like it so we started giving it away on the SmithVoice.com sitelett.



Oracle to Excel? No sweat


Summary:

One of our most popular topics is the Smithvoice.com Export To Anything technique which allows you to convert and export any ISAM without automation or even having the source or destination native programs on the user's machines.  Need to turn Jet data into Lotus 123?  It is a simple issue of using an undocumented JetSQL query syntax and running the SQL off of the Execute method of a DAO database or ADO connection object.

But Oracle, Sybase, DB2 and SQLServer developers had thought themselves out in the cold on this .. figuring that they have to bite the bullet and pay the silly prices for 3rd party data pumps or (egad!) add full blown MS-Access installation to their systems and use it's not-so-fast ODBC linking in order to use this powerful technique.



<< 1 2 >> 
who is smith     contact smith     rss feed
Since 1997 a place for my stuff, and it if helps you too then all the better smithvoice.com