Microsoft's (un)secret weapon for winning the BI battle

Microsoft's (un)secret weapon for winning the BI battle

Posted using ShareThis

database administration

GSA to Present Cloud Initiative at NCOIC
By Kevin L. Jackson , Vice President at Dataline A General Services administration (GSA) representative is now scheduled to provide a briefing on the agency's cloud computing initiative during a %26ldquo; Best Practices for Cloud Initiatives using Storefronts %26rdquo; session on September 21, 2009 in Fairfax, VA. The session, part of the Network Centric Operations Industry Consortium (NCOIC) Plenary , is expected to foster an interactive dialog on interoperability and portability standards for Fed

sql server

Intus Security N�01
1-Cross Site Request Forgery 2-�� Protegete del XSS !! 3-HTTP Parameter Pollution 4-sql server en Microsoft sql server 5-�No seas victima del Pharming! 6-El Remote Code Execution 7-Slowloris: Denegaci�n de servicio en Apache 8-�Protege Tu Bluetooth! Descargar Temas relacionados: Phrack N�62 Phrack en Espa�ol N�62 Insecure Magazine N�01 Hack x Crack N�12 Hack x Crack N�11 Comparte este tema:

sql

Generate INSERT INTO script for existing data in sql Server 2008
It always amazes me how little features are built into sql Server Management Studio. One of these (trivial) things is to generate a script which inserts existing data. Fortunately, it has become a feature in sql Server 2008. short story: right click the database > tasks > generate scripts > enable %26ldquo;script data%26rdquo; option full story: here

t-sql

Today's Link: Free eBook %26ndash; SQL Server�Tacklebox
%26ldquo;SQL Server Tacklebox%26rdquo; eBook by Rodney LandrumContent (Verbatim from the site)Scripts, tools and techniques to tackle SQL Server issuesTroubleshoot performance issuesReceive notifications of impending issuesFight off data corruptionDocument and report on your serversAutomate and standardize SQL Server installationMigrate data and manage data growthSecure access to your serversBe thankful to these guys! Download their free trial (The ebook itself is FREE).Here's where to get it: http://www.red-ga

sql server reporting services

sql server 2008 R2 August Community Technology Preview Available
Microsoft released sql server 2008 R2 August Community Technology Preview which includes the Report Builder 3.0 R2 August CTP redistributable.

ssas

Nice%26hellip; first baby steps with Gemini
I was able (thanks to some friends at Microsoft) to download and install the SQL 2008 R2 August CTP and Microsoft Office 2010 %26ldquo;Gemini%26rdquo; add-in%26hellip; Gemini is effectively an Excel Add-in%26hellip;. and appears as an additional tab on the Ribbon%26hellip; First I tried to just get some simple stuff together by getting some data from the Access Northwind database..I was taken through a neat little import wizard, selected all the Northwind tables and the result was a report on what had been imported On

ssis

Using Variables in ssis Script Component
I've found a technique to efficiently exchange information between a script component and the host ssis package. I always use package level variables as I have not seen nor heard of any reason to use component level variables. I don't use the readonly/writeonly variables in the script task editor. Instead I use the following VB code: Dts.VariableDispenser.LockForRead("User::sales_file") Dts.VariableDispenser.LockForWrite("User::ftp_sales") The above code locks the sales_file� variable for

ssrs

SQL Server 2008 R2 CTP - Where is Reportbuilder 3.0?
Having just installed the August CTP of SQL Server 2008 (R2) it was mentioned in the notes that it comes with ReportBuilder 3.0 that has the added functionality of being able to map spatial data (amonst other things). It IS included with the install, however it's not immediately obvious where%26hellip; does not appear on list of newly installed programs etc etc%26hellip;. If you install the report server you will see that it can be installed %26ldquo;out of the box%26rdquo; as a click-once install from the report server home

sql server integration services

Upload, Process and Report%26hellip;Made Simple
I am currently hiring a new developer and since these opportunity are far and between nowadays, I want to make sure I pick the best one for our environment.� I am already doing all of the basics: recruiter interviews, phone interviews, in person interviews, each with increasingly more in-depth technical questions.� But, I wanted to add an additional step of a practical interview.� Basically, come up with a development request, with as little information as possible, so that I could see where the

sql server integration services

Upload, Process and Report%26hellip;Made Simple
I am currently hiring a new developer and since these opportunity are far and between nowadays, I want to make sure I pick the best one for our environment.� I am already doing all of the basics: recruiter interviews, phone interviews, in person interviews, each with increasingly more in-depth technical questions.� But, I wanted to add an additional step of a practical interview.� Basically, come up with a development request, with as little information as possible, so that I could see where the

ssrs

SQL Server 2008 R2 CTP - Where is Reportbuilder 3.0?
Having just installed the August CTP of SQL Server 2008 (R2) it was mentioned in the notes that it comes with ReportBuilder 3.0 that has the added functionality of being able to map spatial data (amonst other things). It IS included with the install, however it's not immediately obvious where%26hellip; does not appear on list of newly installed programs etc etc%26hellip;. If you install the report server you will see that it can be installed %26ldquo;out of the box%26rdquo; as a click-once install from the report server home

sql server

Reporting Services Lookup Functions
One new SSRS sql server 2008 R2 feature that caught my attention is lookup functions. When reading the Reporting Services discussion list, I come frequently across questions that ask if it is possible to look up a value from a dataset other than the dataset the region is bound to. Excluding getting the first or last value (First and Last functions) or aggregate functions that work on the entire dataset, the only solution was to cache the dataset in a report code-behind code and use custom code t

sql

Securing Wordpress: An Overview
Wordpress by default isn't the most secure pre-rolled blogging and content management system on the market but the sheer amount of developer and community support makes it an easily deployable and extendable web-app. We're going to go over some ideas based on past problems with Wordpress and offer suggestions to help secure a basic install. Let's start by looking at the WP (Wordpress) security track record. milw0rm.com shows a lot of sql injection problems, most of them in plugins and a fe

ssas

Nice%26hellip; first baby steps with Gemini
I was able (thanks to some friends at Microsoft) to download and install the SQL 2008 R2 August CTP and Microsoft Office 2010 %26ldquo;Gemini%26rdquo; add-in%26hellip; Gemini is effectively an Excel Add-in%26hellip;. and appears as an additional tab on the Ribbon%26hellip; First I tried to just get some simple stuff together by getting some data from the Access Northwind database..I was taken through a neat little import wizard, selected all the Northwind tables and the result was a report on what had been imported On

database administration

Batch Processes for Organisations
Have you ever wanted to build a process to validate all of your Account addresses? Or perhaps create a background process, iterating through millions of records, creating object relationships based on complex logic? What if you could implement these processes natively on the saleforce.com platform? In Winter '10, Apex code is planning to release Batch Apex. This feature will provide customers the ability to natively build and deploy complex business processes, operating over entire data sets, le

ssis

Which version of ssis-DTS Package Search is right for you
The download page for ssis-DTS Package search presents three choices: ssis-DTS Package Search for SQL Server 2000 on Windows x86 ssis-DTS Package Search for SQL Server 2005 on Windows x86 ssis-DTS Package Search for SQL Server 2008 on Windows x86 Although there are really only two different versions of the executable, I wanted to give a SQL Server 2000 choice to make it clear that DTS is still supported. Actually both versions support DTS packages. The reason for the two versions is

t-sql

�Puedo utilizar IIF en t-sql?
Esta publicaci�n tiene origen a partir de una consulta realizada por un compa�ero. Es usual que esta pregunta se la hagan aquellos que vienen con conocimientos adquiridos en Access, aunque en este caso se trataba de reescribir para SQL Server una consulta originalmente escrita en MySQL (IF en vez de IIF). Luego de buscar un poco llegu� a unas FAQs que dieron soluci�n a este problema. Te guste o no, las consultas que utilicen IIF (o IF en MySQL) deber�n ser reescritas utilizando la expresi�n

sql server reporting services

MS sql reporting services in Silverlight is real!
The fact that Microsoft is the monopolist of the software market is incontrovertible. But no one is perfect%26hellip;Microsoft has two powerful technologies: MS sql reporting services that is the world recognized industry standard of report generators, and the Silverlight, a relatively new, but extremely promising technology for BI, that acquires hundreds of fans literally with every breath we make. Silverlight promises to be the № 1 platform for BI applications creation due to the fact that it not only

mssql

Inventory Data Feeds
I have 2 vendors that have a datafeeds. One is clothing and the other fragrance/skincare datafeed that updates inventory daily. This needs to able to add/edit/delte/ as needed. OS Commerce Shopping cart. Place bid

ssas

HF SSB JRC JSS 2150,AIS,VHF,INMARSAT,EPIRB,RADAR,GPS JRC ,02193355277,97273601
CV.KBSA BIDANG MARIE JRC GMDSS JRC : - JRC JSS 2150 MF/ HF RADIO TELEPHONE - JRC JSB 196GM 150W MF/ HF RADIO - JRC JSS 296/ 596/ 896 250/ 500/ 800W MF/ HF RADIO - JRC JHS 770S SIMPLEX/ SEMI DUPLEX VHF RADIO - JRC JHS 780D SIMPLEX/ DUPLEX VHF RADIO TELP - JRC JUE 85 INMARSAT C MOBILE TERMINAL - JRC JQE 103 EPIRB - JRC JQX 30A SART - JRC NCR 333 NAVTEX AIS JRC : - JRC JHS 182 AIS INMARSAT JRC : - JRC JUE 500 INMARSAT FLEETBRODBAND - JRC JUE 410F FLEET F77 MARITIME SATELITE - JRC J

sql server reporting services

MS sql reporting services in Silverlight is real!
The fact that Microsoft is the monopolist of the software market is incontrovertible. But no one is perfect%26hellip;Microsoft has two powerful technologies: MS sql reporting services that is the world recognized industry standard of report generators, and the Silverlight, a relatively new, but extremely promising technology for BI, that acquires hundreds of fans literally with every breath we make. Silverlight promises to be the № 1 platform for BI applications creation due to the fact that it not only

t-sql

SQL Server 2008: Extended Events Manager GUI
For those of you going to our September 16th event here %26hellip; one of our sessions is being changed to cover Extended Events. I believe that Extended Events in SQL Server 2008 is one of those under utilized hidden gems within the system. It can be used for a wide variety of situations including: Troubleshooting [...]

sql

Download the sql Server 2008 R2 Enterprise CTP
Ladies and gentlemen, start your downloads. The sql Server 2008 R2 community preview is now available for downloading.� Read the Data Platform Insider blog entry for more details. The download link in that blog entry didn't work for me, but the ever-insightful Wesley Backelant pointed out that it's available in MSDN/Technet too.� In your product downloads, click on Servers, sql Server 2008.� The R2 Enterprise CTP is cleverly hidden in there, with downloads for x86 (hmmm), x64 and Itani

sql server

Best practices for Maximo performance
Here are some links to help with tuning your Maximo application. These range from database configuration to websphere.

ssrs

Giant bulb VU meter
The latest Inventgeek project is a 12 outlet control box. They decided to demo it using a giant bulb based VU meter . The control box has 12 individual outlets hooked up to two layers of six solid state relays. [Jared] notes that ssrs can be very expensive, but he purchased his on eBay for ~$10 each. Wiring and installation on this project is incredibly clean and they plan on using the control box for future how-tos. The simple audio circuit used for the VU is based on the LM3915. You'll find f

mssql

Quiz Component
I have a pet website, and I would like to offer my users various pet quizzes. I would also like to be able to use this component as a kind of %26ldquo;chapter test%26rdquo; for our Online Paid Dog Training Clients. Quizzes should be categorized on the front end for the user so they can select [...]

sql server integration services

Upload, Process and Report%26hellip;Made Simple
I am currently hiring a new developer and since these opportunity are far and between nowadays, I want to make sure I pick the best one for our environment.� I am already doing all of the basics: recruiter interviews, phone interviews, in person interviews, each with increasingly more in-depth technical questions.� But, I wanted to add an additional step of a practical interview.� Basically, come up with a development request, with as little information as possible, so that I could see where the

database administration

Forum database backups
Learn the importance of having forum database backups, and the different methods available for forum backups available for vbulleting, IPB, phpbb e.t.c Nothing is more important for the community than its consistency and continuity, I have highlighted all into my post.

ssis

SQL Output to an Email Attachment
This is a quick example of how to take the output of a sql query and email it to someone. The above image shows a few of the pieces. �Create a variable, in this case filename . �You then open the properties editor for the sendmail task. �You select fileAttachments �and link the variable. �This will send the text file you create as an attachment. �Now we go to the DataFlow �task to see how to connect the output of your sql to that same textfile. You create a DataReader

sql server

ASP.NET Dashboard
Programmers Wanted! Extra Cash Available For Completion Of a New Freelance Project I am looking for a asp.net c# vs2005 dashboard.  Database will be sql server 2005.  Please do not bid if you don't already have a dahsboard.  When you bid, please send me the link so that I know what ....... [ Read More ] Array skills are always in high demand, and buyers will pay a lot of money for a knowledgeable coder. Never before has it been so easy to work from home and make great money doing it. Yo

sql

Scrape Google Trends To Db
I am in need of a scraper which compiles data from the google trends RSS feed and puts it into a database organized by keyword/phrase, date scraped, and the number of times the keyword/phrase has appeared. Then a simple web interface to view this data, filterable or searchable by each column. I also want to [...]

t-sql

SQLAuthority News %26ndash; Humorous SQL Cake %26ndash; Funny SQL Cake
I� received the following interesting images in email during the past 2 months. I think they are superbly hilarious! I received them from various people at different times, so their is unknown. Let me know which of the following images you find the most interesting. Hope you enjoyed watching them! Reference : Pinal Dave ( http://blog.SQLAuthority.com ) Posted in Pinal Dave, SQL, SQL Authority, SQL Humor, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority

database administration

[SharePoint] Cas d'�tude %26ndash; MOSS 2007 en mode Haute Disponibilit� avec SQL Server 2005 database Mirroring sous environnement virtuel avec Hyper-V
Beaucoup d'environnement de production requi�re la disponibilit� permanente des informations, des documents et autres applications m�tiers de l'entreprise, il en va de m�me pour les infrastructures utilisant SharePoint 2007. La p�rennit� des fermes SharePoint et des donn�es utilisateurs tient dans l'int�grit� des bases de donn�es de la ferme! Et l'acc�s � l'information pour les utilisateurs tient � la disponibilit� des composants de la ferme SharePoint, a savoir: Les serveurs Webs Frontaux

ssrs

ssrs Reports URL - Performance issue on 64 bit with SQL Server 2005
Something I recently came across on an Dynamics AX 2009 instance, was a ssrs reports URL, performance issue. This is also referred to as the reports manager URL, it's the http://server/reports URL. What I saw was that the reports URL would be working fine, and then after some time of being idle, the worker process that runs that URL in IIS 7.0 would of course get destroyed to free that RAM up. On start back up, of that worker process, the reports URL would enver return. Closer details sh

ssis

SQL Output to an Email Attachment
This is a quick example of how to take the output of a sql query and email it to someone. The above image shows a few of the pieces. �Create a variable, in this case filename . �You then open the properties editor for the sendmail task. �You select fileAttachments �and link the variable. �This will send the text file you create as an attachment. �Now we go to the DataFlow �task to see how to connect the output of your sql to that same textfile. You create a DataReader

sql server integration services

Upload, Process and Report%26hellip;Made Simple
I am currently hiring a new developer and since these opportunity are far and between nowadays, I want to make sure I pick the best one for our environment.� I am already doing all of the basics: recruiter interviews, phone interviews, in person interviews, each with increasingly more in-depth technical questions.� But, I wanted to add an additional step of a practical interview.� Basically, come up with a development request, with as little information as possible, so that I could see where the

ssas

HF SSB JRC JSS 2150,AIS,VHF,INMARSAT,EPIRB,RADAR,GPS JRC ,02193355277,97273601
CV.KBSA BIDANG MARIE JRC GMDSS JRC : - JRC JSS 2150 MF/ HF RADIO TELEPHONE - JRC JSB 196GM 150W MF/ HF RADIO - JRC JSS 296/ 596/ 896 250/ 500/ 800W MF/ HF RADIO - JRC JHS 770S SIMPLEX/ SEMI DUPLEX VHF RADIO - JRC JHS 780D SIMPLEX/ DUPLEX VHF RADIO TELP - JRC JUE 85 INMARSAT C MOBILE TERMINAL - JRC JQE 103 EPIRB - JRC JQX 30A SART - JRC NCR 333 NAVTEX AIS JRC : - JRC JHS 182 AIS INMARSAT JRC : - JRC JUE 500 INMARSAT FLEETBRODBAND - JRC JUE 410F FLEET F77 MARITIME SATELITE - JRC J

sql server reporting services

MS sql reporting services in Silverlight is real!
The fact that Microsoft is the monopolist of the software market is incontrovertible. But no one is perfect%26hellip;Microsoft has two powerful technologies: MS sql reporting services that is the world recognized industry standard of report generators, and the Silverlight, a relatively new, but extremely promising technology for BI, that acquires hundreds of fans literally with every breath we make. Silverlight promises to be the № 1 platform for BI applications creation due to the fact that it not only

ssrs

C�mo agregar un filtro a una tabla con Report Builder�2.0
Hola a todos. En estos d�as me enfrent� a un problema al querer filtrar datos en una sola regi�n de datos en mi reporte y no en todo el Dataset. Pues les cuento que me pareci� importante escribir al respecto por si se les presenta alguna vez esta situaci�n. Para ver el art�culo: http://www.intermezzo-bi.com/Default.aspx?id=476Muchas gracias, y cualquier cosa me cuentan su opini�n

mssql

Mailing List Programming
We require someone to program a mailing list management program to allow for automatic unsubscriptions by email recipients, etc. Please respond as soon as possible. Place bid

sql

Cara membackup database sql Server
Wednesday, August 5th, 2009 %26ndash; 12:29 pmE-Book berikut menjelaskan bagaimana cara membackup database pada sql Server 2005 Express dengan alat bantu Microsoft sql Server Management Studio Express.Download cara-membackup-database-sql-serverLihat E-Book secara onlineSemoga bermanfaat.Tags: microsoft, sql server 2005, studio express This entry is filed under Tips %26 Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackbac

database administration

Biggest Companies Rake In Recovery Act Contracts
During the past five months, 17 of the largest government contractors have won more than $1.6 billion in Recovery Act contracts %26mdash; more than all small businesses combined %26mdash; according to a new spending analysis conducted by Government Executive. The data, which is updated through July 15, was obtained through USASpending.gov.The overwhelming majority of these contracts were issued by the Energy Department, primarily for construction, demolition and environmental cleanup projects at its laborator

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 server

Hadoop %26ndash; Come elaborare grandi dataset
Supponiamo di avere un file ASCII contenente valori di parametri ambientali, ad esempio le temperature orarie giornaliere di una data zona relative ad un intero anno. Un tale file potrebbe essere prodotto da una centralina di rilevamento del tipo utilizzato in meteorologia. Supponiamo adesso di voler calcolare la temperatura media di ciascun mese oppure di ciascun giorno della settimana. Quali strumenti potremmo utilizzare? Potremmo importare il file in un foglio elettronico (OpenOffice Calc/Exc

t-sql

TSQL Challenge 11: Calculating the lowest price of an item by applying discount coupons
TSQL Challenge 11 was a practical problem. Given a a list of products and a list of discount coupons, we needed to find the minimum price for all the products based on certain rules. Here are those rules: Maximum two coupons can be applied on the same product The discount price can not be less than 70% of the original price The total amount of the discount can not exceed 30$ Also, note that coupons are applied in a cumulative way. So the second coupon is applied on the result of the o

ssis

Implementing %26 Maintaining Integration Services 2008 MS SQL SERVER Bellevue Redmond Seattle
September 14, 2009 to September 18, 2009 Bellevue Redmond Seattle Kirkland Issquah Sammamish Eastside Northwest United States This is a one week instructor-led course that provides students with knowledge and skills to implement an integration services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. This training will teach you how to create ssis packages, implement control flow, data flow, logging, debugging, error han

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

sql server reporting services

SSRS %26ndash; Excel Unformatted Export
Have you ever had a report that was sorted, grouped, and met every requirement?� Assuming you did, have you ever had someone call you up and ask for your perfect report exported to Excel and then sorted in a different fashion?� Maybe they just want the raw data and not all the groups and formatting?� OK, this can be accomplished with a little work, but wouldn't it be nice to have a user export option to accomplish this task?� The current SSRS %26ldquo;Excel Export%26rdquo; option exports the groups and heade

ssrs

ssrs %26ndash; Excel Unformatted Export
Have you ever had a report that was sorted, grouped, and met every requirement?� Assuming you did, have you ever had someone call you up and ask for your perfect report exported to Excel and then sorted in a different fashion?� Maybe they just want the raw data and not all the groups and formatting?� OK, this can be accomplished with a little work, but wouldn't it be nice to have a user export option to accomplish this task?� The current ssrs %26ldquo;Excel Export%26rdquo; option exports the groups and heade

database administration

Scan your Wordpress blog for security vulnerabilities
[Category Wordpress | August 3, 2009] There may be lots of chances that your blog is lacking various security vulnerabilities, for fixing security vulnerabilities I recommend you to use WP Security Scan.Why should you use WP Security Scan? As I said above that there may be chances that some security vulnerabilities lacking behind after wordpress installation. WP Security Scan Plugin Scans your WordPress installation for security vulnerabilities and suggests corrective actions.It Scans followin

sql server reporting services

Job: Sr. Database Developer %26ndash; sql server
July 30th, 2009 Posted in JobsSr. Database Developer %26ndash; sql server %26ndash; .Net (VB or C#) %26ndash; Boston, MA Area %26ndash; Up to $100K+ DOE Up to $100K DOE + Bonus Local Candidates Only %26ndash; No SponsorshipCompany Mid-Sized, successful, and growing Boston based global investment management company %26ndash; Great Company %26ndash; Lots of Upside %26ndash; Excellent Compensation Package %26ndash; BonusPosition Responsibilities %26ndash; Summary The Data Technologies team is responsible for supporting and architecture of a global sql environment. Responsibili

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