Sunday, September 16, 2007
SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. more
Saturday, March 17, 2007
layers or workloads: data warehousing, reporting and
analysis, and performance management. These are
designed to provide a consolidated, comprehensive data
source and tools to help improve decision making.
Microsoft BI is to help decision makers at all levels.
An IDC report issued this summer—found that Microsoft’s
BI market share growth outpaced that of most rivals.
More to the point, both Gartner and IDC now agree:
Microsoft is now a BI force to be reckoned with, trailing
established leaders such as Business Objects SA, SAS
Institute Inc., and Cognos Inc. for overall BI market
Thursday, January 12, 2006
It can be a challenge to pass such a list of values to a stored procedure. In earlier times I had been using so called composite queries, or dynamic SQL. It includes putting together a string to be compiled and executed using EXECUTE statement. For example:
CREATE PROCEDURE CustomerByRegion
declare @sql varchar(1000)
set @sql = 'select * from Customers where Region IN (' + @List + ')'
-- call procedure
declare @List varchar(100)
set @List = '''OR'', ''CA'', ''WA'''
execute CustomerByRegion @List
Article by Alex Grinberg, more
Friday, December 16, 2005
This case study takes up a sample financial web application “Trade Analysis” designed and developed by Prakash Financials. Trade Analysis application supports trade analysis for client specific trade data. Client in this article represents mostly an organization. ‘User’ is any user that uses the services of “Trade Analysis”. There may be many users from one single organization/client and there may be more than one client registered for the using “Trade Analysis”. When an organization decides to use “Trade Analysis”, few users from the organization are registered with “Prakash Financials”, with same or different access privileges.
Article by Jayram Tallamraju, more
Sunday, November 06, 2005
VistaDB 2.1 database for .NET has been released
This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, data management and data migration tools. Free trial is available for download.
- Learn more about VistaDB
- Repost this to your blog and receive a FREE copy of VistaDB 2.1!