Assuming database is required, the following 112 results were found.
-
Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Restructured extension into an MVC model (fixes H3 and Module Class Suffix issues) - Removed Joomla! Admin Option: Content Database Length - Date Uploaded: Mon, 13th Jun 2011 1.6.3 - Core script reverted to v1.5.2 - Styled Joomla! Admin Options into...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
tools and instead have built a back-end Joomla! administration component that only works in MS Internet Explorer; any database hacks or FTP file uploads immediately corrupt this component. The component itself is sort of good, but file description has...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
their templates compatible with phpBB. phpBB3 installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the phpBB3 system. For installation purposes, this mysql user has...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
need to remove these and restore your website. I'd suggest joomlapack if you're using a joomla site, backup just the database, do a fresh install of joomla and use the database sql file as the migration script. There are some more details of prevous CB...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
you've lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
(eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
THE BELOW: this works for me and the timetabling system I have, you need to adjust how you get the values from your events database). First get the events from your database and then get the rooms: ), Events AS ( --Create some events to place on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator rows so ideally we would like: Day ---------------- Monday Monday Monday Tuesday Tuesday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB