SQL Server 2005 Install Samples

AshokTechnical TipsLeave a Comment

If you have installed SQL Server 2005, it is likely you have installed the samples as well. In my case, I installed what I thought to be everything, realizing that the samples did not install. When I went in through the normal set up to install them, I was not able to. Thankfully, I found a workaround that prevented me from having to uninstall and reinstall… Go to Start –> Control Panel –> Add/Remove Programs Click “Change” for SQL Server 2005 Entering the setup from this approach, you will have the option to add/change components. Follow the wizard, and when … Read More

Outlook/Exchange 2003 Address Book

AshokTechnical TipsLeave a Comment

Have you wondered why the Outlook/Exchange 2003 address book does the (sometimes strange) things that it does? …when does it refresh/replicate? …does it work the same online versus offline? …etc., etc. Well, I found a great Microsoft KB Article to answer these questions that I just had to share: http://support.microsoft.com/?kbid=841273 Enjoy!

Oracle Client Download (10g Windows Client)

AshokTechnical Tips6 Comments

Following is the link to the Oracle 10g Release 2 Client for Windows: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html As of this writing (in January 2006), this is the latest Windows Client available. Update: Oracle Client Download (11g Windows Client) – 32 bit and x64.

Copy Table Columns and Data

AshokTechnical TipsLeave a Comment

As you may know, in Oracle the syntax from creating a table that is the same as another is: 1 CREATE NEWTABLE AS SELECT * FROM TABLEcreate NEWTABLE as select * from TABLE In SQL Server, the syntax is slightly different: 1 SELECT * INTO NEWTABLE FROM TABLEselect * into NEWTABLE from TABLE Note: This will not copy indexes, constraints, triggers, or other attributes of the table. It will copy the column names, data type, and data only.

SQLDataSource in .aspx Examples

AshokIndustry TrendsLeave a Comment

I will be placing SQLDataSource examples here shortly. I know there is controversy relating to placing SQL or even Stored Procedure names in .aspx files, but the reality is that for some applications, there is no need to concern ourselves with the complexities related to N-tiered, fully-abstracted, technical-utpoia development. This is especially prevalent when the resources working on an implementation do not have the background or ability (for a variety of reasons not always their own doing) to deliver solutions with these concepts intact each time.  Certainly, Microsoft must have agreed as they allow/support this approach.  None-the-less, feel free to engage in healthy … Read More

asp:ControlParameter vs. asp:FormParameter in Master Page

AshokTechnical Tips3 Comments

I hit what I considered to be an annoying “issue” in ASP.NET 2.0 the other day that I thought I would share so others can avoid the problem. I created a form with some text controls and an sqldatasource that called a stored proc while accepting parameters via asp:FormParameter. This worked great and tested out fine. Once I added the same code into a Master Page, everything began getting passed as “NULL” (it was no longer finding the FormParameters on the page. After troubleshooting for more time than I preferred, I found out that I can achieve success by using … Read More

Oracle Books for Developers

AshokTechnical TipsLeave a Comment

Following are some of the best Oracle books for developers. The only thing that gets DBA’s more upset than making a mistake that compromises a production database is when a developer makes the mistake. Even if it is merely culture-driven, developers need to be on top of their game when it comes to database-reliant enterprise applications. It only makes you that much better. Here are some good places to start: Cost-Based Oracle Fundamentals – Jonathan Lewis Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions – Thomas Kyte Effective Oracle by Design – Thomas Kyte

Oracle Materialized View Manual Refresh

AshokTechnical Tips1 Comment

Following is the call that can be made to refresh your materialized view in Oracle manually: 1 EXECUTE DBMS_SNAPSHOT.REFRESH('[MV_NAME]’,'[refresh_option]’);execute DBMS_SNAPSHOT.REFRESH(‘[MV_NAME]’,'[refresh_option]’); Refresh Options: ? – Uses default F or f – Fast C or c – Complete A – Always complete