dptechnicalblog.blogspot.com
Database and BI Concepts Blog: SSIS - Types of Transformations
http://dptechnicalblog.blogspot.com/2011/04/ssis-types-of-transformations.html
Database and BI Concepts Blog. Saturday, April 23, 2011. SSIS - Types of Transformations. SSIS transformation tasks can use memory or buffer in different ways. The way transformations use memory can impact the performance of your SSIS package dramatically. Transformations buffer usage can be categorised as below. In general if you can avoid using fully blocking and partial blocking transformations, your SSIS package will perform better. The transfromations can be classified as below. SSIS transformation ...
dptechnicalblog.blogspot.com
Database and BI Concepts Blog: SQL Server : SQL Job Status
http://dptechnicalblog.blogspot.com/2012/02/sql-server-sql-job-status.html
Database and BI Concepts Blog. Monday, February 13, 2012. SQL Server : SQL Job Status. SQL Server check job status with all job related information. EXEC dbo.sp help job @job name = N'TestSQLJob' ,. Job aspect = N'ALL' ;. Check run status of a job - check if job currently running. SQL Server Agent - Running = 1 means currently executing. DECLARE @job id uniqueidentifier. SELECT @job id=job id FROM msdb.dbo.sysjobs WHERE name=N'TestSQLJob'. EXEC master.dbo.xp sqlagent enum jobs 1, sa, @job id. Recently I ...
dptechnicalblog.blogspot.com
Database and BI Concepts Blog: April 2011
http://dptechnicalblog.blogspot.com/2011_04_01_archive.html
Database and BI Concepts Blog. Saturday, April 30, 2011. SQL Server: Maintaining Integrity during Transactions. Data integrity is the most important aspect of anything and everything we do in database. We developers often tend to ignore couple of things, or take things for granted. One of them is we forgot the Microsoft left it to the developer to decide whether to abort a transaction automatically when there is an error. For detailed information, go through this link. Wednesday, April 27, 2011. There ar...
balakrishnanp.blogspot.com
SharePoint 2007/2010: October 2009
http://balakrishnanp.blogspot.com/2009_10_01_archive.html
Tuesday, October 13, 2009. SharePoint 2003 to Moss 2007 Upgrade : DataBase Migration. Upgrade SharePoint 2003 to MOSS 2007 , Refer the following links,. Thursday, October 8, 2009. Access Denied in Operations and Applications Management tabs. So, I followed these steps to update the password for the account that is used by the Central Administration application pool. I followed these steps:. 183; Then do an iisreset /noforce. Then its works fine! Subscribe to: Posts (Atom). Farhan Faiz - SharePoint. Share...
balakrishnanp.blogspot.com
SharePoint 2007/2010: February 2010
http://balakrishnanp.blogspot.com/2010_02_01_archive.html
Friday, February 19, 2010. Install MOSS 2007 and WSS 3.0 on Windows Server 2008 R2 – you will need SP2 slipstream. Today i encountered an issue while installing the moss 2007 on Windows Server 2008 R2, it threw an error stating " This program is blocked due to compatibility issues. I thought it could be hardware compatibility issue, then i found out that it is required to upload the lastest service pack to updates. Folder of moss in Moss software. Saturday, February 6, 2010. 3 Restore the previously back...
balakrishnanp.blogspot.com
SharePoint 2007/2010: August 2011
http://balakrishnanp.blogspot.com/2011_08_01_archive.html
Tuesday, August 16, 2011. Migrating MOSS 2007 SSP/MySites to SharePoint 2010 in a database attach scenario. How do we migrate mysites only from MOSS 2007 farm to Sharepoint 2010 farm . This article to get more. Subscribe to: Posts (Atom). Farhan Faiz - SharePoint. Http:/ blog.thekid.me.uk. JQuery - How To. SQL Server - Pinal Dave. SQL Server - Vinod Kumar. Migrating MOSS 2007 SSP/MySites to SharePoint 2010. There was an error in this gadget. View my complete profile.
sqlblog.com
Jamie Thomson : Collecting information about your SSIS packages [SSIS Nugget]
http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby. Collecting information about your SSIS packages [SSIS Nugget]. Did you know that is is possible to read the contents of a SSIS package (i.e. a .dtsx file) from within SQL Server Management Studio (SSMS) using T-SQL? For example, take the following T-SQL snippet:. C: tmp MyPkg.dtsx'. All properties of a package. Note t...
dptechnicalblog.blogspot.com
Database and BI Concepts Blog: November 2010
http://dptechnicalblog.blogspot.com/2010_11_01_archive.html
Database and BI Concepts Blog. Tuesday, November 30, 2010. SQL Server Builtin functions to validate the data. Recently I came across a scenario in which I need to validate the data against the datatype. After some searching I found the below SQL Server Builtin functions to validate the data. SELECT ISNUMERIC('1234')- Returns 1 for success and 0 for failure. SELECT ISDATE('11-30-2010')- Returns 1 for success and 0 for failure. Saturday, November 27, 2010. SQL Server Trouble shooting. 4 SQL Server Articles.
dptechnicalblog.blogspot.com
Database and BI Concepts Blog: October 2010
http://dptechnicalblog.blogspot.com/2010_10_01_archive.html
Database and BI Concepts Blog. Monday, October 18, 2010. SQL SERVER: ALTER column datatype. Though it appears simple, often we search google or refer to msdn for simple SQL queries. CREATE tableA(col1 Int,col2 Varchar(100),col3 Varchar(50). To alter the datatype for col3 in tableA, we need to do the below. ALTER col3 Varbinary(MAX) NULL. SQL SERVER: Problem with SELECT *. Assumption: tableA , tableB exists. SELECT * FROM tableA. Solution: Always use explicit column names in the SQL queries. To get latest...
SOCIAL ENGAGEMENT