ssas

SQL Server 2008 data warehousing video tutorials
Recently I stumbled upon some interesting SQL Server 2008 data warehousing screencast by Eric Hanson. Eric Hanson is the principal program manager for SQL Server data warehousing. Below mentioned are the links to these screencasts. SQL Server 2008 Configuring tempdb for Data Warehouse SQL Server 2008 Configure DW Storage SQL Server 2008 Star Join Query Optimization SQL Server 2008 Star Join Query to Excel Pivot Table

sql

sql command for removing post revisions in Wordpress.
Aug.02, 2009 in Uncategorized Back up your database before executing the command just in case you did something wrong or phpmyadmin screwed up.sql command for removing post revisions for WordpressDELETE FROM wp_posts WHERE post_type = %26ldquo;revision%26rdquo;;You can execute it in phpmyadmin by clicking the sql butto, pasting it in the sql window�and pressing Go button. sql��If you want to� disable post revisions for Wordpress there are plugins available to disable or custumize how many post revisions you can

mssql

Online Poker %26 Bingo Site
i NEED PROFESSIONAL TEAM FOR THIS PROJECT !!!!!!!!! Please do not waste my and your time %26hellip;.. I need to develop a poker %26 bingo site including design and payment systems as well I need 3d poker site like http://pkr.com all games like Omaha Texas etc also i need same poker in 2d as well i need to give my [...]

sql server

Need Professional Hacker To Test My Site For Exploits by pspsales
I am looking for a professional hacker to test my site on its current test server before it goes live. You will be looking for exploits that could potentially lead to my site being hacked. You must know the following: XSS; Remote sql Injection%26hellip; (Budget: $30-250, Jobs: PHP, Script Installation, [...]

sql server integration services

Using IBM's OLE DB Provider for DB2 with SSIS
If you have never used IBM's OLE DB Provider for DB2 with sql server integration services before, here's a step-by-step way to set it up.� Note that this is NOT Microsoft's OLE DB Provider for DB2, but rather IBM's OLE DB Provider.� IBM's iSeries Information Center has some good information about their provider.� This provider has to be installed separately from SSIS, so if you are developing locally, make sure you have installed the provider before completing the steps in SSIS below. Crea

ssis

A Close Look at LookUp
Look Up Transormation Pre-requisite: SQL Server Integration Services (ssis) Are you new to ssis' Look-Up? Bing it! Or visit, http://msdn.microsoft.com/en-us/library/ms141821.aspx. Presented is the ssis internal about the Look-Up component. %26bull;�� Memory: The Look-Up component operates in the Full Cache mode , i.e. while executing it caches the entire reference table/dataset into memory, this is done in the pre-execute phase and the database is not contacted again. The other mo

t-sql

SQLAuthority News %26ndash; Download Microsoft SQL Server Management Pack for Operations Manager 2007
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities. The following list gives an overview of the features of the SQL Server management pack. Support for Enterprise, Standard and