FileStream Data Type : SQL Server 2008

I am loving the enthusiasm that people have for SQL Server 2008. Everyday I come across many questions on SQL Server 2008, this shows that people are curious and I am pretty sure that people are regularly reading and learning SQL Server 2008 to know more about it and how it can help to improve…

0

Table-valued Parameters – SQL Server 2008

Hi… here is one more article on SQL Server 2008 Enhancements. In past we should have found it a bit difficult to pass numerous parameters to the T-SQL Statements or Functions or Stored Procedures. The approach we used to take is creating a Temporary Table on Demand and insert the values to the Temporary Table…

0

Scale up with SQL Server 2005 / SQL Server 2008 – NUMA

This article is related to the NUMA (Non Uniform Memory Access) feature available with SQL Server. NUMA is a very useful feature to scale up the Server. Even before we discuss how SQL Server 2005 supports NUMA we have a few questions that needs to be addressed. A question that is frequently asked is: What…

0

SQL Server 2008 – Enhancements in Date and Time Data Types

I am finding SQL Server 2008 very exciting. Every day it’s a new learning for me and my eyes glitter seeing the sweet surprises that SQL Server 2008 is bringing in for efficient data management. I like SQL Server because I realize that data is like the life blood for any business, any forecasting any…

0

SQL Server 2008 – HierarchyID – Part II

Hi ! are you interested to know more about the HierarchyID then grab a bag of chips for yourself and read on. If you haven’t read about the HierarchyID then it is recommended that go to my last post SQL Server 2008 – HierarchyID – Part I and read that first. HierarchyID is definitely a…

0

SQL Server 2008 – HierarchyID – Part I

I am excited by the cool new features that SQL Server 2008 is binging up ! SQL Server 2008 is bringing some commendable new features one of the nice feature is HierarchyID. This a new data type that is available in the in the latest July CTP of the SQL Server 2008 Developer Edition. Organizations…

0

Data Compression with SQL Server 2005 SP2 and SQL Server 2008

One of the very useful feature introduced in SQL Server 2005 SP2 and SQL Server 2008 is vardecimal data type. When the databases are growing every day it is a significant concern for the DBAs to use the storage space efficiently. Bigger the row size then bigger the backups will be, bigger the indexes will…

0

SQL Server 2008 – Katmai

Excited about SQL Server 2008 ! so I am. "Your Data, Any Place, Any Time" It is highly exciting to know about the features in SQL Server 2008. The mission of SQL Server 2008 is to provide your data on your demand at your place, isn’t it exciting. You can check your last day’s sales…

0

Dynamically add images to SQL Server 2005 Reports – ASP.Net Web Project

It is very exciting to know that people are widely using SQL Server 2005 Reporting Services. I am always happy to answer their questions. A couple of days back a gentleman requested for some help on the project that I have posted on this blog – How to dynamically display the Images in SQL Server…

0

Business Intelligence Virtual Labs

http://www.microsoft.com/technet/traincert/virtuallab/bi.mspx The following labs are available on this page: Business Intelligence: Excel 2007 PivotTables and Analysis Services Business Intelligence: Using Business Scorecard Manager 2005 and ProClarity for Performance Management Business Intelligence: Building Integrated BI Solutions Leveraging SQL 2005 and Office 2007 Servers Business Intelligence: Building Analytic Applications with ProClarity Business Intelligence: Report Builder Business Intelligence:…

0