(Ameet Phadnis) Last year I wrote an article on ASPalliance entitled Working with SharePoint Templates. In that article I explained how we can customize SharePoint templates to brand your website. For that process you needed to know lot of stuff and frankly, if you missed any steps, the whole Templa
Other News
SQL Server 2005 Express vs. Desktop Engine (MSDE)
(Serdar Yegulalp) SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) are both free and redistributable. Each product provides a medium where database administrators can work between MS Access and the full version of SQL Server. But there are key differences to consider. (R)
Getting started with DB2 Document Manager, Part 3: Learn how to use compound documents
(Paul R. Welka) This tutorial builds upon Part 1 of this series and illustrates a valuable feature of the product. In this step-by-step tutorial, learn how to set up compound document relationships. Specifically, you learn how to set up the document management system to maintain the relationship bet
To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
(Alexey Kovyrin) When we optimize clients’ SQL queries I pretty often see a queries with SQL_CALC_FOUND_ROWS option used. Many people think, that it is faster to use this option than run two separate queries: one – to get a result set, another – to count total number of rows. In this post I’ll try t
What is your SQL Server backup strategy?
(Steven Warren) Most database administrators (DBAs) know what it’s like to be called away from home or dinner or even awakened in the middle of the night to answer a page or a cell-phone call concerning some type of database disaster. These are the times you’re glad that you have a systematic backup
Use Trace to capture Production Server Activity
(Allen White) One of the great things about SQL Server is that there are many ways to accomplish the same task.
Importing CSV Files, SQL Server Management Tools
Don’t Miss the Weekly SQL Server Show… Released on Fridays, available now. Watch it here. Featured Article(s) Importing a .csv File into SQLExpress Using Bulk Insert Have you wondered how to import text file data into SQLExpress without using DTS or SSIS? This article will show you a possible approach using the T-SQL Bulk Insert Command. Report Distribution Options Get […]
XML Data – To be stored or not to be stored, and beyond…
(Marco Gralike) It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be archived and you will need an account to access them). Because I am highly interested on XML / XMLDB stuff, I scrolled th
Yup, it’s definitely time to start thinking about that DB2 9 for z/OS upgrade
(Willie Favero) And how do I know that? For starters, I just finished reading a paper by Julian Stuhler of Triton Consulting titled “DB2 9 for z/OS – Data On Demand”. If you know someone who needs a nice concise “to the point” description of the value of DB2 9 for z/OS, this is definitely the paper
Avoid Oracle Portal at all costs
(Rex Baldazo) The main reason my Learning Oracle ADF series this month was so late, the reason I had so little time to work on the series, was because I spent most of the month struggling with Oracle Portal. If your boss ever brings up the subject of Oracle Portal, you should run screaming from the