Sql Server 2008

This class provides a fast and universal method for accessing SQL Server database. Create Instance At first you create an instance of SqlDatabase class. Dim sqldb As New SqlDatabase("Data Source=(local); Initial Catalog= ; UId = ; Pwd = ;") For more information about connection strings, visit ConnectionStrings.com. ExecuteNonQuery Method Executes a Transact-SQL statement against...
Read more »

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful. You can report bugs, opinions and suggestions to me. <<DONWLOAD>> << dataAccess.vb >> Imports System Imports System.IO Imports System.Text Imports System.Data Imports System.Data.SqlClient Namespace SqlDataProvider ''' <summary>...
Read more »

WITH set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “M”)’ set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “F”)’ member Customer.AggMale as ‘Aggregate() member Customer.AggFemale as ‘Aggregate() SELECT {.} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM
Read more »

Recently, we’ve jumped into the world of multi-dimensional OLAP.  We’re currently using SQL Server Analysis Services which has been great to create the data cubes and Microsoft Sharepoint with Business Scorecard Manager to render the cubes.  The database and cube work wonderfully.  We have had issues with Scorecard Manager 2005 though (namingly, it doesn’t render well to...
Read more »

The CODE This article is based on SQL Server 2008 CTP 3. Some of the information may change by the time the product is finally released. Before we create a Function or Stored Procedure that accepts a TABLE variable, we need to define a User Defined TABLE Type. SQL Server 2008 introduced a new...
Read more »

Enterprise Project Management (EPM), dalam hal luas, adalah bidang pengembangan organisasi yang mendukung organisasi dalam mengelola dan integrally beradaptasi sendiri untuk perubahan dari transformasi. Dalam beberapa tahun terakhir, dengan adopsi umum (TI) praktek pemerintahan, Enterprise Manajemen Proyek telah menjadi lebih spesifik: sedangkan di tahun 1990-an secara umum telah fokus pada pengelolaan satu proyek, disusul...
Read more »

Good news for those who want to take advantage of SQL Server 2008 Spatial and ArcGIS. ESRI’s ArcGIS 9.3 software, the next scheduled release of ESRI’s ArcGIS suite, will take full advantage of the new spatial technology in the upcoming release of SQL Server 2008. With the November SQL Server 2008 community technology preview...
Read more »