New Horizons Get Schooled Blog

Get quick database login information from the application code

Posted on 5/8/12 3:23 PM by Get Schooled in application code, in asp.net, in database, in IT Career, in Tips & Tricks

So, you're asked to fix a database problem for a web application. The trouble is that nobody can tell you a valid database username and password—or even where the database is! You could spend hours searching the application code and tracking down everyone in your company who you think might know.

0 CommentsContinue Reading →

Use a New Method to Write Queries and Avoid Headaches

Posted on 7/5/11 11:00 AM by Get Schooled in database, in naming convention, in New Horizons Computer Learning Center, in Tips & Tricks

Avoid headaches while writing queries by using this column-naming method

0 CommentsContinue Reading →

Alternatives to storing BLOB data in the database

Posted on 1/14/11 3:00 PM by Get Schooled in BLOBs, in database, in MSQL 7+, in .NET, in New Horizons Computer Learning Center, in PDFs, in Tips & Tricks

Practical alternatives to storing BLOB data in the database (MSQL 7+)

0 CommentsContinue Reading →

Upgrading to 10g an obvious choice for RAC databases

Posted on 12/18/09 12:22 PM by Get Schooled in ASM, in database, in DBA, in New Horizons Computer Learning Center, in oracle 10g, in RAC

ASM makes upgrading to 10g an obvious choice for RAC databases (Oracle Database 10g)

0 CommentsContinue Reading →

Never hit the wrong database

Posted on 11/22/09 2:31 PM by Get Schooled in database, in Microsoft, in New Horizons Computer Learning Center, in SQL Server, in Tips & Tricks

Never hit the wrong database again in the Query window (SQL Server)
It’s easy to do. You create an object and later wonder why it’s not there. This can happen if you’re in Query Analyzer or the Query window in Microsoft SQL Server Management Studio and forget to select the correct database in the dropdown box. In some cases, you may have even selected the correct database, but if you’re working with SQL Server Express, it may connect you to the wrong database when you reconnect.
To avoid this problem, get into the habit of starting your query pages with a Use statement, such as:

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.

     

    Subscribe