sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Content

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Content

ssis

ssis - Avoiding the Sort Components
When using a Merge or Merge Join component in a data flow, your incoming data is required to be sorted. While it may be easy to drop a Sort component into your data flow, it may make more sense to perform the sort in your source query (if you are using a source such as an OLE DB Source component). If you decide to use an ORDER BY in your source and want to tell the ssis Data Flow that your data is sorted, follow the below steps: First, ensure that your data is being sorted with the ORDE

Blog Content

ssas

Senior DBA - SQL
Senior Database Administrator Urgent position for Senior SQL DBA. We are looking to recruit a self-starting, creative and innovative Senior DBA .Based in our Dublin office, this role requires an enthusiastic person who is committed to the role and sets their own priorities. The successful candidate will have the opportunity to work in an open, dynamic environment and collaborate closely with business users at all levels and serve a key role in designing, developing and maintaining complex and in

Blog Content

mssql

Magento Shopping Cart
I need a Magento shopping cart modification to allow the following functions. 1. To allow three groups of users to login to the site (extension will be provided). 2. Three different prices be assigned to each group (extension will be provided). 3. To allow users to print price lists, invoices and shipping notes and labels for their own [...]

Blog Content

database administration

Cross Country Infotech (CCI) Walk-in for Java, J2EE, Networking System Admin.
This job is posted by Tushar and available at itjobsdelhi.blogspot.com Cross Country Infotech (CCI) Walk-in on Sept, 19th 2009 at Pune Software Developer (4-10 years exp): Java, J2EE, Alfresco, ECM, Documentum, PeopleSoft, WebLogic, Data Warehousing, Business Objects, DataStage, Informix 4GL Infrastructure Management (4 to 10 years exp): System administration (Solaris / Unix / Windows / WebLogic), System Security, Networking, database administration (Oracle/Postgre

Blog Content

sql

Signpost
Sometimes I feel as if all I do is direct people where to find the things they are looking for. Much like a signpost does. Now, I am not complaining about this. In fact, I want to be the signpost for others. I have no problem helping people find the information they need. And that is what I am doing here as I point you to a new article of mine over on Simple-Talk . It is on sql Server consolidation and is based upon a series of blog posts I did here . I enjoyed writing on the topic an

Blog Content

sql server reporting services

sql server 2008 R2: Creaci�n de un informe de tipo mapa!
Siguiendo con las novedades que vienen con sql server 2008 R2, y en particular con la nueva regi�n de datos de tipo Mapa que tenemos disponible para crear informes en sql server reporting services 2008, en esta ocasi�n os dejo un v�deo demostrativo sobre como construir un informe utilizando este nuevo tipo de regi�n. El v�deo ha sido realizado por Alberto Rivera .

Blog Content

sql server

Java/J2EE Jobs: Team Lead Required for an IT Company
Posted on September 16th, 2009 Java/J2EE Jobs: Team LeadSkills: Java, J2EE, Springs, iBatis, JSF, Java Rebel, IntelliJ, Selenium, Ant, MS sql server, Servelets, SVNExp: 4 %26ndash; 6 YearsJob Description: Good track record. Knowledge of Hibernate, Spring FrameWork, Core Java, JSP, Servlets, JDBC Desirable Skills -Spring, iBatis, JSF, SVN, Java Rebel, IntelliJ, Selenium, Ant, MS sql server with 5 years of proven experience. Team Leading Capabilities. Experience on JUnit testing. Experience on any jav

Blog Content

t-sql

SQLAuthority News %26ndash; Download Microsoft SQL Server StreamInsight CTP2
Microsoft SQL Server StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for timely and relevant processing of data. StreamInsight allows software de

Blog Content

ssrs

BI Training Update
We are now in the finale of our training, the Final project week. In our final project we will develop a system that can be useful for Setfocus. Initially they sent us the relational database that served as basis for the development of the OLAP Database. On the first day, we developed a dimensional model in MS Visio and generate a script for the schema that we can use as our staging database. We just finished the ETL part using SSIS and tomorrow our target is to finish cube creation using SSAS.

Blog Content

database administration

Active Directory Plus
Click to enlarge Active Directory Plus 2.5.5.0 ADUC+ is an easy to use, drag %26 drop application based on Microsoft's Active Directory Users and Computers. It allows you to administer your own forest as well as any external domain you trust. With ADUC+ you can restore deleted objects WITH their properties, such as group memberships, exchange settings and telephone number. In fact, you can Roll Back any changes you make to your Active Directory or Network Environment. Suppose you have accidental

Blog Content

t-sql

SQL SERVER %26ndash; Plan Caching and Schema Change %26ndash; An Interesting Observation
Last week, I had published details regarding SQL SERVER %26ndash; Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention is definition of schema change. I was well aware of this definition, but I have often found that users are not familiar with what exactly does a schema change mean. Many people assume that a change in the table structur

Blog Content

sql

sql Server 2005 Setup Doesn't Recognize IIS 7 on Windows Server 2008 R2 x64
Have you ever received a warning message when installing sql Server 2005 that indicates that you do not have Internet Information Services (IIS) installed, even though you have and it is working perfectly fine? I ran into a similar situation when I was installing sql Server 2005 Enterprise x64 on a Windows Server 2008 R2 Enterprise x64 edition. Here's what the warning message looked like. Notice that the warning is related to the IIS Feature Requirement and ASP.NET Version Registration Requireme

Blog Content

mssql

Need Ajax To Use Comet
Hi, I have a page with data that changes with Ajax. I need it to send the data using Comet Push Technology instead. Please only bid if you are familiar with Comet. Place bid

Blog Content

database administration

OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052)
OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052) by Paperback: 733 pages Publisher: McGraw-Hill Osborne Media; 1 edition (May 2, 2008) Language: English ISBN-10: 0071591028 ISBN-13: 978-0071591027 Description of OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052) A Fully Integrated Study System for OCA Exam 1Z0-052Prepare for the Oracle Certified Associate Oracle database 11g administration I exam with help from this exclusive Oracle

Blog Content

ssrs

Kerberos SPN Generation / Setup Tool
This is the first installment for a series of blog posts that describe how to use the Kerberos SPN Generation Setup Tool Beta in terms of documenting and helping you plan and creates SPNs for Kerberos Constrained Delegation with Microsoft BI tools.� The following is the outline of this series.� I will update this post as I complete the individual segments.� You can download the Kerberos SPN Generation Setup Tool Beta at RobertLambrecht.com .��� Rather than just complain about Microsoft no

Blog Content

t-sql

SQLAuthority News %26ndash; Risk and Health Assessment Program for Microsoft SQL Server %26ndash; Scoping Tool v1.2
This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server %26ndash; Scoping Tool v1.2 Reference : Pinal Dave ( http://blog.sqlauthority.com ) Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server

Blog Content

sql server

sqlAuthority News %26ndash; Risk and Health Assessment Program for Microsoft sql server %26ndash; Scoping Tool v1.2
This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft sql server. Download Risk and Health Assessment Program for Microsoft sql server %26ndash; Scoping Tool v1.2 Reference : Pinal Dave ( http://blog.sqlauthority.com ) Posted in Pinal Dave, sql, sql Authority, sql Documentation, sql Download, sql Query, sql server

Blog Marketing

ssas

Senior DBA - SQL
Senior Database Administrator Urgent position for Senior SQL DBA. We are looking to recruit a self-starting, creative and innovative Senior DBA .Based in our Dublin office, this role requires an enthusiastic person who is committed to the role and sets their own priorities. The successful candidate will have the opportunity to work in an open, dynamic environment and collaborate closely with business users at all levels and serve a key role in designing, developing and maintaining complex and in

Blog Marketing

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Marketing

sql server reporting services

Jessica Moss Reports On sql server reporting services
In this RunAs Radio podcast , Richard and I talk to Jessica Moss about sql server reporting services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis services to provide a deeper level of reporting. Jessica M. Moss, a Microsoft sql server MVP and business intelligence mentor with Solid

Blog Content

sql server reporting services

Jessica Moss Reports On sql server reporting services
In this RunAs Radio podcast , Richard and I talk to Jessica Moss about sql server reporting services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis services to provide a deeper level of reporting. Jessica M. Moss, a Microsoft sql server MVP and business intelligence mentor with Solid

Blog Content

ssis

ssis, SAS Developer jobs, walkin on Sat 12th Sept 09
Posted on September 10th, 2009 ssis DevelopersQualification: Any GraduateExp: 3-9yrsWalk-in Date: 12th Sept 09Time: 10:00am to 01:00pm Company Name: CTSLocation: PuneVenue:Cognizant Technology Solutions 3rd floor, Winchester, Hiranandani Business Park, Powai,Mumbai.Website: https://www.cognizant.comKeywords: CTS walkins, DataWarehousing, DBA, jobs in CTS, Jobs in Mumbai, Mumbai Career, Mumbai jobs, Mumbai walkins, SAS, Saturday Walkins, Software Developer, ssis, Walkin Mumbai, Weekend Jobs, We

Blog Content

mssql

Forum Posting Contest
September 10th, 2009 Forum Posting ContestI started a new forum at www.forum.trafficgeek.net that uses the forum script IP Board version 3 (IPB3). I wish to start a posting contest and need a utility program written to count the posts.I would like this program to do the following:Scan the mysql database and determine the top 10 posters within a specified date range.I would like to specify (or omit) certain forum sections from the post count. For example, I do not want to include the chat fo

Blog Content

t-sql

SQL SERVER %26ndash; SQL Server Desktop Screen Background
Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am regular reader of his blog. Few of the other interesting posts written by him are following. Who do I talk to in Microsoft about%26hellip; Test your Restores, or, a Cautionary Tale If due to any reason, the original image is moved, you can download the imag

Blog Marketing

ssis

Transaction Log Shipping Copy job update
I need to configure TransactionLogShipping of a database between two database servers. Primary database is on production server that is SQL Server 2008 Standard installed on Windows Server 2003 x32 (used as web server as well). Secondary database is on SQL Server 2008 Developer installed on Windows Server 2008 x64 (I'll use it as development database with almost up-to-date data for developing and testing heavy statistics reports). And both servers are in DIFFERENT networks. OK. Let's config

Blog Marketing

sql

Senior Software Engineer in Test
Skills/Requirements:� Experience testing distributed systems Worked on high volume websites, Understand of and interaction with an operations team, Influenced their development team to have testability designed into a product Expertise in Java + one or more dynamic languages

Blog Content

sql server reporting services

SSRS 2008: Como a�adir tus propias plantillas de informe!
Como sab�is, sql server reporting services (SSRS) cuenta con dos plantillas pre-definidas para crear informes. Una de ellas nos permite crear el informe desde cero (plantilla de tipo Report Item) y la otra a trav�s de un asistente (plantilla de tipo Report Wizard): Pero, �Podemos a�adir nuestras propias plantillas de informe? Por supuesto, lo �nico que tenemos que hacer en el BI Management Studio es: Crear la plantilla de informe base que en s� es un informe, pero que contiene

Blog Content

mssql

Cs-cart Modification
I am using CS-Cart for my site. I need someone to customize the template and improve some features including: _ News function with thumbnail ( on user interface and admin interface). This function is already on the site. Just a customization. _ Look and feel %26ndash; categories border and positioning. _ Integrate forum ( Vbulletin or else) All features are [...]

Blog Content

database administration

TECH SUPPORT-VOICE EXECEUTIVES REQUIRED
Location:Hyderabad/ SecunderabadKey Skills:Technical support,BE,BtechSpecialization:database administration (DBA),Client Server,Software EngineerJob Function:IT/Telecom - SoftwareIndustry:CRM/CallCentres/BPO/ITES/Med.TransQualification:School %26 Gra... Related posts: BPO Walk-Ins @ ACCENTURE : Customer / Tech Support : On 31 A 4 Sep 2009 HTML clipboard Customer Care %26 Support Executive Location:Bengaluru/ BangaloreKey Skills:communication skill,Specialization:Client Server,Tra

Blog Marketing

sql server

Checking Naming Conventions of MSsql Constraints and Indexes
If you create constraints and indexes in Management Studio, they are automatically named based on their type and the name of the table they belong to. If you create them manually, or overwrite their default names, naming may end up inconsistent. Here are two simple queries to check for naming conventions. Check that the constraint names match 'constraint type' + 'table name': SELECT p.name, CASE c.type WHEN 'F' THEN 'FK' WHEN 'D' THEN 'DF' WHEN 'UQ' THEN 'UK'

Blog Marketing

ssrs

Vertical Text Rotation in ssrs Text Boxes
If you are trying to make text display/rotate vertically, try changing the text box's writing mode to tb-rl.References:http://msdn.microsoft.com/en-us/ms189363.aspx

Blog Marketing

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Marketing

ssas

IT Walk-Ins @ HCL TECHNOLOGIES : Data Warehousing : Bangalore / Chennai / Noida : On 5 Sep 2009
HTML clipboard /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} Experience: 4-7 Years Location: Chennai

Blog Marketing

sql

Exposing Web Services as Database Views
In recent years, Web Services have become the defacto standard in passing� data between applications.�� They make communication between disparate computer languages and architectures relatively simple.� For the most part, we tend to think of web services in terms of traditional application development (Java, .NET, Ruby, PHP, etc %26hellip;) and inter-process communication.� What if we looked at them from another perspective?� What if we could easily integrate web services into the database?� Make them co

Blog Marketing

ssrs

Motorb�t p� grund
Vid kl 01:30 natten mot fredag inkommer ett larm till Sj�r�ddningscentralen, MRCC, g�llande en motorb�t som g�tt p� grund i S�derhamns sk�rg�rd. Telefonkontakten med haveristen �r mycket d�lig men man lyckas f� fram att man ska finnas n�gonstans runt Tjockholmen och Branth�ll varp� ssrs i S�derhamn larmas. Rescue Arizona anl�nder till omr�det strax f�re kl 02:00 men kan inte se n�gon haverist varp� �ven Kustbevakningens fartyg KBV 309 som ligger i Hudiksvall g�r ner mot omr�det. V�dret �r d�l

Blog Marketing

ssis

Transaction Log Shipping Copy job update
I need to configure TransactionLogShipping of a database between two database servers. Primary database is on production server that is SQL Server 2008 Standard installed on Windows Server 2003 x32 (used as web server as well). Secondary database is on SQL Server 2008 Developer installed on Windows Server 2008 x64 (I'll use it as development database with almost up-to-date data for developing and testing heavy statistics reports). And both servers are in DIFFERENT networks. OK. Let's config

Blog Content

mssql

Cpanel Whm Whmcs Clone
Please visit the two sites to see what exactly are thy a) cPanel + Whm and b) WHMCS cpanel.net and whmcs.com I need these under one branding with much better features Some of notable Competiting tools are � VirtualMin � DirectAdmin � Plesk � LXAdmin � Helm 3 %26 4 � Ensim � InterWorx � DotNetPanel � WHMSonic � CentovaCast � SCPanel � CastControl � TCAdmin � HyperVM Some of the free alternative Available are webmin [...]

Blog Content

t-sql

SQL SERVER %26ndash; FIX %26ndash; ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724) Fix/Workaround/Solution: The solution is very simple. Create the empty database with the same name on another server/instance first. Take full back of the same and forced

Blog Content

sql server reporting services

sql server 2008 R2: Algunas novedades en reporting services (I)!
Finalmente esta semana he encontrado un rato para poder instalar la CTP de sql server 2008 R2 y ver algunas de las novedades. De momento os destaco las siguientes de forma resumida y r�pida y centradas en la parte de reporting services: Nuevo Report Manager Por fin el Report Manager cambia de look %26 feel y de como utilizar sus funcionalidades. No es SharePoint, pero se parece bastante: A nivel de �tem publicado en el Report server, aparecen unos men�s contextuales muy parecido

Blog Content

sql server

Microsoft Fails To Patch sql server Password Exploit, What's New%26hellip;
News of the latest Microsoft Corporation (NasdaqGS: MSFT ) sql server security ball drop%26hellip; This time, Sentrigo , a security vulnerability company, and publishers of Hedgehog (an outstanding product by the way) have discovered an exploitable flaw in the crufty sql servers' process memory data stream. But wait, there's more! Microsoft's failure to supply an appropriate patch, has apparently forced Sentrigo to go forth and release their own workaround. Astonishing. More information, and a s

Blog Marketing

ssis

Consume a Web Service in SQL Server Integration Services
In this post, we will see how to consume a webservice in ssis using Web Service Task Using Web Service Task Web Service Task is used to execute Web Method. We can get the value returned from the web service, assign it to a variable and later use it in ssis package. This can also be used to get a list of available values, store it into a file and use that file as a data source for the package. This task is available as a control flow task; when dragged and dropped onto design area we need to

Blog Content

ssis

Consume a Web Service in SQL Server Integration Services
In this post, we will see how to consume a webservice in ssis using Web Service Task Using Web Service Task Web Service Task is used to execute Web Method. We can get the value returned from the web service, assign it to a variable and later use it in ssis package. This can also be used to get a list of available values, store it into a file and use that file as a data source for the package. This task is available as a control flow task; when dragged and dropped onto design area we need to

Blog Content

t-sql

SQL SERVER %26ndash; What is Data Mining %26ndash; A Simple Introductory Note
According to MacLennan et al. (2009), data mining is defined as %26ldquo; the process of analyzing data to find hidden patterns using automatic methodologies. %26rdquo; Consider the following simple example that explains this concept. By analyzing the data on the items purchased from a supermarket or a chain of such stores, information on the products that are sold most can be obtained and accordingly supply of that particular products are increased and vice versa. Data mining, in short, is an analytical acti

Blog Marketing

sql server

New sql server 2008�E-Learning
Looking to ramp up on sql server 2008? We just released a new 16-hour e-learning collection (8 individual two-hour courses):Get it here: Implementing and Maintaining Microsoft sql server 2008Source: Born to Learn

Blog Marketing

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

Blog Content

sql

Oscommerce Custom Order Report
September 1st, 2009 Oscommerce Custom Order ReportREQUIREMENT / FUNCTIONALITY Need experienced osCommerce developer to code, test and implement a PHP script within osCommerce 2.2. The script will generate an admin custom report on specified sales orders. The report will be a summary of each sale within a specified date range.The report must be laid out and contain the same fields specified in the attached PDF document and be styled (using CSS) to clearly display each field. No images, just te

Blog Content

mssql

Excel Dedupe
August 31st, 2009 Excel DedupeNeeds done immediately. I need the attached file Deduped if the following fields are identical:House# Suf St.Dir. StreetName Type Unit #Then, you will only keep a single row and will change the first name to FAMILY and delete the Middle Name all togther.That is if there is:Smith, Sara 101 Main Street, Bel Air Smith, Tom 101 Main Street, Bel Air Smith, Joe 101 Main Street, Bel Airwill become Smith Family 101 Main Street, Bel AirPlease bid if you completely under

Blog Marketing

mssql

Excel Dedupe
August 31st, 2009 Excel DedupeNeeds done immediately. I need the attached file Deduped if the following fields are identical:House# Suf St.Dir. StreetName Type Unit #Then, you will only keep a single row and will change the first name to FAMILY and delete the Middle Name all togther.That is if there is:Smith, Sara 101 Main Street, Bel Air Smith, Tom 101 Main Street, Bel Air Smith, Joe 101 Main Street, Bel Airwill become Smith Family 101 Main Street, Bel AirPlease bid if you completely under

Blog Marketing