The amount of spatial data captured in databases is increasing exponentially. This includes data from mobile phones, GPS units through to home detention bracelets used for home arrests. Typically these devices capture information such as latitudes and longitudes. The spatial capabilities of...
When you start moving large volumes of data, tuning SSIS will become very important. This video tutorial outlines the importance of Blocking, Partial Blocking, & Non -Blocking transformations and how to design packages so they will run faster.
Transact - Structure Query Language (T-SQL) is Microsoft's (& Sybase's) proprietary extension to SQL. Its used for querying, altering and defining databases. Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by...
Step by step instructions on how to install SQL 2008 (release 2) onto a PC running Vista. This tutorial consists of 5 parts. 1) An explanation of the various components of SQL 2008 2) SQL licencing options 3) Step by...
Sooner or later (and most likely sooner) you will run into a technical problem that you can't solve. This applies to any technical issue- whether its a problem with SQL Analysis Services, or Excel, or a coding bug. In this...