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...
puilsandmakean.blogspot.com
November 2010
http://puilsandmakean.blogspot.com/2010_11_01_archive.html
Kurup Limo Javanist Highest Marifat. Monday, November 29, 2010. Brouillette Died April 2011. Error in the questions for the exam 70-433. Preparing for the exam in 1970 -433 upcycle questions attached to the book. In one of them I found this here is a bug:). Task (question) was based on an arrangement of questions to choose from the available code. Inquiry had to pay pet owners who live in Seattle and have over 50-tuple (detailed description in the picture below). Unfortunately. DECLARE @ TABLE AS PETS.
fangyuanmsbi.com
方圆培训 | FangyuanMSBI - Useful Resourse自学园地
http://www.fangyuanmsbi.com/useful-resourse33258233982225322320.html
26041;圆培训 FangyuanMSBI. Basic Database课程. Interview Training 面试培训. Crystal Report 课程. Price and Guide 价目/选课指南. Useful Resourse自学园地. FAQ 问答. Free Online Tutorial and Resources. Learn SQL, VB,XML. Http:/ www.w3schools.com/sitemap/default.asp. Http:/ www.tutorialspoint.com/sql/sql-databases.htm. Http:/ sqlzoo.net/wiki/Main Page. Http:/ www.tomjewett.com/dbdesign/dbdesign.php? A Quick-Start Tutorial on Relational Database Design. Relational Database Design - Normalization. BIDN: http:/ bidn.com. A surprising...
davidbridgetechnology.com
Resources
http://www.davidbridgetechnology.com/Resources.aspx
David Bridge Technology Limited. Database development and administration / .net web application development, Stockport. Available to work in Manchester, Cheshire, Derbyshire, Yorkshire, Merseyside, Lancashire. Read my articles on SQL server development / administration on my Wordpress blog. Journey to SQL Authority. SQL Server Central.com. Paul S Randel on SQL Server (SQLSkills). 4 guys from rolla. Links open in a new window. Download my CV (Pdf). Download my CV (Word).
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...
dptechnicalblog.blogspot.com
Database and BI Concepts Blog: December 2010
http://dptechnicalblog.blogspot.com/2010_12_01_archive.html
Database and BI Concepts Blog. Monday, December 6, 2010. Use of SQL Server CTEs. SQL Server 2005 introduced Common Table Expression concept. CTE can be used as alternative to complex sub queries. CTEs replace traditional Group By condition to remove duplicate records from db tables having or not having primary keys. WITH CTE1(Id,Name) as. SELECT EMPLOYEE ID, EMPLOYEE NAME FROM EMP. SELECT Id, Name FROM CTE1. CTEs can be used in SQL JOIN conditions similar to db tables or views. Saturday, December 4, 2010.