-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Terry's Business Intelligence

Terry is a BI Developer in London, focusing on DataWarehouse design and Reporting using SQL Server SSIS/SSAS/SSRS.

SQL Logical Query Processing Order

This probably applies more to beginners or people who have been using SQL for a while but have been wondering why sometimes the query works in a certain way and sometimes it didn’t. Before I read the book for the exam 70-461, I found it relatively easy to just plonk…

Read more

1 comments, 402 reads

Posted in Terry's Business Intelligence on 3 June 2013

SQL and Relational Theory

Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the Microsoft label, T-SQL is a Microsoft flavour of the more standard ANSI and ISO version of SQL which is based on a branch of mathematics called Relational Model. Relational Model…

Read more

0 comments, 680 reads

Posted in Terry's Business Intelligence on 31 May 2013

The right terminology for the right audience

For those who has the privilege of being in the technology consulting industry for some time and started out in the technical side of things, remember those books or courses that teach about methodology or best practices? For example, for project management, you need to specify a requirements gathering stage,…

Read more

0 comments, 307 reads

Posted in Terry's Business Intelligence on 17 January 2013

Address Clean-up for Mail Merge using SSIS

Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands of addresses to prepare for a snail mail merge? What? You’re still doing it now in the 21st century? Just kidding. Chances are, you will need to be able to…

Read more

2 comments, 649 reads

Posted in Terry's Business Intelligence on 19 October 2012

Newer posts