Discuss Content Posted by Amit Lohia

Discussions about content posted by Amit Lohia.

RE: How do Searches on a Form with Subforms work?

Aaron:This is an old question so you may have answered it by now. How is your subform related to the main form? Are you linked on a particular field? If you can clarify the issue, that may generate a better response.Thanks,Sam

ODBC connect to Oracle in Windows 2003

We've been migrating DTSs from a Windows 2000/SQL 2000 box to a Windows 2003/SQL 2000 box and have had trouble moving the connections to Oracle.  We installed first Oracle 9.2 and then Oracle 8.1.7 without any change.  We're able to connect via SQL Plus to each of the databases without problem, so I know everything […]

RE: ETL

Huh?

You have created a certificate for MyUser with...

Keep Bad Guys at Bay with the Advanced Security Features in SQL Server

In this article I'll explore the most interesting security enhancements in SQL Server 2005 from a developer's viewpoint. I covered admin security features in the Spring 2005 issue of TechNet Magazine. But there are plenty of dev-specific security enhancements I can explore, such as endpoint authentication and support for the security context of managed code that executes on the server.

RE: How to move text file in Stored Prcoedure

That's what I was about to finish typing .

RE: Comparing date fields in a single row

I'm bad about remembering error coding when I try and answer a question quickly.  Glad it helped. 

RE: Every DBA Should Know Which Databases are be Backed Up

I'm wondering what the advantages are to using DECLARE to create a table in memory versus CREATE #tmpTbl or even a SELECT...INTO #tmpTbl. I've used data type of table in functions that return a table but never like this in a proc. Anyone?

RE: Teamwork

That really hits home for me too. I agree with Del (above). I have a short list of developers that I actually consider savvy enough to build solid code and an immense list of developers that I [know] from experience code horribly. The "good" coders are the ones that take pride in their work. It's […]